How to Build a SaaS Financial Model (With a Free Template)
12 MIN READ
|
Updated on July 22, 2026
What Is a SaaS Financial Model?
A SaaS financial model is a forecast that projects a subscription business’s revenue, costs, and cash flow from the way it earns money: recurring plans, expansion, churn, and increasingly, usage- and outcome-based charges.
It ties operating assumptions, such as new customers, retention, and pricing, to the metrics finance and investors track, including MRR, ARR, gross margin, and burn. A good model doesn’t just report the past. It shows how a decision made today changes the numbers 12, 24, or 36 months out.
That definition hides a trap.
A model is only as accurate as the revenue streams it can represent. Most recurring-revenue companies now blend subscription with usage- or outcome-based pricing, so a spreadsheet that assumes flat monthly fees forecasts a business that no longer exists.
This guide walks through what belongs in a modern model, a four-layer framework for building one, and how to represent usage and hybrid revenue that older templates leave out.
Prefer to start from a working file?
Grab the free SaaS financial model template, built for both subscription and usage-based revenue, and fill it in as you read.
Related reading: SaaS KPIs covers the metrics your model should output.
Why a SaaS Financial Model Differs From a Traditional Model
A traditional financial model assumes a sale is a single event. You sell a unit, book the revenue, and move on. Recurring revenue breaks that assumption in four ways, and a model that treats a subscription like a one-time sale will misstate almost every line.
First, revenue recurs and compounds. One customer who pays $500 a month is worth far more than a $500 one-time sale, and the model has to carry that customer forward across periods.
Second, revenue is deferred: cash collected upfront for an annual plan is earned month by month, so bookings, billings, and recognized revenue diverge.
Third, churn erodes the base every period, so growth is a race between new revenue and lost revenue. Fourth, existing customers expand, so the same account can grow without a new sale.
Now a fifth shift is reshaping the model again. 51% of recurring-revenue companies combine subscription with usage- or outcome-based pricing, while 75% retain a subscription element, according to the Chargebee State of Recurring Revenue & Monetization Report (n=473).
A subscription-only model can’t represent the consumption revenue that half the market now earns. For teams weighing that shift, our hybrid pricing guide breaks down how the two models combine in practice.
The 4 Layers of a SaaS Financial Model
Most templates stop at revenue and a rough profit-and-loss (P&L) statement, which is why they look precise but can’t answer a real planning question. A complete model has four connected layers. We call this framework the SaaS Financial Model Stack, and each layer feeds the one above it: get the bottom wrong and everything above it drifts.
Layer 1 — the revenue model (MRR/ARR build)
The base layer projects recurring revenue. Start with monthly recurring revenue (MRR), then build it forward with a simple identity: beginning MRR, plus new MRR, plus expansion MRR, minus contraction MRR, minus churned MRR, equals ending MRR.
Annual recurring revenue (ARR) is that figure times 12. This waterfall is the spine of the model, because every other layer reacts to how recurring revenue grows and decays.
Layer 2 — the P&L (COGS, gross margin, operating expenses)
The second layer turns revenue into profitability. Cost of goods sold (COGS) for SaaS covers hosting, third-party infrastructure, support, and payment processing, and subtracting it from revenue gives gross margin.
Below that sit operating expenses: sales and marketing, research and development, and general and administrative costs. This layer shows whether the growth in Layer 1 is efficient or bought at any price.
Layer 3 — unit economics (CAC, LTV, LTV:CAC, payback)
The third layer tests whether the business model works one customer at a time. Customer acquisition cost (CAC) is the fully loaded cost to win an account. Lifetime value (LTV) estimates the gross profit a customer generates before churning.
The LTV:CAC ratio and CAC payback period, the months to recover acquisition cost, tell you whether each new customer funds the next. Weak unit economics turn fast growth into a faster cash burn.
Layer 4 — scenarios and drivers (base/best/worst, fundraising cases)
The top layer is what makes the model decision-useful, and it’s the one most spreadsheets skip. Instead of hard-coded numbers, connect the model to drivers: conversion rate, average deal size, churn rate, and pricing. Then flex those drivers into base, best, and worst cases, plus a fundraising scenario that shows the runway a round buys.
A model without this layer can describe a plan. It can’t answer “what happens if we change pricing,” which is the question that matters most.
How to Model Usage-Based and Hybrid Revenue
Here’s where most templates break. Usage revenue is variable and consumption-driven, so the flat MRR assumption in Layer 1 stops working.
An AI-native company that bills on tokens, compute, or inference can’t forecast on seats, and the felt pain is real on both sides of the house: finance flies blind on consumption until the invoice lands, and engineering rebuilds the model every time the metering logic changes.
The fix is to model usage as a driver, not a fixed line. For each metered product, the revenue formula is units consumed times rate, projected from expected adoption and consumption curves rather than a single monthly number.
You layer that variable revenue on top of any recurring base, which is why hybrid models need both a subscription waterfall and a usage projection running side by side. The payoff shows up in margins: 67% of companies using a hybrid pricing model expect improved margins, compared with 32% of those on pure usage-based pricing, per the same Chargebee report.
This shift is accelerating with AI.
80% of companies adding AI to their products are also evolving their pricing, and those that align pricing with AI innovation are 2x more likely to grow fast, the report found. The hard part is cost visibility: over 80% of companies identify cost-related issues as their biggest AI monetization hurdle, and the two top usage-based pricing challenges are explaining the pricing structure to customers (22%) and building and maintaining metering infrastructure (21%).
A model can only represent usage revenue accurately if it draws on accurate metering data.
This is where billing infrastructure matters: Chargebee Billing meters usage such as API calls, tokens, compute, and seats, and bills flat, usage-based, and hybrid models natively, so the consumption numbers feeding your model reflect what customers were charged. For a deeper build, see the usage-based pricing playbook.
The difference between the two model types is stark once you lay them side by side.
| Dimension | Subscription-only model | Hybrid/usage-ready model |
|---|---|---|
| Revenue inputs | Seats and fixed plan tiers | Seats and plans plus metered units (API calls, tokens, compute) |
| Forecast driver | Fixed MRR per account | Recurring base plus units consumed times rate |
| Churn treatment | Plan cancellations only | Plan churn plus consumption decline |
| Data source | Manual entry, static assumptions | Metered billing data from the system of record |
| When it breaks | The moment you add usage or outcome pricing | Scales with new pricing models |
How to Build a SaaS Financial Model Step by Step
Most founders start from a downloaded template and never connect the drivers, so the model looks precise but isn’t decision-useful. Building it in order fixes that, because each step feeds the next.
Here’s a seven-step sequence.
- Set your assumptions and drivers. List the inputs that move the model: new customers per month, average contract value, conversion rate, churn rate, and pricing. Keep them in one clearly labeled tab so every downstream formula points back to a driver you can change.
- Build the recurring revenue model. Construct the MRR waterfall, beginning MRR plus new plus expansion minus contraction minus churn, and roll it forward month by month. Convert to ARR for annual views.
- Layer in usage and hybrid revenue. For each metered product, model units consumed times rate, then add that variable stream on top of the recurring base rather than folding it into flat MRR.
- Build the P&L. Subtract COGS to get gross margin, then add operating expense lines for sales and marketing, research and development, and general and administrative costs.
- Calculate unit economics. Derive CAC, LTV, the LTV:CAC ratio, and CAC payback from the revenue and expense layers so they update automatically as drivers change.
- Add scenarios. Duplicate the driver assumptions into base, best, and worst cases, plus a fundraising case, and confirm the outputs shift when you flex an input.
- Validate against benchmarks. Sanity-check growth, margins, and retention against known SaaS ranges, and pressure-test the assumptions that carry the most weight.
Work through this, and the model becomes a decision tool, not a static artifact. To see where these steps sit on a broader operational curve, review the SaaS finance ops maturity model.
Prefer to start from a working model? Open the free SaaS financial model template and follow these steps directly in it.
Which Metrics and Benchmarks to Track
A model is only useful if you track the outputs that reveal health, then compare them against a reference point. Seven metrics carry most of the weight for a SaaS business.
- MRR and ARR: recurring revenue on a monthly and annualized basis, the headline of any SaaS model.
- Gross and net revenue churn: the rate at which recurring revenue leaves, before and after expansion offsets it.
- Net revenue retention (NRR): revenue kept and expanded from existing customers; above 100% means the base grows without new sales.
- CAC payback: the months needed to recover the cost of acquiring a customer.
- LTV:CAC ratio: the value a customer returns relative to what it cost to win them.
- Burn multiple: net cash burned divided by net new ARR, a read on how efficiently growth is funded.
- Rule of 40: a widely used industry rule of thumb that a SaaS company’s growth rate plus profit margin should total at least 40; it’s a convention for balancing growth against profitability, not a hard threshold.
Track these monthly against forecast, and let the scenario layer show how each one moves when a driver changes.
How to Use the Free SaaS Financial Model Template
The free SaaS financial model template gives you the four layers already wired together, so you fill in assumptions and watch the outputs update. It’s among the most-used assets we publish, and it’s built to model both subscription and usage-based revenue.
Start in the input cells, marked in yellow, where you set your drivers: starting customers, new customers per month, churn rate, average revenue per account, and pricing. The revenue report then builds your MRR and ARR waterfall automatically, separating new, expansion, contraction, and churned revenue so you can see what’s driving the trend.
For hybrid businesses, the usage inputs let you model consumption revenue alongside the recurring base rather than forcing everything into a flat fee.
The P&L tab applies your cost assumptions to produce gross margin and operating results, and the metrics view surfaces unit economics and retention.
Change one driver, such as churn or pricing, and trace how it ripples through revenue, margin, and cash. That’s the point of a connected model: it turns a question into an answer in seconds.
When to Move Beyond a Spreadsheet
A spreadsheet is the right tool right up until it isn’t.
The break rarely announces itself. It shows up as multiple product lines, several geographies, and two or three pricing models colliding in one file, until the single-sheet forecast drifts from reality and no one fully trusts it. Manual entry errors compound quietly, and finance rebuilds the model from scratch every time pricing changes.
The felt cost is concrete: finance loses weekends at month-end reconciling numbers a system should have produced.
The signal to move is data, not size. A model runs on first-party subscription, payment, and usage data, and when that data lives in a spreadsheet keyed by hand, accuracy decays as the business grows. This is where connected billing infrastructure changes the math.
Chargebee Billing provides the first-party subscription, payment, and usage data a model runs on, with built-in MRR, ARR, and churn reporting and analytics so the numbers come straight from the system that charged the customer.
Revenue recognition under ASC 606 and IFRS 15 is a separate discipline, handled by Chargebee RevRec rather than the billing layer.
The payoff is validated pricing and a model you can trust. Limechat increased cash flow 2.5x in six months after validating its pricing model on Chargebee.
Frequently Asked Questions
What is a SaaS financial model?
A SaaS financial model is a forecast that projects a subscription business’s revenue, costs, and cash flow from how it earns money: recurring plans, expansion, churn, and usage- or outcome-based charges. It links operating assumptions to metrics such as MRR, ARR, gross margin, and burn, and shows how today’s decisions change the numbers over the next one to three years.
How is a SaaS financial model different from a traditional financial model?
A traditional model treats each sale as a one-time event. A SaaS model carries revenue forward across periods, separates deferred from recognized revenue, accounts for churn and expansion in every period, and increasingly represents usage- and hybrid-pricing streams that a single-sale model can’t capture.
How do you forecast MRR and ARR?
Build MRR forward month by month: beginning MRR, plus new MRR, plus expansion MRR, minus contraction MRR, minus churned MRR, equals ending MRR. ARR is ending MRR times 12. The monthly waterfall shows recuexactly which motion, acquisition, expansion, or churn, is driving the trend.
How do you model usage-based revenue?
Model usage as a driver, not a fixed line. For each metered product, the revenue formula is units consumed times rate, projected from expected adoption and consumption curves. Because usage is variable, layer it on top of any recurring base, and feed it accurate metering data rather than a flat monthly estimate.
What is the Rule of 40?
The Rule of 40 is a widely used industry rule of thumb: a SaaS company’s growth rate plus its profit margin should total at least 40. It’s a quick balance check rather than a strict standard — high growth can offset thin margins, and strong margins can offset slower growth.
How often should you update a SaaS financial model?
Update actuals against forecast monthly, so the model reflects real performance rather than stale assumptions. Review the scenario and driver assumptions quarterly, or sooner when you change pricing, launch a product, or raise a round.
Build the Model, Then Trust the Data Behind It
A SaaS financial model earns its keep when it represents how you make money, across subscription, usage, and hybrid revenue, rather than only the parts a flat spreadsheet can hold. Build it in four connected layers, model usage as a driver, and validate the outputs against benchmarks you trust.
Start from a working file rather than a blank sheet: the free SaaS financial model template is set up for both subscription and usage-based revenue. And when the spreadsheet starts drifting from reality, the fix is cleaner data at the source. See how Chargebee helps you monetize with confidence — book your personalized demo today.
Related Content
