Customer Lifetime Value (CLV) Calculator

How to Use the CLV Calculator

Lifetime value is the number that tells you how much you can afford to spend winning a customer. It is also the number most often inflated, usually by building it from revenue instead of profit and from a churn rate that flatters. Both mistakes push the answer in the same direction, and the result is a company that spends confidently on customers it loses money on.

1. Enter monthly revenue per customer. The average across your whole base, not the largest account and not the plan you wish everyone bought. If your mix is very uneven, run the calculation separately by segment.
2. Enter gross margin. What remains after the cost of serving that customer — hosting, support, payment fees, delivery. This is the step that converts a revenue figure into a value figure.
3. Enter monthly churn. The share of customers who leave each month. Three per cent monthly means the average customer stays about 33 months, and small changes here move the answer more than anything else on the page.
4. Set a discount rate so the calculator can also show the present value. Money arriving in year three is worth less than money arriving now, and on a long customer life the difference is substantial.
5. Add your acquisition cost to get the ratio and the payback period — the two figures that turn lifetime value from an interesting number into a budget decision.

The churn table is the important part of this page. It shows what the same customer is worth at five different retention rates, and the spread is usually wider than people expect.

Customer Lifetime Value Formula

Lifetime value is gross profit per period divided by the churn rate. The rest follows from it.

The relationship between churn and value is not linear, and that is the whole point. Halving churn does not add 50% to lifetime value — it doubles it. Every improvement in retention is worth proportionally more than the last, which is why mature subscription businesses spend so heavily on it.

Example

$62 a month, 72% margin, 3.5% monthly churn

1. Monthly gross profit: 62 × 0.72 = $44.64.
2. Average customer life: 1 ÷ 0.035 = 28.6 months, or about two years and five months.
3. Lifetime value: 44.64 ÷ 0.035 = $1,275.43.
4. Lifetime revenue, for comparison: 62 ÷ 0.035 = $1,771.43 — the figure you get by forgetting to apply the margin.
5. Discounted at 10% a year: 44.64 ÷ (0.035 + 0.008333) = $1,030.15.
6. Against a $620 acquisition cost: ratio 2.06 : 1, payback 13.9 months.

This business does not clear the benchmarks

A 2.06:1 ratio is below the 3:1 that most investors treat as the floor, and a 13.9-month payback is beyond the twelve-month target. Neither is a catastrophe, and together they say something specific: the business is buying customers at a price it can just about justify, with no margin for the lifetime value estimate being optimistic. If churn is actually 4% rather than 3.5%, the ratio falls to 1.80.

What half a point of churn is worth

Reduce monthly churn from 3.5% to 3.0% and the average life extends from 28.6 to 33.3 months. Lifetime value rises from $1,275.43 to $1,488.00 — a 16.67% increase from a half-point improvement. Nothing else available to this business moves the number that far that cheaply, and it is the reason retention work usually outperforms acquisition work once a product is established.

Why Churn Dominates the Answer

The same customer at five different churn rates.

At 8% monthly churn the ratio drops below 1.00, which means the business loses money on every customer it acquires. Between 2% and 8% — a range most subscription businesses move through at some point — lifetime value varies fourfold. No other input on this page has anything like that influence.

Typical monthly churn varies by market. Consumer subscriptions often run 5% to 7%. Small-business software tends to land between 3% and 5%. Enterprise contracts, measured annually, frequently come in under 1% a month. If your figure sits well outside the range for your market, check the definition before celebrating or panicking — churn measured on customers, on revenue and on logos gives three different answers.

The discounted figure deserves more attention than it usually gets. On a 28-month life the discount takes 19.2% off the value; on a ten-year enterprise relationship it would take far more. Any business making decisions on undiscounted lifetime value from long customer lives is overstating what those customers are worth today, which is exactly the error the present value calculator exists to correct.

Four Assumptions That Deserve Scrutiny

Four assumptions inside this calculation that deserve scrutiny.

Churn is not constant. Most products lose a large share of new customers in the first few months and then retain the survivors far better. A single blended rate underestimates the value of a customer who has already stayed a year, and overestimates the value of one who signed up yesterday. Cohort analysis is the proper fix; a blended rate is the workable approximation.

Revenue per customer moves. Businesses with upgrades, seat growth or annual price rises see revenue expand over a customer's life, sometimes enough to offset churn entirely. If your net revenue retention is above 100%, this formula understates lifetime value substantially and you need a model that accounts for expansion.

Gross margin is often guessed. Support costs, hosting, payment fees and account management all belong in it, and all are easy to forget. A margin assumed at 80% that is really 65% overstates lifetime value by 23% — build it from the gross profit calculation rather than estimating.

Averages hide the distribution. If a fifth of your customers produce four-fifths of the value, an average lifetime value tells you almost nothing useful about who to acquire. Segment before you spend: the customers worth $3,000 and the customers worth $200 justify very different acquisition budgets.

Used carefully, lifetime value is the number that makes acquisition spending rational rather than nervous. Used carelessly, it is the number that justifies spending far too much for years before anyone checks. Pair it with the CAC calculator and re-run both every quarter with real data rather than the assumptions you started with.