Customer Lifetime Value Formula: How to Calculate CLV in 2026

62% of B2B companies don't measure the ROI of their customer experience programs. Forrester dropped that stat in 2025 and it blew my mind. Six out of ten. Making budget decisions, hiring decisions, go-to-market calls — without knowing what a customer is actually worth over time.

I've talked to founders who know their MRR to the cent but go blank when you ask about their customer lifetime value formula. The name sounds like a finance textbook nobody asked to read. But it's not that scary. We're breaking it all down today.

What Is Customer Lifetime Value (And Why It Matters in 2026)

Customer Lifetime Value — people call it CLV, CLTV, LTV, doesn't matter, same thing — is the total revenue you can expect from one customer over the entire time they stick with you.

But if you clicked on this article, I'm going to assume you already knew that part. The real question is: why do so many B2B teams still get it wrong?

Think about it. In B2C, you've got thousands of transactions to crunch. Some guy buys shoes four times a year, you model that, done. B2B? Completely different animal. Maybe 47 clients. Sales cycles dragging for months. Deal sizes jumping from $3,000 to $180,000 depending on the account. Someone on r/datascience nailed it: "We just stare at a spreadsheet full of averages and hope for the best." Yeah. That's most companies.

The other problem? Data silos. Revenue in one tool, churn data in another, support tickets somewhere else. So people give up and wing it.

But the ones who figure it out? Massive edge. Bain & Company found that a 5% increase in retention boosts profits 25% to 95%. Gainsight and Forrester's 2025 data says 76% of B2B annual revenue comes from existing customers. McKinsey's 2025 research: personalization done well drives 40% revenue gains. Omnichannel customers have 30% higher CLV.

By the way — B2B loyalty programs are showing an 82% retention increase, 79% CLV increase, and 4.8× ROI. I was gladly surprised by those numbers. Companies that understand how CLV transforms local B2B prospecting are playing a completely different game.

All that to say that understanding your customer value formula isn't some nice-to-have. It's the difference between guessing and knowing.

The Basic Customer Lifetime Value Formula

Okay so let's start with the basics. What exactly are we going to calculate? If you've ever wondered how to calculate lifetime value of a customer, this is your section.

Here's the simple customer lifetime value formula:

CLV = Average Purchase Value × Purchase Frequency × Customer Lifespan

Three things 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. Annual contracts? That's 1. Monthly orders? That's 12.

Customer Lifespan: How many years the average customer stays before leaving. Trickiest to estimate, but we'll get to that.

Quick customer lifetime value example. Take Mike. Mike runs a B2B company and his average client pays $5,000 a year, buys once per year, and stays for about 4 years. His CLV? $5,000 × 1 × 4 = $20,000. Not complicated at all. And now Mike knows that each new client is worth roughly twenty grand over their lifetime. That changes how much he's willing to spend to acquire one.

When should you use this version? Board presentations. Quick back-of-napkin estimates. Early-stage companies that haven't been around long enough to build fancy models. It's a starting point, not the final answer — but it's a really good starting point.

Customer Lifetime Value Formula in Excel (Step-by-Step)

Let's do that really quick. Open a spreadsheet. Column A: Purchase Value. Column B: Frequency. Column C: Lifespan. Column D: =A2*B2*C2. Done. This customer lifetime value formula excel setup lets you sort your entire customer base by CLV instantly.

For SaaS the formula is =(Gross Margin% × ARPU) / Churn Rate. And if you want better accuracy, build separate tabs for each customer cohort — group by signup quarter. People on r/analytics keep saying this: cohort-based CLV beats one giant average every time. Your 2022 customers behave nothing like your 2025 ones. You don't even need a fancy CLV calculator — a well-structured spreadsheet does the job.

How to Calculate CLV for B2B and SaaS Companies

Now that being said, the basic formula has limits. Running a SaaS product or selling complex B2B services? You need formulas that fit your model. Some call it the LTV formula, others say CLV calculation — same destination, different roads.

The SaaS version. This is the customer lifetime value SaaS formula and I think it's actually cleaner than the basic one:

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

Let me do quick math. Say your gross margin is 80%, your ARPU is $200/month, and you churn 3% of customers each month. That gives you: (0.80 × $200) / 0.03 = $5,333. Notice how this formula bakes in the customer lifetime value formula retention rate already, because churn is literally just the flip side of retention. If 3% leave, 97% stay. Same coin.

B2B Services version:

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

This one subtracts what it cost you to land the client in the first place. More realistic for agencies and consulting firms where acquisition costs can be brutal.

And here's a formula I use constantly. The customer lifespan formula: Lifespan = 1 / Churn Rate. Ten percent annual churn? Your average customer sticks around 10 years. Twenty percent? Five years. Super simple division but it changes everything when you plug it into your models.

I know what you might be thinking: "We only have like 50 clients, this can't possibly work for us." Actually it can. Even with a small account base, 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

This one's for the finance people. Or anyone with long-term contracts where time value of money matters.

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

The customer lifetime value formula with discount rate says: 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.

But honestly? For most B2B companies, executive judgment plus simpler formulas works fine. Start with deal size times renewals times retention, then refine. Don't over-engineer it.

CLV vs. CAC — The Golden Ratio

This is where your CLV calculation becomes a real weapon. 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

The CLV vs CAC ratio benchmark: 3:1 minimum for healthy. 5:1 is the sweet spot. Below 1:1? You're paying more to get customers than they'll ever return. Above 5:1? Could mean you're under-spending on growth. Maybe time to invest in finding new B2B SaaS clients.

Customer acquisition cost vs lifetime value stops being a textbook concept when it starts driving real decisions. Pricing. Budgets. Channel strategy. Which markets to enter. The ratio tells you all of it.

Real-World CLV Examples That Prove the Math Works

Enough theory. Let's look at companies that are actually doing this and making money from it.

Starbucks. Everyone's favorite example and for good reason. Their average customer spends $25,272 over their lifetime. The profit margin on that? 21.3%. Customer satisfaction sitting at 89%. Those numbers don't happen by accident. Every loyalty perk, every app notification, every seasonal drink — it all ties back to maximizing lifetime value per customer. So what is a good customer lifetime value? Depends entirely on your model. For a coffee chain, $25k is incredible. For an enterprise SaaS company, that might be a small account.

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

Cloudastructure. This is a B2B example I don't see people mention enough. Near-100% retention rate. The company has straight up said that retention is as critical as new sales and they talk about "huge CLV per customer." When your clients basically never leave, even moderate annual revenue per account compounds into something massive.

Adidas adiClub. 240 million members. The loyalty members? They 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 just offering random discounts and hoping for the best.

Astrid & Miyu. Smaller brand, unbelievable numbers. Loyalty members spend 220% more per year and are 6× more likely to repurchase. Proof that you don't need to be a Fortune 500 to make CLV work for you.

What do all these companies have in common? They use CLV to decide where money goes. Not vibes. Not whoever yells loudest in the meeting. Actual math connected to an actual sales pipeline for local leads and a real retention strategy.

Now here's the thing. To calculate meaningful CLV, you need decent data on who you're targeting. Garbage in, garbage out — whatever CLV model you build. Platforms like Scrap.io let you build real-time prospect lists from Google Maps — fresh data, not some six-month-old spreadsheet someone's selling for $500. You can try it free for 7 days with 100 leads included.

How to Use CLV to Prioritize Your Prospecting

So you've run the numbers. Now what? How does this change what you do Monday morning?

Not every lead is going to become a $50,000 lifetime customer. Some will churn in three months. The game is figuring out which is which before you blow your acquisition budget. That's customer profitability analysis in a nutshell.

Can we take a moment to put ourselves in the shoes of a sales team that doesn't do this? They treat every lead the same. Same outreach, same effort. Meanwhile the team down the road spends 80% of their energy on the 20% of prospects most likely to become high-CLV accounts. Who wins?

Start with your existing customers. Sort by CLV. Top 20% — what's the pattern? Industry? Company size? Good reviews? Strong online presence? That pattern is your Ideal Customer Profile. Go define your Ideal Customer Profile formally and use it to filter every new prospect.

Then allocate accordingly. Best budget goes to highest-CLV segments. Run account-based marketing for accounts matching your top customer profile. Segments that churn fast and spend little? Stop pouring thousands into them.

AI is sharpening all of this. Reports from 2025 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.

What if instead you could spot those high-CLV prospects before spending a dime? Scrap.io's filters let you sort by rating, reviews, website presence — all signals of an established, growing business. Your first 100 leads are free.

Common CLV Mistakes (And How to Avoid Them)

I've watched teams make these same errors over and over. Painful to watch every time.

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 lifetime value formula with churn isn't optional. The customer lifespan formula — 1 divided by 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. This one kills me. Pretty dashboard, quarterly review presentation, then... nothing changes. CLV only matters when it drives action. Connect it to CAC. Tie it to local prospecting KPIs. 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 eighteen months old, it's stale. Recalculate quarterly minimum.

By the way — if your purchase cycles are irregular (most B2B companies, let's be real), 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. That's the one you can do on a napkin. 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. Meaning every customer brings in three times what you spent to acquire them. The best companies hit 5:1. If you're below 1:1, you're losing money on each customer. Above 5:1 sounds amazing but it might actually mean you're under-investing in growth — which is its own problem.

How do you calculate CLV with churn rate?

First figure out customer lifespan: 1 ÷ churn rate. So if 10% of your customers leave each year, average lifespan is 10 years. Then multiply that by average annual revenue per customer. For SaaS companies specifically, use CLV = (Gross Margin % × ARPU) / Churn Rate — it's a bit cleaner for subscription models.

Can you calculate CLV in Excel?

Yeah, and it's not complicated. Columns for purchase value, frequency, and lifespan. Multiply across. For SaaS, your formula is =(Gross Margin% × ARPU) / Churn Rate. I'd also recommend adding cohort tabs — group customers by the quarter they signed up and track CLV per group. Way more useful than one big average.

What's the difference between CLV and LTV?

Honestly? Nothing. CLV, LTV, CLTV — all the same metric. Customer Lifetime Value versus Lifetime Value. Marketing people tend to say CLV, finance people often say LTV. Don't overthink it. Pick whichever your team uses and move on.

Compliance Note

Your CLV data is internal — you're calculating your own numbers, so GDPR doesn't apply to that part at all. Where it gets relevant is when you use CLV insights to go target new prospects. Then you need to follow CAN-SPAM: clear sender info, honest subject lines, working unsubscribe link, your physical address in the email. International contacts? GDPR matters. Scrap.io covers compliance in detail here if you want to go deeper on the legal side.

Time to Actually Do Something With This

Look, 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: 5% retention bump can mean 95% more profit. 76% of B2B revenue from existing customers. The numbers are screaming at us. 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 wrong prospects. You need to know what ICP means in sales — the profile of people most likely to become your highest-CLV accounts. Find those. Focus your budget there. Stop spreading it across everyone who might say yes.

If you want accurate CLV, if you want to spot high-value prospects before competitors do, if you want real-time data instead of stale spreadsheets — try Scrap.io free for 7 days. Your first 100 leads are included. Go target the accounts actually worth your time.