Cash Flow Forecast-
Jan (£) feb (£) march April (£) May (£) June (£) July (£) Aug. (£) Sept (£) Oct (£) Nov (£) Dec (£)
(£)
Opening 100 880 2090 8860 8080 14,545 13,085 18,815 (13,515) (12,865) (13,055) (13,222)
balance
(b/f)
Income 6000 8000 13,000 18,000 23,000 28,000 33,000 7000 1900 260 23 5
Total
Sales
Total 6000 8000 13,000 18,000 23,000 28,000 33,000 7000 1900 260 23 5
inflows
Total 5900 7120 10910 9140 14,920 13,455 19,915 (11,815) (11,615) (12,606) (13,032) (13,217)
cash
available
Expenses
Purchase 20 30 50 10 5 20 300 400 200 50 40 49
Employe 1,000 1,000 900 500 250 100 400 500 400 100 40 40
es' wage
Heat & 1,000 1,000 800 400 20 200 300 600 550 200 50 30
light
Rent 3,000 3,000 300 150 100 50 100 200 100 100 60 20
Total 5020 5030 2050 1060 375 370 1100 1700 1250 450 190 139
outflows
Closing 880 2090 8860 8080 14,545 13,085 18,815 (13,515) (12,865) (13,055) (13,222) (13,356)
balance(
c/f)
Jan (£) feb (£) march April (£) May (£) June (£) July (£) Aug. (£) Sept (£) Oct (£) Nov (£) Dec (£)
(£)
Opening 100 880 2090 8860 8080 14,545 13,085 18,815 (13,515) (12,865) (13,055) (13,222)
balance
(b/f)
Income 6000 8000 13,000 18,000 23,000 28,000 33,000 7000 1900 260 23 5
Total
Sales
Total 6000 8000 13,000 18,000 23,000 28,000 33,000 7000 1900 260 23 5
inflows
Total 5900 7120 10910 9140 14,920 13,455 19,915 (11,815) (11,615) (12,606) (13,032) (13,217)
cash
available
Expenses
Purchase 20 30 50 10 5 20 300 400 200 50 40 49
Employe 1,000 1,000 900 500 250 100 400 500 400 100 40 40
es' wage
Heat & 1,000 1,000 800 400 20 200 300 600 550 200 50 30
light
Rent 3,000 3,000 300 150 100 50 100 200 100 100 60 20
Total 5020 5030 2050 1060 375 370 1100 1700 1250 450 190 139
outflows
Closing 880 2090 8860 8080 14,545 13,085 18,815 (13,515) (12,865) (13,055) (13,222) (13,356)
balance(
c/f)