jojo's soap business CASH FLOW FORECAST YEAR ONE Month 1 RECEIPTS Product 1 v 1000 Product 2 v 500 Product 3 v 250 Owners Loans Other VAT 88 TOTAL 1,838 PAYMENTS Raw Materials Wages Premises Insurance HLP Telephone Advertising Office costs Travel etc Professional fees Repairs Other Capital equipment Bank charges Loan repayments Loan interest Drawings Tax VAT VAT to FIRS TOTAL BALANCE BANK BALANCE VATrate
Month 2 1000
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12 1000
Total 3,000 500 250 0 0 0 188 3,938
50 1,050
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
50 1,050
v
400 400
v v
100
100 v v v
25 1,025 813 813 5%
0 63 63 988 1,800
0 50 50 (50) 1,750
0 0 0 0 1,750
0 0 0 0 1,750
0 0 0 0 1,750
0 0 0 0 1,750
0 0 0 0 1,750
0 0 0 0 1,750
0 0 0 0 1,750
0 0 0 0 1,750
0 0 0 1,050 2,800
400 0 400 0 0 100 0 0 100 0 0 0 0 0 0 0 0 0 25 113 1,138 2,800
50
3/13/2009
Cash flow forecast You can, if you choose, simply delete the cells with the totals, print this out and complete it by hand. If you prefer, you can use this as an electronic spreadsheet. If you registered for VAT, you should insert v in column B for each of your products on which you pay VAT and for each of thes expense items for which you are able to recover the VAT. You should then insert figures in the spreadsheet net of VAT - the spreadsheet will calculate the VAT for you. Teh net VAT is paid to FIRS monthly so this is shown in the month following the month in which it is accrued. the figure to the right of the total column is the VAT still outstanding at the end of the year. The VAT rate is currently 5%, but can be adjusted if required. Don't forget to fill in your name in the top left hand corner Check all your figures carefully.