Lifetime Value Calculation (SaaS Metric)
Formula is ARPU / Customer churn rate, but what happens when churn rate is 0%? (No customer churn in that period). Thanks.
Trending Content - Investment Banking Forum
| +190 | Why UBS Is the Worst Place to Start Your IB Career | 32 | 6h |
| +160 | ONLY THESE BANKS OR YOU STRUCK OUT | 39 | 13h |
| +117 | IB Energy Drink Tier List / Ranking | 78 | 1h |
| +65 | Firm Thinks I'm Lying About Offer | 20 | 12h |
| +58 | Indiana University Fraternity Pipelines | 35 | 4h |
| +40 | Rogo AI | 20 | 1h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 1d |
| +38 | Elite Boutique interview questions | 10 | 1h |
| +34 | Suspended for a Year | 16 | 27m |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 16 | 7m |
Career Resources
You simply would never run that formula as snapshot. In this case you at least need to limit the period for which you are forecasting, to get to a meaningful number or prob. adjust it.
By the way: look at churn over time. A lot of SaaS companies even have negative net churn for some time but in the long-term it becomes positive and/or moves towards an industry average. I would also aggregate the revenue / logos and work with company wide churn to get more meaningful numbers. Also try to go down from ARPU to different profit metrics because customer lifetime is most interesting in a cost / profit perspective because (i) CLTV is a metric for an optimization function, not an absolute (unless you use it as valuation input/comparison) and (ii) a ratio often cancels out crazy assumptions as they tend to be in both numbers and if it doesnt, at least the craziness becomes more obvious.
Thanks.
1) Can you provide what other profit metrics or things I should be taking a look at to evaluate a potential SaaS business?
2) To confirm: you should use logo churn % and not rev % for the LTV calculation right?
3) "...prob. adjust it"... how do you adjust it?
As a more rigorous way of calculating it, it would be the forecasted total contribution profit for the average customer into the future. Contribution profit because for each dollar of additional revenue we need to subtract out marginal costs associated with that additional revenue.
So forecast out probability-unweighted revenue per logo as ARPU forecasted into future (could grow or stay same each year depending on assumptions), then multiply each year by contribution margin, and probability-weight the year by the logo-retention rate x years out, i.e. the probability any given logo will actually still be around in that year. Then sum this up for 10-15 years. Logo-retention weighting approaches 0 over time, so additional years beyond 10 years or so don't change the LTV that much.
Following
there are really good documents on this. two i have been using over the years are page 20 of KPMGs report and the appendix (page 19+) of credit suisse' report. cant post links for whatever reason
google:
Transforming your SaaS business KPMG - the first PDF is the right one from 2016
2017 Software Outlook credit suisse - the first PDF is the right one from 2017
Sit autem illum vel debitis qui et cupiditate. Impedit saepe quia commodi sit non quam. Eligendi praesentium voluptas voluptatem. Quas ad qui provident soluta est natus. Blanditiis est eveniet maxime et fuga nam qui. Aut ea officiis a totam.
Illum animi error consequatur aliquid rem ea optio et. Odit laboriosam velit impedit atque error officia. Aut ratione et repellat libero. Distinctio veniam ratione pariatur quasi alias voluptatibus laboriosam. Excepturi hic non voluptatem veritatis pariatur quis cum. Et cupiditate maiores facere saepe maxime veniam velit veritatis.
Dolorum qui aut aut velit odit. Doloremque fuga delectus eligendi repellendus ut. Perferendis sunt adipisci sed itaque labore. Et fugit veritatis sapiente et consequatur ut tempora asperiores. Alias nemo vitae ullam asperiores aperiam. Perspiciatis sint ab ab. Aut suscipit officia facilis enim odit quasi.
Officiis ipsum quidem officia repellendus recusandae perferendis. Dolorem deserunt ea laborum nisi perferendis. Magni occaecati sit ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...