A good SaaS financial model template is built from five connected tabs: an assumptions tab you actually edit, a revenue model driven by MRR and churn, the three linked statements, a unit economics tab, and a dashboard. The single rule that separates a model that works from one that breaks: you change an assumption in one place, and every downstream number updates automatically. Hardcoded numbers scattered across tabs are why most founder spreadsheets fall apart.
This guide is the tactical companion to our conceptual pillar on how a SaaS financial model works. That one explains the thinking; this one is the blueprint, the exact tabs and rows, so you can build a template or evaluate one. If you would rather not maintain a spreadsheet at all, skip to the end.
The five tabs every SaaS model template needs
| Tab | What it holds | Rule |
|---|---|---|
| 1. Assumptions | Every input: growth, pricing, churn, CAC, hiring plan, cost ratios | The ONLY place you type numbers. Everything else references it. |
| 2. Revenue model | New customers, MRR/ARR build, churn and expansion | The MRR waterfall: start + new + expansion − churn = end. |
| 3. Three statements | P&L, balance sheet, cash flow, linked | Auto-linked from revenue + costs. Cash flow ties to the balance sheet. |
| 4. Unit economics | CAC, LTV, payback, LTV:CAC | Derived from the revenue and cost assumptions, not typed in. |
| 5. Dashboard | Headline metrics, runway, charts for the board | Read-only summary. Pulls from everything above. |
The flow is one direction: assumptions feed the revenue model, the revenue model and cost assumptions feed the three statements, the statements feed unit economics and the dashboard. Change churn on the assumptions tab and your MRR, cash flow, runway and LTV:CAC all move together.
What goes in the assumptions tab
This is the tab you live in. Group inputs so they are easy to find and stress-test:
- Revenue drivers: new customers per month (or lead-to-customer funnel), pricing/ARPA, monthly churn, expansion rate.
- Cost drivers: gross margin or COGS ratio, headcount plan by function with fully loaded cost, sales and marketing spend, other opex.
- Cash and financing: starting cash, billing terms (monthly vs annual upfront), any funding.
Colour the input cells (blue is the convention) so anyone opening the model knows what is safe to change and what is a formula.
Top-down vs bottom-up
Build revenue bottom-up: start from your actual acquisition channels and conversion, not from "we will capture 1% of a huge market." Investors discount top-down TAM slides fast. A bottom-up build (leads, conversion, new customers, MRR) is defensible because every number traces to something you can influence. Use top-down only as a sanity check on the bottom-up result.
The mistakes that break founder models
- Hardcoding. Typing a number into a formula cell instead of referencing the assumptions tab. One month you update the assumption and half the model ignores it.
- Overestimating revenue, underestimating CAC. The two errors that flatter the model and blow up in diligence. Anchor to benchmarks: CAC payback commonly runs 12 to 18 months for B2B SaaS (Benchmarkit 2025), and LTV:CAC of 3:1 is the target that only around 44% of companies actually hit.
- Ignoring cash timing. Booking revenue when a deal closes rather than when cash arrives. Annual upfront and net-60 terms change runway materially.
- Static headcount. Assuming the team never grows. Hiring is usually the biggest cost lever; model it explicitly.
- No scenarios. A single base case is a guess. Build at least a downside so you know your runway if you hit 80% of plan.
Try the unit economics math below with your own numbers to sanity-check the model's assumptions:
Frequently asked questions
What should a SaaS financial model template include?
Five connected tabs: assumptions (all inputs), a revenue model with the MRR waterfall, the three linked financial statements, unit economics (CAC, LTV, payback), and a dashboard. Everything references the assumptions tab so one change flows through.
How do I build a financial model from scratch?
Start with the assumptions tab, build the bottom-up revenue model from acquisition and churn, link the three statements to it, derive unit economics, and summarise on a dashboard. Build revenue bottom-up, not from top-down market share.
Should I use Excel or Google Sheets?
Either works for a template. Google Sheets is easier to share and collaborate on; Excel has more modelling power. The bigger issue is that both break down as the model grows, which is when founders move to dedicated software.
What is the difference between top-down and bottom-up modelling?
Bottom-up builds revenue from your actual drivers (leads, conversion, customers, price). Top-down starts from market size and a share assumption. Build bottom-up; investors trust it more and it is easier to defend.
Why do spreadsheet models break?
Hardcoded numbers, broken formula links, no version control, and no live data. They are fine early and get fragile as assumptions multiply, which is the point most founders move to a tool.
Or skip the spreadsheet
A template is a great way to learn the mechanics. But every spreadsheet model eventually hits the same wall: assumptions sprawl, formulas break, and there is no live connection to your billing or bank. Adlega is the model as software, built for SaaS. The five tabs above come pre-wired: a driver-based assumptions layer, an MRR waterfall, three linked statements, unit economics and a dashboard, all connected so one change flows through, plus an AI CFO that explains any number with formula-level traceability. It updates on live data instead of manual paste, and never breaks when you insert a row. Build your SaaS model free in Adlega while it is in beta.
Related: how a SaaS financial model works, building a model for investors, and the best SaaS modeling software.