Customer Lifetime Value Calculator · Calculation guide

Estimate customer profit over a chosen period after acquisition cost.

Calculation guide

For business owners exploring costs, cash flow or valuation scenarios.

Keep revenue, cost and time periods consistent. Profit margin divides by revenue; markup divides by cost. Discounted cash flows are scenario assumptions, and terminal growth must be below the discount rate. Payback uses linear interpolation within the recovery period. Customer lifetime value uses the entered finite horizon, retention, margin and discount assumptions. No valuation or business outcome is guaranteed.

CLV=Σ_{t=1}^N Revenue·Margin·Retention^(t−1)/(1+d)^t−CAC

Inputs

Revenue per period

Expected revenue from one active customer in each modeled period.

Gross margin

Share of revenue left after direct costs, before customer acquisition cost.

Periods

Number of equally spaced payment or forecast periods, not automatically years.

Retention

Share of customers expected to stay into the next period; the first period assumes an active customer.

Discount rate per period

Discount rate per modeled customer period, not necessarily per year.

Acquisition cost

One-off cost of gaining one customer, subtracted from discounted customer profit.

Worked example

InputValue
Revenue per period1,000
Gross margin60%
Periods24
Retention95%
Discount rate per period0%
Acquisition cost0

Formula:

CLV=Σ_{t=1}^N Revenue·Margin·Retention^(t−1)/(1+d)^t−CAC

Net lifetime value = 8496.13170793473

Period = 1.00000000000000; Expected revenue = 1000.00000000000; Profit present value = 600.000000000000; Net lifetime value = 600.000000000000

Period = 24.0000000000000; Expected revenue = 307.356867725024; Profit present value = 184.414120635014; Net lifetime value = 8496.13170793473

ResultValue
Net lifetime value8,496.131708
Gross profit present value8,496.131708
Revenue present value14,160.219513
Acquisition cost0

Interpreting the result

Discounted expected customer profit minus one-off acquisition cost.

Expected customer revenue multiplied by margin and discounted across the entered retention horizon.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Revenue per period1,0001,100Net lifetime value8,496.1317089,345.744879
Gross margin60%66%Net lifetime value8,496.1317089,345.744879
Periods2426Net lifetime value8,496.1317088,837.758866
Retention95%85%Net lifetime value8,496.1317083,919.06913
Discount rate per period0%1%Net lifetime value8,496.1317087,700.393349
Acquisition cost01Net lifetime value8,496.1317088,495.131708
Customer Lifetime Value Calculator →