LTV looks simple until your revenue data gets messy. Discounts, plan changes, failed payments, and uneven churn can all distort the number. To calculate it well, start with the right formula, use clean ARPU and churn data, then test the result against customer cohorts.
This guide walks through each step. You can do the math in a spreadsheet, or use a tool such as Chartsy to ask plain-English questions about Stripe or Paddle data and view the result as a chart.
Table of Contents
- Step 1: Choose the Right LTV Formula for Your SaaS Business
- Step 2: Calculate ARPU From Subscription Revenue
- Step 3: Measure Churn and Estimate Customer Lifespan
- Step 4: Calculate LTV With a Worked SaaS Example
- Step 5: Validate LTV With Cohorts and Use It for Decisions
- FAQ
- Conclusion
Step 1: Choose the Right LTV Formula for Your SaaS Business
Before you calculate LTV, decide whether you need a quick revenue estimate or a margin-adjusted unit economics figure.
For most subscription businesses, the simple formula is:
LTV = ARPU ÷ Monthly customer churn rate
ARPU means average revenue per user. Churn must be written as a decimal, not as a whole number.
Use your measured ARPU and monthly churn rate to estimate LTV:
Estimated LTV = ARPU ÷ Monthly customer churn rate
This figure estimates total subscription revenue from an average customer. It assumes churn stays stable and customers pay the same amount throughout their lifetime. Those assumptions make the formula useful, but they also limit it.
For a closer view of unit economics, include gross margin:
Margin-adjusted LTV = (ARPU × Gross margin) ÷ Monthly churn rate
Including gross margin produces a lower figure because it accounts for direct delivery costs before sales and marketing costs.
The standard definition of customer lifetime value focuses on the value of a customer relationship over time. Your own formula should match the decision you need to make. Use revenue LTV for a quick trend check. Use margin-adjusted LTV when deciding how much you can spend to acquire customers.
Do not mix monthly ARPU with annual churn. Pick one time period and keep every input in that period.

Key Takeaway: Start with LTV = ARPU ÷ monthly churn, then add gross margin when the number will guide acquisition or budget decisions.
Step 2: Calculate ARPU From Subscription Revenue
To calculate LTV correctly, first calculate ARPU from the same revenue period as your churn rate.
The basic formula is:
ARPU = Monthly recurring revenue ÷ Active paying customers
Imagine your business has recurring monthly revenue and 500 active paying customers. Your ARPU is calculated by dividing recurring monthly revenue by active paying customers.
Monthly recurring revenue ÷ 500 = ARPU
Use active paying customers in the denominator. Do not include free users, expired trials, or accounts that never paid. If one customer has several subscriptions, decide whether you are measuring per account or per subscription. Then use that choice every month.
Revenue needs the same care. A useful ARPU figure should reflect recurring subscription revenue, not every dollar that passed through your payment system.
- Exclude sales tax and VAT collected for a government.
- Separate one-time setup fees from recurring charges.
- Account for refunds and discounts when they reduce collected revenue.
- Keep annual plans on a monthly basis by dividing the annual recurring amount by 12.
Annual plans can make ARPU look strange if you use cash collected in one month. A customer who pays upfront should contribute the prorated monthly recurring amount for this calculation, not the entire payment in the payment month.
Failed payments also need a clear rule. If an invoice has not been collected, decide whether your ARPU uses billed revenue or collected revenue. Collected revenue is usually better for cash planning. Billed revenue may help when you want to measure contracted demand. Do not switch between them without recording the change.
If you want to see how ARPU feeds into LTV, the ARPU guide from Chartsy explains the metric and its role in subscription analysis. Chartsy can also turn Stripe and Paddle data into charts from plain-English questions, which can reduce the time spent building formulas by hand.
Step 3: Measure Churn and Estimate Customer Lifespan
Churn tells you how quickly customers leave. In the LTV formula, it also estimates how long the average customer stays.
For customer churn, use:
Monthly customer churn = Customers lost during the month ÷ Customers at the start of the month
If you start with 500 customers and lose 10, your monthly churn is 2%.
10 ÷ 500 = 0.02, or 2%
With a stable 2% monthly churn rate, estimated customer lifespan is:
Average customer lifespan = 1 ÷ Monthly churn rate
1 ÷ 0.02 = 50 months
This does not mean each customer stays for exactly 50 months. It is an average estimate based on a steady churn rate. A young SaaS company with a small customer base may see large swings from just one or two cancellations.
Revenue churn can tell a different story. Losing one small customer is not the same as losing one large account. Track both measures when your plans have wide price gaps.
| Measure | Formula | Use it when |
|---|---|---|
| Customer churn | Customers lost ÷ Starting customers | You want to study account retention |
| Gross revenue churn | Lost recurring revenue ÷ Starting recurring revenue | You want to see revenue lost before expansion |
| Net revenue churn | Lost revenue minus expansion revenue ÷ Starting recurring revenue | Existing customer growth offsets some losses |
Do not use net revenue churn in the basic LTV formula. Expansion revenue can hide cancellations, while customer LTV still depends on how long accounts remain active. Keep customer churn and revenue churn as separate inputs.
Subscriptions are recurring billing arrangements that continue until a customer or business changes or cancels them. That distinction matters when you define a churn event. A failed payment may need a recovery window before you count the account as churned.
Write down your churn rules before calculating LTV. Decide how you will treat pauses, reactivations, downgrades, canceled trials, and accounts that return after a failed payment. A consistent rule is more useful than a perfect-looking number that changes each month.
Step 4: Calculate LTV With a Worked SaaS Example
Now combine ARPU and churn in one SaaS example.
Assume these figures:
- Monthly recurring revenue: not specified
- Active paying customers: 750
- Customers lost in the month: 15
- Gross margin: 80%
First, calculate ARPU:
Monthly recurring revenue ÷ active paying customers = ARPU
Next, calculate monthly customer churn:
15 ÷ 750 = 0.02, or 2%
Now calculate revenue LTV:
ARPU ÷ monthly customer churn = revenue LTV
Finally, calculate margin-adjusted LTV:
(ARPU × gross margin) ÷ monthly customer churn = margin-adjusted LTV
The revenue LTV figure is useful when you want to compare customer value across plans. The margin-adjusted LTV figure is better for acquisition planning because it removes the part of revenue needed to deliver the service.
Suppose your average customer acquisition cost is $1,000. Compare the simple LTV to CAC ratio with the margin-adjusted LTV to CAC ratio.
That gap is worth paying attention to. A team that uses revenue LTV may think it has more room for paid acquisition than it really does. But do not treat any ratio as a law. Sales cycles, cash timing, onboarding costs, and expansion revenue can change the decision.
Also test the result against a second period. If churn rises from 2% to 4% while ARPU stays at $80, LTV falls to $2,000. A small change in churn can move the result more than a modest price increase.
Pro Tip: Keep a revenue LTV column and a margin-adjusted LTV column in your model. Label both clearly so nobody uses the larger number for a cost decision by mistake.
Step 5: Validate LTV With Cohorts and Use It for Decisions
A formula gives you an estimate. Cohort analysis tells you whether that estimate resembles customer behavior.
Group customers by signup month, acquisition channel, plan, or company size. Then track how much revenue each group keeps over time. A January cohort may have a different LTV from a June cohort because pricing, onboarding, or product quality changed between those periods.
Start with a simple cohort table:
| Cohort view | What to compare | Decision it can support |
|---|---|---|
| Signup month | Retention after 3, 6, and 12 months | Find changes in onboarding or product value |
| Pricing plan | ARPU beside customer churn | Check whether a higher price brings higher value |
| Acquisition channel | Observed revenue beside CAC | Shift spend toward better customer groups |
| Customer segment | Retention, expansion, and support cost | Set clearer sales and service priorities |
Compare formula-based LTV with observed cohort revenue. If the formula produces a much higher result than newer cohorts produce after their first year, your forecast may be too generous. Possible causes include rising churn, a short observation window, lower-priced customers, or a formula based on old data.
Use LTV to guide decisions, not to decorate a dashboard. If one plan has high ARPU but also high churn, test onboarding before raising ad spend. If a lower-priced plan keeps customers longer, check whether it creates a stronger payback profile.
Review failed payments separately. Payment recovery can improve retained revenue without changing product usage. Refunds also need their own view because they reduce collected revenue but do not always mean a customer canceled.
Chartsy is useful when you want to ask questions such as which plan has the highest LTV or how LTV changes by signup month. Its plain-English query approach can be quicker than building each filter by hand. Still, review the metric definition before using any platform output in a board forecast. Both software and spreadsheets can hide assumptions.
Once an LTV gap points to an action, the next question is often how to automate that action. For teams assessing vendors in this area,this guide to choosing an AI automation vendorcovers questions about durable systems, ownership, and return on investment.

Set a review schedule. Monthly checks work for a small company with fast changes. Quarterly cohort reviews may be enough once the customer base is larger and the data is steadier. Keep the formula fixed while you test inputs, then document any change.
FAQ
What is the simplest way to calculate LTV for SaaS?
The simplest SaaS LTV formula is ARPU divided by monthly customer churn. If ARPU is $80 and monthly churn is 2%, LTV is $4,000. Use matching time periods, write churn as a decimal, and treat the result as an estimate rather than a promise about each customer.
Should SaaS LTV include gross margin?
Yes, include gross margin when LTV will guide CAC or acquisition spending. Use the formula, ARPU multiplied by gross margin, divided by monthly churn. Revenue LTV is fine for a quick comparison, but margin-adjusted LTV shows the revenue left after direct service costs.
How do you calculate LTV with annual subscriptions?
Calculate annual ARPU first, then divide by annual churn. You can also convert the plan to monthly terms by dividing its recurring annual value by 12, then use monthly churn. Do not use a one-time annual payment as one month of revenue, because that inflates the estimate.
What churn rate should I use for LTV?
Use customer churn when you want the expected value of an average account. Use revenue churn as a separate view when customers pay very different amounts. Base the rate on a consistent period and define how you treat failed payments, pauses, reactivations, and cancellations before running the calculation.
Why does my LTV change so much each month?
LTV can change sharply because churn sits in the denominator. A small customer base, a few large cancellations, plan changes, discounts, or failed payments can move the result. Check the raw customer count, ARPU source, and churn definition before changing your pricing or acquisition plan.
Conclusion
Use ARPU divided by monthly customer churn as your starting point, then add gross margin and cohort checks before making a budget decision. Calculate the figure once with a clean data set, repeat it by plan or signup month, and document the rules behind it. If you want to reduce spreadsheet work, explore Chartsy's subscription analytics for Stripe and Paddle data, then verify its assumptions against your own records.

Written by
Chartsy TeamThe Chartsy Team writes guides, product updates, and resources to help SaaS and eCommerce founders make sense of their metrics, without SQL or spreadsheets.
Chartsy