Startup financial model, 3 years
A simple three year model for a subscription style startup. Enter your price, how many customers you start with and add, how fast the monthly intake grows, how many customers you lose, and your costs. The Model sheet works out 36 months of customers, revenue, cost of goods, salaries, other costs, profit before tax and cash. The Summary sheet gives each year's totals, the lowest cash balance, the first month cash would run out and a chart of cash. Download it as Excel, OpenDocument, PDF or CSV.
Inputs
Startup financial model, 3 years
Change the yellow assumptions. The Model sheet works out 36 months and the Summary sheet shows each year and your cash.
Company Lumen Meal Kits
First month 2027-01-01
Cash at the start 120,000.00
Price per customer per month 29.00
Customers at the start 0
New customers in the first month 40
Growth of new customers each month (%) 6
Customers lost each month (%) 4
Cost of goods (% of revenue) 45
Salaries per month 9,000.00
Salary increase each year (%) 5
Rent and tools per month 1,800.00
Marketing (% of revenue) 12
Model
Monthly model
Every cell is worked out from the Inputs sheet. Do not type here.
| Month number | Month | Customers at month end | New customers | Customers lost | Revenue | Cost of goods |
|---|---|---|---|---|---|---|
| 1 | 2027-01-01 | 40 | 40.0 | 0.0 | 1,160 | 522 |
| 2 | 2027-02-01 | 81 | 42.4 | 1.6 | 2,343 | 1,054 |
| 3 | 2027-03-01 | 123 | 44.9 | 3.2 | 3,553 | 1,599 |
| 4 | 2027-04-01 | 165 | 47.6 | 4.9 | 4,792 | 2,157 |
| 5 | 2027-05-01 | 209 | 50.5 | 6.6 | 6,065 | 2,729 |
| 6 | 2027-06-01 | 254 | 53.5 | 8.4 | 7,375 | 3,319 |
| 7 | 2027-07-01 | 301 | 56.7 | 10.2 | 8,725 | 3,926 |
| 8 | 2027-08-01 | 349 | 60.1 | 12.0 | 10,121 | 4,554 |
| 9 | 2027-09-01 | 399 | 63.8 | 14.0 | 11,565 | 5,204 |
| 10 | 2027-10-01 | 450 | 67.6 | 16.0 | 13,062 | 5,878 |
| 11 | 2027-11-01 | 504 | 71.6 | 18.0 | 14,617 | 6,578 |
| 12 | 2027-12-01 | 560 | 75.9 | 20.2 | 16,234 | 7,305 |
| 13 | 2028-01-01 | 618 | 80.5 | 22.4 | 17,919 | 8,063 |
| 14 | 2028-02-01 | 678 | 85.3 | 24.7 | 19,676 | 8,854 |
| 15 | 2028-03-01 | 742 | 90.4 | 27.1 | 21,512 | 9,680 |
| 16 | 2028-04-01 | 808 | 95.9 | 29.7 | 23,431 | 10,544 |
| 17 | 2028-05-01 | 877 | 101.6 | 32.3 | 25,441 | 11,448 |
| 18 | 2028-06-01 | 950 | 107.7 | 35.1 | 27,547 | 12,396 |
| 19 | 2028-07-01 | 1,026 | 114.2 | 38.0 | 29,756 | 13,390 |
| 20 | 2028-08-01 | 1,106 | 121.0 | 41.0 | 32,076 | 14,434 |
Summary
Summary by year
| Item | Year 1 | Year 2 | Year 3 | Words shown | |
|---|---|---|---|---|---|
| Revenue | 99,611 | 351,332 | 799,404 | None | |
| Cost of goods | 44,825 | 158,099 | 359,732 | ||
| Gross profit | 54,786 | 193,233 | 439,672 | ||
| Salaries | 108,000 | 113,400 | 119,070 | ||
| Rent, tools and marketing | 33,553 | 63,760 | 117,529 | ||
| Profit before tax | -86,767 | 16,073 | 203,074 | ||
| Customers at year end | 560 | 1,469 | 3,167 | ||
| Cash at year end | 33,233 | 49,306 | 252,379 | ||
| Lowest cash during the year | 33,233 | 23,414 | 57,193 | ||
| Months with a profit | 0 | 7 | 12 | ||
| First month with negative cash | None | ||||
| Gross margin in year 3 | 55.0% |
