Blog · Finance metrics and formulas
Customer profitability measures contribution earned during a defined period, while lifetime value estimates future contribution. This comparison applies both measures to the same customer groups and shows why their rankings can differ.
Customer profitability and lifetime value answer different questions: what did these customers contribute during the reporting period, and what might they contribute after today? The first is an actual result within an agreed cost boundary. The second depends on future behavior, costs and the timing of cash flows.
Use both before changing coverage or acquisition spending. A larger lifetime estimate does not remove a loss already earned.
| Question | Customer profitability | Remaining lifetime value |
|---|---|---|
| Time covered | A completed reporting period | Future periods after the valuation date |
| Starting files | Revenue, product cost and service activity | The same customer groups plus approved future assumptions |
| Main uncertainty | Cost completeness and allocation quality | Future contribution, retention and discounting |
| Useful decision | Pricing or service-cost review | Retention investment or acquisition economics |
| Essential check | Contribution reconciles to source totals | Discounted future rows reconcile to the estimate |
The lifetime value glossary defines the broader measure. This comparison uses contribution after product and service costs for both columns, leaving corporate overhead and tax outside both. The margin definitions guide explains why changing that boundary changes the meaning of profit.
Current customer contribution = Period revenue − Period product cost − Period service cost
Remaining LTV = Sum of [Conditional future contribution in year t × Probability of remaining active in year t ÷ (1 + Annual discount rate)^t]
Conditional contribution is the amount expected if the relationship remains active. Weight it by survival probability, unless the supplied forecast already includes attrition.
A US service provider compares recently onboarded customers with established customers at its year-end valuation date. The following illustrative figures are totals for the same membership of each group throughout the comparison. The future rows are supplied annual planning assumptions conditional on the relationships remaining active.
| Group and basis | Revenue (USD) | Product cost (USD) | Service cost (USD) | Contribution (USD) |
|---|---|---|---|---|
| New: completed year | 100,000 | 50,000 | 30,000 | 20,000 |
| Established: completed year | 80,000 | 40,000 | 10,000 | 30,000 |
| Completed-year total | 180,000 | 90,000 | 40,000 | 50,000 |
| New: each future year if active | 100,000 | 50,000 | 20,000 | 30,000 |
| Established: each future year if active | 80,000 | 40,000 | 10,000 | 30,000 |
The current-period ranking favors established customers: $30,000 against $20,000. The new group has higher revenue but also higher service cost during onboarding. Its assumed future contribution rises only because planned service cost falls from $30,000 to $20,000; that change requires evidence from completed onboarding cohorts.
Current contribution reconciles as 180,000 − 90,000 − 40,000 = $50,000, the same as 20,000 + 30,000. Use a customer profitability report to validate that starting point before projecting it.
For this example, finance approves a 10% annual discount rate and a three-year horizon, with no terminal value. The assumed annual retention rates are 90% for the new group and 80% for the established group. Each year's contribution is treated as received at year-end; an exiting customer contributes nothing for that year under this simplified convention.
Survival probabilities therefore compound: the new group's second-year probability is 0.90 × 0.90 = 0.81. These constant rates illustrate the comparison; they are not a recommended universal assumption. Fader and Hardie's discussion of CLV formulas shows why cash-flow timing and retention assumptions must be explicit, including the limitations of constant retention.
| Group | Future year | Probability active | Conditional contribution (USD) | Expected contribution (USD) | Present value (USD) |
|---|---|---|---|---|---|
| New | 1 | 90.0% | 30,000 | 27,000 | 24,545.45 |
| New | 2 | 81.0% | 30,000 | 24,300 | 20,082.64 |
| New | 3 | 72.9% | 30,000 | 21,870 | 16,431.25 |
| Established | 1 | 80.0% | 30,000 | 24,000 | 21,818.18 |
| Established | 2 | 64.0% | 30,000 | 19,200 | 15,867.77 |
| Established | 3 | 51.2% | 30,000 | 15,360 | 11,540.20 |
For each row, divide expected contribution by 1.10 raised to its future year. Keep full precision internally and round displayed dollar results to cents. Summing unrounded values gives $61,059.35 for the new group and $49,226.15 for the established group, totaling $110,285.50. Summing displayed new-group rows produces a one-cent rounding difference.
In Excel, with the new group's expected contributions in B2:D2, the independent discounted check is:
=NPV(10%,B2:D2)
Microsoft's NPV documentation specifies equally spaced, end-of-period cash flows. It also explains that a cash flow at the valuation date belongs outside the function. Covirage is not affiliated with Microsoft.
The new group ranks lower on current contribution but higher on finite-horizon remaining LTV. That result comes from its assumed lower future service cost and stronger retention, rather than its revenue alone. It is a planning estimate over the stated horizon, not a promise of lifetime earnings.
Change only its annual retention assumption to 80%, leaving all other inputs unchanged, and its remaining LTV becomes $49,226.15. The reduction is $11,833.21 using unrounded values. Both groups then have identical future assumptions, so their remaining-value estimates must match.
Finance owns the cost boundary and discount assumptions; customer teams supply evidence for service workload and retention. Compare actual future results with those assumptions. A customer lifetime value dashboard can organize that review without replacing the calculation with one headline number.
Bring revenue, cost and service exports alongside your supplied lifetime assumptions and valuation date. Covirage maps the columns, and its tools compute and check current contribution and the supplied future scenarios; the external AI model explains the comparison with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See customer profitability in Covirage for the supporting context.
Yes, if current costs include temporary onboarding work and credible future contribution exceeds the remaining costs. Positive lifetime value depends on those assumptions. It does not reverse the current loss or prove that further investment will pay off.
Use expected contribution after the costs necessary to earn the revenue. Revenue alone ignores product and service economics. State which costs are included so the lifetime estimate can be compared with current customer profitability on the same basis.
Only when you deliberately want a measure spanning both periods and label it accordingly. A remaining lifetime estimate starts at its valuation date. Adding a completed period changes the time boundary and can double count cash flows already included elsewhere.