Love it. Good to know that this channel is actively tracking the hot topics on the market! Please keep the SaaS stuff going. Thank you
@financialmodeling2 жыл бұрын
Thanks for watching!
@jayliu6452 жыл бұрын
Thanks for the point on the "Gross Retention", great point ! Net Retention seems mask many underlying variables.
@isaacluo31932 жыл бұрын
Thanks Brian,really love your video!It would be really helpful if you can elaborate the point where you made in the last part. You said if the net retention is 110%, the churn rate is at least 10%. Thank you very much in advance!
@John-thinks2 жыл бұрын
I believe the idea is that a 20% price increase would mean 20% increase in profits and thus you "retain" 120% of previous period's revenue in a scenario where nobody unsubscribed. So if you have a net retention of 110% after the 20% price increase, then you've lost some customers. Remember: Revenue is price per subscription * quantity of subscriptions sold. So if price went up by 20%, then quantity sold had to decrease (~10%, although I think the math is slightly trickier than this in reality?) to get you to the 110. Hope that helps.
@financialmodeling2 жыл бұрын
What John said below (thanks for responding). Essentially, price increases can distort a metric like "net retention" because a company could cover up a poor cancellation rate just by raising prices substantially on the remaining customers. In fact, sometimes a big enough price increase could *cause* a higher cancellation rate. So when a company presents a "net retention rate" of over 100%, you always want to ask about the effect of price increases and license expansions vs. cancellations.
@kambizraoufi2 жыл бұрын
@Mergers & Inquisitions / Breaking Into Wall Street many thanks for taking the time to share such a great lesson with the community. Could you share the link to the Excel file. Thank you
@financialmodeling2 жыл бұрын
Thanks. You can click "Show More" and scroll to the links below.
@BaoNganPhan-l3w Жыл бұрын
Really helpful and understandable! Thank you for sharing and keep going with more amazing videos with us! 🙌
@financialmodeling Жыл бұрын
Thanks for watching!
@Jajangthecat2 жыл бұрын
damn cac payback is genius. as a marketing director, I'll be adding this to our metrics report.
@financialmodeling2 жыл бұрын
Glad to contribute to humanity.
@ShannonCatalano-h7r5 ай бұрын
Thanks for the content! Super helpful. When you say discount rate, are you referring to the average discount from list? Or cost of capital?
@financialmodeling5 ай бұрын
The Cost of Capital or WACC, which changes based on the company's stage and maturity.
@Talib_Husain182 жыл бұрын
really amazing content, sooo informative and comprehensive. Thank you so much
@financialmodeling2 жыл бұрын
Thanks for watching!
@BetoMexicano2 жыл бұрын
Thank you, this was an enlightening video.
@financialmodeling2 жыл бұрын
Thanks for watching!
@JoshOlawale2 жыл бұрын
Can’t wait til you release the case studies
@financialmodeling2 жыл бұрын
Coming soon!
@elijahgachohi67882 жыл бұрын
@@financialmodeling Eagerly awaiting the case studies, especially the Confluence one.
@TonyPhan-j7q Жыл бұрын
Really helpful. I have seen varying definitions around how CAC is defined - looks like you are using a New Logo subset of S&M here which makes sense but don't you want to allocate the remainder as a cost of expansion - netting against LTV?
@financialmodeling Жыл бұрын
You typically look at new vs. existing customers separately in these calculations because it costs less to maintain an existing customer relationship. You could look at some type of combined ratio that includes the initial subscription + expansions over time and then deduct the S&M cost required to renew, but that would be different from the normal LTV / CAC metric.
@pfknob2 жыл бұрын
Thank you. This is great! You said that we can download the spreadsheet. Where is the link?
@financialmodeling2 жыл бұрын
Click "Show More" and scroll to the links below Resources.
@pfknob2 жыл бұрын
@@financialmodeling Thank you!! Love your excellent videos.
@JUQR12 жыл бұрын
@@financialmodeling they are only KZbin links? What about the spreadsheet?
@John-thinks2 жыл бұрын
What are "leads?" Thanks for the content!
@ggas33dfdf2 жыл бұрын
A lead is a potential customer you can contact because he/she gave you the allowance to do so. Leads can be defined differently by industry. For example a lead in a SaaS business could be something different in comparison to a lead in manufacturing or financial service business. In terms of SaaS a lead is usually someone who showed interest in your product and signed up for a newsletter or a free trial for your product.
@dbsk062 жыл бұрын
@@ggas33dfdf THANK YOU! interview coming up :)
@financialmodeling2 жыл бұрын
What Martin said below (thanks for responding). A lead is just a "prospective customer" from any source (email newsletter, phone, networking, website visitors, etc.). Enterprise-focused businesses always need to be generating leads, which they then speak to and hope to convert into customers eventually.
@brandonkim40442 жыл бұрын
Really enjoying your videos! Just wondering if you have any plans to make Shipping & Aviation Metrics as well? Appreciate it
@financialmodeling2 жыл бұрын
Thanks. We do have a full case study of EasyJet in our financial modeling course. I don't know that there's enough to say about just the metrics and ratios to make for an interesting/useful separate video here, but maybe.
@nilayagarwal9416 Жыл бұрын
More videos on SaaS and VC related topics please
@financialmodeling Жыл бұрын
Thanks. We have just posted several recently if you look at the recent uploads.
@nilayagarwal9416 Жыл бұрын
thanks. appreciate the efforts.@@financialmodeling
@sonerguney3225 Жыл бұрын
Very good. Can we have the excel file to download?
@financialmodeling Жыл бұрын
Thanks. Click "Show More" and scroll to the links under "Resources."
@JUQR12 жыл бұрын
I’m sorry but there is no link to the excel spreadsheet... am I missing something. Someone pls respond I’d love to get started using this outline.
@financialmodeling2 жыл бұрын
Click "Show More" and scroll down to the links.
@arthursitbon71092 жыл бұрын
This video is very instructive :) Can we have the excel sheet pls ?
@financialmodeling2 жыл бұрын
Click on "More" and scroll down to get the files.
@John-thinks2 жыл бұрын
Can someone explain why LTV / CAC is useful at ALL? It seems like nonsense to me. Why are we not comparing LTV to total customer costs including both CAC and retention costs? You don't access the full LTV just with the acquisition cost. You need to pay to keep them too, right? Are we basically just assuming that the cost of switching becomes higher as you become more entrenched and thus retention costs are trivially low??
@financialmodeling2 жыл бұрын
The answer is that the retention costs are even more difficult to determine than the initial acquisition costs. And yes, it costs something to keep each customer, but this is usually much less than the initial acquisition cost, especially if it's a product that's difficult to switch away from. LTC / CAC is mostly a metric that is useful in very broad strokes, i.e., if it's far below 1.0x, you know the company has a problem, but getting something in the 2.0x - 4.0x range doesn't mean much except for "it seems about normal."