Cash flow forecast - example

	B	C	D	E	F	G	H	I	J	K	L	M	N	P
1						All $K					Change cells in rows with BLUE text
2
3		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total

4
5	Beginning balance	155	146	147	111	118	87	27	14	-15	-41	-67	-93
6
7	Inflows
8	Individual donations	15		5		10								30
9	Foundation grants				50									50
10	Sponsorships		25					25						50
11														0
12														0
13
14	Total inflows	15	25	5	50	10	0	25	0	0	0	0	0	130
15
16	Outflows
17	Personnel	12	12	12	12	12	12	14	14	14	14	14	14	156
18	Professional fees	5	5	17	5	22	11	5	8	5	5	5	5	98
19	Marketing			5			30							35
20	Travel	7	7	7	26	7	7	19	7	7	7	7	7	115
21														0
22														0
23														0
24														0
25														0
26														0
27	Total outflows	24	24	41	43	41	60	38	29	26	26	26	26	404
28
29	Ending balance	146	147	111	118	87	27	14	-15	-41	-67	-93	-119
30
31
32
33
34
35
36
37
38
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	DATA FOR CHARTS
75
76		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
77	Ending balance	146	147	111	118	87	27	14	-15	-41	-67	-93	-119
78
79
80		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
81	Total inflows	15	25	5	50	10	0	25	0	0	0	0	0
82	Total outflows	24	24	41	43	41	60	38	29	26	26	26	26
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100