LTV calculator
See what a customer is worth over their whole time with you. Enter how much and how often they buy, or their monthly payment and churn, and the lifetime value, LTV to CAC ratio and payback time appear as you type.
Customer lifetime value calculator: three modes. Repeat purchases: enter the average order value, how many times a year a customer buys, how many years they stay and your gross margin to see the customer lifetime value, lifetime revenue and gross profit a year. Subscription: enter the revenue per customer each month, your gross margin and monthly churn to see the lifetime value and the average customer lifetime in months. Add what it costs to win a customer to either mode for the LTV to CAC ratio and the months it takes to earn that cost back. LTV to CAC: enter a lifetime value, your sales and marketing spend and the customers it won to see your cost per customer and the ratio.
The Coavon team · · 11 min read
Customer lifetime value (LTV, or CLV) is the gross profit a customer brings in over their whole time with you. For a business with repeat customers, multiply the average order value by how many times a customer buys a year, by how many years they stay, and by your gross margin. A customer who spends $80 four times a year for three years, at a 40% gross margin, is worth $80 × 4 × 3 × 40% = $384.
The calculator above does this for repeat purchases and for subscriptions, and compares the result with what it costs to win a customer. Below: how to use it, the LTV formula for each kind of business, where to find each number, worked examples, the LTV to CAC ratio, and how to raise the lifetime value of your customers.
Looking for a loan-to-value calculator? In mortgages and car loans, LTV means loan to value: the loan amount divided by the value of the home or car, times 100. This page is about customer lifetime value, the LTV used in business and marketing.
How to use the LTV calculator
Pick the mode that matches how your customers pay you:
- Repeat purchases: for shops, online stores, restaurants and service businesses whose customers come back and buy again. Enter the average order value, the purchases a year, the years as a customer and your gross margin. You get the lifetime value, the lifetime revenue behind it and the gross profit a customer brings in each year.
- Subscription: for software, memberships and monthly retainers. Enter the revenue per customer each month, your gross margin and your monthly churn, the share of customers who cancel in a month. You get the lifetime value and how long the average customer stays.
- LTV to CAC: you already know your lifetime value and want to compare it with what winning customers costs. Enter the lifetime value, your sales and marketing spend for a period and the new customers it brought in.
In the first two modes, add the cost to win a customer (CAC) to see the LTV to CAC ratio and how many months a customer takes to pay back what it cost to win them. Leave the gross margin empty if you only want lifetime revenue, but the profit figure is the one to make decisions with.
The LTV formula
Customer lifetime value = Average order value × Purchases a year × Years as a customer × Gross margin
For a subscription, the length of a customer's life comes from churn: if 3% of customers cancel each month, the average customer stays 1 ÷ 0.03 = 33.3 months. That gives a shorter formula:
Subscription LTV = Revenue per customer a month × Gross margin ÷ Monthly churn
| To find | Formula |
|---|---|
| Lifetime revenue (repeat purchases) | Average order value × Purchases a year × Years as a customer |
| Customer lifetime value (repeat purchases) | Lifetime revenue × Gross margin |
| Average customer lifetime (subscription) | 1 ÷ Monthly churn, in months |
| Customer lifetime value (subscription) | Revenue per customer a month × Gross margin ÷ Monthly churn |
| Cost to win a customer (CAC) | Sales and marketing spend ÷ New customers won |
| LTV to CAC ratio | Customer lifetime value ÷ CAC |
| Months to earn back CAC | CAC ÷ Gross profit a customer brings in each month |
How to calculate customer lifetime value, step by step
- Find your average order value. Divide revenue over a period by the number of orders in it. $240,000 from 3,000 orders is $80.
- Find how often a customer buys. Divide the number of orders by the number of different customers who placed them. 3,000 orders from 750 customers is 4 a year.
- Find how long customers stay. Look at how many years customers keep buying before they stop. Say 3.
- Multiply them for lifetime revenue. $80 × 4 × 3 = $960.
- Multiply by your gross margin. $960 × 40% = $384 customer lifetime value.
That $384 is the most you could spend winning a customer and still break even on them. In practice you want to spend well under it, because the business has other costs to pay and the lifetime value is an estimate.
Revenue LTV or profit LTV?
Many LTV figures you see are lifetime revenue: what a customer pays you in total. That is easy to work out but can be misleading, because a business that keeps 20% of each sale and one that keeps 80% could have the same revenue LTV and very different businesses. Lifetime value based on gross margin, what is left after the direct cost of serving the customer, tells you what a customer is really worth to you and what you can afford to spend to win one.
| Shop A | Shop B | |
|---|---|---|
| Lifetime revenue per customer | $960 | $960 |
| Gross margin | 20% | 60% |
| Customer lifetime value (profit) | $192 | $576 |
Our gross margin calculator works out the margin to use, from your revenue and cost of goods sold.
Where to find each number
| Input | How to work it out | Where it usually comes from |
|---|---|---|
| Average order value | Revenue in a period ÷ number of orders in it | Your shop, payment or accounting system |
| Purchases a year | Orders in a year ÷ number of different customers | Order history, or your CRM |
| Years as a customer | Average time between a customer’s first and last purchase | Order history; for a young business, an honest estimate |
| Monthly churn | Customers who cancelled in a month ÷ customers at the start of it | Your billing or subscription system |
| Gross margin | (Revenue − Cost of goods sold) ÷ Revenue | Your accounts |
| CAC | Sales and marketing spend ÷ New customers won in the same period | Your accounts and your CRM |
Use the same period for every number, and leave out one-off sales that will not repeat, or the lifetime value will look higher than it is.
LTV examples
An online store
Customers spend an average of $55 an order, order 3 times a year and keep buying for 2 years. Lifetime revenue is $55 × 3 × 2 = $330. At a 45% gross margin, the customer lifetime value is $148.50. If ads win customers for $50 each, the LTV to CAC ratio is about 3 : 1, and each customer pays back their $50 in about 8 months ($148.50 ÷ 2 years = $74.25 of gross profit a year, or $6.19 a month).
A software subscription
Customers pay $50 a month, the gross margin is 80% and 3% of customers cancel each month. The average customer stays 1 ÷ 0.03 = 33.3 months, so lifetime revenue is about $1,667 and the lifetime value is $50 × 0.80 ÷ 0.03 = $1,333. With a CAC of $400, each customer brings in $40 of gross profit a month and pays back their cost in 10 months.
An agency with monthly retainers
Clients pay a $4,000 monthly retainer. The people doing the work cost $2,200 a month for each client, a 45% gross margin, and about 1 in 25 clients ends their retainer each month, a 4% churn. The lifetime value is $4,000 × 0.45 ÷ 0.04 = $45,000, and the average client stays 25 months. If winning a client takes $9,000 of sales time and marketing, the ratio is 5 : 1.
How churn changes everything
In the software example, cutting monthly churn from 3% to 2% raises the average customer lifetime from 33 to 50 months and the lifetime value from $1,333 to $2,000, with no change in price. Keeping customers longer is often the fastest way to raise LTV.
| Monthly churn | Average lifetime | LTV at $50 a month and 80% margin |
|---|---|---|
| 1% | 100 months | $4,000 |
| 2% | 50 months | $2,000 |
| 3% | 33.3 months | $1,333 |
| 5% | 20 months | $800 |
| 10% | 10 months | $400 |
The LTV to CAC ratio
Lifetime value on its own does not tell you whether a customer is worth winning. Compare it with your customer acquisition cost (CAC): everything you spend on sales and marketing in a period, divided by the new customers won in that period. The LTV to CAC ratio is lifetime value ÷ CAC.
- Below 1 : 1, you spend more winning each customer than they ever bring in, and every new customer loses money.
- Around 1 : 1, customers pay back what they cost to win and nothing more, leaving nothing for the rest of the business.
- Around 3 : 1 is a widely used rule of thumb for a healthy balance: each customer brings in about three times what they cost to win.
- Far above that can mean you are spending too little on growth and could win more customers profitably.
Look at how long the payback takes, too. A 3 : 1 ratio where customers take four years to pay back their cost ties up much more cash than one where they pay it back in six months.
What is a good customer lifetime value?
There is no good LTV on its own: a $50 lifetime value is excellent for a business that wins customers for $5, and a disaster for one that pays $100. What matters is:
- How it compares with your CAC. That is the ratio above, and it tells you how much you can spend on marketing.
- Which way it is moving. A lifetime value that falls month after month is an early sign that customers are leaving sooner or spending less.
- How it differs between customers. Work it out for each channel, product or customer type. The customers from one channel are often worth far more than from another, which tells you where to spend.
How to increase customer lifetime value
- Keep customers longer. Find out why customers leave and fix the biggest reason first. Even a small fall in churn raises lifetime value a lot, as the table above shows.
- Make the start smooth. Customers who get value quickly are more likely to stay. Check in during the first weeks, not only when they are about to renew.
- Stay in touch with quiet customers. Notice when a customer has not bought or spoken to you for a while, and reach out before they drift away.
- Raise the order value. Bundles, add-ons and a higher plan that is worth the price raise what each customer spends.
- Review your prices. A price rise goes straight into gross margin, and so into lifetime value. Test it on new customers first.
- Improve your margin. Lower the cost of serving each customer: buy for less, cut waste, and for services, keep track of the hours each client really takes.
Common LTV mistakes
- Using revenue instead of profit. Spending up to the revenue LTV to win customers loses money once costs are paid.
- Mixing periods. Average order value from this year, churn from last year and CAC from one month give a number that describes nobody.
- Trusting one average. One big customer can make the average look far better than a typical customer. Work it out per group of customers, too.
- Assuming customers stay for ever. A young business has not yet seen how long customers stay. Use a cautious lifespan and update it as real data comes in.
- Forgetting it is an estimate. Lifetime value predicts the future from the past. Recalculate it every few months.
How to calculate LTV in Excel or Google Sheets
With the average order value in A2, purchases a year in B2, years as a customer in C2 and gross margin in D2 (as a percentage):
- Lifetime revenue:
=A2*B2*C2 - Customer lifetime value:
=A2*B2*C2*D2 - Subscription LTV, with monthly revenue in E2, gross margin in D2 and monthly churn in F2:
=E2*D2/F2 - LTV to CAC, with the lifetime value in G2 and CAC in H2:
=G2/H2 - Months to earn back CAC, for a subscription:
=H2/(E2*D2)
Keep your best customers longer
Lifetime value grows when customers stay, and customers stay when nothing about them is forgotten. Scope, Coavon's CRM, keeps every client, their contacts, deals and history in one place, with follow-ups on a date for a person and rules that react when a record has gone quiet, so someone checks in before a client drifts away. Its Analytics shows revenue won and win rate. Alongside it, Flow tracks the time spent on each client's work, so the true cost of serving them, and so your margin, is something you can look up.
How do you calculate customer lifetime value?
Multiply the average order value by the number of purchases a customer makes a year, by the number of years they stay, and by your gross margin. A customer who spends $80 four times a year for three years at a 40% gross margin is worth $384.
What is the LTV formula for a subscription?
Revenue per customer a month × gross margin ÷ monthly churn. A $50 subscription with an 80% gross margin and 3% monthly churn has a lifetime value of $50 × 0.8 ÷ 0.03 = $1,333.
What is the difference between LTV and CLV?
None: LTV (lifetime value) and CLV (customer lifetime value) are two names for the same measure, sometimes also written CLTV.
What is a good LTV to CAC ratio?
Around 3 : 1 is a widely used rule of thumb: each customer brings in about three times what it cost to win them. Below 1 : 1, every new customer loses money.
How do you calculate customer lifetime from churn?
Divide 1 by the monthly churn rate. With 3% of customers cancelling each month, the average customer stays 1 ÷ 0.03 = 33.3 months.
Should LTV use revenue or profit?
Profit, ideally gross margin. Revenue LTV is easier to work out but overstates what a customer is worth and how much you can spend to win one.
Is this a loan-to-value (LTV) calculator?
No. In mortgages and car loans, LTV means loan to value: the loan divided by the value of the property or car. This calculator is for customer lifetime value.
Does the calculator save my numbers?
No. Everything is worked out in your browser. Nothing you enter is saved or sent anywhere.