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 customer lifetime value (LTV) and why does it matter for SaaS businesses?
Customer lifetime value (LTV) is the total revenue a SaaS business can expect from a single customer before they churn.
CLV measures the total net revenue a business can expect from a single customer relationship, linking retention directly to long-term profitability. For subscription businesses, LTV is a lighthouse metric because it tells you how much you can afford to spend acquiring each new customer. If your LTV is low relative to your customer acquisition cost (CAC), your growth engine is leaking before it even gets started. Tracking LTV by pricing tier or customer segment gives you the sharpest picture of which parts of your business are actually healthy. -
What is the difference between LTV based on revenue churn versus user churn?
Revenue churn LTV measures how long customer revenue lasts, while user churn LTV measures how long individual customers stay subscribed.
The distinction matters because the two models serve different business models. Revenue churn LTV is better suited to B2B SaaS companies with tiered pricing, upsells, and expansion revenue, where a customer can shrink or grow their spend over time. User churn LTV works better for B2C subscription products or flat-rate pricing, where every active subscriber is worth roughly the same amount. Choosing the wrong model can lead you to misread your unit economics and misallocate marketing or retention budget. -
What is the formula for calculating LTV in a subscription business?
The core LTV formula for subscription businesses is: LTV equals ARPU (average monthly recurring revenue per user) multiplied by average customer lifetime.
Customer lifetime is itself derived from your churn rate: if your monthly churn rate is 2%, average customer lifetime is 50 months. From there, LTV is simply your ARPU multiplied by that figure. For a more accurate picture, you can layer in gross margin (margin-adjusted LTV) or a discount rate to account for the time value of money (discounted cash flow LTV). Baremetrics calculates these figures automatically from your Stripe data, so you are not doing this arithmetic in a spreadsheet every month. -
What is a discounted cash flow LTV model and when should SaaS companies use it?
A discounted cash flow (DCF) LTV model adjusts standard lifetime value calculations to reflect the fact that future revenue is worth less than revenue earned today.
Traditional LTV models treat a dollar received in month one the same as a dollar received in month 36, which overstates the real value of long-term customer relationships. The DCF approach applies a discount rate to future cash flows, giving a more realistic view of what each subscriber is actually worth in present-day terms. This model is most useful for late-stage SaaS companies with predictable revenue, and for founders or CFOs preparing unit economics for investor diligence. The LTV to CAC ratio is a favorite compound metric for SaaS investors, and DCF LTV makes that ratio more defensible. -
How do you use LTV by segment to improve your ideal customer profile (ICP)?
Segmenting LTV by pricing plan, acquisition channel, or customer type reveals which customer groups drive the most long-term revenue and stay the longest.- Break your subscriber base into cohorts by plan tier, billing interval, or company size.
- Compare average LTV and churn rate across each segment to spot the stickiest groups.
- Identify what your highest-LTV customers have in common, then use that to sharpen your ICP.
- Shift acquisition and onboarding focus toward channels and messaging that attract those profiles.
-
What is a margin-adjusted LTV model and why do investors prefer it?
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 revenue.
Standard LTV figures can be misleading because they ignore the cost of serving each customer. Factoring in gross margin gives you a number that reflects what actually flows to the bottom line over a customer relationship. The LTV to CAC ratio is best evaluated in the context of company size and ACV, and investors consistently prefer margin-adjusted figures because they reveal whether a business is genuinely profitable at the unit level. For B2B SaaS companies with tiered pricing and upsell motion, this model gives the most honest read on unit economics. -
How do you track LTV month over month without a dedicated analytics tool?
You can track LTV month over month manually by maintaining a Google Sheet that logs ARPU, churn rate, and customer lifetime for each billing period.- Record monthly ARPU and your churn rate for each pricing tier separately.
- Calculate customer lifetime by dividing one by your churn rate for each segment.
- Multiply ARPU by customer lifetime to get LTV, then log it each month to spot trends.
- Add a gross margin column to shift toward margin-adjusted LTV as your data matures.
![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)