Customer Lifetime Value Calculator: Formula, Free Tool & Worked Examples
Estimate how much a customer is really worth, compare it against what you spend to win them, and see the formula behind every number.
If you have ever asked how to calculate customer lifetime value, you have probably run into a wall of conflicting formulas — one for subscription businesses, another for e-commerce, and a third that finance teams use for board reporting. This guide untangles them, then hands you a free, interactive customer lifetime value calculator that works for SaaS, subscription, and e-commerce business models, in five currencies, with a built-in CLV:CAC ratio, churn and retention math, and a printable report you can share with your team.
Customer lifetime value calculation is not a vanity metric. It is the number that tells you whether your marketing spend is sustainable, whether a subscription price increase makes sense, and whether a customer segment is worth investing in at all. We will walk through the core customer lifetime value calculation formula, show how the lifetime value of a customer calculation changes for SaaS versus e-commerce, and work through real numbers for businesses in the United States, United Kingdom, Canada, Australia, and India.
What Is Customer Lifetime Value (CLV)?
Customer Lifetime Value — also written as CLV or LTV (lifetime value) — is the total net profit a business expects to earn from a single customer over the entire span of their relationship with the company. It is not the same as revenue. Revenue tells you what a customer paid; CLV tells you what they were worth after accounting for the cost of serving them.
A customer's lifetime value is calculated by combining how much they spend, how often they buy or renew, how long they stay, and how profitable each of those purchases is after costs. Get any one of those inputs wrong — an overly optimistic retention estimate, for instance — and the resulting CLV can lead a business to overspend on acquisition.
Why CLV Matters
CLV matters because it turns a single acquisition decision into a long-term profitability question. A customer who pays a small amount monthly for five years can be worth far more than one who makes a single large purchase and never returns. Without calculating lifetime value, it's easy to over-invest in acquisition channels that bring in low-retention customers, or under-invest in a loyal segment that would justify a much higher marketing budget.
- Marketing budgeting: CLV sets a ceiling on what you can profitably spend to acquire a customer (your CAC).
- Retention prioritization: it quantifies the dollar impact of reducing churn by even one percentage point.
- Business valuation: subscription businesses are often valued partly on the strength of their aggregate customer lifetime value versus acquisition cost.
- Pricing decisions: knowing lifetime value helps you judge whether a price increase, downgrade, or bundling change will grow or shrink long-term profit.
The Customer Lifetime Value Formula, Explained
There isn't one universal formula for calculating customer lifetime value — there are several, suited to different business models. All of them are variations on the same idea: multiply what a customer is worth per period by how many periods they stick around, then subtract the cost of serving them.
The Simple (General) CLV Formula
The most common starting point for calculating customer lifetime value is:
CLV = Average Order Value × Purchase Frequency × Customer Lifespan × Gross Margin
This version works well for retail and e-commerce, where customers make discrete purchases rather than paying a recurring subscription fee.
The SaaS / Subscription CLV Formula
For subscription and SaaS customer lifetime value calculation, the formula is usually expressed in terms of recurring revenue and churn instead of order frequency:
CLV = (Average Revenue Per User × Gross Margin %) ÷ Churn Rate
Here, 1 ÷ Churn Rate approximates the average customer lifespan in periods. A 5% monthly churn rate implies an average customer lifespan of roughly 20 months (1 ÷ 0.05). This is the formula most SaaS founders mean when they ask how to calculate customer lifetime value for SaaS.
The Retention-Rate Variant
Some finance teams prefer to express the same relationship using retention rate instead of churn:
CLV = (ARPU × Gross Margin %) × [Retention Rate ÷ (1 − Retention Rate)]
This produces the same result as the churn-based formula, since retention rate and churn rate are complements of each other (Retention = 1 − Churn).
Key Variables Explained
| Variable | What it means | Typical source |
|---|---|---|
| Average Order Value (AOV) | Average amount spent per transaction | Total revenue ÷ number of orders |
| Average Revenue Per User (ARPU) | Average recurring revenue per customer per period | MRR ÷ active subscribers |
| Purchase Frequency | How many times an average customer buys per year | Total orders ÷ unique customers |
| Customer Lifespan | Average duration a customer stays active | 1 ÷ churn rate, or historical cohort data |
| Gross Margin (%) | Revenue remaining after direct costs of goods or service delivery | (Revenue − COGS) ÷ Revenue |
| Retention Rate (%) | Share of customers who remain active period over period | 1 − churn rate |
| Churn Rate (%) | Share of customers who cancel or stop buying period over period | Lost customers ÷ starting customers |
| Customer Acquisition Cost (CAC) | Total sales & marketing spend to acquire one customer | Total S&M spend ÷ new customers acquired |
Interactive Customer Lifetime Value Calculator
Enter your own numbers below. Choose a business model to switch between the e-commerce (AOV-based) and SaaS/subscription (ARPU and churn-based) formulas. All calculations run in your browser — nothing is sent anywhere, though the tool can save your last inputs locally so you don't have to retype them.
Customer Lifetime Value & CLV:CAC Calculator
Estimate disclaimer: This is a modeled estimate based on the figures you entered, not a guarantee of future results. Real customer behavior varies by cohort, seasonality, and market conditions — revisit this calculation regularly with updated data.
How to Use the Calculator
- Pick your business model: e-commerce/retail if customers make discrete purchases, or SaaS/subscription if they pay recurring fees.
- Enter your Average Order Value and purchase frequency (e-commerce) or your ARPU and monthly churn rate (SaaS).
- Enter your gross margin — this converts revenue into profit, which is what CLV should really measure.
- Optionally enter your CAC to see your CLV:CAC ratio and payback period.
- Click Calculate to see your CLV, lifetime profit, ratio, and a step-by-step breakdown of exactly how each number was produced.
- Use Download CSV or Print Results to save the output for a pitch deck, board update, or budget conversation.
Worked Examples by Country
Customer behavior, pricing norms, acquisition costs, and typical retention all vary by market. The mechanics of the formula don't change, but the inputs you'd realistically enter will look different depending on where your customers are.
| Market | Example business | Illustrative ARPU / AOV | What tends to differ |
|---|---|---|---|
| United States | SaaS project management tool | $49/month | Larger addressable market often supports higher CAC tolerance |
| United Kingdom | DTC subscription box | £28/month | VAT and shipping costs affect gross margin calculations |
| Canada | E-commerce apparel brand | CA$95 AOV | Cross-border shipping to the US can extend customer lifespan for some brands |
| Australia | B2B SaaS for trades businesses | AU$65/month | Smaller domestic market can mean higher relative CAC, making CLV discipline more important |
| India | Subscription ed-tech platform | ₹499/month | Lower ARPU is often offset by larger customer volumes and lower CAC |
In every case, the calculation logic is identical: multiply what a customer is worth per period by how long they stay, adjust for margin, and compare the result to acquisition cost. Only the currency and the realistic input ranges change.
CLV vs. CAC: Why the Ratio Matters More Than Either Number Alone
A high CLV means little if it costs just as much to acquire the customer. That's why the CLV:CAC ratio — customer lifetime value divided by customer acquisition cost — is often treated as more informative than CLV in isolation. A ratio around 3:1 is commonly cited as a reasonable target for many subscription businesses, though the right ratio for any specific company depends on its growth stage, margins, and how quickly it needs to recoup cash.
| Customer Lifetime Value (CLV) | Customer Acquisition Cost (CAC) | |
|---|---|---|
| Measures | Long-term value a customer generates | Cost to win one new customer |
| Best for | Deciding how much retention effort is worth | Deciding how much marketing spend is sustainable |
| Limitation | Depends on projections that can be wrong | Says nothing about long-term profitability alone |
| Used together | The CLV:CAC ratio and payback period turn both into one profitability signal | |
Comparison Tables: Business Models & Customer Segments
| SaaS / Subscription | E-commerce | |
|---|---|---|
| Core formula input | ARPU and churn rate | Average order value and purchase frequency |
| Revenue pattern | Recurring, predictable | Discrete, often seasonal |
| Biggest lever | Reducing churn | Increasing repeat purchase rate |
| Common pitfall | Using annual churn where monthly churn is meant, or vice versa | Ignoring returns and discounts when calculating true AOV |
| Subscription | One-time purchase | |
|---|---|---|
| Lifetime value driver | Retention over many billing periods | Repeat purchase behavior and referrals |
| Forecasting ease | Generally easier due to recurring revenue | Harder; depends on discretionary repurchase timing |
| Best use case | Software, media, subscription boxes | Big-ticket goods, services with long replacement cycles |
| High retention | High churn | |
|---|---|---|
| Effect on CLV | Increases CLV substantially, since 1÷churn grows fast as churn falls | Suppresses CLV even with strong ARPU |
| Strategic priority | Protect what's working; expand ARPU carefully | Fix onboarding and value delivery before scaling acquisition spend |
| Risk | Complacency about acquisition efficiency | Overspending on acquisition to replace departing customers |
Benefits of Calculating Customer Lifetime Value
- Gives marketing a defensible ceiling for acquisition spend.
- Surfaces which customer segments are genuinely profitable, not just high-revenue.
- Makes the financial case for retention and customer success investment concrete.
- Improves the accuracy of revenue forecasts and growth planning.
Limitations of CLV Calculations
- CLV is a projection, not a fact — it assumes future behavior resembles past behavior.
- Simple formulas ignore discount rates and the time value of money; more advanced discounted CLV models account for this.
- Churn and margin figures can shift quickly with pricing changes, competition, or product changes, making static CLV estimates go stale.
- Aggregate CLV can hide wide variation between customer segments.
Common Mistakes When Calculating Lifetime Value
- Using revenue instead of profit — omitting gross margin overstates CLV.
- Mixing monthly and annual churn without converting them consistently.
- Ignoring CAC entirely, which makes it impossible to judge whether the CLV is actually attractive.
- Applying a single company-wide CLV to every marketing channel or segment, when the real numbers vary widely between them.
- Treating a one-time calculation as permanent instead of recalculating as churn, pricing, or margin shift.
Expert Tips & Best Practices
- Recalculate CLV by cohort (e.g., customers acquired in a given quarter) rather than relying on one blended average.
- Track CLV:CAC ratio and payback period side by side — a great ratio with a very long payback period can still create cash flow strain.
- When in doubt about your churn number, calculate it directly from cohort data rather than estimating it.
- Revisit gross margin assumptions whenever COGS, hosting costs, or fulfillment costs change materially.
Frequently Asked Questions
What is Customer Lifetime Value (CLV)?
Customer Lifetime Value is the total profit a business expects to earn from one customer across the entire relationship, after accounting for the cost of serving them — not just the revenue they generate.
What is Lifetime Value (LTV)?
LTV is simply another common abbreviation for the same concept as CLV. The terms are used interchangeably across SaaS, marketing, and finance contexts.
How do you calculate customer lifetime value?
Multiply what a customer spends per period by how many periods they remain a customer, then adjust for gross margin. E-commerce businesses typically use Average Order Value × Purchase Frequency × Lifespan × Margin; subscription businesses typically use (ARPU × Margin) ÷ Churn Rate.
What is the customer lifetime value formula for SaaS?
The common SaaS formula is CLV = (Average Revenue Per User × Gross Margin %) ÷ Monthly Churn Rate. This accounts for recurring billing and uses churn to estimate average customer lifespan.
How is customer lifetime value calculated in e-commerce?
E-commerce CLV is usually calculated as Average Order Value × Purchase Frequency per year × Customer Lifespan in years × Gross Margin percentage.
What is a good CLV:CAC ratio?
A ratio of roughly 3:1 is commonly referenced as healthy for many subscription businesses, though the ideal ratio varies by industry, growth stage, and how quickly a business needs to recover cash from acquisition spend.
How does CLV differ from CAC?
CLV measures what a customer is worth over time; CAC measures what it costs to acquire them. Comparing the two — rather than looking at either alone — shows whether acquisition spend is actually profitable.
Why is CLV important for SaaS companies specifically?
SaaS revenue is recurring, so small changes in churn compound significantly over a customer's lifespan. CLV translates retention improvements into a concrete profit figure, which is central to SaaS unit economics and fundraising conversations.
How to calculate customer lifetime value in Excel?
Set up columns for AOV or ARPU, purchase frequency or churn rate, gross margin, and lifespan, then write a formula cell that multiplies (or divides, for the churn-based version) these inputs according to the formula for your business model. The calculator on this page performs the same calculation automatically.
What is the difference between retention rate and churn rate?
They are complements of one another: Retention Rate = 1 − Churn Rate. A 95% retention rate corresponds to a 5% churn rate over the same period.
Can CLV be negative or unreliable?
CLV itself is rarely negative, but it can be unreliable if churn, margin, or spending assumptions are inaccurate or based on too small a sample of customers. Treat early-stage CLV estimates with caution and revisit them as more data accumulates.
How often should a business recalculate CLV?
Most businesses benefit from recalculating CLV quarterly, or immediately after a significant pricing, product, or churn change, since stale inputs can produce misleading figures.
Does CLV account for the time value of money?
The simple formulas shown here do not. More advanced "discounted CLV" models apply a discount rate to future cash flows to reflect that a dollar earned later is worth less than a dollar earned today.
What is MRR and how is it related to CLV?
Monthly Recurring Revenue (MRR) is the predictable subscription revenue collected each month. ARPU, a key CLV input for SaaS businesses, is typically derived by dividing MRR by the number of active subscribers.
How does Google Ads ROI relate to customer lifetime value?
Comparing what an ad channel spends per conversion (cost per acquisition) against the CLV of the customers it brings in shows whether that channel is a profitable investment over the long run, not just at the moment of the sale.
What counts as a "good" customer lifetime value?
There is no universal good number — it depends entirely on your CAC, margins, and industry. A CLV is generally considered healthy when it comfortably exceeds CAC and the payback period fits your cash flow tolerance.
How do B2B and B2C CLV calculations differ?
B2B customers often have longer sales cycles, higher contract values, and lower volume, so B2B CLV calculations tend to rely more on account-level retention and expansion revenue, while B2C calculations often work from larger, more aggregated customer cohorts.
What is customer payback period?
Payback period is how long it takes for the gross profit generated by a customer to cover the cost of acquiring them — essentially, CAC divided by monthly gross profit per customer.
Is a higher CLV always better?
A higher CLV is generally favorable, but it should always be read alongside CAC and payback period — a very high CLV built on unrealistic retention assumptions is not actually better than a modest, well-supported one.
Can this calculator be used for agencies or B2B services?
Yes — select the SaaS/subscription model if you bill recurring retainers, or the e-commerce model if your engagements are project-based with variable order values.
Final Summary
Customer lifetime value calculation is really a discipline, not a single formula: choose the version that fits your business model, be honest about your churn and margin numbers, and always read the result next to your acquisition cost. Use the calculator above to run your own numbers, export the results, and revisit the calculation as your retention and pricing evolve.
No comments:
Post a Comment