SMB Cash Flow Projection Example.xlsx

	C	D	E	F	G	H	I	J	K	L	M	N	O	P
14	XYZ Company - Monthly Cash Flow Projections
15	Select a month to start	Apr	May	June	July	Aug	Sept	Oct	Nov	Dec	Jan	Feb	Mar	Total
16
17	Receipts													Total
18	Sales	$32,541	$36,528	$28,254	$36,528	$12,635	$32,541	$36,528	$38,965	$32,541	$36,528	$36,528	$32,541	$392,658
19	Other revenue	$2,865	$2,956	$1,258	$2,956	$9,854	$2,865	$2,956	$31,256	$2,865	$2,956	$2,956	$2,865	$68,608
20		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
21		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
22	Total receipts	$35,406	$39,484	$29,512	$39,484	$22,489	$35,406	$39,484	$70,221	$35,406	$39,484	$39,484	$35,406	$461,266
23
24	Less payments
25	Direct costs
26	Materials	$1,164	$1,164	$1,164	$1,164	$1,164	$1,164	$1,164	$1,164	$1,164	$1,164	$1,164	$1,164	$13,968
27	Stock	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
28	Packaging	$1,365	$1,365	$1,365	$1,365	$1,365	$1,365	$1,365	$1,365	$1,365	$1,365	$1,365	$1,365	$16,380
29	Fixed costs
30	Salaries and wages	$19,210	$19,210	$19,210	$19,210	$19,210	$19,210	$19,210	$19,210	$19,210	$19,210	$19,210	$19,210	$230,520
31	Rent/mortgage	$4,120	$4,120	$4,120	$4,120	$4,120	$4,120	$4,120	$4,120	$4,120	$4,120	$4,120	$4,120	$49,440
32	Web site hosting and maintenance	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
33	Electricity	$825	$825	$825	$825	$825	$825	$825	$825	$825	$825	$825	$825	$9,900
34	Insurance	$238	$238	$238	$238	$238	$238	$238	$238	$238	$238	$238	$238	$2,856
35	Marketing and advertising	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$12,000
36	Office supplies	$410	$410	$410	$410	$410	$410	$410	$410	$410	$410	$410	$410	$4,920
37	Total cash payments	$28,332	$28,332	$28,332	$28,332	$28,332	$28,332	$28,332	$28,332	$28,332	$28,332	$28,332	$28,332	$339,984
38
39	Net cash flow	$7,074	$11,152	$1,180	$11,152	-$5,843	$7,074	$11,152	$41,889	$7,074	$11,152	$11,152	$7,074	$121,282
40
41	Opening bank balance	$0	$7,074	$18,226	$19,406	$30,558	$24,715	$31,789	$42,941	$84,830	$91,904	$103,056	$114,208
42
43	Closing bank balance	$7,074	$18,226	$19,406	$30,558	$24,715	$31,789	$42,941	$84,830	$91,904	$103,056	$114,208	$121,282	$121,282
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
101
102
103
104
105
106
107
108
109
110
111
112
113