Scale. Optimize. Succeed.

Home  ›  Resources  ›  Tools  ›  Lifetime value

Customer Lifetime Value Calculator

Lifetime value is usually quoted in revenue, over a lifespan nobody measured, without discounting money that arrives in two years. This works it out in contribution, shows what that stream is worth today, and puts it next to what you pay to acquire a customer.

INPUTS

Six

RUNS IN

Your browser

EMAIL REQUIRED

No

FORMULA

Printed below

Desk with a calculator and planning documents, modelling what a customer is worth over time

A lifetime value you cannot finance is a forecast, not an asset.

What a customer is worth, in contribution

Six inputs. Change any of them and every figure updates as you type.

$Typical order total, excluding tax and delivery charged to the customer.
%After goods, fees, delivery and returns. Using gross margin here inflates everything below.
Average purchases per active customer per year, from your own order data.
yrHow long a customer keeps buying. Measure it; do not assume five years.
$Blended CAC, ideally. The CAC calculator works it out if you do not have it.
%What money is worth to you over time. Set to zero to skip discounting.
Contribution per year—Order value × margin × orders per year
Lifetime contribution—Across the full lifespan, undiscounted
Present value today—The same stream, discounted at the rate above
LTV to CAC ratio—Lifetime contribution divided by acquisition cost
Months to pay back CAC—How long the acquisition money is tied up
Orders per customer, lifetime—Orders per year × lifespan

Formula: contribution per year = order value × contribution margin × orders per year. Lifetime contribution = that figure × lifespan. Present value discounts the same stream as an annuity: contribution per year × (1 − (1 + rate)−years) ÷ rate. The ratio uses the undiscounted lifetime figure, which is the convention; the present value tile is there so you can see what the convention costs you. Nothing is sent anywhere — this runs entirely in your browser.

Why most lifetime value numbers are too big

Three assumptions do almost all the damage, and two of them are usually never measured.

The first is revenue instead of contribution. A lifetime value quoted in revenue describes money that passed through the business, not money it kept, and on a 30% margin it overstates the real figure by more than three times. The second is lifespan: five years is the number people reach for, and almost nobody has checked it against their own cohorts.

The third is time. Contribution arriving in year three is worth less than contribution arriving now, and if you are funding acquisition from cash flow it may be worth a great deal less. That is what the discount rate is for, and why the present value tile turns amber when it falls below what you paid to acquire the customer — a perfectly healthy-looking ratio can hide a payback you cannot finance.

Accountant working through repeat purchase figures with a calculator and documents

Four ways lifetime value gets inflated

Each of these makes a customer look more valuable than the accounts will ever show.

Quoting it in revenue

The most common error by a distance. Lifetime revenue is not lifetime value; only the contribution is yours, and the gap is the whole margin structure of the business.

Assuming the lifespan

A number nobody measured, usually rounded up. If your cohort data shows most customers stop after eighteen months, using three years doubles the answer.

Averaging across everybody

A blended lifetime value across one-time buyers and subscribers describes neither. Segment by acquisition channel first — the cheapest channel often delivers the worst cohort.

Ignoring when the money arrives

A three-year payback is a financing decision. The present value and payback tiles exist so that decision is taken deliberately rather than discovered later.

Our retention guide covers measuring repeat behaviour by cohort, which is where the lifespan and frequency inputs should come from. If you cannot state a lifespan honestly, the LTV calculator derives the order count from a repeat rate instead.

Lifetime value FAQs

The questions this calculator usually raises.

Yes. Lifetime value and customer lifetime value are the same idea, and both are used interchangeably in eCommerce. What matters far more than the initials is whether the figure is quoted in revenue or in contribution, because those two answers differ by the whole margin structure of the business.

Three to one is the convention, borrowed from software businesses, and it is a rule of thumb rather than a law. What actually matters is whether the ratio is above one on contribution, and whether you can finance the payback period. A 2:1 ratio with a four-month payback is a healthier business than a 4:1 ratio with a three-year one.

From your own order data. Group customers by the month of their first order and look at when purchasing stops in each cohort. Most stores that measure it for the first time find the honest number is considerably shorter than the one they had been quoting.

If the money is material and arrives more than a year out, yes. Discounting answers a real question: what is a stream of future contribution worth to the business today, given that cash is finite and has alternative uses. Set the rate to zero if you would rather see the undiscounted figure.

Because the discounted lifetime contribution has fallen below what you paid to acquire the customer. The undiscounted ratio can still look acceptable while that is true, which is exactly the situation the tile exists to surface.

Directly. Lifetime value sets the ceiling on what you can afford to pay for a customer, and the CAC calculator works out what you are actually paying. Running both on the same period is the point.

Related tools and reading

Working through acquisition cost figures on paper with a calculator and pen

CALCULATOR

The other half of the ratio: blended CAC, paid CAC and the break-even your margin supports.

Calculator beside a margin spreadsheet on a desk, working out eCommerce profit per order

CALCULATOR

Works out the contribution margin this calculator asks for, from your price and cost lines.

Senior strategists reviewing eCommerce performance charts during an audit session

FREE AUDIT

Five working days across six disciplines, including whether your cohort data supports the lifespan you are using.

Lifetime value built on an assumed lifespan?

It usually is, and the honest figure is usually shorter. The free audit rebuilds it from your own cohorts rather than from a number somebody picked.

Free account

Get the eCommerce benchmarks other agencies charge for

Register for free access to our quarterly benchmark reports, the growth audit template we run on every new client, and the Margin Memo newsletter.