An example of a projected cash flow statement for a year
Details Sales Purchases Bank balance at the beginning of the month Cash receipts Cash sales Debtors Business Finance Total Cash Payments Rent Telephone Transport costs Owner's salary Wages Electricity Interest (Loan finance) Cash purchases Creditors Loan repayments Land & buildings Machinery Fixtures & fittings Vehicles Tax Other expenses* Total Surplus/shortfall Bank balance at the end of the month Jan 15 000 4 800 Feb 16 500 5 280 Mar 17 500 5 600 Apr 18 000 5 760 May 19 000 6 080 Jun 20 000 6 400 Jul 22 000 7 040 Aug 22 000 7 040 Sep 22 000 7 040 Oct 23 000 7 360 Nov 25 000 8 000 Dec 30 000 9 600 Total 250 000 80 000
85 000 7 500 20 000 27 500 1 800 120 180 2 250 1 300 250 233 2 400 0 80 000
2 967 8 250 7 500 0 15 750 1 800 130 200 2 250 1 300 250 233 2 640 2 400 0 0
7 314 8 750 8 250 0 17 000 1 800 130 200 2 250 1 300 250 233 2 800 2 640 0 0
12 511 9 000 8 750 0 17 750 1 800 140 210 2 250 1 300 250 233 2 880 2 800 470 0
17 728 9 500 9 000 0 18 500 1 800 140 210 2 250 1 600 250 233 3 040 2 880 470 0
23 155 10 000 9 500 0 19 500 1 800 160 230 2 250 1 600 250 233 3 200 3 040 470 0
5 721 11 000 10 000 0 21 000 1 800 180 240 2 250 1 600 250 233 3 520 3 200 470 0
12 778 11 000 11 000 0 22 000 1 800 190 260 2 250 1 600 250 233 3 520 3 520 470 0
20 485 11 000 11 000 0 22 000 1 900 190 270 2 250 1 600 250 233 3 520 3 520 470 0
28 082 11 500 11 000 0 22 500 1 900 190 300 2 250 1 800 250 233 3 680 3 520 470 0
35 789 12 500 11 500 0 24 000 1 900 210 350 2 250 1 800 250 233 4 000 3 680 470 0
20 945 15 000 12 500 0 27 500 1 900 220 350 3 250 3 200 250 233 4 800 4 000 470 0
20 000 0 1 000 109 533 (82 033)
0 0 200 11 403 4 347
0 0 200 11 803 5 197
0 0 200 12 533 5 217
0 0 200 13 073 5 427
0 23 501 200 36 934 (17 434)
0 0 200 13 943 7 057
0 0 200 14 293 7 707
0 0 200 14 403 7 597
0 0 200 14 793 7 707
0 23 501 200 38 844 (14 844)
0 0 200 18 873 8 627
85 000 0 125 000 110 000 20 000 255 000 0 22 000 2 000 3 000 28 000 20 000 3 000 0 2 796 40 000 35 200 4 230 80 000 0 0 20 000 47 002 3 200 310 428 55 428
2 967 Other expenses*
7 314
12 511
17 728
23 155
5 721
12 778
20 485
28 082
35 789
20 945
29 572
29 572
this refers to the following examples of expenses in your income statement: advertising, bank charges, accounting fee, insurance, licence and legal costs