ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Manual Cash Flow Forecast - 12 Months
4
Key:
5
These cells auto-calculate for you
6
Insert your own text/numbers into these cells as relevant.
7
8
9
10
Select your starting month:
11
12
MONTHS
13
Cash In123456789101112TOTAL
14
Revenue/Sales£0£0£0£0£0£0£0£0£0£0£0£0£0
15
Other Income£0£0£0£0£0£0£0£0£0£0£0£0£0
16
Other Income£0£0£0£0£0£0£0£0£0£0£0£0£0
17
Grants£0£0£0£0£0£0£0£0£0£0£0£0£0
18
Total cash in-flows (A)£0£0£0£0£0£0£0£0£0£0£0£0£0
19
20
MONTHS
21
Cash Out123456789101112TOTAL
22
Taxes for business premises£0£0£0£0£0£0£0£0£0£0£0£0£0
23
Utilities (gas, electricity, water)£0£0£0£0£0£0£0£0£0£0£0£0£0
24
Marketing and advertising expenses£0£0£0£0£0£0£0£0£0£0£0£0£0
25
Rent or premises costs£0£0£0£0£0£0£0£0£0£0£0£0£0
26
Insurance£0£0£0£0£0£0£0£0£0£0£0£0£0
27
Accounting & Legal£0£0£0£0£0£0£0£0£0£0£0£0£0
28
Consumables£0£0£0£0£0£0£0£0£0£0£0£0£0
29
Equipment£0£0£0£0£0£0£0£0£0£0£0£0£0
30
Software Cost£0£0£0£0£0£0£0£0£0£0£0£0£0
31
Staff costs£0£0£0£0£0£0£0£0£0£0£0£0£0
32
Total cash out-flows (B)£0£0£0£0£0£0£0£0£0£0£0£0£0
33
34
Your net cash flow (A-B)£0£0£0£0£0£0£0£0£0£0£0£0£0
35
36
Your monthly opening business bank account balance£0£0£0£0£0£0£0£0£0£0£0£0£0
37
38
Your closing cash position£0£0£0£0£0£0£0£0£0£0£0£0
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100