Customer Lifetime Value (LTV) Calculator

Lifetime value estimates the contribution one customer relationship produces before it ends, and this tool builds it in layers. Average purchase value times purchase frequency gives annual revenue per customer. Multiplying by expected lifespan in years gives simple LTV. Multiplying by gross margin converts revenue into contribution, which is the only version that can honestly be set against acquisition spend, since revenue dollars and cost dollars are not comparable when cost of goods runs 20 to 60 percent. The discounted figure applies a factor of 1 divided by (1 + d)^t to each future year, because margin collected in year five is not worth its face value today. At a 10 percent rate, year-five cash is worth about 62 cents on the dollar, so the gap between simple and discounted LTV widens sharply for long-lived relationships. Rates of 8 to 15 percent are common proxies for a private company cost of capital. The fixed-lifespan form used here is a deliberate simplification of an underlying retention curve. Real customer bases are heterogeneous, with a minority of accounts generating a disproportionate share of value, so an average lifespan drawn from a skewed distribution overstates the typical customer and understates the best ones. Segment-level LTV is generally more actionable than a single company-wide number. Other standard caveats: revenue expansion and price increases are not captured by a static purchase value, service and support costs are only partially reflected in gross margin, and survivorship bias inflates lifespan estimates taken from currently active customers. Against acquisition cost, a ratio of 3 to 1 is the usual adequacy threshold.

Lifetime value grew out of the catalogue and direct-mail industry, where firms had transaction histories at the individual customer level decades before most other businesses did. Recency, frequency and monetary value scoring, developed in mail-order practice through the mid-twentieth century, was the practical ancestor: it ranked house-list customers by future purchasing potential and set the allowable spend for reactivating them. Database marketing texts of the late 1980s, including work by Robert Shaw and Merlin Stone, moved the idea from list scoring toward an explicit present value of an ongoing relationship. Formalisation followed in the academic marketing literature. David Schmittlein, Donald Morrison and Richard Colombo published the Pareto/NBD framework for counting customers in Management Science in 1987, modelling purchase timing and dropout probabilistically rather than assuming a fixed lifespan. Robert Blattberg and John Deighton argued in a 1996 Harvard Business Review article that marketing budgets should be tested against customer equity, and Paul Berger and Nada Nasr set out closed-form lifetime value models in 1998. Sunil Gupta, Donald Lehmann and Jennifer Ames Stuart linked customer lifetime value to firm valuation in a 2004 Journal of Marketing Research paper. Peter Fader and Bruce Hardie later produced simpler estimable models such as BG/NBD, and the discounted margin formulation implemented here is the working simplification that subscription businesses adopted from that lineage.