Financial Planning
Customer Lifetime Value: Show the Assumption Risk
Separate observed customer contribution from a modeled lifetime estimate and show how churn assumptions change the answer.
What you will learn
- calculate observed contribution per original cohort member
- inspect a simplified churn-based estimate
- show how uncertain retention changes modeled value
Customer lifetime value is a model of value from a customer relationship, not a number you observe in full while customers are still active. Start with contribution actually earned by a defined cohort. If you estimate a lifetime beyond that history, disclose the retention, margin, time horizon and discount assumptions that create the estimate.
Write the value definition beside the number
Bessemer’s cloud-finance framework treats customer value as a profit-stream question. A revenue-only lifetime and a contribution-based lifetime are not interchangeable. State whether acquisition costs, retention costs and discounting are included.
This worksheet uses pre-acquisition, undiscounted contribution: customer revenue less the defined variable cost to serve. It is not net profit, a valuation or a recommended acquisition budget. Use the unit-economics lesson to choose and document that cost boundary.
Calculate what has actually been observed
Fictional cohort: 100 customers start together. Total contribution from that original cohort is $1,000, $900, $800, $700, $600 and $500 in its first six months. Include the original customers who stopped contributing in the original-cohort denominator.
| Observed measure | Calculation | Result |
|---|---|---|
| Six-month cohort contribution | $1,000 + $900 + $800 + $700 + $600 + $500 | $4,500 |
| Contribution per original customer | $4,500 / 100 | $45 |
| Observation window | First six months | Not a full lifetime |
Dividing only by surviving customers would answer a different question. Active customers have an unfinished observation window: their future contribution is unknown, not zero.
Treat the churn shortcut as a model
A simplified steady-state model divides contribution per active customer per month by monthly customer churn. At $20 monthly contribution and 5% monthly churn, it produces $400. The shortcut assumes stable behavior and costs, no expansion, a compatible timing convention and no discounting. It is not a claim that every customer stays twenty months.
It can fail when churn changes with tenure, annual contracts renew in batches, segments differ or recent cohorts are too young. Zero observed churn in a short window does not justify infinite value.
Show the sensitivity, not one confident output
| Hypothetical monthly churn | Monthly contribution | Simplified modeled contribution value |
|---|---|---|
| 2.5% | $20 | $800 |
| 5% | $20 | $400 |
| 10% | $20 | $200 |
The modeled output changes fourfold between the first and last assumptions. This does not prove either extreme is likely. It shows why retention evidence matters more than additional decimal places. Keep the observed $45 six-month figure separate from these different modeled scenarios.
Copy the observed-versus-modeled worksheet
Customer unit, segment and cohort start:
Original customer count:
Observed months and data cutoff:
Revenue and included variable service costs by cohort age:
Observed contribution / original customers:
Active customers with incomplete observation:
Modeled monthly contribution and retention assumptions:
Discounting, expansion and acquisition-cost treatment:
Sensitivity cases and reasons:
Observed result versus extrapolated amount:
Source owner and next evidence checkpoint:Exercise: change margin without changing retention
Using the same simplified 5% monthly churn assumption, delivery costs increase and monthly contribution falls from $20 to $15. What happens to modeled value?
Answer: it falls from $400 to $300, a $100 or 25% reduction. Stable retention does not protect value when the cost to serve changes. This exercise does not establish how much a business should spend to acquire a customer.
Present the uncertainty clearly
- Show the customer unit and cohort age.
- Retain original-cohort denominators for observed value.
- Keep observed contribution distinct from modeled future contribution.
- Label cost, churn and discount assumptions.
- Do not turn a small sample into a universal lifetime.
Keep the reviewed cohort brief with your fundraising materials in Finta. Ask Aurora to help explain the difference between observed value and assumptions you still need to test. Check the figures in the source workbook before using the explanation in an investor discussion. For broader scenarios, use the financial-model guide.
Finta Field Guide. By Finta Editorial Team. Sources checked November 14, 2026. Examples are original, fictional teaching exercises, not customer results, benchmarks or individualized financial, accounting, legal or tax advice.