ABCDEFGHIJKLMNOPQRSTUVWXY
1
Cash Flow Forecast Template
Product COGS %25.00%
NOTE: Since this is a public link please download the spreadsheet or make yourself a copy before changing the data. I don't the world to have your P&L!
2
www.selleraccountant.comOther COGS %33.00%How-to video
https://drive.google.com/file/d/1Vmrhh_7rM88Cz9teaSV4rNfrxpArmFAk/view
3
Expected Ad%5.00%
4
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
5
Operations
6
Expected Sales (less returns)$52,824$49,613$46,824$64,256$87,001$89,532$125,542$59,259$52,177$78,532$149,845$223,152
7
Product COGS$13,206$12,403$11,706$16,064$21,750$22,383$31,386$14,815$13,044$19,633$37,461$55,788
8
Other COGS$17,432$16,372$15,452$21,204$28,710$29,546$41,429$19,555$17,218$25,916$49,449$73,640
9
Gross Profit$22,186$20,837$19,666$26,988$36,540$37,603$52,728$24,889$21,914$32,983$62,935$93,724
10
Advertising Budget$2,641$2,481$2,341$3,213$4,350$4,477$6,277$2,963$2,609$3,927$7,492$11,158
11
Other Overhead/Expenses$9,500$9,500$9,500$9,500$10,500$10,500$10,500$11,000$11,000$10,500$10,500$12,000
12
Expected Impact from OPS (Operating Profit)$10,045$8,857$7,825$14,275$21,690$22,627$35,951$10,926$8,305$18,557$44,943$70,566
13
Financing
14
SBA Loan-$500-$500-$500-$500-$500-$500-$500-$500-$500-$500-$500-$500
15
Line of Credit-$750-$750-$750-$750-$750-$750-$750-$750-$750-$750-$750-$750
16
Amazon Lending$0$0$0$0$0$0$0$0$0$0$0$0
17
Expected New Loans (adding money to the business)
$0$0$0$0$0$0$0$0$0$25,000$0$0
18
Total Impact of Debt-$1,250-$1,250-$1,250-$1,250-$1,250-$1,250-$1,250-$1,250-$1,250$23,750-$1,250-$1,250
19
Inventory Impact
20
Expected Inventory Purchases-$12,403-$11,706-$16,064-$21,750-$22,383-$31,386-$14,815-$13,044-$19,633-$37,461-$55,788$13,206
21
22
Investing
23
Expected Owner investments$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
24
Expected profit distributions(and tax payments)$0.00$0.00$0.00-$8,017.97$0.00$0.00-$17,577.58$0.00$0.00-$16,554.56$0.00$0.00
25
Expected total from Investing$0.00$0.00$0.00-$8,017.97$0.00$0.00-$17,577.58$0.00$0.00-$16,554.56$0.00$0.00
26
27
EXP TOTAL CHANGE IN CASH FOR THE MTH
-$3,608-$4,099-$9,489-$16,744-$1,943-$10,009$2,308-$3,368-$12,578-$11,709-$12,095$82,522
28
Beginning Available Cash$125,000$121,392$117,292$107,803$91,060$89,117$79,109$81,417$78,048$65,471$53,762$41,666
29
Ending available Cash$121,392$117,292$107,803$91,060$89,117$79,109$81,417$78,048$65,471$53,762$41,666$124,189
30
31
Target Cash Available for rainy day(2x Overhead)$19,000$19,000$19,000$19,000$21,000$21,000$21,000$22,000$22,000$21,000$21,000$24,000
32
Surplus or (Deficit) In Cash Expected$102,392$98,292$88,803$72,060$68,117$58,109$60,417$56,048$43,471$32,762$20,666$100,189
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