7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
A B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
Cash flow forecasting - Chinese Food - Home delivery business
Receipts Jan. Introduced Capital: £10,000 Sales Excluding VAT: £21,753 VAT on sales: £3,807 Total Cash In (a): £35,560 Payments: Equipment: Wages: Purchases: VAT on Purch.: Rent Business Rates: VAT Refund / excess: Jan. £160 £6,874 £5,830 £1,020 £1,200 £250 £2,787 Feb. £23,237 £4,066 £27,303 Feb. £160 £7,343 £6,228 £1,090 £1,200 £250 £2,977 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £27,882 -£578 £14,804 £14,226 March £24,619 £4,308 £28,927 March £160 £7,780 £6,598 £1,155 £1,200 £250 £3,154 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £28,931 -£3 £14,226 £14,222 April £23,025 £4,029 £27,054 April £160 £7,276 £6,171 £1,080 £1,200 £250 £2,950 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £27,721 -£667 £14,222 £13,556 May £24,510 £4,289 £28,799 May £160 £7,745 £6,569 £1,150 £1,200 £250 £3,140 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £28,848 -£49 £13,556 £13,507 June £25,335 £4,434 £29,769 June £160 £8,006 £6,790 £1,188 £1,200 £250 £3,245 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £29,474 £294 £13,507 £13,801 July £22,960 £4,018 £26,978 July £160 £7,255 £6,153 £1,077 £1,200 £250 £2,941 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £27,672 -£694 £13,801 £13,108 August £21,574 £3,775 £25,349 August £160 £6,817 £5,782 £1,012 £1,200 £250 £2,764 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £26,620 -£1,270 £13,108 £11,837 Sept. £21,310 £3,729 £25,039 Sept. £160 £6,734 £5,711 £999 £1,200 £250 £2,730 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £26,419 -£1,380 £11,837 £10,457 Oct. £24,681 £4,319 £29,000 Oct. £160 £7,799 £6,615 £1,158 £1,200 £250 £3,162 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £28,978 £22 £10,457 £10,480 Nov. £27,419 £4,798 £32,217 Nov. £160 £8,664 £7,348 £1,286 £1,200 £250 £3,512 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £31,056 £1,161 £10,480 £11,641 Dec. £26,150 £4,576 £30,726 Dec. £160 £8,263 £7,008 £1,226 £1,200 £250 £3,350 £833 £560 £72 £240 £200 £130 £480 £120 £6,000 £30,093 £633 £11,641 £12,274 Totals £10,000 £286,573 £50,150 £346,723
£1,920 £90,557 £76,802 £13,440 £14,400 £3,000 £36,710 £9,996 £6,720 £864 £2,880 £2,400 £1,560 £5,760 £1,440 £66,000 £334,449
Loan: £833 Marketing £560 Advertising: £72 Insurance: £240 Transportation: £200 Telephone: £130 Gas: £480 Electricty: £120 Drawings: £0 Total Cash Out (b): £20,756 Net Cash Flow: £14,804 Opening balance: Closing balance: £14,804
Ref.:D.Hilton
Cash Flow Template.
April 2006