Blog / Finance

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:

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 findFormula
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 ratioCustomer lifetime value ÷ CAC
Months to earn back CACCAC ÷ Gross profit a customer brings in each month

How to calculate customer lifetime value, step by step

  1. 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.
  2. 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.
  3. Find how long customers stay. Look at how many years customers keep buying before they stop. Say 3.
  4. Multiply them for lifetime revenue. $80 × 4 × 3 = $960.
  5. 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 AShop B
Lifetime revenue per customer$960$960
Gross margin20%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

InputHow to work it outWhere it usually comes from
Average order valueRevenue in a period ÷ number of orders in itYour shop, payment or accounting system
Purchases a yearOrders in a year ÷ number of different customersOrder history, or your CRM
Years as a customerAverage time between a customer’s first and last purchaseOrder history; for a young business, an honest estimate
Monthly churnCustomers who cancelled in a month ÷ customers at the start of itYour billing or subscription system
Gross margin(Revenue − Cost of goods sold) ÷ RevenueYour accounts
CACSales and marketing spend ÷ New customers won in the same periodYour 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 churnAverage lifetimeLTV 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.

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 to increase customer lifetime value

Common LTV mistakes

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):

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.

Coavon · Blog · Templates · Features · Pricing