Resource
SaaS financial model guide
How a subscription business is modelled for transaction work: the ARR bridge, cohort-based retention forecasting, CAC payback, revenue recognition against billings and deferred revenue, and the checks diligence applies to each.
01
What a SaaS model has to do
A SaaS financial model is a subscription engine attached to a three-statement build. The value of the business sits in the recurring revenue base and the economics of acquiring and retaining it, so the model must forecast revenue from customers and contracts rather than from a growth percentage applied to last year's total.
Structurally this means a customer and cohort layer feeding an ARR bridge, the ARR bridge feeding recognised revenue, and recognised revenue feeding the P&L, with deferred revenue and billings driving the cash movement separately. Collapsing those layers into a single revenue line is the most common reason a SaaS model fails diligence.
Cohort layer
New customers by acquisition month, with retention and expansion applied to each cohort independently.
ARR bridge
Opening ARR, new, expansion, contraction, churn, closing ARR — reconciling in every period.
Recognition layer
Contracted value spread over the service term; annual upfront billings do not equal revenue.
Cash layer
Billings and collections drive deferred revenue and working capital; these diverge sharply from revenue in a growing business.
Cost layer
Cost of revenue (hosting, support, professional services) separated from sales and marketing, R&D and G&A.
02
ARR and the metric definitions that matter
SaaS metrics are not standardised, which is why every model should state its definitions on the face of the schedule. Two companies reporting the same ARR growth can have materially different underlying performance depending on whether professional services, usage overages, annual prepay discounts or non-renewing contracts are included.
In a transaction context, expect the definitions to be tested. The ARR a seller reports and the ARR a buyer underwrites are frequently different numbers, and the gap is usually definitional rather than arithmetical.
ARR / MRR
Annualised value of committed recurring contracts at a point in time. Exclude one-off implementation, professional services and non-recurring usage unless separately disclosed.
Gross revenue retention
Closing ARR from a cohort excluding expansion, over opening ARR. Measures the leak; cannot exceed 100%.
Net revenue retention
Closing ARR from a cohort including expansion, over opening ARR. Above 100% means the installed base grows without new logos.
Logo churn
Customers lost over opening customers. Diverges from revenue churn where losses concentrate in small or large accounts.
CAC and payback
Fully loaded sales and marketing spend over new customers acquired; payback measured against gross-margin-adjusted ARR, not gross ARR.
LTV / CAC
Useful directionally only. It is highly sensitive to the churn assumption and should never carry the valuation on its own.
03
Cohort-based revenue forecasting
Cohort forecasting takes each group of customers acquired in a period and applies retention and expansion curves observed in the historical data, rather than applying a blended churn rate to the total base. It matters because retention is rarely constant: early-life churn is typically far higher than mature-cohort churn, so a blended rate understates losses in a fast-growing business and overstates them in a stabilising one.
Build the historical cohort triangle first. If the data does not support a cohort view, say so and use a blended approach with the limitation disclosed — an unsupported cohort model is worse than an honest simple one.
Historical triangle
ARR retained by cohort by month since acquisition, sourced from the billing system rather than the general ledger.
Retention curve
Fit the observed decay and hold it flat beyond the point the data supports; do not extrapolate improvement without evidence.
Expansion
Model seat growth, tier upgrades and price uplifts separately from retention so net and gross retention both remain visible.
Segmentation
Split by segment, channel or plan where behaviour differs materially; a single blended curve hides mix shift.
New bookings
Drive from sales capacity — reps, ramp time, quota and attainment — rather than a growth rate, wherever headcount is the binding constraint.
04
Revenue recognition, billings and deferred revenue
Recurring revenue is recognised over the service period. A customer paying twelve months upfront generates cash and deferred revenue on day one and recognised revenue over the following twelve months. In a growing subscription business the difference between billings and revenue is a substantial source of cash, and it reverses if growth stops — which is why deferred revenue movement must be modelled explicitly rather than folded into a working capital percentage.
Implementation fees, professional services and usage-based components each follow their own pattern and should be modelled as separate streams with their own margin profile.
Billings
Revenue plus the movement in deferred revenue. The cash-generative measure, and the one most sensitive to contract term mix.
Deferred revenue
A liability, not debt in the ordinary sense — but its treatment in the net debt bridge is negotiated, and the buyer bears the cost of servicing it.
Contract term mix
A shift from monthly to annual prepay flatters cash while leaving revenue unchanged. Disclose the mix in every period.
Services revenue
Lower margin, non-recurring, and usually valued at a materially lower multiple. Keep it separate from ARR.
Capitalised costs
Contract acquisition costs and capitalised development affect both the P&L and the quality of reported EBITDA.
05
What diligence tests in a SaaS model
SaaS diligence concentrates on whether the recurring base is as durable as reported and whether the earnings are as clean as presented. Most findings come from reconciling the billing system to the general ledger and from re-cutting the customer data on the buyer's own definitions.
ARR reconciliation
Billing-system ARR reconciled to recognised revenue and to the general ledger, with every bridging item explained.
Contract review
Term, notice periods, auto-renewal, price escalators and termination rights for the largest accounts.
Concentration
Revenue and ARR by customer; a base with meaningful concentration carries a different risk profile whatever the retention headline.
Capitalised development
Policy consistency, and the adjusted EBITDA impact if the buyer expenses what the seller capitalises.
Normalised EBITDA
Founder compensation, share-based payment, one-off implementation revenue and non-recurring items removed on a defined basis.
06
Reviewing the model
A SaaS model should be reviewable without the author present. Definitions stated, drivers visible, and every reported metric traceable to a schedule rather than a hardcode.
Bridge integrity
Does the ARR bridge reconcile opening to closing in every period, including the forecast?
Definition sheet
Is each metric defined on the face of the model, and is the definition applied consistently across history and forecast?
Cash reconciliation
Do billings, deferred revenue and collections tie to the cash flow statement?
Assumption support
Is the forecast retention curve supported by the historical triangle, or does it assume an unexplained improvement?
Sensitivities
How does equity value move under a reasonable downside on net retention and on CAC payback?
Discuss an Engagement
If you require support with financial modelling, business valuation or financial due diligence for a live transaction or strategic engagement, we'd be pleased to discuss your requirements.