Thank you Kenji for your videos! I am very interesting in financial modelling a valuation since two years ago and your videos have helped a lot to remember some concepts and methods in a easy way
Hi Kenji, please do the comparable valuation for a real company. Thanks for this one. Also, I've heard about Country premiums in comparable companies where the comps are beyond one economic environment. Can you also throw some light on that? Thanks Kenji.
Thank you for such simple explanations and also telling us what was simplified and why. Also please make a comparable company analysis and other models for real companies.
Thank you for this video. But please I wanted to ask, if you were doing a price to book ratio, how would the comparables differ in terms of the later part where there is net debt, implieed enterprise value, etc.? basically the enjoy lemon valuation section.
Hey Kenji. Great Video. What can we do if the peer companies are out of region? For Example Company 1 (UK - Figures in GBP) Company 2 - 5 (US - Figures in USD). How can we deal with the issue of currency exchange?
Hey kengi i think you did a mistake at while calculating P/E Ratio @ 5:59 P/E formula is is (CMP OF A SHARE/EPS). Hope you find this comment useful and if I was wrong please correct me......
Hey there I don't think so...the price per share / earnings per share is the same thing as the market capitalisation / the net income. It's just at different scales (one relative, the other absolute), but the result is the same.
First comment 😊 I really want to take a moment and say THANK YOU SO MUCH for your effort and your time All of your videos have helped me to learn all models in excel. God bless you Kenji
Hi Kenji. I have downloaded some of your Excel Files and I wish to use them for and educational purpose. Based on the Note, I need your permission to go ahead with this. Actually, I will do some modifications on the file to be able to have it meet the purpose. Thank you and I really enjoy your videos, they are quite explicit!
Hi Kenji, thank you for your explanation it is very clear! I have one question about the multiples calculations. When calculating the multiples did you use historical financial data or forecasted data? Thank you!
Thank you! Typically you'd have one year of historical data, and 2 more years of forecasted data. For this example though, we didn't consider the years as the figures were just made up for simplicity.
@@KenjiExplains Thank you for your answer! Sorry but I have a follow up question. Is there a website or resource available which expands on the simplification made in this video? Thank you again!
Thank you for the video, it is very helpful. However, in order to calculate the implied enterprise value in EV/EBITDA, shouldn’t the median be multiplied with the EBITDA instead of the Revenue? I’m a little bit confused in this part.
Hello Kenji! I have a quick questions with the companies’ financial data(Revenue, EBITDA, Net Inocme) you pulled, can it be data for a single quarter? Or does it have to be full fiscal year numbers? And thank you so much for making these videos! They are SUPER helpful!!!
Yeah you can do this on a quarterly basis as well! Just make sure it's consistent (everything as quarters or everything as years) Thank you for watching my videos :)
Hey there, I think it’s more the actual learning that’s valuable and can get you the right skills a recruiter might look for…not so much the certificate
I think you have made some mistakes in implied enterprise value calculation. The was a huge gap between ratio of EV/Revenue, EV/EBITDA, which actually results a big gap in enterprise value as well. However, your calculation is not that.
This guy is not for beginers. He is too fast and not understandable at all. Please provide a disclaimer about the pre-requisites before you dive deep in to the valuation.
Hi Kenji, when I getting the Market Data, I found that it will be hard to collect the data, ESR 1821.HK, SF REIT 2191.HK, CML REIT 1503.HK, Link REIT 0823.HK, Mapletree Investment Trust MIT.SG & Goodman Group GMG.AU, as you can see, 4 company from HK, 1 from SG and 1 from AU. It is very hard to collect the market data, do you have a resource to collect data via a single resources and trustable? and use same currency?
📝 Learn Finance & Valuation using code EARLYFINANCE for $50 OFF: www.careerprinciples.com/courses/finance-valuation-course
Hi Kenji
One of the two best IB prep channels on YT. Eternally grateful for your content 🙌🏼
What is the other one called?
@@darislavdikov7573 “High Finance Graduate” is also pretty thorough.
@@keenanachziger4330 thank you
You explain it so simply thank you sir as always
Thanks for watching!
Hi Kenji, thank you so much for your videos! They are one of the most helpful ones and you can explain things very well!
Thanks for the kind comment!
Thank you Kenji for your videos! I am very interesting in financial modelling a valuation since two years ago and your videos have helped a lot to remember some concepts and methods in a easy way
Super helpful video as always Kenji!! You’re the best
Hahah thank you!
I watch your videos more often. It is really helpful in implementing the theoretical knowledge into practice in a simpler way.thanks
Great to hear! thanks for watching :)
Hi Kenji, please do the comparable valuation for a real company. Thanks for this one.
Also, I've heard about Country premiums in comparable companies where the comps are beyond one economic environment. Can you also throw some light on that? Thanks Kenji.
I have been interested in Financial modeling and valuation for well over a year now. Thanks for the great work
Hi Kenji, I really appreciated for your useful videos, please keep it up. Make more awesome videos like this! From Indonesia.
Love you Kenji. Would love to see a real comparable analysis if you have the time and energy. Thank you very much. Keep up the hard work!
Thank you for such simple explanations and also telling us what was simplified and why. Also please make a comparable company analysis and other models for real companies.
Solid coverage of the comparable companies analysis. Super excited about the valuation course!
Thanks for the help!
Kenji San, Thank you for your details, pros/cons in concise matters. Keep up the good work!
Good examples, and explanation overall. Keep up the good job.
Glad it was helpful!
Thank you for this video. But please I wanted to ask, if you were doing a price to book ratio, how would the comparables differ in terms of the later part where there is net debt, implieed enterprise value, etc.? basically the enjoy lemon valuation section.
Hey Kenji. Great Video. What can we do if the peer companies are out of region? For Example Company 1 (UK - Figures in GBP) Company 2 - 5 (US - Figures in USD). How can we deal with the issue of currency exchange?
Hey kengi i think you did a mistake at while calculating P/E Ratio @ 5:59 P/E formula is is (CMP OF A SHARE/EPS). Hope you find this comment useful and if I was wrong please correct me......
Hey there I don't think so...the price per share / earnings per share is the same thing as the market capitalisation / the net income. It's just at different scales (one relative, the other absolute), but the result is the same.
Thank you for your videos and for making them easy to understand!
Glad you like them, more coming soon :)
how do you get the x's next to the multiples to automatically appear
Click on Home/Number Format/ More Format.
Then select Custom in the Number section and type 0.00"x"
Here you go
Great Video! Thanks for the explanation
First comment 😊
I really want to take a moment and say THANK YOU SO MUCH for your effort and your time
All of your videos have helped me to learn all models in excel.
God bless you Kenji
Hi Vishnu, really appreciate your comment! Best of luck with your career :)
Great content! Keep going Kenji!
Cheers Andreu! XD
Hi Kenzy. would love to watch comparable company analysis on real company. Looking forward to next video on CCM.
Hi Kenji, thank you for your videos!
Could you do a video show "How to do a stock pitching as a professional?"
Thank you again! Have a nice day Kenji!
Hey yeah I’ve got that noted! Hopefully in the coming months :)
Hi Kenji. I have downloaded some of your Excel Files and I wish to use them for and educational purpose. Based on the Note, I need your permission to go ahead with this. Actually, I will do some modifications on the file to be able to have it meet the purpose.
Thank you and I really enjoy your videos, they are quite explicit!
Yes please a comparable company video on a real company
Love your video! It really helps a lot❤.
Hi Kenji, thank you for your explanation it is very clear! I have one question about the multiples calculations. When calculating the multiples did you use historical financial data or forecasted data? Thank you!
Thank you! Typically you'd have one year of historical data, and 2 more years of forecasted data. For this example though, we didn't consider the years as the figures were just made up for simplicity.
@@KenjiExplains Thank you for your answer! Sorry but I have a follow up question. Is there a website or resource available which expands on the simplification made in this video? Thank you again!
Can you do a video on how to build a value chain?
Why didn't you include enjoy lemon in median high ?
Thank you for the video, it is very helpful. However, in order to calculate the implied enterprise value in EV/EBITDA, shouldn’t the median be multiplied with the EBITDA instead of the Revenue? I’m a little bit confused in this part.
Your correct, thats also what he is doing in the video.
Thanks!
Hello Kenji! I have a quick questions with the companies’ financial data(Revenue, EBITDA, Net Inocme) you pulled, can it be data for a single quarter? Or does it have to be full fiscal year numbers? And thank you so much for making these videos! They are SUPER helpful!!!
Yeah you can do this on a quarterly basis as well! Just make sure it's consistent (everything as quarters or everything as years) Thank you for watching my videos :)
@@KenjiExplains I see I see! Thank you so much for your speedy reply🙌🏼
Hey Kenji.
You and many UA-camr advertised for Financial Edge. But are those micro degrees actually something a recruiter would look at?
Hey there, I think it’s more the actual learning that’s valuable and can get you the right skills a recruiter might look for…not so much the certificate
Is it not more accurate to do the valuation using the EV/FCF multiple? (if the company generates fcf)
Great video
Thank you very much. Could you please explain, why we add the net debt to the equity value?
Net debt(subtract cash, add liabilities) + equity value give you enterprise value(EV), a key component of indicators like EV/EBITDA
To find the enterprise value you need to add debt because it's also part of the company.
@@KenjiExplains why don't we subtract it?
@@emadr5780 don't question just do
@@australianpatriot you mean there is no reason?
thanks for sharing
How did you get your cell O to show 7.3x instead of a dollar figure?
Thank you
You are using Corporate Finance Institute (CFI) structure 😜. I'm a certified financial Modeler from there. I'm very well aware of these structures.😁😀
Hey there! I’m using the industry standard structure…not sure what you mean by the cfi structure??
Great Video! just one question: is the shortcut alt+H+V+F correct? can't seem to work for me!
hmmm..not sure why. Could it be that you're Excel is not in English or you're using a Mac keyboard?
Hi! I cannot download the file anymore. Could you reupload it?
Please how can I get across to you
Do you have any coupons for your excel course?
Hey you can get 10% off using code EMAIL10
@@KenjiExplains thank you so much 🙏
Good stuff
Cheers!
Hi Kenji
File please?
Please do comparable valuation on a real company
Noted!
❤❤
??? you didn't minus cash when you use Equity value to calculate EV.
I used net debt which is Total Debt - Cash
@@KenjiExplains that is interesting. thanks
You have to slow why you read it like new
I think you have made some mistakes in implied enterprise value calculation. The was a huge gap between ratio of EV/Revenue, EV/EBITDA, which actually results a big gap in enterprise value as well. However, your calculation is not that.
Ah, comps, price per square foot...real estate terms
the video gets more difficult each time :( cant keep up
Sorry about that!
This guy is not for beginers. He is too fast and not understandable at all. Please provide a disclaimer about the pre-requisites before you dive deep in to the valuation.
Man the excel part didn't help me much when u already know everything
Hi Kenji, when I getting the Market Data, I found that it will be hard to collect the data, ESR 1821.HK, SF REIT 2191.HK, CML REIT 1503.HK, Link REIT 0823.HK, Mapletree Investment Trust MIT.SG & Goodman Group GMG.AU, as you can see, 4 company from HK, 1 from SG and 1 from AU. It is very hard to collect the market data, do you have a resource to collect data via a single resources and trustable? and use same currency?
❤❤