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.
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.
In the browser
The Customer Lifetime Value Calculator runs the same calculation in the browser, with discounting, the CLV to CAC ratio, and a year-by-year chart. It is one of 32 free tools in the Marketing Toolkit Hub.