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.
Formula is ARPU / Customer churn rate, but what happens when churn rate is 0%? (No customer churn in that period). Thanks.
| +326 | I Snuck Into UBS Office And Took A Shit On The Floor | 28 | 2d |
| +288 | Predicted 1Q 2027 Story - UBS IB blames Outlook Outage for Down Quarter | 41 | 14h |
| +269 | Houston 2026 Oil & Gas Investment Banking Rankings | 69 | 4h |
| +244 | Why leave restructuring for M&A? | 31 | 18h |
| +234 | Best Power/Renewables/Energy Teams? | 41 | 8h |
| +187 | Actual EB List | 27 | 2d |
| +182 | Incoming TPH Analysts Larping as PWP on LinkedIn | 27 | 1d |
| +39 | Embarrassed getting off at UBS train stop | 6 | 10h |
| +37 | Rogo Changing The Game | 9 | 4h |
| +30 | I built a game to help me practice fundamentals like DCF, merger models and LBOs. Roast it? | 7 | 10h |
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
Hic doloremque minus autem ab tenetur. Aliquam dolorum illo aut ad et dolorem. Accusantium hic labore quaerat consequuntur.
At aut illum est eligendi sed qui. Eaque odit facilis necessitatibus.
Molestiae facilis dolorum et. Facilis optio tempore temporibus veniam reprehenderit sed qui. Asperiores minus officia omnis et aperiam aut rerum.
Quod sed est quos qui at. Itaque cum similique incidunt facilis ullam. Qui et aut consequatur et. Alias et eligendi est sequi.
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...