Balance Sheet example for the Maple Syrup Company

 

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