What a SaaS financial model needs to do
A SaaS financial model is not a spreadsheet of optimistic revenue projections. It is a dynamic tool that translates your assumptions about the business into quantified outcomes — and that updates automatically when those assumptions change.
A well-built model does five things that no business plan narrative can do on its own:
- Shows exactly when you run out of cash under current assumptions
- Calculates your break-even MRR and how long it realistically takes to get there
- Makes the compounding impact of churn visible before it becomes a crisis
- Quantifies how much capital you need to raise and what milestones that buys you
- Lets you stress-test scenarios in minutes rather than discovering them in reality
The goal of this guide is to walk you through building that model from scratch — or at least understand exactly what a good model contains, so you can evaluate whether the one you're using is built correctly.
The structure: inputs, calculations, outputs
Before building anything, establish the architecture. A clean SaaS financial model has three distinct layers:
Inputs sheet — every assumption that drives the model lives here and only here. Pricing, subscriber growth rates, churn rate, headcount, salaries, infrastructure costs, marketing spend. Nothing is hardcoded into formulas. When you want to test a scenario, you change one number in the inputs sheet and every output updates automatically.
Calculation sheets — these sheets contain all the formulas. Revenue builds from subscriber counts and pricing. Costs build from headcount and rates. Cash flow builds from revenue minus costs. No hardcoded numbers — only references to the inputs sheet or other calculation sheets.
Output sheets — these are the summary views: income statement, cash flow statement, balance sheet, SaaS metrics dashboard. These reference the calculation sheets and present results cleanly. These are what you share with investors.
This separation matters because it makes the model auditable, maintainable, and trustworthy. A model where assumptions are scattered throughout formulas is a model that breaks without warning.
1. Build your revenue model
Start with your pricing structure. If you have multiple plans, list each one with its monthly price. Then define your assumptions for how many new subscribers you expect to acquire each month at each plan tier.
New subscribers per month is your primary growth driver. Be realistic — most early-stage SaaS products add 10–50 net new subscribers per month in their first year. Overstating this is the most common modelling error.
Your revenue formula for each period is:
Also include any one-time setup fees, transaction fees, or usage-based revenue as separate line items — but never roll them into MRR. Keep recurring and non-recurring revenue clearly separated.
2. Model churn correctly
This is where most founders' models break down. Churn is not subtracted from a static number — it is applied to the beginning-of-period subscriber count each month, compounding over time. The correct structure is:
Churned Subscribers = Beginning Subscribers × Monthly Churn Rate
New Subscribers = From inputs assumption
Ending Subscribers = Beginning − Churned + New
This structure means that as your subscriber base grows, the absolute number of churned subscribers each month also grows — even if the churn rate stays constant. A model that applies churn as a fixed absolute number rather than a percentage will significantly overstate your subscriber count in later years.
Build this for each plan tier separately if your plans have different churn rates. Higher-priced plans typically retain better — and getting this right affects your blended ARPU trajectory over time.
Annual equivalent = 1 − (1 − monthly churn)^12
3. Build your cost model
Your cost model has two components: cost of revenue (what it costs to deliver your service) and operating expenses (what it costs to run the business). Keeping these separate gives you gross margin as an output — which is essential for calculating break-even and LTV.
Cost of revenue (COGS) includes:
- Cloud infrastructure and hosting costs
- Payment processing fees (model as a percentage of revenue)
- Customer success and support salaries (allocated to COGS)
- Third-party API and service costs that scale with usage
Operating expenses include:
- Engineering and product salaries (R&D)
- Sales and marketing salaries plus ad spend
- General and administrative costs
- Tooling, subscriptions, and office costs
Model headcount as a schedule — not a flat number. Each role has a start month, an annual salary, and benefit loading (typically 20–25% on top of base). This makes the cost model dynamic: adding a hire in month six shows up as a step-change in burn from that month forward, which is exactly how it works in reality.
4. Calculate gross margin
Gross margin is revenue minus cost of revenue, expressed as a percentage. It tells you how much of each MRR dollar is available to cover operating expenses — and it directly feeds your LTV calculation and break-even analysis.
Gross Margin % = Gross Profit ÷ Revenue × 100
Target 70–85% gross margin. If you're below 70%, your infrastructure or service delivery costs are high relative to revenue — which pushes your break-even MRR higher and reduces your LTV.
Track gross margin monthly. In the early stage it will be lower than your long-term target because fixed infrastructure costs are spread across fewer subscribers. As you scale, the fixed portion of COGS gets diluted and gross margin should expand naturally — unless your variable costs are growing faster than revenue, which is an early warning sign worth catching in the model.
5. Build your cash flow model
Revenue minus total costs gives you net income. But net income is not cash flow — and for a pre-revenue SaaS startup, the difference matters enormously. Your cash flow model needs to show the actual cash position of the business each month, accounting for:
- Operating cash flow — net income adjusted for non-cash items like depreciation
- Investing cash flow — capital expenditures on equipment and infrastructure
- Financing cash flow — equity investment rounds and any debt drawn or repaid
The number you care about most is the month when ending cash goes negative — your cash-zero date. Every assumption in your model affects this date. Hiring one more engineer moves it forward by two months. Cutting paid acquisition spend moves it back. A 1% improvement in churn moves it back by three to four months over a 24-month horizon.
Your cash flow model makes all of these trade-offs visible and quantified — so you can make decisions from a position of clarity rather than anxiety.
The five outputs every investor expects
Once your model is built, the outputs should be organised into presentation-ready sheets. Here are the five outputs that belong in every SaaS financial model:
Common mistakes to avoid
Hardcoding assumptions into formulas. If your revenue formula contains the number 79 rather than a reference to a cell called "Plan B Monthly Price", changing your pricing breaks the model in unpredictable ways. Every assumption belongs in the inputs sheet.
Building annual columns instead of monthly. An annual model cannot show you your cash-zero date, cannot model churn correctly month by month, and will not satisfy an investor who wants to see your cash flow trajectory. Monthly columns are non-negotiable.
Applying churn as a fixed number rather than a rate. If you subtract 10 churned subscribers per month regardless of how many subscribers you have, your model significantly overstates your subscriber count in years three through five. Churn must be calculated as a percentage of beginning-of-period subscribers each month.
Overstating new subscriber growth. The most common model error by far. Most pre-revenue founders project 20–30% month-on-month subscriber growth. Most early-stage SaaS products add 10–30 net new subscribers per month in their first year. Model conservatively and let reality beat your projections rather than the other way around.
Forgetting employer-side payroll costs. Salaries in your model should include benefit loading — payroll taxes, health insurance, and other employer-side costs typically add 20–25% to base salary. Forgetting this understates your burn rate by a meaningful amount when you have multiple hires.
Build from scratch or use a template?
Building a SaaS financial model correctly from scratch takes an experienced financial modeller 40–80 hours. The structure needs to be right — inputs separated from calculations, churn compounding correctly, gross margin feeding LTV, cash flow reconciling to the balance sheet. A single structural error compounds across all 60 months and produces outputs you can't trust.
For most founders, the right answer is to start with a purpose-built template that has the correct structure already in place — then spend your time on the assumptions that are specific to your business, rather than on debugging whether the formulas are right.
A good SaaS financial model template should:
- Have all assumptions centralised in a single inputs sheet
- Build revenue from subscriber counts and pricing tiers, not top-line growth rates
- Compound churn correctly month by month against the beginning subscriber count
- Calculate gross margin as a separate output from COGS and operating expenses
- Produce a monthly cash flow statement with a clearly visible cash-zero date
- Calculate all six key SaaS metrics automatically — MRR, ARR, churn, CAC, LTV, NRR
- Include a 3-statement model (P&L, balance sheet, cash flow) for investor and lender submissions
SaaS Financial Model Template
Everything described in this guide — the correct churn model, monthly cash flow, gross margin calculation, all six SaaS metrics, and a full 3-statement financial model — already built and ready to use. Input your assumptions and get your cash-zero date, break-even MRR, and investor-ready outputs in minutes. Available in Excel and Google Sheets.
- Inputs-driven architecture
- Monthly MRR & ARR forecast
- Correct churn waterfall
- CAC, LTV & NRR metrics
- Cash runway & zero date
- 3-statement financial model
- Investment returns (IRR, NPV)
- Excel & Google Sheets
SaaS Startup Costs: How Much Does It Really Cost to Launch?
Engineering, infrastructure, hiring, and marketing — a complete breakdown of what a self-serve SaaS costs before revenue.
SaaS MetricsMRR, ARR, CAC, LTV Explained — The SaaS Metrics Every Founder Must Track
A plain-English guide to the six metrics investors will ask about in your first meeting.
Break-Even AnalysisSaaS Break-Even Analysis: How Much MRR Do You Need to Cover Your Costs?
Calculate the exact MRR required to cover your monthly burn — with a real worked example and the break-even formula.