What’s your TRUE customer lifetime value (LTV)? – DCF provides the answer


The old formula that everyone uses for customer lifetime value (LTV)) –average gross profit per customer divided by churn – ceases to work properly when you have very long customer lifetimes and negative churn. LTV can become infinite, which clearly doesn’t reflect reality. This post offers a new way to calculate LTV based on discounted cash flow analysis that takes into account the risks associated with revenue that is far off in the future, and the time value of money. The resulting LTV can help companies better understand and manage their future revenue streams and it much more accurately reflects what an investor would pay for that future flow of cash.

Most of the content in this article is aimed at SaaS companies that are past the point where they have a repeatable, scalable and profitable sales process, and are well into their expansion phase. If you’re an early stage SaaS startup, still trying to get product/market fit, or experimenting with different ways to make your marketing and sales predictably repeatable and scalable, it is useful to play around with CAC and LTV to get a feel for where you are. But it’s important to note that these formulae will only yield meaningful results when your sales and marketing process and costs are predictable and scalable. Instead of spending too much time obsessing over CAC and LTV, rather focus your energies on solving the problems of improving product/market fit, and making your customer acquisition repeatable, scalable and profitable.

My apologies that there are some complex looking formulae in this article. We have provided a summary below of the key concepts, and a link* to jump straight to the spreadsheet to model your own LTV. For those interested in understanding the theory behind this model, we provide our usual detailed explanation below.

My thanks to my partner Stan Reiss, who co-authored this piece with me, providing all the expert math help.

*Spreadsheet updated 2/23/16 – errors corrected in Cell B78 on Real World Model tab.


For subscription-based businesses who have “negative churn” (they expand revenue from retained customers at a greater rate than lost revenue from churn), you need new formulae to calculate LTV that includes both this expansion rate and churn.

In addition, because you are modeling revenues that will occur far in the future, you will need to apply a discount rate to account for the risks and time value of money. We recommend using a 10% discount rate, but this may differ depending on your own cost of capital.

This approach provides a lower, but more accurate view of your LTV. We have previously recommended your LTV to CAC ratio be greater than 3. However, we will be working with SaaS companies to understand the impact of this lower LTV calculation and will provide an updated recommendation in a future post.

Payback period does not change, and we still recommend a 12 month payback period unless you have easy access to a lot of capital. In that case, your payback period may be 18 months or longer.

Data you’ll need to model this new LTV, using the spreadsheet tool below:

  1. Average starting contract revenue per account
  2. Gross margin (this should include customer support and account management time to retain and upsell)
  3. Churn rate
  4. Growth rate for retained customers

**These #s can be monthly or annual #s, rates.

Real World Model

A more detailed second model in the spreadsheet linked below allows you to input data to reflect how churn and growth rates change over the life of a cohort of customers. You can input this data for whatever time period you have (first year, 18 months, 2 years, etc.) But, don’t obsess over the accuracy of this data and just use the best data you have. The model is much less sensitive to inputs in the far future; it’s more important to ensure your first year or two of assumptions are accurate.

Free Spreadsheet Attached

For those readers interested in modeling their own LTV, an Excel spreadsheet is attached. Click this link to download*.

*Spreadsheet updated 2/23/16 – errors corrected in Cell B78 on Real World Model tab.


All of my regular SaaS/subscription economy readers know that one of the core concepts that I stress is the idea of measuring Unit Economics at the customer level to help entrepreneurs figure out if they have a good business, and if not, what they need to focus on to improve it. Unit economics is a simple concept where we look to make sure that the profit we are getting from a customer over their lifetime (LTV) is greater than the cost to acquire a customer (CAC).  This is needed because in the early days of a fast growing SaaS/subscription business, the EBITDA losses can be huge, and investors and board members need a new kind of tool, that is not provided in the traditional accounting reports, to help them recognize the difference between the good businesses that will eventually produce great profits, and the bad businesses that will never turn a profit. (For more details on this topic, see SaaS Metrics 2.0.)

Those posts, and several others, focused on the importance of retaining customers, and trying to get to “negative churn”. It is this negative churn that now requires us to develop more complex measurements to understand future cash flows.

Traditional Churn and LTV

To study churn, we need to look at a particular  group of customers that signed up in a particular time period. We refer to these groups as cohorts. So you might have a Jan 2014 cohort which is comprised of all the customers that signed up in Jan 2014. We will then want to track how many customers we retain, and how the revenue for each cohort evolves over time.  Here is a graph that shows what happens to the number of customers in a particular cohort over several years with three different monthly Customer Churn Rates.

As you may be able to tell, the graph is an exponential decay, and for exponential situations, we can use a simple formula to get at the average Customer Lifetime:

And from there, we can simply multiply that average lifetime by the average amount of Gross Profit that we make from each customer every year to get to LTV:

Filling this out with the math for average customer lifetime, and gross profit per account, we get this formula:

                (ARPA is the Average Revenue per Account)

So far, we have only looked at a simple version of churn, which is the rate at which our customers churn. However, things are more complicated when we look at how revenue behaves when you have churn.

Why Dollar Retention Rate (DRR) is different to Customer Retention Rate (CRR)

Imagine a situation where we start the year with two customers, one small and one large:

Now let’s look at what happens if we lose Customer 1:

Our Customer Churn was 50%, but our Dollar Churn was only 17%. So we see that these two numbers behave differently, and need to be tracked separately to understand the full picture of what is going on in the business. This points out an obvious fact: it is more important to retain your larger customers than it is to retain your smaller customers.

Now let’s look at what happens if we were able to expand the revenue we are getting from Customer 2 from $5k to $7k:

Something very interesting has happened here: the expansion revenue of $2k from remaining customers was greater than the $1k that we lost from the churned customers, and we have Negative Dollar Churn, even though the Customer Churn remained at 50%.

This is an extremely powerful concept, which I have written about before here: Why Churn is SO critical to success in SaaS. It does raise an interesting question, which is how do we get our current customers to expand, and that requires that we have either variable pricing, and/or additional product modules to sell. I have covered this topic in a prior post on Multi-Axis pricing.


So far we have talked about Customer Churn and Dollar Churn. There are two other terms which you might see used, which are the counterparts to churn:

  • CRR (Customer Retention Rate) which is equal to 1 – Customer Churn Rate
  • DRR (Dollar Retention Rate) which is equal to 1 – Dollar Churn Rate

So a business that has a negative churn rate, will have a Dollar Retention Rate of greater than 100%. These are some of the very best SaaS business out there. Examples of DRR greater than 100% include: Zendesk: 123%, NewRelic 115%, Box: 130%, Rally Software 127%. (For more public company retention rates you might like to check out this article by Pacific Crest.)

Negative Churn invalidates the LTV formula

In the LTV formula above, I kept things simple by using the term “Churn Rate”. But I should have been more precise and used the term Dollar Churn Rate to avoid confusion with Customer Churn Rate. But now we have a problem, if we insert a negative value in the LTV formula, we don’t get the right answer. And you can tell quite easily without a formula, that if our cohort kept growing at 16% every year (which is what is implied by a negative 16% churn rate), then we would have an infinite future revenue stream that would grow and grow from this cohort.

Our first attempt to model this phenomenon, showed that there is a point where the customer churn starts to bring down the revenue. Here’s a graph showing what would happen if you had a cohort of 100 customers that initially started paying you $100 a month, but each remaining customer increased their payment by $5 every month. The monthly Customer Churn Rate is 3%:


In case of interest, the formula used to compute this graph is: clip_image014.png

a = initial ARPA per month x GM %
m = a fixed $ amount of monthly growth in ARPA per account (not compounding)
c = Customer Churn Rate % (in months)

The formula would work equally well for yearly values.
(Note: there is a huge simplification in this formula that we will address later: it assumes a fixed linear expansion in revenue over time, and in most cases this won’t be how expansion revenue happens.)

Using DCF to account for Risk and Time Value of Money

Given that so much of the customer value in this situation occurs way in the future, where there are risks of the market changing, new competition, technology platform changes, etc. it makes sense that we should factor in that risk in some way when computing LTV. Similarly, we all know that if we were offered a dollar in ten years time, we’d value it far lower than a dollar today. Applying a discount to future cash flows is the accepted way to model this phenomenon.

Here is what happens if we apply a 10% annual discount to the cash flows of a SaaS business with 10% annual dollar churn:

The vertical Axis represents the percentage of the initial cohort contract value, and how it drops over time with a 10% annual churn rate. Then the orange and green lines show the impact of adding discounting of future cash flows to the blue baseline.

This shows what we were expecting to achieve: a lower value associated with cash flows that are farther away in time, reflecting future risks and the time value of money.

This far more accurately reflects what an investor would be willing to pay today, for that flow of cash going into the future.

True LTV: DCF applied to a Negative Churn Scenario

The graph below shows what happens to Cash Flows in a Negative Churn scenario:

  • Churn rate of negative 10%, as a result of the following two variables:
    • Customer Churn is 10% annually
    • Remaining customers increase their spend by 22% of the original contract amount every year (note this is linear, not compounding and exponential)


This requires us to come up with a new formula for LTV:

LTV Formula

Where G is the growth rate for the customers that have not churned, and K is defined by the following formula:

LTV - 2

Where Churn is the Customer Churn rate.
Note: the formula above is included in the provided spreadsheet, on the Tab called LTV Calculator.

Using this formula, we can see that the LTV, for a starting contract with $1 of gross margin, changes as follows:

LTV Table

LTV Graph

The left hand bar shows LTV when there is no discount applied. All the CFOs that I talk to know that this number is too high. Then the four bars to the right show what happens to LTV when we apply discounts to future cash flows.

What is the right Discount Rate?

All financial theory is consistent about one thing: every time managers spend money they use capital, so they should be thinking about what that capital costs the company.  There can be many sources of capital, and the weighted average of those sources is called WACC (Weighted Average Cost of Capital).  For most companies it’s just a weighted average of debt and equity, but some could have weird preferred structures etc. so it could be more than just two components.

The discount rate that is used in a DCF should be your company’s Weighted Average Cost of Capital (WACC).

If we were looking at the true cost of capital, we’d suggest the following discount rates to use:

  • 10% for public companies
  • 15% for private companies that are scaling predictably (say above $10m in ARR, and growing greater than 40% year on year)
  • 20-25% for private companies that have not yet reached scale and predictable growth

The earlier the stage of the startup and the greater the risk in the business, the higher the discount.

However, there is an argument to be made that startup SaaS companies shouldn’t be using a different discount rate to public SaaS companies, as their goal is to show that they have the needed unit economics to eventually become a public company. And investors, board members and management will want to compare their LTV numbers to other larger companies. So given that thinking, we’d be inclined to suggest that the whole industry standardize on using one way of calculating LTV using discounted cash flow, and use one discount rate, which would probably be 10%. That way you could compare private company LTV numbers with public company LTV numbers. We are charting new territory with this analysis, so it will be interesting to hear readers’ feedback on this question.

We have provided the detailed thinking, formulae and calculations behind those numbers on the following page: “How to calculate the discount rate for use in a DCF” Here we go into how to calculate WACC. A key component of WACC  is the cost of equity, which is computed using CAPM, the Capital Asset Pricing Model to arrive at a discount rate. This is explained in more detail in that article for those who have the curiosity to dig deeper.

Impact of DCF on the LTV:CAC Ratio

My regular readers will know that I have long recommended that SaaS startups should have an LTV : CAC ratio of greater than 3.  Given that we will now be looking at lower LTV numbers because of using DCF, this recommendation will need to be changed to a lower number. I don’t yet have a firm point of view on what this new ratio should be, and will be spending time with a bunch of companies that decide to use the DCF version of the LTV formula to watch what this does to their LTV:CAC ratio before making a final recommendation.

However, my other recommendation, that SaaS companies should measure their Months to recover CAC remains a great metric to understand whether your company has good unit economics. For companies looking to optimize their cash flow, I have recommended that they try to recover CAC in 12 months or less. But if your startup is able to cheaply raise a lot of capital, you may be able to relax this, and recover CAC in 18 months, or even a bit longer.

Introducing CORE – Cost of Retention and Expansion

Most readers will realize that it requires Account Managers time and effort to retain customers, and additional sales effort to get expansion revenue. In most organizations this cost is part of the Sales expense, which may be fine for accounting purposes, but is not going to reflect correctly in our CAC and LTV calculations, as it will show up as a misleading number in CAC.  To give you a sense for this, imagine a mature SaaS company with a large installed base producing about $100 million in recurring revenue. To keep that installed base happy, and to maximize retention, that company will likely have a large number of Account Managers. If the cost of these Account Managers shows up in CAC for newly added customers, it will make the CAC number much higher than it really is.

The solution is to move the costs of these Account Managers, plus any extra sales people that are needed to generate expansion revenue in that customer base, into the LTV side of the equation, as these are really a true Cost of Retention and Expansion (CORE) and should be treated similarly to COGS when computing the Gross Margin for that recurring revenue. So in the formulae above*, when computing Gross Margin %, don’t forget to include both COGS and CORE.

How to calculate CORE and Gross Margin % for an average customer

You will likely know how many customers a single Account Manager can handle. And if you have specialist Expansion Sales Reps, again, you will likely know how many customers they can handle. As an example, let’s say that our organization has both Account Managers and Expansion Sales Reps. In that situation CORE for a single customer is calculated as follows:

CORE Formula

And Gross Margin % now becomes:


Where COS is the Cost to Serve a single customer (hosting costs + support costs).

Understanding the effectiveness of an Expansion Revenue Salesforce

If you have dedicated sales people that only work on generating expansion revenue, and they are in addition to the Account Managers, it will be interesting to see what the CAC and LTV is for expansion revenue. My recommendation would be to create a second parallel tracking system to track these two elements. That will allow you to figure out the return on this investment, and compare it to other potential investments that you could make elsewhere in the business.

The Real World is more Complicated!

All of the above formulae make some key assumptions that typically don’t hold true in the real world:

Assumption 1: Your customers will churn in an exponential decay month after month.

In the real world, churn curves have quite different shapes from one company to another, and frequently improve over time. For instance, many companies using annual contracts will have little churn until the end of the contract periods.

Assumption 2: Your remaining customers will expand their revenue in a linear fashion

In the real world, this is highly unlikely to be the case, and will also vary a lot from company to company. It’s possible that you might see a linear increase if they have some kind of pricing axis such as user seats that increases predictably over time. Other factors such as upsell of new modules will be very non-linear, and will occur at odd times. Some companies might see a lot of expansion in the early days, and then it could taper off.

Assumption 3: Your Gross Margin % will remain constant over time

In the real world, most SaaS companies are able to improve their gross margins substantially in the years before they hit true scale (around $150m in ARR). If it is clear that your gross margins will be increasing predictably, you may find it valuable to model this as a changing variable.

Revenue versus Billings

Another important factor to note is that the formula above focuses on the timing of revenue, which could be very different to how cash is collected. Many startups are able to bill a year in advance, which means that the cash flows would actually be quite different to the revenue flows. Applying DCF to the revenue instead of the actual cash flows would penalize those companies somewhat. Trying to build a formula to take this into consideration would add too much complexity, and we don’t think that the difference warrants that extra complexity. But if you were looking to be entirely accurate about this, you could modify the provided spreadsheet to use cash flows (i.e. billings) instead of revenue.

Modeling the real world

The spreadsheet that accompanies this article provides a way to model your real world experiences on how two of these variables will change. Just go to the “Real World Model” tab of the spreadsheet*, and enter in your values for the churn and expansion as you observe (or believe) they change over time from your cohort analysis. It’s unlikely that you will know more than the one to three years of data, so enter only what you do know, and then use the Residual Value formula to predict the other years.

How should SaaS Startups react to this article

Don’t obsess over getting to the last level of accuracy here. We are using a formula to predict the future, and the future, by it’s very definition is not predictable. So recognize that the value in this analysis is to get enough accuracy to make useful business decisions, such as what factors to look at to improve profitability, which customer segments are most profitable, and which have problems that need addressing, etc.

Make sure you have the data you need to understand Churn, Expansion and LTV

There is one thing that all SaaS companies should do immediately after reading this article, if they haven’t done so already: build a database to track revenue by individual customer by month that can be used with an analytics tool to analyze cohorts. You will need to be able to look at all customers that started in a particular month (a cohort), and track customer count and revenue for that cohort over time. Also make sure to tag each customer with attributes such as “Enterprise”, “SMB” so that you can look at how churn and expansion varies over time for the different types of customers. This analysis will become extremely valuable at showing you which are your most profitable customer segments, and where you need to do work to fix issues.

This data will allow you to get Cohort graphs such as the one shown below, that will allow you to understand the shape of how your customer count and revenue decay over time. To create this graph, we are simply overlaying multiple cohorts data on top of each other, and treating their starting month as Month 0. The shape of these curves can be used with the spreadsheet model provided to calculate your real Customer Lifetime Value (LTV).



I have had many questions over the years from SaaS entrepreneurs and CFOs about how to calculate LTV when they have negative churn. They clearly realized the that old formula of Average Gross Profit per Account divided by Churn did not work in their situation. This article and the attached spreadsheet hopefully addresses that question. My apologies that there are some complex looking formulae in the article. If you are a reader who doesn’t like the look of those, simply download the spreadsheet*, and enter your own data into LTV Calculator.

I am really interested in hearing readers’ feedback on the ideas expressed in this article. Please leave me comments below.

*Spreadsheet updated 2/23/16 – errors corrected in Cell B78 on Real World Model tab

My thanks to my partner Stan Reiss, who co-authored this piece with me, providing all the expert math help. Thanks also to Joe Ferrero, Sai Ho and Alan Black of Zendesk for contributing their insights.

About the Author

David Skok

Stay updated

Related Posts

Customers hate being sold to. Customers hate being sold to. They don’t mind getting expert...

In this article I interview Aaron Ross, co-author of a new book, Predictable Revenue. Aaron...

An Interview with Andrew Quinn of HubSpot Having a high performing team means: Hiring the...

  • Anthony Hurtado

    So this is a great post, really appreciate your approach. One question that I do have is that this seems to be for all tiers of the productt. Yet, the ARPA is gonna be dramatically affected by the tier (I’m thinking Entry, Pro, Enterprise). Should we segment this LTV by these three tiers and leave expansion as a part of another revenue axis, such as number of users?

  • Hi Anthony, Great question. Most of the companies that I work with like to calculate LTV overall, and then also separately for each customer segment. That allows them to see which customer segments are most profitable, and either focus more on those, or go back and look at ways to improve profitability for the other segments. Best, David

  • Kent Huang

    Hi David, thanks for sharing this and we have been avid reads of your articles. One question that we wonder is there is a quantifiable relationship between LTV/CAC and overall P&L. Meaning is there any model that could help assess when overall P&L would turn positive (knowing that most SAAS companies run into heavy loss in their early year to drive growth) after we have estimated the LTV/CAC for all cohorts of customers (present and future)? Many thanks!

  • Hi Kent, there is a very definite relationship between LTV/CAC and overall P&L. However since CAC will show up in the first year and that LTV will materialize over several years, it will only show up if you model the business over several years. The other metric that I suggest you track carefully, Months to recover CAC, has an even more direct immediate relationship to the current year’s P&L, as it directly calculates how much of the CAC will be recovered in the first 12 months.
    To see the effects, you will need to build a model of your SaaS business. I have one model that you can play around with that only covers the sales and marketing part of the business, but since that is such a large part of the P&L, and other parts are more fixed and deterministic, you can still see the effects on P&L very clearly.
    The model is attached to this blog post, and it’s worth reading this and the follow on post to get a feeling for how playing with CAC/LTV affects the P&L and cash flows. http://www.forentrepreneurs.com/saas-economics-1/
    I hope that helps.
    Best, David

  • Scott Thomas

    David, Thank you for taking the time to share these insights – very helpful and it’s much appreciated! Hoping I can get some hand holding in the definition of Gross Margin % as is seems like the formula on the blog is describing a multiple. My sense is, in the definition of Gross Margin % above, the intent is to include COS + CORE in COGS, then calculate Gross Margin the old fashioned way 🙂 i.e. Gross Profit per Account divided by Revenue per account.

    For example, let’s say we use the Gross Margin % formula in the blog above, which is Average Revenue Per Account divided by the sum of COGS+COS+CORE, all on a per account basis. If Revenue per account is $100, COGS per account is $60 + COS per account $12 + CORE per account $25, the Gross Margin Percent would be 103% when I think you mean it to be Average Revenue Per Account, $100, less the sum of COGS+COS+CORE, all on a per account basis (60+12+25) divided by Average Revenue per Account, $100, which would be 3%. What do you think?

  • Rick Carlson

    David and Stan,

    Thank you so much for putting this together. I have what I think is a great situation and want to make sure I am thinking about it correctly. I am using the “real world model” which allows you to plug in customer churn and the growth rate of remaining customers to calc terminal value. For arguments sake, assume my customer churn drops to just ~1% after 24 months in a particular cohort. Better still, if I look deeper into who is actually churning at this point, I am only losing customers that don’t really have any expansion revenue (this is a product of our semi-unique business model) so they are worth far less that the ones that stick around for in month 25 and beyond. The customers that have have expansion revenue are worth 3x what the customers that churn in month 24 are worth, and these high-value customers are barely churning. As such, even the 1% customer churn is not reflective of what is actually happening on a dollar retention rate basis. So my question is, how do best deal with that in the real world model? My instincts are to adjust the customer churn number downward (by ~2/3) to account for only these low value customers leaving – essentially turning the customer churn number back into a dollar churn number. Your thoughts on this issue are greatly apprecaited.

  • Mark Beltra

    Hi David, Just stumbled on the blog. I had a question. Does SAAS metrics apply to non-saas businesses like mine? I wanted to calculate how much undermarketed my products i.e how much I will have to spend more to market my products. Mine is one time machinery selling businesses that is most customers do not buy after one time sale . I spend 20000 dollars for marketing and get 40 customers so CAC is 500 dollars? LTV I am using traditional formula .If same cusotmers do not buy so I have churn rate of 100%. Gross margin 50% and average revenue is 7000 $. Is my LTV 3500$? So does 3500/500 = 7 mean I am not spending enough on marketing? Your reply would be highly appreciated. Thanks.

  • Hi Mark, in theory your calculations are correct. However when you say you spend $500 on marketing, are you including all the human costs of people that work in Marketing and Sales? They should be included in the calculation.

    Best, David

    David Skok
    Matrix Partners
    *Blog*: ForEntrepreneurs.com

    *E*: dskok@matrixpartners.com
    *T*: +1-617494-1223
    *A*: 101 Main Street, 17th Floor, Cambridge, MA 02142
    *Twitter*: @BostonVC

  • Angelinachester

    It’s a great Article, I liked it much, Thank you David Skok for sharing with us, Great Work..

    PG in Bangalore

  • AnaZoe

    Hi David. Really good article. Thank you. In the LTV Calculator, if you link the monthly calculation to the yearly one, you get different values for LTV. How do you explain this?

  • AnaZoe

    More then that, with the same data, the real world model is given a higher LTV then the one in LTV calculator. In this case, which calculation should a business rely on for accurate results?


  • Can you explain what you mean by “link the monthly calculation to the yearly one”? Thanks.

    David Skok
    Matrix Partners
    *Blog*: ForEntrepreneurs.com

    *E*: dskok@matrixpartners.com
    *T*: +1-617494-1223
    *A*: 101 Main Street, 17th Floor, Cambridge, MA 02142
    *Twitter*: @BostonVC

  • Hi AnaZoe, When he has a chance, I will ask my math guru, Stan, to take a look. But I am guessing that the differences lie in the level of detail being fed into the formula. There will be 12x as much info in the monthly versus the annual, which will likely lead to a small variation in the result. Similarly for the real world calculator, this sums the value of each cash flow, versus using a formulae that estimates.

    It’s really important to point out that getting to the nth level of accuracy is not the goal of LTV calculation, as there are so many of the inputs that are really not that reliable, so you would have a false feeling of accuracy that is not justified by the variability of the inputs. The purpose of having a reasonably good idea of LTV is to help you make business decisions, such as:

    – Is our CAC justified in the long run?
    – Which customer types are most profitable, which is a good place to invest more heavily
    – Which customer types are least profitable, and what can we do about that?
    I hope this helps.
    Best, David

    David Skok
    Matrix Partners
    *Blog*: ForEntrepreneurs.com

    *E*: dskok@matrixpartners.com
    *T*: +1-617494-1223
    *A*: 101 Main Street, 17th Floor, Cambridge, MA 02142
    *Twitter*: @BostonVC

  • AnaZoe

    You input the annual data rows 16:19 and calculate the monthly data in rows 52:56 from these: Monthly APRA x Gross Margin % = Annually ARPA / 12 x Gross Margin %, Monthly Churn % = (1 + Annually Churn %)^(1/12)-1 and Monthly Growth % = (1 + Annually Growth %)^(1/12)-1.

  • AnaZoe

    Thanks you your quick answer, David. I agree that not the accuracy of
    calculating LTV is important, but the message it sends. We have a CAC of 270 EUR. When using different formulas and we obtain LTV 582 (classic formula), 414 (using DCF, 20% discount) and 837 (real world calculation, 20% discount), it is important to know on which calculation to rely on for further analysis. How should we approach this matter? Thanks, Ana. https://uploads.disquscdn.com/images/c5d562539d4578c2c09f51f368b93ab6a223b23d552509c157668295b0ae944c.png

  • Hi AnaZoe, those numbers do vary too much. Please can I ask you to email me the various spreadsheets you have used with any needed explanation to describe your inputs, and we will take a look. (dskok at matrixpartners dot com).

    Many thanks, David

    David Skok
    Matrix Partners
    *Blog*: ForEntrepreneurs.com

    *E*: dskok@matrixpartners.com
    *T*: +1-617494-1223
    *A*: 101 Main Street, 17th Floor, Cambridge, MA 02142
    *Twitter*: @BostonVC

  • Bryant

    So on the extended lifetime value equation, why is (1-k) on the right hand side squared?

  • Stan Reiss


    The formula is essentially a sum of two formulas. First, the basic exponential decay of the initial ARPA * GM, which is ARPA * GM * (1 + k + k^2 + k^3 + … ). Solving this infinite series yields the first part, which works out to be ARPA*GM*1/(1-k).

    The second is the growth revenue component. ARPA*GM linearly grows with G, and is also discounted by k for each time period. In time 0 the extra growth is 0, at time one it’s G*k, at time 2 it’s 2G*k^2, at time 3 it’s 3G*k^3, etc. (all multiplied by GM*ARPA of course). If you solve this infinite series you’ll come out with GM*ARPA * kG/(1-k)^2.

  • Sharon

    Hi David, have you seen and can you speak to SaaS companies who make an investment in future growth through negative gross margins? Have you seen SaaS companies acquire new customers at negative gross margin with the strategy of increasing gross margin over the lifetime of the customer?

  • Gloria

    Hi David

    Thanks for sharing this model. I’m an Haas MBA student currently working for a SaaS company and I used your model to calculate the company’s LTV. I know this question was already mentioned further below but I was hoping to get some more clarity from you.

    In the Real World Model, row 64, % of retained customer, is never used in any formula. Your explanation further below was that row 64 doesn’t have to be included in the formula because this is included in the remaining revenue line (row 65).
    My question: Row 65, “Revenue as a % of starting value”, does this refer to OPTION 1) average revenue as a % of the starting value **per remaining customer** or to OPTION 2) total cohort value as a % of the **total cohort** starting value? I initially assumed it is the average % increase per remaining customer (option 1, I got to this value by dividing the total cohort revenue per period by the number of remaining customers and calculated the decrease/increase of this period compared to prior period). If this is the case I think row 64 should be included in the formula in row 66 (ARPA * revenue as a % of starting value * customer churn * (1-discount factor). However, if row 65 refers to the total revenue increase/decrease per cohort period over period (option 2) then I agree that row 64 doesn’t have to be included. Could you please explain what value exactly I’m supposed to enter in row 65? Also, to make sure I understand, does cell B59 refers to revenue growth per remaining customer for the residual time which is equal to my explanation for option 1?

    I appreciate your response.