Great Lecture, you go through it so fast but everything made sense because you always give your reasons. I'm surprised I didn't even have to rewind. Awesome!
This is an incredibly helpful tutorial! Thank you so much. I was reading the book on my own and it's relatively confusing doing it solo. Having you take me through it and bringing in your own examples really clarifies things.
If you're just gonna use the consensus estimates from an equity research paper, may as well take their DCF whilst your at it. Surely you don't want to come up with the exact same analysis? Love to see some modelling videos for revenue (bottom up/ top down)( including projections for fx, M&A and whatever else might impact etc.)
Thanks for watching, my video on the cost of capital thoroughly covers the CAPM formula. Please check this video description for that link. With regards to the capital market line and separation theorem, I'll put it on the list for the next few months!
I must be missing something here. You say EBIT is Before taxes, then when calculating FCF you say Ebit minus taxes. Which taxes if Ebit is without taxes!?
such an awesome video thank you so much for that, i have a question though, regarding the sensitivity analysis, you only used the Exit multiples and not the PGM as well, would you please explain that a little bit more.
Thanks for watching! The book used the exit multiple whereas you could also use the long-term growth rate (ie.PGM), all depends on what variables you choose to select in excel. The actual process of building the sensitivity analysis is relatively simple and there are several videos covering the topic. Essentially what the model does is use Excel's what-if analysis to change variables in the model and see how that impacts the final projection. I didn't spend too much time on that because I am not a fan of the common inputs of the sensitivity analysis. Here's the problem, consider a hypothetical scenario where I am a client and I wanted to review your valuation using only the sensitivity analysis. Would looking at inputs like WACC, beta, cost of equity, and the long-term growth rate tell me anything about the actual performance of the business and what the business needs to produce in order to support such a valuation? Would I be able to understand how you view that business performing? If you watch another one of my videos called "Why is my DCF model incorrect?" you will see that one of the common flaws in any analysis is the sensitivity analysis. Usually, the numbers presented don't make any sense to the buyer using this information because they haven't spent hours looking at the model. Considering performance drivers that actually influence FCF and thus the value of the business is much more relevant for me as an outsider. This means looking at changes in profit margin, cost structure, capex, etc. The focus should be on above the FCF line in order to understand how the analyst projected FCF. The moment you focus on WACC and things after FCF projection, there are dozens of assumptions that I would need to understand before really appreciating the value of such an analysis.
Thank you. It was very helpful lecture. As you said making your own projections take a lot of time and therefore it is sometimes better to use other's estimations. But can anyone provide me with reliable sources where I can find consensus research estimates and equity research reports?