Customer Lifetime Value Calculator

The Customer Lifetime Value Guide

The formulas behind LTV, the retention and lifespan options, how LTV to CAC and payback are worked out, and how to read the results with care.

Open CLV Calculator

What LTV Measures

Customer lifetime value is the gross profit you expect one customer to produce before they stop buying. It turns a one-off sale into a longer-term number, which is what you need when you compare it with what it costs to win that customer in the first place.

The calculator here is deliberately simple. It works from four business inputs: the average order value, how often a customer buys, the gross margin, and how long the customer stays. It then adds one optional cost, the customer acquisition cost, to produce two comparisons. Those comparisons are the LTV to CAC ratio and the simple payback period.

Every result is an estimate. Real customers differ, prices change, and margins move. The calculator tells you what your assumptions imply, which is useful for planning, but it is not a forecast you can bank on.

The Formula Set

The tool uses one consistent set of formulas. It does not switch to a different model in the middle of a calculation, and it does not discount future profit.

Step 1, annual gross profit per customer. Multiply the average order value by the number of purchases per year, then by the gross margin as a fraction. A margin of 40 percent is entered as 40 and used as 0.40.

Step 2, the customer lifetime in years. There are two routes. If a yearly retention rate is entered, the tool uses the retention formula, lifetime = 1 / (1 - retention). A retention of 60 percent gives a lifetime of 2.5 years. This treats the first year as certain, then assumes each later year keeps the same share of customers. If no retention rate is given, the tool uses the expected lifespan you typed.

Step 3, customer lifetime value. Multiply the annual gross profit by the lifetime in years. The result is undiscounted, so it is the simple sum of yearly profit, not a present value.

Step 4, LTV to CAC ratio. Divide the lifetime value by the customer acquisition cost. A ratio of 3.2 means each unit spent acquiring a customer is expected to return 3.2 units of gross profit over the relationship.

Step 5, simple payback period. Divide the acquisition cost by the monthly gross profit, which is the annual figure divided by 12. The result is in months. This version ignores churn, so it describes how long a customer who keeps buying would take to repay the cost.

Using Each Input

Average order value. The typical amount a customer spends in one order, in whatever currency you use. Use a realistic average over a recent period, not the price of your top product.

Purchases per customer per year. The number of orders a typical customer places in a year. A subscription with one box a month is 12. A product bought every few years should use a fraction, such as 0.5 for one order every two years.

Gross margin (%). The share of revenue left after the cost of the goods sold. The field accepts 0 to 100. A margin of 0 gives zero profit and makes every later figure zero or undefined.

Expected lifespan (years). Used only when the retention field is blank. Enter the number of years you expect a customer to keep buying. Decimals are allowed.

Yearly retention rate (%), optional. The share of customers who are still buying at the next year. When you enter a value, the retention formula replaces the lifespan. Values from 0 up to, but not including, 100 are accepted. The tool shows a message at 100 because the formula would divide by zero.

Customer acquisition cost, optional. The average cost to win one new customer, for example the advertising spend divided by new customers in the same period. Without it the ratio and payback show as not calculated. A value of zero gives a zero payback and an undefined ratio, which usually means a cost has been left out.

Reset sample values. Restores the sample inputs used in the first worked example below.

Worked Examples

The two examples use the same business: an order value of 60, three purchases per customer per year, a 40 percent gross margin, and an acquisition cost of 90. The figures below come from running the tool's own logic on these inputs.

Example A, lifespan method. Lifespan is 4 years and retention is left blank.

OutputWorkingResult
Annual gross profit60 x 3 x 0.4072.00
LifetimeEntered lifespan4.00 years
Customer lifetime value72.00 x 4288.00
LTV to CAC ratio288.00 / 903.20 : 1
Simple payback90 / (72.00 / 12)15.0 months

A ratio of 3.2 clears the common 3 to 1 rule of thumb, and the acquisition cost comes back in 15 months if the customer keeps buying at this rate.

Example B, retention method. The same business, but yearly retention is entered as 60 percent. The lifespan field is ignored.

OutputWorkingResult
Annual gross profit60 x 3 x 0.4072.00
Lifetime1 / (1 - 0.60)2.50 years
Customer lifetime value72.00 x 2.5180.00
LTV to CAC ratio180.00 / 902.00 : 1
Simple payback90 / (72.00 / 12)15.0 months

Lower retention cuts the lifetime and drops the ratio to 2.0, below the rule of thumb. The payback is unchanged at 15.0 months, which shows the limit of the simple payback: it does not depend on how long customers stay.

Tips and Common Mistakes

Use gross profit, not salesEntering revenue where margin belongs will inflate every result and make acquisition look cheaper than it is.
Keep the time units the samePurchases per year and lifespan in years must describe the same period, or the lifetime value will be off by a factor.
Match CAC to the same groupDivide acquisition spend by customers won in the same period and from the same channel you are assessing.
Test the sensitivityChange one input at a time. The result is usually most sensitive to margin and retention, so those are the assumptions to check first.

A frequent mistake is combining a high lifespan with a retention rate that implies a much shorter life. Choose one method and keep the other input for reference only, as the tool does.

Frequently Asked Questions

What is a good LTV to CAC ratio?

A ratio of 3 to 1 is a widely quoted rule of thumb, but it is only a guideline. Businesses with long purchase cycles, high margins or strong repeat buying may run comfortably at other levels, and a ratio that looks healthy can hide a very long payback period.

Should I use the retention method or the lifespan method?

Use retention when you have a measured yearly rate for a comparable group of customers, because it reflects how customers actually leave. Use lifespan when you have a reasoned estimate of how long customers stay but no retention measure. The two are not meant to be mixed in one calculation.

Why does the payback period stay the same when retention changes?

The simple payback divides acquisition cost by monthly gross profit per customer, and it does not use lifetime at all. Retention only affects how long a customer keeps paying, so it changes the LTV and the ratio, but not the payback shown here.

Open CLV Calculator