Table of Contents

This post is for early-stage startup founders and CEOs looking for a simple way to track their customer lifetime value (LTV) and analyze the overall health of their business.
If that sounds like you, keep reading for some helpful Google Sheets LTV models that will help you keep track of this important metric month over month and how to derive the insights you need for your business to succeed.
Why is customer lifetime value important?
As a refresher, LTV is a crucial metric to help evaluate how much money on average your business gets from each customer before they leave you (known as churn).
“LTV really is the representation of what is keeping the business going, i.e. how much money you’re getting over time,” says Luke Marshall, CEO at Baremetrics.
Customer lifetime value is often utilized as a lighthouse metric for SaaS startups because it can help inform key longer-term business decisions, like how much money to allocate towards marketing efforts. It also makes you focus more closely on your churn metric.
To be able to glean the most amount of insights from LTV, we recommend you measure your LTV by segment. This is because it will help you more easily spot patterns and overall trends across various plans that you offer.
For example, you'll generally find that lower cost plans, have a higher churn rate than your high cost plans. Therefore, you’ll see a lower LTV for those plans.
Identifying your high LTV clients and having a deep understanding of why they are sticky can help refine your ICP. It can also help you know not only how to keep those high-value clients engaged, but also how to attract similar ones.
For these reasons, your customer lifetime value is a key metric to keep track of.
Now, how exactly do you keep track of it? We’re so glad you asked…
An introduction to model structure
By now, you have a good idea of how crucial your lifetime value is, so it’s time to get to calculating it.
While it's easier to view your LTV in Baremetrics, sometimes you have to get down and dirty in a Google Sheet or Excel because either:
- you’re just starting out and need something familiar
- manual tracking isn't a complete pain (yet)
We get it 100%. So we devised a workaround.
Our awesome CFO advisor, Swapnil, created the four spreadsheets below to help you track your LTV, ARPU, Churn Rate, and Customer Lifetime each month and get revenue/user churn insights manually.
While not as nice as real-time Baremetrics insights, we're sure it'll do the job in a pinch!
Please make sure to make a copy of the Google Sheets below to update with your own numbers.
LTV Model based on Revenue Churn Google Sheets Template
Before getting started, be sure to make a copy of each of the models shared below.

Create a copy of the model from File > Make a copy
Our first basic LTV model template calculates the customer lifetime value (LTV) based on revenue churn. It helps estimate how long customer revenue is likely to last and the total revenue that can be generated over a customer’s lifetime.
The model focuses on revenue retention rather than user retention — making it more suitable for businesses with tiered pricing, upselling, and expansion strategies (e.g., B2B SaaS).
Use cases:
- Best for businesses where revenue retention matters more than user retention.
- Ideal for B2B SaaS or subscription models with multiple pricing tiers and upselling opportunities.
LTV Model based on User Churn Google Sheets Template
Our second basic LTV model calculates the customer lifetime value (LTV) based on user churn. It helps estimate how long customers are likely to stay and the total revenue they will generate over their lifetime.
The model focuses on user retention rather than revenue retention and is most suitable for businesses with consistent or low pricing tiers, such as B2C subscription models.
Use cases:
- Best suited for businesses where user retention matters more than revenue retention.
- Ideal for B2C subscription models or products with flat pricing tiers.
Discounted Cash Flow LTV Model Google Sheets Template
Our discounted cash flow (DCF) LTV model calculates the customer lifetime value (LTV) based on revenue churn while adjusting for the time value of money.
Traditional LTV models assume that cash flows from customers are equally valuable over time — which isn’t true due to inflation and opportunity cost.
The DCF model incorporates a discount rate to reflect the reduced value of future cash flows, providing a more realistic measure of customer value.
Use cases:
- Best for businesses where profitability and long-term growth are more important than short-term gains.
- Ideal for late-stage SaaS companies or businesses with established customer bases and predictable cash flows.
- Useful for VCs and investors focused on unit economics and cash flow sustainability.
- Helps assess whether future cash flows are sufficient to justify customer acquisition costs (CAC).
Stop wasting time on countless spreadsheets. Get a 14-day free trial of Baremetrics now.
Margin-Adjusted LTV Model Google Sheets Template
Our margin-adjusted LTV model calculates the customer lifetime value (LTV) based on revenue churn while adjusting for gross margin.
It helps estimate how long customer revenue is likely to last and the total revenue that can be generated over a customer’s lifetime after accounting for the cost of sales.
Incorporating gross margin refines the calculation to reflect the true contribution of each customer to the business’s profitability.
Use cases:
- Best for businesses where revenue retention matters more than user retention.
- Ideal for B2B SaaS or subscription models with multiple pricing tiers and upselling opportunities.
- Incorporating gross margin gives a more realistic view of the long-term value of each customer.
- Preferred by VCs and investors who focus on unit economics and profitability rather than just top-line growth.
Summary
LTV isn't just a boring business term — it's essentially a roadmap that shows you where to spend your money, who your best customers are, and how your business can grow.
By paying attention to this vital metric, you can turn plain old data into smart plans that help your business move forward.
We know the startup journey isn't easy, but we believe in your vision. When the time is right and you need a partner to help take your business to the next level, Baremetrics will be here — ready to support you every step of the way.
FAQ
-
What is the difference between revenue churn LTV and user churn LTV for SaaS businesses?
Revenue churn LTV measures how long customer revenue lasts, while user churn LTV measures how long individual subscribers stay active before cancelling.
The distinction matters because the two models serve fundamentally different business structures. Revenue churn LTV is the right choice for B2B SaaS companies with tiered pricing, upsells, and expansion revenue, where a single customer can shrink or grow their spend over time without technically churning. User churn LTV works better for B2C subscription products or flat-rate pricing, where every active subscriber contributes roughly the same monthly amount. Picking the wrong model distorts your unit economics and can cause you to misallocate acquisition or retention budget across pricing tiers. -
How do you calculate LTV for a SaaS or subscription business?
The core LTV formula for a subscription business is ARPU multiplied by average customer lifetime, where average customer lifetime equals one divided by your monthly churn rate.
For example, if your ARPU is $200 and your monthly churn rate is 2%, average customer lifetime is 50 months and LTV is $10,000. From there, you can layer in two refinements:- Margin-adjusted LTV: multiply by gross margin to see the true profit contribution per customer, not just top-line revenue.
- Discounted cash flow LTV: apply a discount rate to future cash flows to account for the time value of money, which matters most for investor diligence.
-
When should a SaaS company use a discounted cash flow LTV model instead of a standard LTV calculation?
Use a discounted cash flow LTV model when you need a realistic measure of what future customer revenue is actually worth today, not just what it adds up to on paper.
Standard LTV models treat a dollar received in month one the same as a dollar received in month 36. That overstates the real value of long-term customer relationships because of inflation and opportunity cost. The DCF LTV model applies a discount rate to each future cash flow period, giving a more defensible number for unit economics conversations. This approach is most useful for late-stage SaaS companies with predictable recurring revenue, and for founders or finance leads preparing LTV to CAC ratios for investor diligence. -
How do you use LTV by customer segment to sharpen your ideal customer profile?
Segmenting LTV by pricing plan, billing interval, or acquisition channel reveals which customer groups generate the most long-term revenue and stay the longest before churning.
Start by dividing your subscriber base into cohorts based on plan tier or company size. Compare average LTV and churn rate across each segment to identify your stickiest user groups. Then look at what your highest-LTV customers have in common and use that pattern to tighten your ideal customer profile. Lower-priced plans typically carry higher churn and lower lifetime value, so shifting acquisition focus toward segments that already show strong retention is usually more efficient than trying to repair high-churn cohorts after the fact. Baremetrics customer segmentation dashboards make this comparison straightforward without manual data wrangling. -
What is a margin-adjusted LTV model and why do SaaS investors prefer it over standard LTV?
A margin-adjusted LTV model calculates customer lifetime value after accounting for gross margin, showing the true profit contribution of each customer rather than just top-line subscription revenue.
Standard LTV ignores the cost of delivering your service, which means it can look healthy even when the business is barely profitable on a per-customer basis. Multiplying LTV by gross margin corrects for this and gives a more accurate view of what each subscriber actually contributes to the bottom line. This matters for two reasons:- It produces a more defensible LTV to CAC ratio when presenting unit economics to VCs or investors.
- It helps SaaS founders and finance leads prioritise customer segments that are genuinely profitable, not just high in revenue volume.
![Basic LTV Model [User Churn]](https://baremetrics.com/hs-fs/hubfs/Basic%20LTV%20Model%20%5BUser%20Churn%5D.png?width=751&height=381&name=Basic%20LTV%20Model%20%5BUser%20Churn%5D.png)