Artemis Natural Homes |
|
|
|
|
|
|
|
|
|
|
Funding Projections |
|
|
Years 1 to 5 |
|
|
($) |
|
|
|
|
Begin |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
|
|
|
|
Equity |
|
|
|
|
Owner's Equity |
10,000 |
10,000 |
10,000 |
10,000 |
10,000 |
10,000 |
|
Change from Previous Period |
|
0 |
0 |
0 |
0 |
0 |
|
Preferred |
|
|
Change from Previous Period |
|
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
Debt |
|
|
|
|
Short Term Debt |
0 |
0 |
0 |
0 |
0 |
0 |
|
Change from Previous Period |
|
0 |
0 |
0 |
0 |
0 |
|
Long Term Debt |
|
|
|
Current Portion |
|
|
|
|
Change from Previous Period |
|
0 |
0 |
0 |
0 |
0 |
|
Long Term Debt |
130,000 |
130,000 |
130,000 |
120,000 |
120,000 |
120,000 |
|
See Business Plan
Appendix for |
Change from Previous Period |
|
0 |
0 |
(10,000) |
0 |
0 |
|
explanation of long term
debt and |
Total Long Term Debt |
130,000 |
130,000 |
130,000 |
120,000 |
120,000 |
120,000 |
|
short term real estate
assets |
|
|
|
|
|
|
Interest Rate |
|
|
|
Interest Rate |
|
|
|
Short Term Debt |
|
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
|
Long Term Debt |
|
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
|
|
|
|
|
|
Interest Expense |
|
|
|
|
Short Term Debt |
|
0 |
0 |
0 |
0 |
0 |
|
Long Term Debt |
|
13,000 |
13,000 |
12,000 |
12,000 |
12,000 |
|
Total Interest |
|
13,000 |
13,000 |
12,000 |
12,000 |
12,000 |
|
|
|
Interest Income |
|
|
|
Interest Rate |
|
|
|
Interest Income |
|
|
|
|
|
Retained Earnings |
|
|
|
Net Income |
|
(15,614) |
16,154
|
19,386
|
45,858
|
40,200
|
|
Dividends |
|
0 |
0 |
0 |
0 |
0 |
|
Increase
/ (Decrease) Retained Earnings |
(15,614) |
16,154
|
19,386
|
45,858
|
40,200
|
|
Beginning Retained Earnings |
|
0 |
(15,614) |
539 |
19,925 |
65,783 |
|
Ending Retained Earnings |
|
(15,614) |
539 |
19,925
|
65,783
|
105,983
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|