Maple Syrup Company Cash Flow for year 1

THE MAPLE SYRUP COMPANY
FORECASTED CASH FLOW STATEMENT
YEAR 1 (JAN. to JULY)
JAN FEB. MAR APR MAY JUNE JULY
CASH INFLOWS:
Sales Grade "A" Bulk 703 703
Sales Grade "B" Bulk 527 527
Sales Grade "A" Retail 928
Sales Grade "B" Retail 696
Capital Contributions 20,000 4,000
External Financing 32,000
TOTAL CASH INFLOWS 20,000 36,000 0 0 1,230 1,230 1,624
CASH OUTFLOWS:
For Advertising 125 125
Bank & Service Charges 10 10 10 10 10 10 10
Clean-up & Supplies 300
Containers & Labels 1,125
Fuel 141 141
Insurance 300
Land Rentals
Membership Fees
Professional Fees 1,000
Property Taxes
Repairs & Maintenance
Salaries, Wages & Benefits
Small Tools 200 200
Telephone 50 50
Training & Trade Shows 1,667 1,667 1,667
Utilities 50 50
Payments on Loan 389 389 389 389 389
Building 5,000
Equipment 43,000
Equipment Labour 4,000
TOTAL CASH OUTFLOWS 5,010 50,302 2,456 2,306 1,749 524 524
Excess Cash (Deficiency) 14,990 (14,302) (2,456) (2,306) (519) 706 1,100
Beginning Cash 0 14,990 688 (1,768) (4,123) (4,680) (4,007)
Cash Balance (Overdraft) 14,990 688 (1,768) (4,089) (4,642) (3,974) (2,907)
FINANCING:
Interest Overdraft 0.00 0.00 (14.73) (34.07) (38.68) (33.12) (24.22)
ENDING CASH BALANCE 14,990 688 (1,768) (4,123) (4,680) (4,007) (2,931)

 

THE MAPLE SYRUP COMPANY
FORECASTED CASH FLOW STATEMENT
YEAR 1 (AUG. to DEC.)
AUG. SEPT. OCT. NOV. DEC TOTALS
CASH INFLOWS:
Sales Grade "A" Bulk 1,406
Sales Grade "B" Bulk 1,055
Sales Grade "A" Retail 956 928 2,813
Sales Grade "B" Retail 717 696 2,109
Capital Contributions 24,000
External Financing 32,000
TOTAL CASH INFLOWS 1,673 1,624 0 0 0
CASH OUTFLOWS:
For Advertising 125 375
Bank & Service Charges 10 10 10 10 10 120
Clean-up & Supplies 300
Containers & Labels 1,125
Fuel 281
Insurance 300
Land Rentals 0
Membership Fees 0
Professional Fees 1,000
Property Taxes 0
Repairs & Maintenance 300 300
Salaries, Wages & Benefits 0
Small Tools 400
Telephone 100
Training & Trade Shows 5,000
Utilities 100
Payments on Loan 389 389 389 389 389 3,890
Building 5,000
Equipment 43,000
Equipment Labour 4,000
TOTAL CASH OUTFLOWS 524 399 399 399 699
Excess Cash (Deficiency) 1,149 1,225 (399) (399) (699)
Beginning Cash (2,931) (1,796) (576) (983) (1,394)
Cash Balance (Overdraft) (1,781) (571) (975) (1,382) (2,093)
FINANCING:
Interest Overdraft (14.85) (4.76) (8.12) (11.52) (17.44) (201.51)
ENDING CASH BALANCE (1,796) (576) (983) (1,394) (2,110)