Maple Syrup Cash Flow for year 2
- |
- Email a Friend |
Digg
| 
StumbleUpon
| 
Facebook
|
THE MAPLE SYRUP COMPANY
|
|||||||
| JAN | FEB. | MAR | APR | MAY | JUNE | JULY | |
| CASH INFLOWS: | |||||||
| Sales Grade "A" Bulk | 1,992 | 1,992 | |||||
| Sales Grade "B" Bulk | 1,494 | 1,494 | |||||
| Sales Grade "A" Retail | 2,630 | ||||||
| Sales Grade "B" Retail | 1,972 | ||||||
| Capital Contributions | 6,000 | ||||||
| External Financing | 25,000 | ||||||
| Total Cash Inflows | 6,000 | 25,000 | 0 | 0 | 3,486 | 3,486 | 4,602 |
| CASH OUTFLOWS: | |||||||
| For Advertising | 354 | 354 | |||||
| Bank & Service Charges | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
| Clean-up & Supplies | 750 | ||||||
| Containers & Labels | 3,188 | ||||||
| Fuel | 398 | 398 | |||||
| Insurance | 450 | ||||||
| Land Rentals | |||||||
| Membership Fees | |||||||
| Professional Fees | 500 | ||||||
| Property Taxes | |||||||
| Repairs & Maintenance | |||||||
| Salaries, Wages & Benefits | |||||||
| Small Tools | 200 | 200 | |||||
| Telephone | 75 | 75 | |||||
| Training & Trade Shows | 500 | ||||||
| Utilities | 125 | 125 | |||||
| Payment on Loan | 389 | 389 | 665 | 665 | 665 | 665 | 665 |
| Equipment | 20,000 | 7,000 | |||||
| Equipment - Labour | 6,000 | ||||||
| Total Cash Outflows | 26,399 | 4,237 | 8,398 | 1,273 | 2,500 | 1,029 | 1,029 |
| Excess Cash (Deficiency) | (20,399) | 20,764 | (8,398) | (1,273) | 986 | 2,457 | 3,573 |
| Beginning Cash | (2,110) | (22,697) | (1,949) | (10,434) | (11,805) | (10,909) | (8,522) |
| Cash Balance (Overdraft) | (22,509) | (1,933) | (10,348) | (11,707) | (10,818) | (8,451) | (4,949) |
| FINANCING: | |||||||
| Interest Overdraft | (187.57) | (16.11) | (86.23) | (97.56) | (90.15) | (70) | (41) |
| Ending Cash Balance | (22,697) | (1,949) | (10,434) | (11,805) | (10,909) | (8,522) | (4,990) |
| THE MAPLE SYRUP COMPANY FORECASTED CASH FLOW STATEMENT YEAR 2 (AUG. to DEC.) |
||||||
| AUG. | SEPT. | OCT. | NOV. | DEC | TOTAL | |
| CASH INFLOWS: | ||||||
| Sales Grade "A" Bulk | 3,984 | |||||
| Sales Grade "B" Bulk | 2,988 | |||||
| Sales Grade "A" Retail | 2,709 | 2,630 | 7,969 | |||
| Sales Grade "B" Retail | 2,032 | 1,972 | 5,977 | |||
| Capital Contributions | 6,000 | |||||
| External Financing | 25,000 | |||||
| TOTAL CASH INFLOWS | 4,741 | 4,602 | 0 | 0 | 0 | |
| CASH OUTFLOWS: | ||||||
| For Advertising | 354 | 1,063 | ||||
| Bank & Service Charges | 10 | 10 | 10 | 10 | 10 | 120 |
| Clean-up & Supplies | 750 | |||||
| Containers & Labels | 3,188 | |||||
| Fuel | 797 | |||||
| Insurance | 450 | |||||
| Land Rentals | 0 | |||||
| Membership Fees | 400 | 400 | ||||
| Professional Fees | 500 | |||||
| Property Taxes | 0 | |||||
| Repairs & Maintenance | 750 | 750 | ||||
| Salaries, Wages & Benefits | 0 | |||||
| Small Tools | 400 | |||||
| Telephone | 150 | |||||
| Training & Trade Shows | 500 | |||||
| Utilities | 250 | |||||
| Payment on Loan | 665 | 665 | 665 | 665 | 665 | 7,428 |
| Equipment | 27,000 | |||||
| Equipment - Labour | ||||||
| TOTAL CASH OUTFLOWS | 1,029 | 675 | 675 | 675 | 1,825 | |
| Excess Cash (Deficiency) | 3,712 | 3,927 | (675) | (675) | (1,825) | |
| Beginning Cash | (4,990) | (1,289) | 2,638 | 1,963 | 1,288 | |
| Cash Balance (Overdraft) | (1,278) | 2,638 | 1,963 | 1,288 | (537) | |
| FINANCING: | ||||||
| Interest Overdraft | ($11.00) | 0 | 0 | 0 | ($4.00) | ($604) |
| ENDING CASH BALANCE | (1,289) | 2,638 | 1,963 | 1,288 | (541) | |