Maple Syrup Company Cash Flow Statement for year 3

THE MAPLE SYRUP COMPANY
FORECASTED CASH FLOW STATEMENT
FOR YEAR 3 (JAN. to JULY)

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