Calculate Lifetime Value (LTV)

Christopher Peters · Customer Analytics

Why LTV Matters

Lifetime value is obviously important for running a successful business, so how can it be calculated?

The Simplest Way

Annual

LTV = average revenue per year / churn % per year

Quarterly

LTV = revenue/quarter / churn%/quarter

Monthly

LTV = revenue/month / churn%/month

Recommendations

1. Start with yearly granularity

I recommend starting with yearly, because it compresses information more than quarterly or monthly — thus lowering the error caused by variance (e.g., if there's a sudden influx of newly acquired customers).

2. Trend-adjust the revenue component

The limitation of the simple approach is the risk of using a stale average revenue figure. If average revenue has been increasing (or decreasing) over time, and you want the figure to apply to new customers to drive acquisition, it's advantageous to use more recent customers' average revenue per period.

⚠️ Don't trend-adjust churn. New customers are typically more fragile than long-time customers (before they "burn in"), so using new-customer churn tends to overestimate the churn rate — causing you to underestimate LTV and under-invest in acquisition.

The key insight: it's valuable to think about how average revenue and churn have changed over the company's lifetime.

3. Build confidence intervals via bootstrapping

At this point, the calculation produces a single number, but realistically the actual realized values will be above or below that figure. So — how much?

Figuring out if the range is material requires taking random samples of customers with replacement (bootstrapping) and calculating LTV as above for each sample to produce multiple estimates. Then you can characterize the range you're likely to experience.

This is important for:

  • Downside protection — guarding against over-investment in acquisition
  • Upside capture — preventing under-investment that causes disappointing revenue growth

4. Graduate to econometric models

A trend-adjusted, bootstrapped range is better than most companies can produce and can be extremely valuable. But there's often a lot more ROI to be gained by continuing to improve the LTV calculation's quality.

Using advanced econometric and statistical methods, it's possible to create a model that uses fewer and more reliable assumptions. That means fewer ways for the calculation to fail and a higher degree of accuracy. With a higher degree of accuracy, it's possible to:

  • Calibrate customer acquisition cost (CAC) more finely
  • Invest more confidently in advertising
  • Generate more revenue through better-calibrated decisions

Many critical business decisions depend on LTV, which makes it all the more valuable to have an accurate estimate.

Need a More Accurate LTV Estimate?

I build custom LTV models using econometric methods that reduce assumptions and increase accuracy.

Get in Touch →