|
Assets |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
|
Current Assets |
|
|
|
|
|
|
|
Cash |
335,899 |
648,667 |
2,557,641 |
6,019,783 |
10,733,153 |
(From Cash Flow Statement) |
|
Investments |
|
|
|
|
|
External Values |
|
Accounts Receivable |
|
|
300,000 |
750,000 |
1,500,000 |
External Values |
|
Notes Receivable |
|
|
|
|
|
External Values |
|
Inventory |
|
|
150,000 |
375,000 |
750,000 |
External Values |
|
Total Current Assets |
335,899 |
648,667 |
3,007,641 |
7,144,783 |
12,983,153 |
|
|
|
|
|
|
|
|
|
|
Plant and Equipment |
|
|
|
|
|
|
|
Building / Leasehold improvements |
0 |
0 |
0 |
0 |
0 |
External Values |
|
Plant and Equipment |
0 |
0 |
200,000 |
300,000 |
500,000 |
External Values |
|
Total Net Property & Equip |
0 |
0 |
200,000 |
300,000 |
500,000 |
|
|
|
|
|
|
|
|
|
|
Other Assets |
0 |
0 |
0 |
0 |
0 |
External Values |
|
Total Assets |
335,899 |
648,667 |
3,207,641 |
7,444,783 |
13,483,153 |
|
|
|
|
|
|
|
|
|
|
Liabilities & Owner Equity |
|
|
|
|
|
|
|
Current Liabilities |
|
|
|
|
|
|
|
Short Term Debt |
|
|
|
|
|
External Values |
|
Accounts Payable |
|
|
225,000 |
500,000 |
1,000,000 |
External Values |
|
Income Taxes Payable |
|
|
|
|
|
External Values |
|
Accrued Liabilities |
|
|
100,000 |
125,000 |
150,000 |
External Values |
|
Total Current Liabilities |
0 |
0 |
325,000 |
625,000 |
1,150,000 |
|
|
|
|
|
|
|
|
|
|
Long Term Debt |
70,000 |
70,000 |
0 |
0 |
0 |
(From Cash Flow Statement) |
|
Total Liabilities |
70,000 |
70,000 |
325,000 |
625,000 |
1,150,000 |
|
|
|
|
|
|
|
|
|
|
Owner / Stockholder Equity |
|
|
|
|
|
|
|
Common Stock |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
(From Cash Flow Statement) |
|
Retained Earnings |
1,162,899 |
2,075,667 |
4,879,641 |
9,841,783 |
17,605,153 |
|
|
Less Cash Dividends |
(900,000) |
(600,000) |
(400,000) |
(1,000,000) |
(2,000,000) |
External Values |
|
Total Owners' Equity |
265,899 |
1,478,667 |
4,482,641 |
8,844,783 |
15,608,153 |
|
|
|
|
|
|
|
|
|
|
Total Liabilities & Equity |
335,899 |
1,548,667 |
4,807,641 |
9,469,783 |
16,758,153 |
|
|
Source of Funds |
Year 1 |
Year 2 |
Year 3 |
Year4 |
Year 5 |
|
|
Net Income After Taxes |
1,162,899 |
912,768 |
2,803,974 |
4,962,142 |
7,763,370 |
(From Income Statement) |
|
|
|
|
|
|
|
|
|
Funds from Operations |
1,162,899 |
912,768 |
2,803,974 |
4,962,142 |
7,763,370 |
|
|
Sale of Stock |
3,000 |
0 |
0 |
0 |
0 |
(From Cash Flow Statement) |
|
Increased Long Term Debt |
70,000 |
0 |
(70,000) |
0 |
0 |
(From Cash Flow Statement) |
|
Total Source of Funds |
1,235,899 |
912,768 |
2,733,974 |
4,962,142 |
7,763,370 |
|
|
|
|
|
|
|
|
|
|
Use of Funds |
|
|
|
|
|
|
|
Building / Leasehold improvements |
0 |
0 |
0 |
0 |
0 |
(From Balance Sheet) |
|
Plants & Equipment |
0 |
0 |
200,000 |
100,000 |
200,000 |
(From Balance Sheet) |
|
Cash Dividends |
900,000 |
600,000 |
400,000 |
1,000,000 |
2,000,000 |
(From Balance Sheet) |
|
Increased Working Capital |
335,899 |
312,768 |
2,133,974 |
3,862,142 |
5,563,370 |
(From Summary of Changes in Working Capital) |
|
Total Use of Funds |
1,235,899 |
912,768 |
2,733,974 |
4,962,142 |
7,763,370 |
|
|
|
|
|
|
|
|
|
|
Summary of Changes |
|
|
|
|
|
|
|
in Working Capital: |
|
|
|
|
|
|
|
Cash |
335,899 |
312,768 |
1,908,974 |
3,462,142 |
4,713,370 |
(Cash derived from Cash Flow Statements; |
|
Investments |
|
|
|
|
|
remaining items derived from Balance Sheet) |
|
Accounts Receivalbe |
|
|
300,000 |
450,000 |
750,000 |
|
|
Notes Receivable |
|
|
|
|
|
|
|
Inventory |
|
|
150,000 |
225,000 |
375,000 |
Note: Increases in these items appear as |
|
Short Term Debt |
|
|
|
|
|
positive values; decreases appear as negatives. |
|
Accounts Payable |
|
|
(225,000) |
(275,000) |
(275,000) |
|
|
Income Taxes Payable |
|
|
|
|
|
|
|
Increased Working Capital |
335,899 |
312,768 |
2,133,974 |
3,862,142 |
5,563,370 |
|