SaaS Financial Model: MRR, Churn, CAC & LTV Explained

How to build a SaaS financial model — MRR and churn, CAC, LTV and the LTV:CAC ratio, the Rule of 40 and CAC payback, in a linked Excel model.

A SaaS financial model projects a subscription business using the metrics that actually drive it: recurring revenue, churn, customer-acquisition cost and lifetime value. Because SaaS revenue is recurring and its costs are front-loaded, a generic model misses what investors care about. Here are the SaaS-specific mechanics, and how they fit into a full model.

The SaaS revenue engine: MRR and churn

Monthly recurring revenue (MRR) is the heartbeat. Model it as opening MRR, plus new MRR from acquired customers, plus expansion from upsells, minus churned MRR from cancellations and downgrades. Net revenue retention — expansion minus churn on the existing base — is the single number that shows whether the business grows even without new customers; best-in-class SaaS retains over 100%.

CAC, LTV and the LTV:CAC ratio

Customer-acquisition cost (CAC) is total sales and marketing spend divided by new customers. Lifetime value (LTV) is average revenue per customer × gross margin ÷ churn rate. The LTV:CAC ratio is the headline efficiency metric — 3:1 or better is the rule of thumb — and CAC payback, the months to recover CAC from gross-margin dollars, should sit under 12–18 months for healthy unit economics.

Gross margin and the Rule of 40

SaaS gross margins are high — typically 75–85% after hosting and support — which is why the model must separate that thin COGS from operating spend. The Rule of 40 (revenue growth rate + profit margin ≥ 40%) is the balance investors use to judge whether you are trading growth for burn sensibly.

Cash: burn, runway and CAC payback

Because SaaS pays CAC upfront but collects revenue over months, growth consumes cash even at strong unit economics. The model must show burn, runway and peak funding need — and, if you bill annually, the working-capital benefit of collecting a year of revenue in advance, which appears as deferred revenue on the balance sheet.

Fitting it into the three statements

The SaaS metrics feed a normal three-statement model: MRR × 12 drives income-statement revenue, CAC sits in operating expenses, deferred revenue is a balance-sheet liability that releases into revenue over time, and the linked cash flow shows the true burn. That linkage is what turns a metrics dashboard into a fundable model.

Build a SaaS model free

EasyFinancialModels includes a SaaS template with MRR-and-churn revenue, CAC, roughly 80% gross margin and realistic defaults, producing a 15-sheet linked Excel model with DCF and IRR. Build a SaaS financial model free for up to 3 years, then edit every assumption to match your own cohort economics.

→ Build your financial modeling model free with the Financial Model tool

More Financial Modeling guides

How to Build a Financial Model in Excel · Quarterly Financial Model: When to Use Quarterly Forecasts Instead of Annual Models · Industry Financial Model Templates: How to Choose the Right Revenue Drivers · How to Build a Startup Financial Model for Investors · The Three-Statement Financial Model Explained

About the author

Every model is built and reviewed by the project's Financial Advisor — a Fellow Chartered Accountant (FCA), Chartered Global Management Accountant (CGMA) and Associate Chartered Management Accountant (ACMA) with around two decades of corporate finance, audit and accounting experience, designing investor-grade financial models across industries. Full credentials and background are available on LinkedIn. More about the author →

← All guides · WACC calculator · DCF calculator · IRR calculator · Inside the 15-sheet model