Page 11 - 342_

Table 2
Year 1 – Cashflow forecast
July Aug Sept Oct Nov Dec Jan Feb Mar April May June TOTAL
£ £ £ £ £ £ £ £ £ £ £ £ £

Income

Sales 375 875 1,125 1,325 1,625 2,050 2,375 2,625 2,525 2,150 1,900 1,700 20,650
Outgoings
Cost of
150 200 250 - 280 370 450 500 550 460 400 360 3,970
materials
Telephone 100 - 100 - - 150 - - 200 - - 150 700
Bank charges 100 - 50 - - 50 - - 50 - - 50 300
Advertising 150 50 50 50 50 50 50 50 50 50 50 50 700
Printing,
postage and 50 110 10 20 20 20 30 30 20 20 20 20 370
stationery
Motor
450 50 50 50 150 75 100 100 75 75 75 200 1,450
expenses
Accountancy
- - - - - - - - - - - 300 300
fees
Insurances 35 35 35 35 35 35 35 35 35 35 35 35 420
Sundry
30 20 20 20 20 20 20 20 20 20 20 20 250
expenses
Purchase of
1,000 - - - - - - - - - - - 1,000
equipment
Hire purchase
175 175 175 175 175 175 175 175 175 175 175 175 2,100
repayment
Class 2
National 20 20 20 20 20 20 20 20 20 20 20 20 240
Insurance
Income
tax/Class 4
- - - - - 1,000 - - - - - 1,000 2,000
National
Insurance
Drawings 700 700 700 700 700 700 700 700 700 700 700 700 8,400
Total
2,960 1,360 1,460 1,070 1,450 2,665 1,580 1,630 1,895 1,555 1,495 3,080 22,200
outgoings
Net income (2,585 (1,380
(485) (335) 255 175 (615) 795 995 630 595 405 (1,550)
less outgoings ) )
Bank balance (2,585 (3,070 (3,541 (3,286 (3,111 (3,878 (3,083 (2,088 (1,557
- (962) (557) -
b/f ) ) ) ) ) ) ) ) )
(2,585 (3,070 (3,405 (3,286 (3,111 (3,726 (3,083 (2,088 (1,557 (1,937
(962) (557) (1,550)
) ) ) ) ) ) ) ) ) )
Overdraft
- - (136) - - (152) - - (99) - - (52) (439)
interest
Bank (2,585 (3,070 (3,451 (3,286 (3,111 (3,878 (3,083 (2,088 (1,557 (1,989
(962) (557) (1,989)
balance c/f ) ) ) ) ) ) ) ) ) )

11