A SaaS financial model is only useful when subscription activity, revenue recognition, customer economics and cash flow tell a consistent story. A rising ARR headline cannot repair a broken churn calculation or fund next month's payroll.
Start with a customer and MRR bridge
Use an explicit roll-forward from beginning to ending customers. Separately bridge recurring revenue. Changes in pricing, plan mix and customer counts should never be buried in an unexplained growth percentage.
Consider an illustrative subscription business that starts the month with 300 paying customers at an average $100 MRR each. It acquires 50 customers and loses 12. Ending customers are 338. The beginning MRR is $30,000.
| MRR movement | USD |
|---|---|
| Beginning MRR | 30,000 |
| New customer MRR | +5,000 |
| Expansion MRR from existing customers | +600 |
| Churned MRR | −1,200 |
| Contraction MRR | −300 |
| Ending MRR | 34,100 |
Ending MRR is $34,100, implying a $409,200 annualized run rate. That is not the same as recognized revenue for the year, contracted annual revenue or cash collected in advance.
Churn, gross retention and net retention measure different things
Logo churn for the illustrative month is 12 ÷ 300 = 4%. That measures customer count lost, not revenue lost. If higher-priced accounts churn disproportionately, revenue churn can be much worse than logo churn.
Using the same cohort: ($30,000 + $600 − $300 − $1,200) ÷ $30,000 = 97% net revenue retention. Gross revenue retention excludes expansion and equals ($30,000 − $300 − $1,200) ÷ $30,000 = 95%.
Do not add new-customer MRR into NRR. NRR is a measure of recurring revenue retained and expanded from the starting customer cohort. Mixing in new business makes retention look stronger than it is.
For robust analysis, track customer and revenue cohorts over time, account for seasonality, and define how upgrades, downgrades, reactivations, refunds and currency changes are classified.
Make CAC and payback consistent with the revenue model
Suppose the business spends $12,000 in attributable sales and marketing costs to acquire those 50 new paying customers. The illustrative customer acquisition cost is $240 per new customer.
If average monthly revenue per customer is $100 and gross margin is 75%, monthly gross profit per customer is $75. A simplified gross-margin CAC payback is $240 ÷ $75 = 3.2 months.
This simplified result assumes a stable monthly contribution, no timing lag, no churn during payback and that all relevant acquisition costs were captured. For a real model, distinguish paid-channel CAC from fully loaded blended CAC and match cohort acquisition spending to the customers it generated.
Simple LTV formulas such as monthly gross profit divided by monthly churn are sensitive to constant-churn assumptions. They are not a substitute for measured cohort contribution and survival curves.
ARR is not cash runway
SaaS companies can bill monthly, annually in advance or after service delivery. Those billing terms change cash receipts without necessarily changing subscription MRR. A three-statement forecast should bridge billed amounts, deferred revenue, receivables, recognized revenue and cash collections.
Cash runway should be derived from the projected cash balance and expected net cash burn under stated financing and operating assumptions. A simple current-cash divided by average-burn calculation may be a useful diagnostic, but is not reliable when hiring, collections, capex and taxes are uneven.
Model headcount starts, infrastructure capacity, customer-support costs, payment processing, commissions, debt service and financing milestones explicitly. It is entirely possible for ARR to grow while cash runway contracts.
Model checks that catch expensive mistakes
- Ending customers in one month must equal the next month's beginning customers.
- New, expansion, contraction and churned MRR must reconcile to ending MRR without unexplained plugs.
- Retention calculations must exclude new-customer acquisition and use consistent starting cohort definitions.
- Revenue recognition, invoicing and cash receipts must reconcile through deferred revenue and receivables.
- Acquisition costs should reflect the intended CAC definition and appropriate timing.
- Downside scenarios should affect customer acquisition, retention, pricing, margins and hiring, not just top-line revenue.
Related services: SaaS forecasting models, unit economics and pricing, and independent financial model reviews.
All figures are hypothetical for explanation. Subscription definitions vary between companies; document yours before comparing metrics across businesses.