Customer Lifetime Value Worked Examples: Six Scenarios, Arithmetic Shown
Six CLV scenarios worked step by step: the historic retail formula, churn-based subscriptions, what lower churn is worth, discounting, the LTV:CAC check, and cohort comparisons.
Six numbers-heavy scenarios, each worked step by step with the assumptions in the open: a retail store priced with the historic formula, a subscription priced with churn, the effect of cutting that churn, a discounted present-value view, the LTV-to-CAC check that decides whether acquisition is affordable, and a cohort comparison that catches what averages hide. The arithmetic is deliberately plain — multiplication and one division per step — because the value of these examples is reproducibility: swap in your own figures and the method transfers unchanged. A /customer-lifetime-value-calculator.html session makes the mechanics instant; reading the assumptions honestly is the part that stays manual.
CHAPTER 01How to Read These Examples
Each scenario names its inputs and shows the full arithmetic, so nothing depends on a hidden assumption. Margins are gross contribution after costs that scale per sale; churn is measured on recent cohorts; lifespans come from observed behavior or the one-divided-by-churn approximation, and each example says which. Where a simplification is bold, the text flags it as such.
All figures are illustrative. Real businesses add taxes, support costs, refunds, and seasonality, and those can move results materially. Treat each example as a template for a calculation you would run on your own data — the shape of the reasoning is the durable part.
CHAPTER 02A Retail Store, Priced With the Historic Formula
Inputs: average order sixty dollars, four orders per year, gross margin fifty-five percent, and an active buying life of three years estimated from repeat-purchase records. CLV = 60 × 4 × 0.55 × 3. The steps: 60 × 4 is 240 dollars of yearly revenue; times 0.55 is 132 dollars of yearly contribution; times three years is 396 dollars of lifetime contribution.
Notice what the margin factor did: it removed 324 dollars of revenue that the business never keeps. An acquisition decision made on the 720-dollar revenue figure would justify spending nearly twice what the margin-honest 396 can support. The formula's four factors are also its four levers — purchase frequency and margin are usually the most improveable, and the cheapest to test.
CHAPTER 03A Subscription, Priced With Churn
Inputs: twenty-nine dollars monthly price, eighty percent margin after hosting and support, five percent monthly churn from the last two cohorts. Monthly contribution is 29 × 0.80 = 23.20. Average lifetime is 1 ÷ 0.05 = 20 months. CLV = 23.20 × 20 = 464 dollars — equivalently 23.20 ÷ 0.05, the compact form the calculator uses.
The twenty-month lifespan is an average across a distribution: some subscribers stay for years, many leave inside six months. That spread is the reason lifetime averages flatter and distributions warn — the arithmetic assumes survival that a meaningful slice of customers will not deliver, and the honest response is to check the average against actual cohort curves before betting a budget on it.
CHAPTER 04What Cutting Churn Is Worth
Hold everything constant and move churn from five percent to three percent monthly. Contribution stays 23.20; average lifetime becomes 1 ÷ 0.03, about 33.3 months; CLV becomes 23.20 ÷ 0.03 = 773 dollars. A two-point churn improvement added roughly 309 dollars of estimated value per customer — about two-thirds more value from no acquisition change at all.
This sensitivity is why churn assumptions deserve audits. If the five percent figure came from a launch-era cohort riding novelty, the honest CLV is lower; if recent onboarding improvements moved churn to four percent, the honest CLV is higher — 580 dollars at 23.20 ÷ 0.04. Recompute the churn input monthly; it dominates every other input the calculator has.
CHAPTER 05Adding a Discount Rate
Apply a one percent monthly discount to the base case: contribution divided by churn plus discount, or 23.20 ÷ (0.05 + 0.01) = 386.67, about 387 dollars versus the undiscounted 464. The seventy-seven dollar difference is the present-value cost of waiting for profits that arrive across twenty months. Longer-lived customers carry more of this haircut.
The simplification is worth naming: folding discount into the denominator assumes constant churn and contribution indefinitely, which is a modeling convenience rather than a forecast. For planning horizons of a few years the approximation is commonly used; for pricing decisions with long contracts, a month-by-month discounted model is the more defensible instrument.
CHAPTER 06The LTV:CAC Check
Pair the base subscription with acquisition: CLV of 464 against a fully loaded CAC of 300 gives a ratio of 1.55 to 1 — well below the commonly cited 3:1 screen. Payback sits at 300 ÷ 23.20, about thirteen months. The paired reading is blunt: at current costs and assumptions, each acquisition dollar buys roughly fifty-five cents of lifetime contribution beyond break-even.
The productive response is numerical, not motivational: lift contribution to 26.40 via a modest price move (CLV 528), or cut CAC to 200 through channel mix (ratio 2.3), or combine both (528 ÷ 200 = 2.6). Reaching 3:1 becomes a dated plan with two levers instead of a vague ambition — and each lever's progress is checkable monthly in the calculator.
CHAPTER 07A Cohort Comparison
Two cohorts, twelve months of tracked contribution each. The earlier cohort contributed 150 per customer by month twelve; the newer cohort, after an onboarding rebuild, contributed 186. The blended average across all customers moved only from 158 to 164 — nearly invisible — because old vintages still dominate the base. The cohort chart shows the change plainly; the average hides it.
Extrapolating the newer cohort to a full lifetime requires care — twelve months of observed behavior supports a projection, not a prophecy. A common approach applies current churn to the improved base: if monthly churn eased from 5.0 to 4.2 percent, lifetime contribution rises accordingly, and a /customer-lifetime-value-calculator.html session updates with one changed input. Cohorts catch change early; that is their job.
🔑 Key takeaways
- Historic CLV is four multiplications: 60 × 4 × 0.55 × 3 = 396 — and the margin factor is what keeps the number honest.
- Subscription CLV = contribution ÷ churn: 23.20 ÷ 0.05 = 464, with an average lifetime of twenty months at five percent churn.
- Churn dominates: 5% → 3% lifts CLV from 464 to 773 with no acquisition change — audit the churn input monthly.
- Discounting trims the long tail: 23.20 ÷ (0.05 + 0.01) ≈ 387; pick a convention and keep it consistent.
- LTV:CAC is a paired judgment: 464 vs 300 is 1.55:1 with roughly thirteen-month payback — build the fix as two numeric levers, not a hope.
- Cohort charts reveal improvements that blended averages swallow; project young cohorts with current churn, not optimism.
❓ Frequently asked questions
Can I mix formulas — use historic CLV for a shop with a membership?
Prefer one method per analysis, chosen by how the money arrives. If most revenue is subscription, churn-based fits; if most is repeat purchase, historic fits. Hybrid models can compute both and sanity-check one against the other.
How much data do I need before CLV is trustworthy?
Enough elapsed time to observe real churn and repeat behavior — commonly a few full cohort cycles. Young businesses can still compute a provisional CLV, labeled as such, and revise it as cohorts mature.
Why does my CLV disagree with finance's customer profitability figures?
Finance usually allocates fixed costs, salaries, and support beyond gross contribution, producing a lower per-customer figure. Both are valid for different questions; CLV screens acquisition decisions, while profitability statements judge the whole operation.
Should refunds and returns reduce CLV?
Yes — in the revenue-to-margin conversion. Net revenue and a margin rate that reflects returns is the honest form. Excluding them quietly inflates every downstream number, including any LTV:CAC ratio built on top.
How often should CLV be recomputed?
Monthly for the churn input in subscription models; quarterly for full recomputations including margins and lifespans. The point of a schedule is catching drift while it is still cheap to react to.
What is the most common CLV mistake in practice?
Counting revenue as if it were margin. It inflates every result, flatters every acquisition, and usually survives for quarters because the error makes everything look better. Fixing it is one multiplication — and usually the most sobering one in the whole analysis.
The free Customer Lifetime Value Calculator on Toolfyra runs everything in your browser — no signup, nothing uploaded.
Open the Customer Lifetime Value Calculator →📚 More in the Toolfyra blog · or browse all free online tools.