Customer LTV Cohort Decay Analyzer

Calculate discounted customer lifetime value, model retention decay across churn scenarios, and identify the exact month your acquisition cost is recovered. Built on the economics your CFO uses, not the spreadsheet shortcut.

Retention Model

Customer Economics

% of customers lost each month. 3% monthly = ~30% annual churn.
Your cost of capital or required ROI rate.
Discounted Customer Lifetime Value
$0
Adjust inputs and run analysis
LTV : CAC Ratio
CAC Payback
Avg Lifetime
Month 12 Retention

The Compounding Power of Retention

Most businesses obsess over customer acquisition. Fewer understand that a 5% reduction in churn often has a greater impact on enterprise value than a 25% increase in new bookings. This is because retention compounds: a customer retained for 36 months instead of 18 doesn't generate 2× the value — they generate exponentially more, because the early periods where you were recovering your acquisition cost are amortized across a much longer revenue window.

The Discounted LTV Formula

This model uses the economically rigorous form of LTV, not the simplified version (ARPU / churn rate) commonly used in dashboards. The full formula accounts for the time value of money:

Monthly Gross Profit = ARPU × Gross Margin Monthly Discount Rate = (1 + Annual Discount Rate)^(1/12) − 1 Discounted LTV = Monthly Gross Profit ÷ (Monthly Churn Rate + Monthly Discount Rate)

This produces a present value — the sum of all future gross profit streams, discounted back to today. A dollar earned in month 24 is worth less than a dollar earned today, and the formula accounts for this rigorously. The undiscounted version (ARPU × GM / churn) overstates LTV, often significantly at high discount rates.

Understanding the Retention Curve

The cohort retention curve shows what percentage of a customer cohort (a group acquired at the same time) remains active at each month. With constant churn, this follows an exponential decay: Retention(t) = (1 − Monthly Churn)^t. A 3% monthly churn retains 97% of customers after month 1, 94.1% after month 2, and so on. By month 24, approximately 48% of the original cohort remains. This is the mathematical foundation that determines every downstream LTV calculation.

What the Scenario Comparison Shows

The bottom chart models three parallel universes: your base churn rate, half that churn rate (the optimistic scenario — what happens if you invest heavily in customer success), and double that churn rate (the risk scenario — competitive pressure, poor onboarding, or product issues). The vertical spread between these curves by month 36 quantifies, in dollars, exactly what your retention engineering is worth.

The CAC Payback Period: What It Actually Means

Your CAC payback period is the month at which cumulative gross profit from a customer cohort equals the cost of acquiring them. Until that month, every active customer is a net liability on a cash flow basis. After it, every month they remain is pure profit contribution. Businesses with payback periods longer than 18 months carry meaningful working capital risk: if a cohort churns heavily before payback, you have permanently destroyed capital. This is why investors scrutinize payback period alongside LTV:CAC — both metrics must be healthy for the unit economics to work.

Frequently Asked Questions

What is customer lifetime value (LTV) and how is it calculated here?

Customer lifetime value (LTV) is the present value of all future gross profit a business expects to earn from a customer relationship. This tool uses the discounted formula: LTV = (ARPU × Gross Margin) ÷ (Monthly Churn Rate + Monthly Discount Rate), which accounts for both the probability of customer attrition at each time step and the time value of money via the discount rate. It is more rigorous than the common shortcut of ARPU / churn rate, which ignores discounting and overestimates LTV.

What is a healthy LTV:CAC ratio, and what does it mean if mine is below 1?

The standard benchmark is 3:1 — you earn $3 in lifetime gross profit for every $1 spent acquiring a customer. Interpretations by range:

  • < 1:1: Every customer acquired destroys capital. The business is fundamentally uneconomic at this CAC and churn structure. Immediate action is required on one or more inputs.
  • 1:1 to 2:1: Marginal. You are recovering acquisition cost but generating little excess return. Growth accelerates losses before they stabilize.
  • 3:1 to 5:1: Healthy. Standard benchmark for SaaS and B2B services.
  • > 5:1: Either an exceptional business or you may be under-investing in acquisition, missing available growth.
How does reducing churn by even 1% change my LTV?

Churn reduction has a non-linear, compounding impact on LTV. With a 3% monthly churn and $1,800 ARPU at 72% margin, average customer lifetime is approximately 33 months. Reducing churn to 2% extends average lifetime to 50 months — a 51% increase in lifetime with only a 1 percentage-point change in churn rate. This is because LTV = GM / churn in its simplified form: halving churn doubles LTV. The relationship is hyperbolic. At very low churn rates (<1%), even small improvements become enormously valuable, which is why enterprise SaaS businesses invest heavily in customer success infrastructure.

What monthly churn rate is considered good for B2B services?

Benchmarks vary significantly by contract structure and market segment:

  • Enterprise B2B (annual contracts, high switching costs): 0.5%–1.5% monthly (6%–18% annualized)
  • SMB B2B (monthly contracts, moderate switching costs): 2%–5% monthly
  • Consulting / project-based: Measured differently — often as repeat engagement rate rather than churn
  • SaaS (general): Under 2% monthly is strong; under 1% is exceptional

High churn is often a symptom: poor onboarding, product-market fit gaps, or customers who were acquired before they were truly qualified.

What discount rate should I use?

The discount rate should reflect the opportunity cost of your capital — what you could earn by deploying that money elsewhere at equivalent risk. Common approaches:

  • Early-stage businesses: 20%–30% to reflect high risk and investor required returns
  • Growth-stage businesses: 12%–20%
  • Mature, profitable businesses: 8%–12% (often close to WACC)
  • Conservative SaaS default: 10%–15%

A higher discount rate reduces LTV because future revenue streams are penalized more heavily. Using 0% effectively says a dollar earned in year 3 is identical to a dollar earned today — which is economically incorrect.

Can I use this tool for non-subscription businesses?

Yes, with reframing. For transactional businesses (e-commerce, project-based services):

  • Set ARPU to average transaction value per month (total annual spend ÷ 12).
  • Set Churn Rate to the monthly probability that a customer does not repurchase — the inverse of your repeat purchase rate.
  • Set Gross Margin to your typical product or project margin.

The math is structurally identical because any customer relationship can be modeled as a probability of continuation at each time period. The key is ensuring your churn rate honestly reflects how often customers disengage permanently versus temporarily.

What is the difference between gross LTV and net LTV?

This tool calculates gross LTV — the present value of gross profit (revenue after variable costs and COGS). It does not subtract acquisition cost, ongoing customer success costs, or account management overhead beyond what's captured in your gross margin input. Net LTV would subtract CAC and ongoing service costs from gross LTV to produce a true per-customer profit figure. The LTV:CAC ratio displayed here approximates net economics by comparing the gross LTV against acquisition cost directly.

How accurate is constant-rate churn modeling?

Constant-rate (exponential decay) churn is a simplification. In reality, most businesses experience time-varying churn: new customers are most likely to churn in months 1–3 (the critical onboarding window), and customers who survive beyond month 6–12 churn at significantly lower rates. This creates an L-shaped or bathtub-shaped retention curve rather than a smooth exponential. The constant-rate model underestimates the importance of the onboarding window and overestimates long-term attrition. A full cohort analysis with actual retention data will reveal the true curve shape — and usually shows that the first 90 days are worth disproportionate investment.

Reduce Churn. Engineer Retention. Compound Value.

This model shows you the mathematics of retention — but the levers are operational: onboarding architecture, health scoring systems, proactive intervention triggers, and expansion revenue strategies. White Oak Intelligence builds the data infrastructure and analytical systems that identify at-risk customers before they churn, turning a theoretical LTV into a realized one.

Schedule a Retention Diagnostic