Sample Coffee Shop Cash Flow Projections.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	MONTHLY CASH FLOW PROJECTION						Year 1
2
3		Startup	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Annual
4
5	Days Open in the Month		24	27	25	26	26	25	26	25	25	26	25	26
6
7	1. BEGINNING CASH	4,000	22,367	20,999	18,766	15,732	13,244	10,538	7,020	7,106	7,188	6,811	8,350	9,673
8
9	2. CASH RECEIPTS
10	Beverage and Food Sales		13,608	15,309	14,175	14,742	14,742	14,175	14,742	14,175	14,175	16,848	16,200	16,848	179,739
11	Sales Tax Collected		1,004	1,129	1,045	1,087	1,087	1,045	1,087	1,045	1,045	1,243	1,195	1,243	13,256
12	NextStage Loan	50,000													0
13
14	3. TOTAL CASH RECEIPTS	50,000	14,612	16,438	15,220	15,829	15,829	15,220	15,829	15,220	15,220	18,091	17,395	18,091	192,995
15
16	4 TOTAL CASH AVAILABLE	54,000	36,979	37,437	33,986	31,561	29,073	25,759	22,849	22,326	22,408	24,901	25,745	27,764
17
18	5. CASH PAID OUT
19	Inventory Purchases (35%)	4,500	4,763	5,358	4,961	5,160	5,160	4,961	5,160	4,961	4,961	5,897	5,670	5,897	62,909
20	Officer Wages		2,268	2,552	2,363	2,457	2,457	2,363	2,457	2,363	2,363	2,457	2,363	2,457	28,917
21	Other Wages		1,620	1,823	1,688	1,755	1,755	1,688	1,755	1,688	1,688	1,755	1,688	1,755	20,655
22	Payroll Expenses (10%)		389	437	405	421	421	405	421	405	405	421	405	421	4,957
23	Payroll Service		100	100	100	100	100	100	100	100	100	100	100	100	1,200
24	Accounting and Legal	0	75	75	575	75	75	575	75	75	575	75	75	575	2,900
25	Advertising/Promotion	0	250	250	0	250	0	0	250	0	0	250	0	0	1,250
26	Insurance	0	1,950	0	0	0	0	0	0	0	0	0	0	0	1,950
27	Loan Payment to Nonprofit Lender		375	375	375	375	901	901	901	901	901	901	901	901	8,708
28	Office Supplies	50						100							100
29	Credit Card Fees		460	518	479	499	499	479	499	479	479	570	548	570	6,079
30	Postage		50					0							50
31	Rent	2,350	0	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350	25,850
32	Loan Payment to Seller	2,000	3,000	3,000	3,000	3,000	3,000	3,000							18,000
33	Repairs and Cleaning		0	150	150	150	150	150	150	150	150	150	150	150	1,650
34	Security	0	0	0	0	0	0	0	0	0	0	0	0	0	0
35	Sales Taxes			1,004	1,129	1,045	1,087	1,087	1,045	1,087	1,045	1,045	1,243	1,195	12,013
36	Telephone/Internet	0	200	200	200	200	200	200	200	200	200	200	200	200	2,400
37	Utilities		180	180	180	180	180	180	180	180	180	180	180	180	2,160
38	Bank Charges		50	50	50	50	50	50	50	50	50	50	50	50	600
39	Misc		250	250	250	250	150	150	150	150	150	150	150	150	2,200
40	Subtotal	8,900	15,980	18,671	18,255	18,317	18,535	18,739	15,743	15,139	15,597	16,551	16,071	16,951	204,548
41	Equipment	10,000													0
42	Leaseholds	11,000													0
43	Fees and Licenses	1,733													0
44															0
45	6. TOTAL CASH PAID OUT	31,633	15,980	18,671	18,255	18,317	18,535	18,739	15,743	15,139	15,597	16,551	16,071	16,951	204,548
46
47	7. ENDING CASH	22,367	20,999	18,766	15,732	13,244	10,538	7,020	7,106	7,188	6,811	8,350	9,673	10,813
48
49	A. Sales Volume		13,608	15,309	14,175	14,742	14,742	14,175	14,742	14,175	14,175	16,848	16,200	16,848	179,739
50
51	Coffee Sales
52	Average Sales/Customer		$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00
53	Average Customers/Day		63	63	63	63	63	63	63	63	63	72	72	72
54	Average Customers/Hour		7	7	7	7	7	7	7	7	7	8	8	8
55	Hours Per Day		9	9	9	9	9	9	9	9	9	9	9	9
56
57	Daily Sales		567	567	567	567	567	567	567	567	567	648	648	648
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