Maple Syrup Company Cash Flow Statement for year 3
- |
- Email a Friend |
Digg
| 
StumbleUpon
| 
Facebook
|
THE MAPLE SYRUP COMPANY |
|||||||
| JAN. | FEB. | MAR | APR | MAY | JUNE | JULY | |
| CASH INFLOWS: | |||||||
| Sales Grade "A" Bulk | 4,102 | 4,102 | |||||
| Sales Grade "B" Bulk | 3,076 | 3,076 | |||||
| Sales Grade "A" Retail | 5,414 | ||||||
| Sales Grade "B" Retail | 4,061 | ||||||
| Capital Contributions | 10,000 | ||||||
| External Financing | 55,000 | ||||||
| Total Cash Inflows | 10,000 | 55,000 | 0 | 0 | 7,178 | 7,178 | 9,475 |
| CASH OUTFLOWS: | |||||||
| For Advertising | 729 | 729 | |||||
| Bank & Service Charges | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
| Clean-up & Supplies | 1,500 | ||||||
| Containers & Labels | 6,563 | ||||||
| Fuel | 820 | 820 | |||||
| Insurance | 600 | ||||||
| Land Rentals | 1,000 | ||||||
| Membership Fees | |||||||
| Professional Fees | 500 | ||||||
| Property Taxes | |||||||
| Repairs & Maintenance | |||||||
| Salaries, Wages & Benefits | 2,500 | 2,500 | |||||
| Small Tools | 200 | 200 | |||||
| Telephone | 90 | 90 | |||||
| Training & Trade Shows | 500 | ||||||
| Utilities | 250 | 250 | |||||
| Payments on Loan | 665 | 665 | 1,335 | 1,335 | 1,335 | 1,335 | 1,335 |
| Building | 4,000 | ||||||
| Equipment | 54,000 | ||||||
| Equipment - Labour | 10,000 | ||||||
| Total Cash Outflows | 10,675 | 66,038 | 5,115 | 5,005 | 4,435 | 2,574 | 2,074 |
| Excess Cash (Deficiency) | (675) | (11,038) | (5,115) | (5,005) | 2,743 | 4,604 | 7,400 |
| Beginning Cash | (541) | (1,226) | (12,366) | (17,627) | (22,821) | (20,246) | (15,772) |
| Cash Balance (Overdraft) | (1,216) | (12,264) | (17,481) | (22,632) | (20,078) | (15,642) | (8,372) |
| FINANCING: | |||||||
| Interest Overdraft | (10.14) | (102.20) | (145.68) | (188.60) | (167.32) | (130.35) | (69.77) |
| Ending Cash Balance | (1,226) | (12,366) | (17,627) | (22,821) | (20,246) | (15,772) | (8,442) |
| THE MAPLE SYRUP COMPANY FORECASTED CASH FLOW STATEMENT FOR YEAR 3 (AUG. to DEC.) |
||||||
| AUG. | SEPT. | OCT. | NOV. | DEC | TOTAL | |
| CASH INFLOWS: | ||||||
| Sales Grade "A" Bulk | 8,203 | |||||
| Sales Grade "B" Bulk | 6,152 | |||||
| Sales Grade "A" Retail | 5,578 | 5,414 | 16,406 | |||
| Sales Grade "B" Retail | 4,184 | 4,061 | 12,305 | |||
| Capital Contributions | 10,000 | |||||
| External Financing | 55,000 | |||||
| Total Cash Inflows | 9,762 | 9,475 | 0 | 0 | 0 | |
| CASH OUTFLOWS: | ||||||
| For Advertising | 729 | 2,188 | ||||
| Bank & Service Charges | 10 | 10 | 10 | 10 | 10 | 120 |
| Clean-up & Supplies | 1,500 | |||||
| Containers & Labels | 6,563 | |||||
| Fuel | 1,641 | |||||
| Insurance | 600 | |||||
| Land Rentals | 1,000 | |||||
| Membership Fees | 400 | 400 | ||||
| Professional Fees | 500 | |||||
| Property Taxes | 0 | |||||
| Repairs & Maintenance | 1,500 | 1,500 | ||||
| Salaries, Wages & Benefits | 5,000 | |||||
| Small Tools | 400 | |||||
| Telephone | 180 | |||||
| Training & Trade Shows | 500 | |||||
| Utilities | 500 | |||||
| Payments on Loan | 1,335 | 1,335 | 1,335 | 1,335 | 1,335 | 14,680 |
| Building | 4,000 | |||||
| Equipment | 54,000 | |||||
| Equipment - Labour | 10,000 | |||||
| Total Cash Outflows | 2,074 | 1,345 | 1,345 | 1,345 | 3,245 | |
| Excess Cash (Deficiency) | 7,688 | 8,130 | (1,345) | (1,345) | (3,245) | |
| Beginning Cash | (8,442) | (760) | 7,369 | 6,024 | 4,679 | |
| Cash Balance (Overdraft) | (754) | 7,369 | 6,024 | 4,679 | 1,434 | |
| FINANCING: | ||||||
| Interest Overdraft | (6.28) | 0.00 | 0.00 | 0.00 | 0.00 | (820.34) |
| Ending Cash Balance | (760) | 7,369 | 6,024 | 4,679 | 1,434 | |