Cash Flow Projection Tool

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC
1	Calculate
2	Cash Flow Summary
3	Last Updated: 12/31/2019
4
5		Cash Projection Summary							Monthly Projection Summary					Monthly Outflow Breakdown
6
7									Month	Cash In	Cash Out	Balance
8									Jan	$103,187	$176,477	$115,851
9									Feb	$109,672	$106,557	$118,965
10									Mar	$128,424	$185,018	$62,371
11									Apr	$125,488	$122,435	$65,424
12									May	$133,827	$200,976	-$1,725
13									Jun	$159,045	$135,593	$21,727
14									Jul	$154,335	$209,292	-$33,229
15									Aug	$165,134	$151,944	-$20,039
16									Sep	$199,167	$222,931	-$43,803
17									Oct	$191,908	$263,333	-$115,228
18									Nov	$205,988	$168,716	-$77,956
19									Dec	$252,057	$182,883	-$8,783
20									Total	$1,928,230	$2,126,153
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			12/30	1/6	1/13	1/20	1/27	2/3	2/10	2/17	2/24	3/2	3/9	3/16	3/23	3/30	4/6	4/13	4/20	4/27	5/4	5/11	5/18	5/25	6/1	6/8	6/15	6/22	6/29	7/6	7/13	7/20	7/27	8/3	8/10	8/17	8/24	8/31	9/7	9/14	9/21	9/28	10/5	10/12	10/19	10/26	11/2	11/9	11/16	11/23	11/30	12/7	12/14	12/21	12/28
50		Inflows	$8,516	$41,432	$30,683	$9,171	$21,901	$43,973	$32,699	$10,123	$22,876	$10,636	$70,920	$11,174	$23,954	$11,740	$49,891	$37,496	$12,643	$25,459	$53,033	$40,034	$13,955	$26,804	$14,662	$84,506	$15,404	$15,789	$28,684	$60,413	$46,131	$17,428	$30,364	$64,326	$49,352	$19,237	$32,218	$20,211	$101,146	$21,235	$21,765	$34,810	$73,599	$57,158	$24,025	$37,126	$25,241	$114,546	$26,519	$39,682	$27,862	$121,665	$29,272	$30,004	$43,254
51		Outflows	-$36,118	$0	-$59,993	-$68,116	-$42,243	-$6,125	-$60,868	$0	-$39,565	-$18,375	-$37,850	-$66,418	-$15,051	-$53,449	$0	-$67,382	-$10,553	-$52,999	$0	-$118,395	-$16,081	-$3,750	-$54,249	$0	-$74,459	-$11,635	-$57,999	$0	-$75,576	-$17,217	-$101,874	-$6,125	-$76,748	$0	-$12,828	-$62,368	$0	-$150,594	-$18,469	-$62,368	$0	-$88,641	-$14,143	-$145,925	-$6,125	-$12,500	-$77,498	-$19,850	-$67,368	$0	-$91,424	-$15,592	-$61,243
52		Cash Balance	$189,141	$230,573	$201,263	$142,318	$121,976	$159,824	$131,655	$141,779	$125,090	$117,351	$150,421	$95,177	$104,080	$62,371	$112,262	$82,375	$84,465	$56,924	$109,957	$31,596	$29,470	$52,524	$12,937	$97,443	$38,388	$42,542	$13,227	$73,640	$44,195	$44,406	-$27,104	$31,097	$3,701	$22,938	$42,329	$173	$101,319	-$28,041	-$24,745	-$52,303	$21,297	-$10,186	-$304	-$109,103	-$89,987	$12,059	-$38,920	-$19,088	-$58,594	$63,071	$920	$15,331	-$2,658
53
54
55
56			Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
57		Comp & Benefits	$59,985	$59,985	$69,248	$69,248	$74,248	$79,248	$79,248	$83,617	$87,985	$97,985	$97,985	$97,985
58		Admin & Operating	$27,375	$18,625	$31,125	$22,375	$27,375	$22,375	$27,375	$22,375	$27,375	$22,375	$27,375	$22,375
59		Marketing	$26,000	$18,375	$36,294	$20,258	$38,271	$22,335	$40,452	$33,124	$25,855	$44,148	$28,506	$46,931
60		Credit Card	$9,116	$9,572	$10,051	$10,553	$11,081	$11,635	$12,217	$12,828	$13,469	$14,143	$14,850	$15,592
61		COGS/Inventory	$54,000	$0	$37,850	$0	$50,000	$0	$50,000	$0	$68,246	$84,682	$0	$0
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