A free startup financial model in Excel: SaaS, 24 months, burn and runway
New customers and churn to MRR and ARR, gross margin, marketing spend from CAC, a growing team, net burn and cash month by month, the month cash runs out, unit economics and the round size needed: four sheets, no macros.
The file follows a fictional B2B software startup with 1.5 million in the bank. It signs 8 customers in month one, 8% more each month, at 300 a month each, and loses 2.5% of its customers a month. By month 24 it has 442 customers and 1.59 million of ARR, with healthy unit economics: LTV to CAC of 5.2 and a CAC payback under 8 months. But the team grows 3% a month, so cash runs out in month 13, and the company needs a round of about 4.7 million to cover the deficit and keep 18 months of runway.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Startup_Financial_Model_SaaS.xlsx (19 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with Venture Capital, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 10 paperbacks by Julian R. Sterling on tax and incentives, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Four sheets. Inputs are blue cells on a pale blue fill on the Inputs sheet.
Read me
What the file does and its conventions.
Inputs
Starting cash, new customers and their growth, ARPA, churn, gross margin, CAC, team cost and its growth, other costs, and the runway to keep.
Monthly
24 columns: new and lost customers, customers, MRR, revenue, cost of revenue, gross profit, sales and marketing, team, other costs, net burn, cash and ARR.
Summary and Checks
Customers, MRR and ARR at month 24, revenue and burn, lowest cash, the month cash goes negative, the round needed, LTV, LTV to CAC, CAC payback and burn multiple; then the checks: all OK.
What the worked case returns
Measure
Value
Customers at month 24
442
ARR at month 24
1,589,908
Revenue over 24 months
1,242,216
Net burn over 24 months
3,278,734
First month cash goes below zero
13
Round needed (deficit plus 18 months)
4,730,012
LTV to CAC
5.2x
CAC payback
7.7 months
Good unit economics do not prevent running out of cash. Each customer here repays its acquisition cost in under eight months, but the team is hired ahead of revenue, and the gap between spending now and earning later is what the round pays for.
How to use it on your own startup
Enter your cash, customer growth, price and churn on Inputs.
Enter CAC, gross margin and your team and other costs.
Read cash month by month and the month it goes negative on Monthly.
Read the round needed and the unit economics on Summary.
Questions people ask about it
Is this template really free?
Yes. The file costs nothing: you enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference: one column a month.
How is runway calculated?
Cash is rolled forward each month by revenue less every cost. Runway ends in the first month the balance goes below zero: month 13 here.
Can I use it for my own startup?
Yes, by replacing the inputs. The company is fictional, and nothing here is investment advice.
Go further
For how investors read a model like this one, and what a round costs the founders, Venture Capital and its companion workbooks go further.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.