THE MAPLE SYRUP COMPANY FORECASTED BALANCE SHEET FOR THE YEARS ENDING... |
|||||
ASSETS: | Year 1 | Year 2 | YEar 3 | Year 4 | Year 5 |
Current Assets: | |||||
Cash | $ (2,110) | $ (541) | $ 1,434 | $ 16,454 | $ 39,913 |
Fixed Assets: | |||||
Woodlot | 75,000 | 75,000 | 75,000 | 75,000 | 75,000 |
Building | 4,500 | 4,500 | 8,100 | 8,100 | 8,100 |
Accumulated Depreciation | 225 | 450 | 855 | 1,260 | 1,665 |
Net Book Value | 4,275 | 4,050 | 7,245 | 6,840 | 6,435 |
Equipment - Labour | 4,000 | 10,000 | 20,000 | 40,000 | 40,000 |
Equipment | 38,700 | 63,000 | 111,600 | 170,100 | 170,100 |
Accumulated Depreciation | 2,135 | 5,785 | 12,365 | 22,870 | 33,375 |
Net Book Value | 40,565 | 67,215 | 119,235 | 187,230 | 176,725 |
Total Fixed Assets | 119,840 | 146,265 | 201,480 | 269,070 | 258,160 |
TOTAL ASSETS | 117,730 | 145,724 | 202,914 | 285,524 | 298,073 |
LIABILITIES: | |||||
Current Liabilities: | |||||
Current portion - L/T Debt | 2,358 | 4,014 | 8,054 | 12,300 | 13,321 |
Total Current Liabilities | 2,358 | 4,014 | 8,054 | 12,300 | 13,321 |
Long term Debt: | |||||
External Financing Required | 30,592 | 52,073 | 100,235 | 154,161 | 141,865 |
less: current portion | 2,358 | 4,014 | 8,054 | 12,300 | 13,321 |
Long Term Debt | 28,234 | 48,059 | 92,181 | 141,861 | 128,544 |
TOTAL LIABILITIES | 30,592 | 52,073 | 100,235 | 154,161 | 141,865 |
EQUITY: | |||||
Cash Contributions | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 |
Woodlot Contributions | 75,000 | 75,000 | 75,000 | 75,000 | 75,000 |
Labour Contributions | 4,000 | 10,000 | 20,000 | 40,000 | 40,000 |
Investment Tax Credits | (4,800) | (7,500) | (13,300) | (19,800) | (19,800) |
Retained Earnings | (7,062) | (3,849) | 979 | 16,163 | 41,008 |
TOTAL EQUITY | 87,138 | 93,651 | 102,679 | 131,363 | 156,208 |
TOTAL EQUITY & LIABILITIES | 117,730 | 145,724 | 202,914 | 285,524 | 298,073 |