Cash Flow Template

	A	B	C	D	E	F	G	I	K	M	O	Q	S	U	V
1	Cash Flow Projection Dashboard								Organizational Values:
2									Keep team fully paid & resourced (ie benefits, time off, etc.)
3	Below are various scenarios that all seem in the realm of possibilities.								Do no (financial) harm to others (ie keep paying contractors, don't collect money from folks who can't pay)
4	Some common assumptions that have already been made:								Keep money within sustainable businesses, local economies, etc.
5	NO:				YES:				Look to increase money in before cutting expenses
6	Delayed Construction work until at least July				All Pre Construction Work Continues
7	No Travel Expenses until Full Work Starts Up Again				$6k from EIDL Emergency Grant in May
8	No Tool Purchases until Full Work Starts Up again				Client Deposits Remain the Same
9
10
11
12
13	Scenario Tab Name	Scenario Details					Closing Month Estimated Bank Balance
14	Scenario Tab Name	Full Work delayed until...	% of Income Expected until Full Work Return	New Vehicle Purchase?	PPP Loan @ $50k in May		April	May	June	July	August	Sept	Oct	Nov	* ideally, we want a buffer of at least 1 payroll b/c of specific timing of money in/out within a month = $15k buffer needed
15	Original Budget					Original	$40,098	$44,729	$57,473	$65,916	$65,597	$65,841	$54,084	$46,765
16	Scenario 1:	July	80%	Y	No	1	$27,440	$31,741	$45,156	$53,599	$53,280	$53,524	$41,768	$34,449
17	Scenario 2:	July	50%	Y	No	2	$6,440	$241	$13,656	$22,099	$21,780	$22,024	$10,268	$2,949
18	Scenario 3	Sept	30%	No	Yes	3	($7,161)	$30,039	$43,853	$53,366	$54,117	$54,760	$43,402	$36,482
19	Scenario 4:	Sept	0%	No	Yes	4	($28,161)	($1,461)	$12,353	$21,866	$22,617	$23,260	$11,902	$4,982
20
21
22
23
24
25
26
27
28
29
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
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