There are three ways to calculate Customer Lifetime Value, each with different accuracy and complexity. Use the method that matches your data maturity.
Method 1: Simple CLV (Best for Getting Started)
The simplest formula requires just three data points:
CLV = Average Revenue per User (ARPU) × Average Customer Lifespan (years)
Or broken down:
CLV = (Average Purchase Value × Average Purchase Frequency per Year) × Average Customer Lifespan
Step-by-Step: Simple CLV
Step 1: Calculate Average Purchase Value
Average Purchase Value = Total Revenue in Period ÷ Number of Transactions
Example:
- Total Q2 revenue: $500,000
- Total Q2 transactions: 2,000
- Average Purchase Value = $500,000 ÷ 2,000 = $250
Step 2: Calculate Average Purchase Frequency
Average Purchase Frequency = Number of Transactions ÷ Number of Unique Customers
Example:
- Q2 transactions: 2,000
- Unique customers: 500
- Frequency = 2,000 ÷ 500 = 4 purchases per customer per quarter = 16 per year
Step 3: Calculate Annual Customer Value
Annual Value = Average Purchase Value × Annual Frequency
Example:
- Average Purchase Value: $250
- Frequency: 16/year
- Annual Value = $250 × 16 = $4,000
Step 4: Determine Average Customer Lifespan Look at historical data. How long do customers typically stay?
For SaaS:
Lifespan = 1 ÷ Annual Churn Rate
If your annual churn is 20%, lifespan = 1 ÷ 0.20 = 5 years.
Example: Your data shows customers stay for 3.5 years on average.
Step 5: Calculate CLV
CLV = Annual Value × Lifespan
CLV = $4,000 × 3.5 = $14,000
Method 2: Cohort-Based CLV (More Accurate)
Track customers by acquisition cohort and measure actual revenue over time:
Month 1 cohort (customers acquired January):
- 100 customers acquired
- Month 1 revenue: $12,000
- Month 2 revenue: $11,200 (one customer churned)
- Month 3 revenue: $10,400 (more churn)
- Month 12 revenue: $4,000
- Total 12-month revenue: $115,000
- Cohort CLV = $115,000 ÷ 100 customers = $1,150
Then repeat for each cohort and average:
| Cohort | Customers | 12-Month Revenue | CLV | |--------|-----------|------------------|-----| | Jan | 100 | $115,000 | $1,150 | | Feb | 95 | $108,000 | $1,137 | | Mar | 110 | $121,000 | $1,100 | | Apr | 105 | $119,000 | $1,134 | | Average | - | - | $1,130 |
This method is more accurate because it uses actual data, not assumptions about lifespan.
Method 3: Discounted CLV (For Financial Precision)
Accounts for the time value of money:
Discounted CLV = Σ [(Revenue in Period t) ÷ (1 + Discount Rate)^t]
This says: money today is worth more than money in the future.
Example with 10% discount rate:
- Year 1 revenue: $1,000 → Present value: $1,000 ÷ (1.10)^1 = $909
- Year 2 revenue: $1,000 → Present value: $1,000 ÷ (1.10)^2 = $826
- Year 3 revenue: $1,000 → Present value: $1,000 ÷ (1.10)^3 = $751
- Year 4 revenue: $800 → Present value: $800 ÷ (1.10)^4 = $546
- Year 5 revenue: $500 → Present value: $500 ÷ (1.10)^5 = $310
- Discounted CLV = $909 + $826 + $751 + $546 + $310 = $3,342
Compare to simple method (undiscounted):
- Simple CLV = $5,300
The 10% discount rate reflects: if you invested that money at 10% annual return elsewhere, what's it worth today? This is what finance teams prefer.
SaaS Example: Calculating CLV for $29/month Subscription
Given:
- Monthly subscription: $29
- Average customer lifespan: 3 years (36 months)
- Annual churn: 30% (customer stays ~3.3 years)
- Discount rate: 10%
Simple Method:
CLV = $29 × 12 months × 3 years = $1,044
Cohort Method (using real data): Track 100 customers from signup:
| Month | Customers | Revenue | MRR Loss | |-------|-----------|---------|----------| | 1 | 100 | $2,900 | 10 | | 2 | 90 | $2,610 | 9 | | 3 | 81 | $2,349 | 8 | | 6 | 60 | $1,740 | - | | 12 | 30 | $870 | - | | 24 | 5 | $145 | - | | 36 | 1 | $29 | - |
Total 36-month revenue: $29,000 CLV = $29,000 ÷ 100 = $290
(Much lower than simple method because real churn is faster than the average suggests.)
Discounted Method (at 10% discount rate): Using monthly revenue from cohort:
- Months 1-3: $2,859
- Months 4-12: $8,450
- Months 13-24: $3,240
- Months 25-36: $1,890
- Discounted total: ~$13,000 ÷ 100 = $130 discounted CLV
Segment Your CLV: Different Metrics for Different Customers
Don't calculate one CLV for all customers. Calculate by segment:
By Customer Tier:
- Starter plan CLV: $500
- Growth plan CLV: $3,000
- Enterprise plan CLV: $50,000
By Acquisition Channel:
- Google Ads CLV: $1,200
- Referral CLV: $2,100
- Direct/organic CLV: $900
By Industry:
- SaaS customers CLV: $2,500
- Agencies CLV: $4,000
- Freelancers CLV: $400
This reveals which segments are most valuable and where to focus acquisition.
Common Mistakes
Mistake 1: Using average lifespan when you have actual data Don't assume all customers last 3 years if your data shows different retention rates by month. Use cohort analysis.
Mistake 2: Forgetting to account for COGS Revenue CLV isn't the same as profit CLV. Subtract cost of goods and support:
Profit CLV = Revenue CLV - (Cost per Customer × Lifespan)
Mistake 3: Ignoring expansion revenue If customers upgrade/expand, include that in CLV, not just base subscription revenue.
Mistake 4: Calculating CLV without accounting for time lag Customer acquired in January might not generate revenue until February. Use consistent date periods.
Mistake 5: Using historical lifespan for new cohorts "Our 2022 customers lasted 4 years" doesn't mean your 2025 customers will. Product changes, market shifts, and competition change retention. Use recent cohorts for lifespan estimates.
When to Use Each Method
| Method | Best For | Complexity | |--------|----------|-----------| | Simple | Getting started, rough estimates, <6 months data | Low | | Cohort | Growing companies, medium data maturity | Medium | | Discounted | Enterprise/VC-backed, financial planning | High |
Recommendation: Start with Simple to validate unit economics. Graduate to Cohort when you have 12+ months of data. Use Discounted when raising capital or for M&A.
Tools
Spreadsheet: Works fine for Cohort method with pivot tables. Analytics: Amplitude, Mixpanel, Segment track CLV by cohort. Subscription tools: Stripe, Chargebee report CLV estimates.
Related Articles
- What Is Customer Lifetime Value — Strategy and importance
- How to Calculate Customer Acquisition Cost — CAC vs. CLV ratio
- How to Calculate Churn Rate — Impacts CLV calculation