Home Business How to Calculate Customer Lifetime Value (CLV): Formulas and Examples

How to Calculate Customer Lifetime Value (CLV): Formulas and Examples

Analytics charts used to calculate customer lifetime value
Photo: Carlos Muza / Unsplash

Knowing what a customer is worth over the whole relationship changes how you spend on marketing, support and retention. This guide shows how to calculate customer lifetime value (CLV, sometimes written LTV) with simple formulas for both one-off purchases and subscriptions, walks through worked examples, and explains how to use the number to make better decisions.

In short, customer lifetime value is the total revenue, or ideally profit, you can expect from a customer before they stop buying. The Wikipedia overview of customer lifetime value covers the more advanced academic models.

The Basic Customer Lifetime Value Formula

For most businesses, start here:

CLV = Average purchase value × Purchase frequency × Customer lifespan

  • Average purchase value = total revenue ÷ number of orders in a period.
  • Purchase frequency = number of orders ÷ number of unique customers in the same period.
  • Customer lifespan = how many years (or months) a typical customer keeps buying.

How to Calculate Customer Lifetime Value: A Worked Example

Imagine an online store with these yearly numbers:

  • Average order value: $60
  • Orders per customer per year: 3
  • Average customer lifespan: 2.5 years

CLV = 60 × 3 × 2.5 = $450 in revenue per customer.

Revenue isn’t profit, though. If the store’s gross margin is 40%, the profit-based CLV is 450 × 0.40 = $180. That’s the number to compare with what you spend to win a customer.

Customer Lifetime Value for SaaS and Subscriptions

Subscription businesses usually calculate CLV from monthly revenue and churn:

CLV = Average revenue per account (ARPA) ÷ Churn rate

Or, using profit:

CLV = (ARPA × Gross margin %) ÷ Churn rate

Example: a SaaS product earns $50 per customer per month and has 4% monthly churn.

  • Average lifetime = 1 ÷ 0.04 = 25 months
  • Revenue CLV = 50 ÷ 0.04 = $1,250
  • With an 80% gross margin: (50 × 0.80) ÷ 0.04 = $1,000

Churn is the lever that moves this most. Our step-by-step guide on how to calculate churn rate shows how to get that number right.

How to Calculate Customer Lifetime Value in a Spreadsheet

  1. Put average order value in B2, purchases per year in B3 and lifespan in years in B4.
  2. In B5, enter =B2*B3*B4 for revenue CLV.
  3. Put gross margin (e.g. 0.4) in B6 and use =B5*B6 for profit CLV.
  4. For subscriptions, use =(ARPA*Margin)/Churn with monthly figures.

CLV to CAC Ratio: Is Your Growth Profitable?

Customer acquisition cost (CAC) is what you spend on sales and marketing to win one customer. Comparing it with CLV tells you whether growth pays off.

CLV : CACWhat it usually means
Below 1 : 1You lose money on every new customer
Around 3 : 1A widely quoted healthy benchmark
5 : 1 or higherVery efficient – you may be under-investing in growth

Also watch the payback period: how many months it takes for a customer’s profit to cover their acquisition cost.

Common CLV Calculation Mistakes

  1. Using revenue instead of profit when deciding how much to spend on acquisition.
  2. Mixing very different customers into one average. Calculate CLV by plan, channel or segment.
  3. Guessing lifespan for a young business. Use churn data or a conservative estimate.
  4. Ignoring discounts and refunds, which quietly lower real value.
  5. Treating CLV as fixed. Recalculate every quarter as pricing and retention change.

How to Increase Customer Lifetime Value

  • Improve onboarding so customers succeed early and stay longer.
  • Reduce churn with proactive check-ins and easy downgrade options.
  • Raise average order value through bundles, annual plans or add-ons. Our guide to SaaS pricing models covers the options.
  • Encourage repeat purchases with useful email follow-ups and loyalty rewards.
  • Win back lapsed customers with a targeted offer.

Frequently Asked Questions

What is the simplest formula for customer lifetime value?

Average purchase value × purchase frequency × customer lifespan. Multiply by gross margin to turn revenue into profit.

Is CLV the same as LTV?

Yes. CLV (customer lifetime value) and LTV (lifetime value) describe the same idea and are used interchangeably.

What is a good customer lifetime value?

There’s no universal number. What matters is how CLV compares with your customer acquisition cost – a ratio of around 3:1 is a common target.

How often should I calculate CLV?

Quarterly works for most businesses, or whenever you change pricing, launch a new plan or see a shift in churn.

Final Thoughts

Once you know how to calculate customer lifetime value, you can set smarter marketing budgets, spot your most valuable customers and focus on retention where it counts. Start with the simple formula, move to profit-based CLV, and track it alongside churn and acquisition cost.