Templates · 2026-07-12 · 8 min read

Written and reviewed by Project Financial Advisor · FCA · CGMA · ACMA — Chartered Accountant

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

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

Worked example: MRR, churn, CAC and LTV

Suppose a SaaS business ends the month with 1,000 customers each paying $50 — that is $50,000 MRR, or $600,000 ARR. At 3% monthly churn it loses about 30 customers a month, so growth depends on adding more than 30 new ones. With a $400 CAC and a 70% gross margin, each customer contributes $35 a month; an average lifetime of 33 months (1 ÷ 3% churn) implies a lifetime value near $1,155 — an LTV/CAC of about 2.9:1 and a CAC payback of roughly 11 months.

Model new bookings, churn and expansion as separate lines rather than one net figure. Blending them hides whether growth comes from winning customers or from keeping and upselling them — a distinction investors probe closely.

EasyFinancialModels includes a SaaS template with MRR-and-churn revenue, CAC, roughly 80% gross margin and realistic defaults, producing a 16-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.

Tying the metrics into a valuation

The individual SaaS metrics matter because together they drive value. Recurring revenue growth sets the trajectory, net revenue retention determines how durable it is, and the LTV/CAC ratio shows whether that growth is profitable to acquire. A model that links these into forecast ARR, gross margin and free cash flow — rather than leaving them as a disconnected dashboard — lets an investor see the business the way the market will price it: on the quality and durability of recurring cash flows. When retention is strong and acquisition is efficient, even a currently loss-making SaaS business can justify a high multiple, because the model shows those losses buying an annuity of expanding, sticky revenue.

Frequently asked questions

What metrics drive a SaaS model?

Recurring revenue (MRR/ARR), new bookings, churn and expansion, customer acquisition cost (CAC), lifetime value (LTV) and the LTV/CAC and CAC-payback ratios.

What is a good LTV/CAC ratio?

Around 3:1 or higher is considered healthy, with CAC payback under 12 months. Much higher may mean underinvesting in growth; much lower signals inefficient acquisition.

How do you model SaaS churn?

Apply a monthly or annual churn rate to the existing base and layer in expansion revenue. Cohort-based churn is more accurate than a single blended rate for a maturing book.

→ 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) of the Institute of Chartered Accountants of Pakistan (ICAP), 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 16-sheet model