Unit 5: Business Accounting P3

12 Month Cash Flow Template


Jan Feb March April May June July Aug

Opening Balance £ - £ 2,174.00 £ 5,081.01 £ 17,888.02 £ 24,645.03 £ 31,402.04 £ 50,369.05 £ 59,601.06

Cash inflows
Sales £ 30,000.00 £ 30,000.00 £ 30,000.00 £ 37,000.00 £ 37,000.00 £ 37,000.00 £ 41,500.00 £ 41,500.00
Shareholder £ 25,000.00
Investments
Tax £ 18,000.00 £ 22,200.00
Bank Loan £ 80,000.00
Total inflows £ 135,000.00 £ 30,000.00 £ 48,000.00 £ 37,000.00 £ 37,000.00 £ 59,200.00 £ 41,500.00 £ 41,500.00
Cash outflows
Purchases £ 13,500.00 £ 13,500.00 £ 13,500.00 £ 16,650.00 £ 16,650.00 £ 16,650.00 £ 18,675.00 £ 18,675.00
Bank Loan Repayment £ 1,000.00 £ 1,000.00 £ 1,000.00 £ 1,000.00 £ 1,000.00 £ 1,000.00 £ 1,000.00 £ 1,000.00


Machinery £ 85,000.00
Fixtures and Fittings £ 20,000.00
Rent £ 2,083.00 £ 2,083.00 £ 2,083.00 £ 2,083.00 £ 2,083.00 £ 2,083.00 £ 2,083.00 £ 2,083.00
Rates £ 1,700.00 £ 1,700.00 £ 1,700.00 £ 1,700.00 £ 1,700.00 £ 1,700.00 £ 1,700.00 £ 1,700.00
Salarys £ 6,333.33 £ 6,333.33 £ 6,333.33 £ 6,333.33 £ 6,333.33 £ 6,333.33 £ 6,333.33 £ 6,333.33
Telephone £ 100.00 £ 100.00 £ 100.00 £ 100.00 £ 100.00 £ 100.00 £ 100.00 £ 100.00
Post £ 50.00 £ 50.00 £ 50.00 £ 50.00 £ 50.00 £ 50.00 £ 50.00 £ 50.00
Courier Charges £ 1,500.00 £ 1,500.00 £ 1,500.00 £ 1,500.00 £ 1,500.00 £ 1,500.00 £ 1,500.00 £ 1,500.00
Advertising £ 326.66 £ 326.66 £ 326.66 £ 326.66 £ 326.66 £ 326.66 £ 326.66 £ 326.66
Heat and Light £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00
Tax £ 8,100.00 £ 9,990.00
Insurance £ 1,000.00