Customer Lifetime Value Formula: How to Calculate CLV

62% of B2B companies don't measure the ROI of their customer experience programs. That stat from Forrester's 2025 research is worth sitting with. Six out of ten companies make budget calls, hiring decisions, and go-to-market choices without knowing what a customer is actually worth over time. The customer lifetime value formula fixes that. It's not complicated math — it's a way of thinking that separates intentional growth from guesswork.

This guide covers every version of the formula, real-world examples, and the mistakes that make CLV models useless.

What Is Customer Lifetime Value?

Customer Lifetime Value — CLV, CLTV, LTV, all the same thing — is the total revenue you can expect from one customer over the entire time they stay with you.

The real question isn't what it is. It's why so many B2B teams still get it wrong.

In B2C, you've got thousands of transactions to analyze. Someone buys shoes four times a year, you model it, done. B2B is different. Maybe 47 clients. Sales cycles dragging for months. Deal sizes jumping from $3,000 to $180,000 depending on the account. Most teams end up staring at a spreadsheet full of averages and hoping for the best.

The data silos don't help. Revenue lives in one tool, churn data in another, support tickets somewhere else. So people give up.

The ones who figure it out have a real edge. Bain & Company found that a 5% increase in retention boosts profits 25% to 95%. Gainsight and Forrester's 2025 data shows 76% of B2B annual revenue comes from existing customers. McKinsey's 2025 research puts personalization-driven revenue gains at 40%. Omnichannel customers carry 30% higher CLV.

Understanding your customer value formula isn't a nice-to-have. It's the difference between guessing and knowing.

The Basic Customer Lifetime Value Formula

If you've ever wondered how to calculate lifetime value of a customer, start here.

CLV = Average Purchase Value × Purchase Frequency × Customer Lifespan

Three numbers multiplied together. That's it.

Average Purchase Value: Total revenue divided by number of purchases. $500,000 from 100 deals = $5,000 per purchase.

Purchase Frequency: How often one customer buys in a year. Annual contracts = 1. Monthly orders = 12.

Customer Lifespan: How many years the average customer stays before leaving. Trickiest to estimate — more on that below.

A Quick CLV Example

Say Mike runs a B2B company. His average client pays $5,000 a year, buys once per year, and stays about 4 years.

CLV = $5,000 × 1 × 4 = $20,000

Now Mike knows each new client is worth roughly $20,000 over their lifetime. That changes how much he's willing to spend to acquire one.

Use this version for board presentations, quick estimates, and early-stage companies that haven't been around long enough to build complex models. It's a starting point — a really good one.

Customer Lifetime Value Formula in Excel

Open a spreadsheet. Column A: Purchase Value. Column B: Frequency. Column C: Lifespan. Column D: =A2*B2*C2. Done.

For SaaS, the formula is =(Gross Margin% × ARPU) / Churn Rate.

Build separate tabs for each customer cohort — group by signup quarter. Your 2022 customers behave nothing like your 2025 ones. Cohort-based CLV beats one giant average every time. You don't need a fancy CLV calculator. A well-structured spreadsheet does the job.

How to Calculate CLV for B2B and SaaS Companies

The basic formula has limits. Running a SaaS product or selling complex B2B services? You need formulas that fit your model.

The SaaS CLV Formula

CLV = (Gross Margin % × ARPU) / Customer Churn Rate

Quick math: gross margin 80%, ARPU $200/month, monthly churn 3%.

(0.80 × $200) / 0.03 = $5,333

This formula bakes in the retention rate automatically. Churn is just the flip side of retention. If 3% leave each month, 97% stay. Same coin.

B2B Services CLV Formula

CLV = (Average Revenue Per Customer × Customer Lifespan) − Acquisition Cost

This version subtracts what it cost to land the client. More realistic for agencies and consulting firms where acquisition costs run high.

The Customer Lifespan Formula

Lifespan = 1 / Churn Rate

10% annual churn? Average customer stays 10 years. 20% churn? Five years. Simple division, but it changes everything when you plug it into your models.

Business Model	Recommended Formula	Best For
Local Services	Purchase Value × Frequency × Lifespan	Repeat transaction businesses
SaaS	(Gross Margin % × ARPU) / Churn	Subscription companies
Professional Services	(ARPC × Lifespan) − Acquisition Cost	Consulting, agencies, B2B services

Even with a small account base — say 50 clients — running these numbers shows you which segments deserve more budget. You don't need a data science team. Executive judgment plus the basic formula gets you 80% of the way there.

Advanced CLV Formula with Discount Rate

CLV = Gross Contribution × (Retention Rate / (1 + Discount Rate − Retention Rate))

The customer lifetime value formula with discount rate accounts for the fact that a dollar five years from now isn't worth as much as a dollar today. Use it for multi-year B2B contracts or when your CFO wants NPV-adjusted figures.

For most B2B companies, simpler formulas work fine. Start with deal size times renewals times retention, then refine. Don't over-engineer it.

CLV vs. CAC — The Ratio That Drives Decisions

CLV alone is just a number. Pair it with Customer Acquisition Cost and you've got the most important ratio in B2B.

CLV:CAC Ratio = CLV / Customer Acquisition Cost

Benchmarks:

Below 1:1 — you're paying more to get customers than they'll ever return
3:1 — healthy minimum
5:1 — the sweet spot
Above 5:1 — could mean you're under-spending on growth

Customer acquisition cost vs. lifetime value stops being a textbook concept when it drives real decisions: pricing, budgets, channel strategy, which markets to enter. The ratio tells you all of it.

Real-World CLV Examples

Starbucks

Average customer spends $25,272 over their lifetime. Profit margin on that: 21.3%. Customer satisfaction at 89%. Every loyalty perk, every app notification, every seasonal drink ties back to maximizing lifetime value. So what is a good customer lifetime value? Depends entirely on your model. For a coffee chain, $25k is strong. For enterprise SaaS, that might be a small account.

Netflix

CLV of approximately $291.25, based on a 25-month average lifespan and $8.97/month ARPU. Sounds low compared to Starbucks. Multiply it across 250+ million subscribers. Every price hike, every show renewal — CLV calculation behind it.

Cloudastructure

Near-100% retention rate. The company has said publicly that retention is as critical as new sales. When clients basically never leave, even moderate annual revenue per account compounds into something significant.

Adidas adiClub

240 million members. Loyalty members buy 50% more frequently and generate 2× the lifetime value of non-members. That's what happens when you design a program around CLV data instead of offering random discounts.

Astrid & Miyu

Loyalty members spend 220% more per year and are 6× more likely to repurchase. Proof you don't need to be a Fortune 500 to make CLV work.

What do all these companies share? They use CLV to decide where money goes. Not gut feel. Actual math connected to a real retention strategy.

How to Use CLV to Prioritize Your Prospecting

You've run the numbers. Now what changes on Monday morning?

Not every lead becomes a $50,000 lifetime customer. Some churn in three months. The game is figuring out which is which before you blow your acquisition budget.

Start with your existing customers. Sort by CLV. Look at the top 20% — what's the pattern? Industry? Company size? Strong reviews? Good online presence? That pattern is your Ideal Customer Profile. Use it to filter every new prospect.

Then allocate accordingly. Best budget goes to highest-CLV segments. Segments that churn fast and spend little? Stop pouring thousands into them.

AI is sharpening all of this. 2025 reports show AI improves CLV forecast accuracy by 25–40%. Health scoring predicts churn 3–6 months out. Customer success programs tied to CLV data show 15–25% churn reduction (SaaStr and Gainsight). And 58% of consumers leave after one bad experience. One. So retention isn't just product quality — it's every interaction.

To calculate meaningful CLV, you need decent data on who you're targeting. Garbage in, garbage out — whatever CLV model you build. IBLead lets you build targeted prospect lists from Google Maps data across 50M+ businesses in 37 countries. Filter by rating, number of reviews, website presence — all signals of an established, growing business likely to become a high-CLV account. $52 for 10,000 leads. Start free — 200 credits, no card required

Common CLV Mistakes to Avoid

Averaging Everything Together

Your 2023 cohort is not your 2025 cohort. Different market, different pricing, different onboarding. Dumping all customers into one average hides every useful trend. Build cohort models. Group by signup quarter. Thirty extra minutes of setup, massive clarity.

Pretending Churn Doesn't Exist

I've seen spreadsheets projecting CLV with zero churn. Customer lives forever, pays forever. That's not a model — that's a wish. The customer lifespan formula (1 ÷ churn rate) belongs in every model you build.

Ignoring Discount Rates on Long Deals

Past the 4–5 year mark, a future payment is worth meaningfully less than today's. Inflation, opportunity cost, risk. Account for it.

Calculating CLV and Doing Nothing With It

Pretty dashboard, quarterly presentation, then nothing changes. CLV only matters when it drives action. Connect it to CAC. Tie it to your prospecting strategy. Otherwise it's just a number nobody looks at after Tuesday.

Never Updating the Model

Markets shift. Churn rates move. If your CLV calculation is 18 months old, it's stale. Recalculate quarterly at minimum.

If your purchase cycles are irregular — most B2B companies, let's be honest — use cohort-based CLV over 3–5 year windows. And if your data isn't clean? Start anyway. Deal size × renewals × retention. It's only an estimate, but infinitely better than nothing.

FAQ

What is the simplest customer lifetime value formula?

CLV = Average Purchase Value × Purchase Frequency × Customer Lifespan. A B2B client paying $5,000/year who stays 4 years: $5,000 × 1 × 4 = $20,000. Takes about ten seconds.

What is a good CLV to CAC ratio?

You want at least 3:1 — every customer brings in three times what you spent to acquire them. The best companies hit 5:1. Below 1:1, you're losing money on each customer. Above 5:1 might mean you're under-investing in growth.

How do you calculate CLV with churn rate?

First, figure out customer lifespan: 1 ÷ churn rate. If 10% of customers leave each year, average lifespan is 10 years. Multiply that by average annual revenue per customer. For SaaS, use CLV = (Gross Margin % × ARPU) / Churn Rate — cleaner for subscription models.

Can you calculate CLV in Excel?

Yes. Columns for purchase value, frequency, and lifespan. Multiply across. For SaaS: =(Gross Margin% × ARPU) / Churn Rate. Add cohort tabs — group customers by signup quarter and track CLV per group. Far more useful than one big average.

What's the difference between CLV and LTV?

Nothing. CLV, LTV, CLTV — same metric. Marketing people tend to say CLV, finance people often say LTV. Pick whichever your team uses and move on.

Start With the Right Prospects

The CLV formula isn't complicated math. It's a way of thinking that separates companies growing intentionally from ones just reacting.

McKinsey: 40% more revenue from personalization. Bain: a 5% retention bump can mean 95% more profit. 76% of B2B revenue comes from existing customers. The numbers are clear. The companies winning right now aren't guessing which customers matter — they're calculating it and updating their models quarterly.

But the math is pointless if you're chasing the wrong prospects. You need to find the accounts most likely to become your highest-CLV customers. IBLead gives you 50M+ pre-indexed businesses across 37 countries, updated weekly. Filter by Google rating, review count, and detected technologies to find established businesses that match your top customer profile. Export instantly to CSV, import into your outreach tool of choice.

$52 for 10,000 leads — that's $0.005 per contact.

Start free — 200 credits, no card required