ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
7
General AssumptionsInvestorsMonth of Operation Invested
8
Company NamePayHelpaNameValue
9
Projection Start Month1/4/2023Seed Round Equity $ 1,000,000 1
10
11
Accounts Payable Terms
12
% of operating expenses paid in month incurred80%
13
% of operating expenses paid on 1 month delay20%
14
19
Fixed AssetsValueLife Expectancy in YearsSalvage CostPurchased during which month of operation?Fixed Asset Categories
20
NameCategory(up to 6)
21
TrademarkIntangibles $ 1,000 10 $ - 0Intangibles
22
Employee EquipmentEquipment $ 15,000 10 $ - 0Equipment
23
Employee EquipmentEquipment $ 15,000 10 $ - 15
24
25
26
35
36
For assets with an indefinite usable life (land, trademarks, etc), set salvage value equal to current value and life expectancy to any value greater than 0.
37
38
39
LoansOriginal Amount
(Or Outstanding Amount as of Month 1)		First Payment Month (use 1 for Existing Loans)
40
NameInterest RateNumber of Monthly Payments (Remaining)
41
Business Loan $ 130,000 1 2.00%12
42
43
50
51
52
53
How Much Cash Do I Need?
54
55
Working Capital Needed 798,000
Funds to cover operating losses & loan payments until positive cash flow is achieved
56
Months until Positive Cash Flow 14
Number of months the working capital will cover
57
58
Cash needed for Fixed Assets $ 16,000
59
60
Reccomended Buffer $ 90,000
10% buffer to account for unforseen circumstances and overages
61
Total Cash Needed $ 904,000
Cash needed to start business and reach positive cash flow - can come from investments, loans, or both
62
63
Cash from Investments (Above) $ 1,000,000
64
Cash from Loans (Above) $ 130,000
65
66
Total Starting Cash in Model $ 1,130,000 Check:Starting Cash is Sufficient
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
114
115
116
117
118