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
Receipts Introduced Capital: Sales Excluding VAT: VAT on sales: Total Cash In (a): Payments: Equipment: Wages: Purchases: VAT on Purch.: Rent Business Rates: VAT Refund / excess: Loan: Marketing Advertising: Insurance: Transportation: Telephone: Gas: Electricty: Drawings: Total Cash Out (b): Net Cash Flow: Opening balance: Closing balance: Jan. Feb. March April May June July August Sept. Oct. Nov. Dec. Totals £0 £0 £0 £0
£0 £0 Jan. £0 £0 £0
£0 £0 Feb. £0 £0 £0
£0 £0 March £0 £0 £0
£0 £0 April £0 £0 £0
£0 £0 May £0 £0 £0
£0 £0 June £0 £0 £0
£0 £0 July £0 £0 £0
£0 £0 August £0 £0 £0
£0 £0 Sept. £0 £0 £0
£0 £0 Oct. £0 £0 £0
£0 £0 Nov. £0 £0 £0
£0 £0 Dec. £0 £0 £0
£0
£0
£0
£0
£0
£0
£0
£0
£0
£0
£0
£0
£0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
£0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
£0 £0 £0 £0
Ref.:D.Hilton
Cash Flow Template.
April 2006