CLV Calculator

Hosted Excel workbook for estimating customer lifetime value and comparing CLV against acquisition cost.
Download

CLV Calculator

Quantify the long-term value of a customer relationship. The workbook compares CLV against CAC, models retention economics, and helps you compare value across customer segments.

Preview of the CLV Calculator workbook

Key Inputs

  • Average purchase value
  • Purchase frequency per year
  • Gross margin
  • Customer lifespan
  • Discount rate

Notes

The workbook includes a cohort retention view and a CLV:CAC lens for unit economics. It is useful for teaching relationship value and for quick segment comparisons in planning work.