← Every exhibit

Table Table 3 Growth that compounds

Which common miscalculations undermine customer lifetime value models in practice?

MiscalculationWhy it failsCorrective protocol
Using revenue instead of contribution marginService, infrastructure, and delivery expenses are ignoredDefine a strict contribution boundary deducting all variable servicing costs
Assuming permanent constant retentionHazard rates shift across customer tenure; early cohorts drop fasterEstimate empirical survival curves by customer vintage and onboarding cohort
Omitting cost of capital discountingCash flows 5 years out are treated as risk-free and liquidApply the corporate weighted average cost of capital (WACC) to periodic cash flows
Confusing contractual and noncontractual churnInfrequent buyers are labeled as active or dead without statistical modelsDeploy BG/NBD or Pareto/NBD models for noncontractual purchase streams
Blending distinct customer segmentsHigh-churn SMB accounts and stable enterprise accounts average outCalculate CLV separately across distinct contract tiers and acquisition channels
Over-projecting expansion ratesNet expansion from surviving top accounts masks underlying logo attritionModel survival and expansion as separate, interacting cohort functions

Swipe or scroll horizontally if the table is wider than your screen.

Cite Embed

Reference & Evidence

Source: Table from this essay. Sources and interpretation are given in the article.

Related exhibits