Startup finance
How to Build a SaaS Financial Model: Revenue, Costs, Cash
A SaaS financial model is a spreadsheet financial model that turns a short list of drivers (new customers, price, churn, hiring) into monthly revenue, costs, profit and cash. Build it in a fixed order: assumptions first, then the revenue build, then costs, then cash and the three statements, and last the scenarios.
What a SaaS financial model does for a startup
A SaaS financial model answers two questions about the financial health of a SaaS business. How much recurring revenue will the business have in 12, 24 and 36 months, and how much cash will it burn to get there? Corporate Finance Institute describes the usual deliverable as a spreadsheet that forecasts the income statement, balance sheet and cash flow statement, with supporting schedules and key metrics on top. Kruze, a startup accounting firm, notes that investors typically expect all three statements on an accrual basis when you report to a board or raise money.
Recurring revenue makes forecasting easier than in most businesses, because a customer who pays you this month is likely to pay next month too. It also makes it easier to fool yourself, because small errors compound every month. A forecast that simply says “grow 20% a month” hides every assumption that matters. The point of a driver-based SaaS financial model is that each number on the output can be traced back to an input you can argue about.
Budgets and forecasts overlap with a financial model for startups, and the startup budget and forecast guide covers the spending side. This page focuses on the build itself.
Step 1: list the drivers of your SaaS financial model
A driver is an input that moves the output. For a subscription product the short list usually looks like this:
- Customers at the start of the forecast and average revenue per account (ARPA).
- New customers per month, ideally built from leads, conversion rate and sales capacity rather than typed in as a round number.
- Monthly churn, meaning the share of customers or revenue lost each month.
- Expansion, which is extra revenue from upgrades and added seats, and contraction from downgrades.
- Price changes and their timing.
- Gross margin inputs: hosting, support and payment fees per customer.
- Hiring dates and salaries, plus a load for payroll taxes and benefits.
- Opening cash, and any planned funding.
Put these on one assumptions tab of the financial model, with one cell per input and a note on where each number came from. Orb’s guide suggests starting from the most recent MRR if you have history, and from the target pricing plan if you do not. HubiFi recommends collecting at least two years of history (MRR, acquisition costs, operating expenses) when the company has it, and cleaning the data before it goes in. A pre-launch SaaS company has no history, so label every input as a guess and replace it as real data arrives.
Step 2: build the SaaS revenue forecast
Revenue is the part most readers come for, and the cleanest structure is a waterfall of monthly recurring revenue (MRR) that you roll forward each month. Corporate Finance Institute gives the identity in terms of annual recurring revenue, and notes that MRR can be used instead:
Ending MRR = starting MRR + new MRR + expansion MRR - churned MRR
Orb breaks the build into five moves: set the baseline, project new and expansion MRR from the acquisition rate and deal size, subtract churn and contraction, adjust for pricing changes and seasonality, then run scenarios. Corporate Finance Institute adds that you should split customers into segments by industry, region or pricing tier, but not so finely that the split stops adding information.
Two practical points:
- Calculate the churn rate on the same base as the revenue. If you forecast customer counts, churn is a share of customers. If you forecast MRR, churn is a share of starting MRR. Mixing the two is a common reason the revenue line does not match the customer line.
- Separate new, expansion and churned revenue on three rows, even if expansion is zero today. The waterfall is what lets you see later whether growth comes from fresh sales or from existing accounts.
Add cohort analysis once you have history
A flat churn rate treats every customer alike, and real customers do not behave that way. Stripe’s guide on SaaS cohort analysis describes the standard layout: one row per sign-up month, one column per month since sign-up, healthy cohorts flattening out and weaker ones falling away. The same guide warns that cohorts which are too small produce noisy numbers and cohorts which are too broad hide differences.
In a SaaS financial model, cohorts replace the single churn rate input. You take the retention curve of recent cohorts, extend its flattening tail forward, and apply it to each month’s new customers. The method needs several months of data, so early companies start with one rate and switch later. For the retention and churn formulas themselves, see SaaS math: activation, retention and churn.
Step 3: model expenses and gross margin
Start with the cost of delivering the product: hosting, customer support, payment processing and any direct delivery labor. Revenue minus these costs is gross profit. Founderpath, citing the Benchmarkit 2026 report on 342 companies, reports a median software gross margin of 80% in 2025, with a median of 72% for companies under $5 million of ARR. Treat that as a reference range for a SaaS business, since your own number depends on how you classify support and onboarding.
Operating expenses come next. Orb and HubiFi both split them into sales and marketing, research and development, and general and administrative. Within each, mark which lines are fixed (rent, base salaries) and which are variable (commissions, ad spend that scales with volume). The split matters because a downside scenario needs to know which costs fall automatically when sales slow and which need a decision.
Headcount deserves its own schedule: role, start date, salary, and a payroll tax and benefits load. Model the date a person starts in your financial model, not the date you approve the role.
Sales and marketing connects back to the revenue forecast through customer acquisition cost (CAC). If your model assumes 15 new customers a month, it should also assume what winning those customers costs. The unit economics guide on CAC, LTV and payback explains how to measure that number.
Step 4: forecast cash flow and link the financial statements
Profit and cash are different numbers, and a SaaS company shows the gap clearly. A customer who pays $12,000 for a year upfront brings in $12,000 of cash on day one, but revenue is recognized at $1,000 a month as the service is delivered. Founderpath uses the same example: the unearned part sits on the balance sheet as deferred revenue, a liability, until it is earned.
The cash flow statement starts from net income, adds back non-cash items such as depreciation and stock-based compensation, adjusts for changes in working capital (receivables, deferred revenue, payables), subtracts capital expenditure, and adds financing flows such as a funding round or loan repayment. Corporate Finance Institute describes the same sequence. Kruze points out two classification details founders often miss: a SAFE counts as equity on the balance sheet, while a convertible note counts as debt.
A three-statement financial model passes one test. Ending cash on the cash flow statement must equal the cash line on the balance sheet, and the balance sheet must balance. If either check fails, something is linked wrongly. The companion guide on startup financial statements shows how the three connect.
Early on, a monthly cash view may be all you need. For the short term, the 13-week cash flow forecast is a better tool than a 36-month model.
Step 5: run scenario analysis and check the key metrics
Orb and HubiFi both recommend three versions of the forecast: conservative (lower growth, higher churn), base, and optimistic (higher growth, lower churn). Change a handful of inputs only, for example new customers, churn, price and hiring dates, and keep everything else fixed. Three cases that differ in thirty ways teach you nothing.
Then read the outputs of the SaaS financial model. These are the ones worth checking:
- Ending MRR or ARR at 12 and 24 months.
- Monthly burn and months of runway at each point. See burn rate and runway for the arithmetic.
- Customer lifetime value (LTV) to CAC, and the payback period on acquisition spend. Corporate Finance Institute cites an LTV to CAC ratio of 3:1 or higher as a healthy level.
- Rule of 40, the sum of revenue growth and profit margin, with 40% or more as the common bar for software companies. Both Corporate Finance Institute and HubiFi describe it that way.
- The month the lowest cash balance occurs, and how much headroom remains.
HubiFi suggests updating the model monthly or quarterly. A model that is never compared with actuals turns into a pitch document.
A hypothetical 12-month SaaS financial model example
All figures below are invented to show the mechanics. They are not benchmarks. Assumptions:
- Opening position: 40 customers, $200 average monthly revenue per customer, $600,000 in the bank.
- New customers: 10 in month 1, growing 5% a month.
- Churn: 3% of customers each month.
- Expansion: revenue per customer rises 1% a month.
- Cost of revenue: 22% of revenue, so a 78% gross margin.
- Sales and marketing: $12,000 a month plus $350 for each new customer.
- Research and development: $22,000 a month, rising to $23,500 from month 7 for one hire.
- General and administrative: $8,000 a month.
- Customers pay monthly, so cash equals profit in this simplified version.
| Month | New | Churned | Customers | MRR | Gross profit | Operating costs | Net cash flow | Cash at end |
|---|---|---|---|---|---|---|---|---|
| 1 | 10.0 | 1.2 | 48.8 | $9,858 | $7,689 | $45,500 | -$37,811 | $562,189 |
| 3 | 11.0 | 1.7 | 67.1 | $13,832 | $10,789 | $45,859 | -$35,070 | $490,648 |
| 6 | 12.8 | 2.6 | 96.7 | $20,532 | $16,015 | $46,467 | -$30,452 | $394,528 |
| 9 | 14.8 | 3.5 | 129.3 | $28,282 | $22,060 | $48,671 | -$26,611 | $309,177 |
| 12 | 17.1 | 4.6 | 165.5 | $37,299 | $29,093 | $49,486 | -$20,393 | $241,566 |
By month 12 MRR is about $37,300 and the monthly burn has fallen from roughly $37,800 to $20,400, but the company has still spent about $358,000 of its $600,000. At the month-12 burn, $241,566 covers about 11.8 months. That runway figure is the number a seed investor would look at next to the MRR growth, and it tells the founder to start the next raise in the second half of the year, not at the end of it.
Now the scenarios, changing one thing at a time:
| Scenario | Change | Customers, month 12 | MRR, month 12 | Cash, month 12 |
|---|---|---|---|---|
| Base | none | 165.5 | $37,299 | $241,566 |
| Higher churn | 5% a month | 147.2 | $33,166 | $224,470 |
| Slower sales | 20% fewer new customers | 138.0 | $31,090 | $223,793 |
| Faster retention | 2% churn, 7% monthly growth in new customers | 194.4 | $43,820 | $256,736 |
The result is easy to misread. Cash moves only by $17,000 to $18,000 in the weak cases, because fewer new customers also means lower acquisition spend. The damage shows up in MRR instead: 17% lower in the slower-sales case, which is the figure the next investor will price. A model that tracks only cash would call that scenario survivable and miss the problem.
A small cohort check ties back to Step 2. At 3% monthly churn, a group of 100 customers shrinks to about 91 after three months, 83 after six and 69 after twelve. With 1% monthly expansion on the survivors, the revenue from that group is still about 78% of its starting level after a year. Gross retention and net retention are different numbers, and a model should show both.
Common mistakes
- Typing a growth percentage into revenue instead of building it from drivers.
- Forgetting payment timing, so the model shows profit while the bank balance falls.
- Starting salaries on the approval date.
- Using one churn rate forever, even after cohort data shows it changes with age.
- Linking nothing, so the three statements do not agree.
- Building scenarios that change too many inputs at once.
- Presenting a five-year model with monthly detail when only the first year can be estimated with any confidence. In our view, monthly detail past year two adds precision the inputs cannot support.
More finance slips are collected in top finance mistakes startups make. Another view of the same topic is the piece on what makes a financial model good.
Questions readers ask
How long does it take to build a SaaS financial model? A one-sheet revenue and cash model can be built in a day if the drivers are known. A full three-statement version with cohorts takes longer, and most of that time goes to collecting reliable inputs.
Excel, Google Sheets or dedicated software? A spreadsheet is enough for a SaaS business at early stage. Corporate Finance Institute describes the typical model as an Excel spreadsheet. Dedicated planning tools help once several people edit the model.
Which metrics should a SaaS financial model output? MRR or ARR, gross margin, burn, runway, customer acquisition cost, LTV to CAC and net revenue retention are the usual set.
Should the model be top-down or bottom-up? Bottom-up for revenue, because each driver can be tested. Top-down is useful as a sanity check on market size.
How often should I update the model? Monthly, using actuals from the closed books, with a fuller review each quarter.
Sources and limits
- Corporate Finance Institute, “SaaS Financial Modeling: A High-Level Overview” (corporatefinanceinstitute.com), August 2024: model structure, ARR waterfall, LTV to CAC and Rule of 40.
- Orb, “Building a SaaS financial model” (withorb.com), undated, accessed November 2026: revenue build, cost structure, scenarios.
- HubiFi, “How to Build a SaaS Financial Model in 5 Steps” (hubifi.com), October 2025: historical data, scenario analysis, update cadence.
- Stripe, “SaaS cohort analysis” (stripe.com), updated January 2026: cohort layout and caveats.
- Founderpath, “SaaS Financial Statements Guide” (founderpath.com), accessed November 2026: deferred revenue and the Benchmarkit gross margin figures, which we did not check against the original report.
- Kruze Consulting, “3 Financial Statements” (kruzeconsulting.com), updated June 2026: statement expectations, SAFE and convertible note treatment.
Most sources are software vendors or advisory firms, and several are marketing pages for financial model templates, so their thresholds are rules of thumb. The worked example uses invented numbers and simplified billing; real models also handle taxes, annual prepayment and working capital. This page is general information and not accounting, tax or legal advice.