LTV (Life Time Value), also known as Customer Lifetime Value, represents the total profit a single customer generates for your business over the entire duration of the relationship. While LTV is an essential metric for making marketing investment decisions, many marketers find themselves asking "How exactly do I calculate it?" or "Which formula is right for my business?" In this article, we walk through three widely-used LTV calculation formulas with concrete numerical examples, along with industry benchmarks and how to visualize LTV in your CRM.
What Is LTV (Customer Lifetime Value)? Why Does It Matter?
LTV is the total revenue (or profit) you can expect from a customer from the start to the end of their relationship with your company. It is sometimes referred to as CLV (Customer Lifetime Value).
LTV has become increasingly important as customer acquisition costs (CAC) continue to rise. Retaining existing customers is said to cost one-fifth of acquiring new ones, and understanding LTV allows you to determine how much you can invest to acquire a single customer. LTV serves as a foundational metric for budget allocation, customer segment prioritization, and product pricing decisions.
3 LTV Calculation Methods
LTV calculation methods fall into three main patterns. Choose the formula that best fits your business model and data availability.
Formula 1: Average Purchase Value-Based LTV (Basic Formula)
This is the simplest and most widely used LTV formula. It can be applied to a broad range of business models including e-commerce, retail, and subscriptions.
LTV = Average Purchase Value × Average Purchase Frequency (per year) × Average Customer Lifespan (years)
For example, if the average purchase value is $50, the average purchase frequency is 4 times per year, and the average customer lifespan is 3 years, then LTV = $50 × 4 × 3 = $600.
The advantage of this formula is its simplicity and minimal data requirements. Average purchase value and frequency can be readily calculated from CRM purchase data, and customer lifespan can be estimated as the inverse of the churn rate. However, when customer-level variance is high, averages may misrepresent reality—so it is recommended to combine this with segment-level calculations.
Formula 2: Gross Margin-Based LTV (Profitability-Focused)
This method calculates LTV using gross profit (revenue minus cost of goods sold) instead of revenue. It is best suited for understanding the true profit a customer generates.
LTV = Average Purchase Value × Gross Margin Rate × Average Purchase Frequency (per year) × Average Customer Lifespan (years)
For example, if the average purchase value is $50, gross margin rate is 60%, average purchase frequency is 4 times per year, and average customer lifespan is 3 years, then LTV = $50 × 60% × 4 × 3 = $360.
Gross margin-based LTV is especially useful for evaluating investment payback against CAC. A general benchmark is an LTV (gross margin basis) to CAC ratio of 3 or higher for a healthy investment efficiency. Revenue-based LTV alone may overvalue customers who purchase high-COGS products, so use this formula whenever profitability is the focus.
Formula 3: Subscription-Based LTV (MRR-Based)
This formula is optimized for SaaS and subscription businesses. It derives LTV from monthly recurring revenue (MRR) and monthly churn rate.
LTV = ARPU (Average Revenue Per User per month) ÷ Monthly Churn Rate
For example, if ARPU is $100/month and the monthly churn rate is 2%, then LTV = $100 ÷ 0.02 = $5,000. This formula leverages the fact that the inverse of the monthly churn rate equals the average customer lifespan in months (in this case, 1 ÷ 0.02 = 50 months).
For a gross margin-based version, multiply ARPU by the gross margin rate: LTV = ARPU × Gross Margin Rate ÷ Monthly Churn Rate. When the churn rate is very low, LTV can become inflated; in such cases, adding a discount rate—LTV = ARPU × Gross Margin Rate ÷ (Monthly Churn Rate + Monthly Discount Rate)—provides a more conservative estimate.
When to Use Each Formula: A Quick Guide
Which formula to use depends on your business model and purpose. Here is a guide for choosing the right one.
Formula 1 (Average Purchase Value-Based) is ideal for e-commerce, retail, food service, and B2C services with a transactional purchase model. It serves as a great first step for getting a quick read on overall LTV. Formula 2 (Gross Margin-Based) works well for the same business models as Formula 1, plus any business where COGS varies significantly by product. Always use this formula when comparing LTV to CAC for investment decisions. Formula 3 (MRR-Based) is best suited for SaaS, subscriptions, and monthly billing services where MRR and churn rate are already managed as business metrics.
Companies with multiple business models may use different formulas for different products or divisions. What matters most is maintaining a consistent calculation logic within the organization so that trends can be tracked over time.
LTV Benchmarks by Industry
Knowing industry benchmarks helps you assess whether your LTV is high or low. These are approximate reference values for representative industries.
General e-commerce/retail has an average LTV of roughly $100–$500, driven primarily by repeat rate and purchase frequency. D2C and subscription commerce sees LTV of $300–$1,000, where subscription retention rate is the key driver. SaaS (SMB-focused) ranges from $3,000–$10,000 in LTV, with monthly churn rate improvement being the most direct lever. Enterprise SaaS can reach LTV of tens of thousands to hundreds of thousands of dollars, where both contract value and contract length matter. Staffing/HR services see LTV around $500–$3,000, depending on repeat usage. Fitness and gyms average $500–$2,000, calculated simply as monthly fee times average membership duration. Insurance and financial services can reach LTV of several thousand to tens of thousands of dollars, boosted by long-term contracts and cross-sell of additional products.
These benchmarks are general trends and can vary significantly within the same industry depending on the business model and target audience. Calculate your own LTV first, then compare against industry benchmarks to identify improvement opportunities.
Data Requirements for LTV Calculation
Accurate LTV calculation requires the right data in your CRM. Here are the data points needed for each formula.
Formulas 1 and 2 (Purchase Value/Gross Margin-Based) require five data points: purchase amount per transaction, purchase date per transaction, first purchase date, last purchase date, and gross margin rate by product (Formula 2 only). Formula 3 (MRR-Based) requires four data points: monthly billing amount per customer, contract start date, contract end date (churn date), and plan change history.
If this data is missing, start by establishing CRM data entry rules. First purchase date and last purchase date are essential for calculating customer lifespan, so ensure they are reliably captured. Calculating LTV on low-quality data can lead to flawed decision-making.
LTV Calculation Templates You Can Use Today
To help you calculate LTV right away, here is how to set up practical calculation templates. With the following fields in a spreadsheet or Excel, you can perform basic LTV calculations.
Set up the following fields. Input fields: Total revenue for the period (A), Total number of orders for the period (B), Number of unique customers for the period (C), and Average customer lifespan in years (D). Calculated fields: Average Purchase Value = A ÷ B, Average Purchase Frequency (per year) = B ÷ C, and LTV = Average Purchase Value × Average Purchase Frequency × D. To convert to a gross margin basis, add Gross Margin Rate (E) as an input and change the LTV formula to Average Purchase Value × E × Average Purchase Frequency × D.
Subscription-Based LTV Calculation Template
Input fields: Monthly MRR (F), Number of paying customers at month-end (G), and Number of churned customers for the month (H). Calculated fields: ARPU = F ÷ G, Monthly Churn Rate = H ÷ G, Average Customer Lifespan (months) = 1 ÷ Monthly Churn Rate, and LTV = ARPU ÷ Monthly Churn Rate.
Segment-Level LTV Comparison Template
Calculating LTV by segment—not just the overall average—dramatically improves the precision of your campaigns. Extract data from your CRM by segment (industry, plan, acquisition channel, first product purchased, etc.) and apply the templates above to each segment for a side-by-side comparison. This enables data-driven decisions: concentrate resources on high-LTV segments and investigate improvement levers for low-LTV segments.
Visualizing LTV in Your CRM | Xtrategy Use Cases
While spreadsheet calculations are a great starting point, scaling LTV across the organization requires real-time visualization in your CRM. Here is how the marketing ERP platform Xtrategy enables LTV visualization.
LTV Dashboards for a Big-Picture View
Xtrategy automatically calculates LTV from CRM transaction data and visualizes it on a dashboard. Track overall LTV trends monthly and toggle segment-level views (by plan, channel, industry, etc.) with a single click. Whether in board meetings or marketing reviews, you can instantly see whether LTV is trending up or down and which segments are driving the total.
LTV/CAC Ratio for Investment Efficiency
Visualizing LTV alongside CAC lets you assess the health of your marketing investment. Xtrategy integrates marketing cost data (ad spend, promotional costs) with CRM customer data, allowing you to check LTV/CAC ratios by channel and campaign in real time. You can even set up alerts for channels where the LTV/CAC ratio drops below 3.
Cohort Analysis to Track LTV Improvement Trends
To accurately evaluate whether LTV improvements are materializing, cohort analysis (grouping customers by acquisition period) is essential. Xtrategy's cohort analysis feature lets you compare cumulative revenue and retention rates over time for groups like "customers acquired in January 2025" versus "customers acquired in April 2025." This allows you to quantitatively confirm whether campaign improvements are showing up in newer cohorts—forming a strong foundation for PDCA cycles.
5 Approaches to Improve LTV
Once you've calculated your current LTV, it's time to work on improvement. Breaking LTV into its components reveals the levers available to you.
The first approach is increasing average purchase value through upsell and cross-sell proposals, premium plan design, and bundle discounts. Analyze CRM purchase data to identify which customer profiles and timing yield the best results for upsell and cross-sell.
The second approach is boosting purchase frequency through reminder emails, repeat-purchase campaigns, and subscription plans. Analyze purchase interval data in your CRM to pinpoint when frequency tends to decline and deploy campaigns at that exact timing.
The third approach is extending customer lifespan by improving onboarding, strengthening customer success, and detecting and intervening at early churn signals. For subscription businesses, reducing churn rate is the single most impactful lever for LTV.
The fourth approach is improving gross margins through procurement cost optimization, steering customers toward higher-margin products, and revising discounting policies. When managing LTV on a gross margin basis, the impact of these initiatives is directly reflected.
The fifth approach is segment-level campaign optimization. Rather than running the same campaigns for all customers, concentrate resources on high-LTV segments and design targeted initiatives for low-LTV segments focused on their specific improvement areas. Segment-level LTV data from your CRM becomes the basis for prioritizing campaigns.
3 Common Pitfalls in LTV Calculation
While LTV is a powerful metric, miscalculating it can lead to misguided decisions. Here are three common pitfalls.
The first pitfall is relying solely on the overall average. LTV tends to have high variance across segments. Looking only at the average—which may be inflated by a small number of high-LTV customers—can lead to inappropriate investment decisions for the majority. Always calculate LTV by segment and check the distribution.
The second pitfall is overestimating customer lifespan. For new products or services with limited churn data, there is a tendency to assume overly optimistic retention. Use conservative estimates or reference churn rates from existing products as a proxy.
The third pitfall is changing the calculation logic mid-stream and losing the ability to compare over time. If you alter the formula, reporting period, cost inclusions, or segment definitions, historical comparisons become invalid and you can no longer track improvement. Define calculation logic upfront and, if changes are necessary, recalculate historical data as well.
Conclusion: LTV Calculation Is the Starting Point, Not the Finish Line
In this article, we covered three LTV calculation methods. Formula 1 (Average Purchase Value × Purchase Frequency × Customer Lifespan) is the simplest and most versatile. Formula 2 adds a gross margin component for accurate profitability analysis and CAC comparison. Formula 3 (ARPU ÷ Churn Rate) is purpose-built for subscription businesses.
Calculating LTV is just the starting point. The real goal is to use these numbers to identify where improvement opportunities lie—average purchase value, frequency, lifespan, or gross margin—and translate those insights into segment-specific campaigns.
Start by using the templates in this article to calculate your company's LTV and compare differences across segments. Once you can visualize and monitor LTV in real time through your CRM, you will have taken the first step toward a truly data-driven customer strategy.
Learn how to leverage CRM data for marketing campaigns. From customer segmentation to MA integration and email/ad optimi...
