Comparable Company Analysis Excel Walkthrough | Valuation Multiples

[@KenjiExplains]

📝 Learn Finance & Valuation using code EARLYFINANCE for $50 OFF: www.careerprinciples.com/courses/finance-valuation-course

[@Artisticgirl2811]

Hi Kenji

[@Ashen4]

how do you get the x's next to the multiples to automatically appear

[@Hugo_Serie]

Click on Home/Number Format/ More Format. Then select Custom in the Number section and type 0.00"x" Here you go

[@keenanachziger4330]

One of the two best IB prep channels on YT. Eternally grateful for your content 🙌🏼

[@darislavdikov7573]

What is the other one called?

[@keenanachziger4330]

@@darislavdikov7573 “High Finance Graduate” is also pretty thorough.

[@darislavdikov7573]

@@keenanachziger4330 thank you

[@gauravkothari5417]

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......

[@KenjiExplains]

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.

[@TuanLe-pf4oz]

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.

[@mr.sophisticated.7951]

You are using Corporate Finance Institute (CFI) structure 😜. I'm a certified financial Modeler from there. I'm very well aware of these structures.😁😀

[@KenjiExplains]

Hey there! I’m using the industry standard structure…not sure what you mean by the cfi structure??

[@isaacobomhese4325]

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.

[@tushargarg9118]

Why didn't you include enjoy lemon in median high ?

[@abcdef1064]

Hi Kenji, thank you so much for your videos! They are one of the most helpful ones and you can explain things very well!

[@KenjiExplains]

Thanks for the kind comment!

[@trader__AP]

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?

[@inviertehoy_]

Yes please a comparable company video on a real company

[@gebruwolde1762]

You have to slow why you read it like new

[@marsaetos9610]

Good examples, and explanation overall. Keep up the good job.

[@KenjiExplains]

Glad it was helpful!

[@samuelsuarez8304]

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

[@johnadjei2395]

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.

[@camlex6310]

Super helpful video as always Kenji!! You’re the best

[@KenjiExplains]

Hahah thank you!

[@grindmood8144]

Is it not more accurate to do the valuation using the EV/FCF multiple? (if the company generates fcf)

[@ranjansinghvlog6490]

Hi Kenzy. would love to watch comparable company analysis on real company. Looking forward to next video on CCM.

[@HUNTIN_P30PL3]

How did you get your cell O to show 7.3x instead of a dollar figure?

[@philippjansen6079]

Hi! I cannot download the file anymore. Could you reupload it?

[@ujanghartato5634]

Hi Kenji, I really appreciated for your useful videos, please keep it up. Make more awesome videos like this! From Indonesia.

[@songoku7897]

Please do comparable valuation on a real company

[@KenjiExplains]

Noted!

[@willzinner8813]

You explain it so simply thank you sir as always

[@KenjiExplains]

Thanks for watching!

[@ateghafuh2964]

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!

[@JoyceFecunda-xd8gk]

Great Video! Thanks for the explanation

[@lostant5354]

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.

[@elirosen]

Your correct, thats also what he is doing in the video.

[@i123456987654]

Ah, comps, price per square foot...real estate terms

[@Daniel-rn1de]

Hey Kenji. You and many KZbinr advertised for Financial Edge. But are those micro degrees actually something a recruiter would look at?

[@KenjiExplains]

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

[@gkollias14]

Great Video! just one question: is the shortcut alt+H+V+F correct? can't seem to work for me!

[@KenjiExplains]

hmmm..not sure why. Could it be that you're Excel is not in English or you're using a Mac keyboard?

[@prathameshpandit4705]

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.

[@stev6072]

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!

[@KenjiExplains]

Hey yeah I’ve got that noted! Hopefully in the coming months :)

[@Standbyualways]

Kenji San, Thank you for your details, pros/cons in concise matters. Keep up the good work!

[@Artisticgirl2811]

Please how can I get across to you

[@karimezzeddine2240]

Can you do a video on how to build a value chain?

[@bodgukalism3]

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!

[@markagbeko1204]

I have been interested in Financial modeling and valuation for well over a year now. Thanks for the great work

[@xueqinghan63]

Love your video! It really helps a lot❤.

[@colemanvan]

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?

[@heikotimberlake3029]

??? you didn't minus cash when you use Equity value to calculate EV.

[@KenjiExplains]

I used net debt which is Total Debt - Cash

[@heikotimberlake3029]

​@@KenjiExplains that is interesting. thanks

[@tristanontheway]

the video gets more difficult each time :( cant keep up

[@KenjiExplains]

Sorry about that!

[@michaelquach7046]

Solid coverage of the comparable companies analysis. Super excited about the valuation course!

[@KenjiExplains]

Thanks for the help!

[@zainabalghazaly628]

❤❤

[@bulbabulbasaur]

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!!!

[@KenjiExplains]

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 :)

[@bulbabulbasaur]

@@KenjiExplains I see I see! Thank you so much for your speedy reply🙌🏼

[@CFASDM]

I watch your videos more often. It is really helpful in implementing the theoretical knowledge into practice in a simpler way.thanks

[@KenjiExplains]

Great to hear! thanks for watching :)

[@alexmason9397]

Man the excel part didn't help me much when u already know everything

[@Sab23239]

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!

[@KenjiExplains]

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.

[@Sab23239]

@@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!

[@Artisticgirl2811]

Hi Kenji

[@vishnunalla1647]

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

[@KenjiExplains]

Hi Vishnu, really appreciate your comment! Best of luck with your career :)

[@sparkofjoy3191]

Thank you for your videos and for making them easy to understand!

[@KenjiExplains]

Glad you like them, more coming soon :)

[@alexandralyu836]

thanks for sharing

[@KareemAbdo555]

File please?

[@jessmaryse5648]

Thanks!

[@emadr5780]

Thank you very much. Could you please explain, why we add the net debt to the equity value?

[@keenanachziger4330]

Net debt(subtract cash, add liabilities) + equity value give you enterprise value(EV), a key component of indicators like EV/EBITDA

[@KenjiExplains]

To find the enterprise value you need to add debt because it's also part of the company.

[@emadr5780]

@@KenjiExplains why don't we subtract it?

[@australianpatriot]

@@emadr5780 don't question just do

[@emadr5780]

@@australianpatriot you mean there is no reason?

[@jarubootangsanakul387]

Thank you

[@markagbeko1204]

Great video

[@calvinbenson3663]

Do you have any coupons for your excel course?

[@KenjiExplains]

Hey you can get 10% off using code EMAIL10

[@calvinbenson3663]

@@KenjiExplains thank you so much 🙏

[@andreugiro2807]

Great content! Keep going Kenji!

[@KenjiExplains]

Cheers Andreu! XD

[@saurabhvedwal5206]

❤❤

[@glamapandacapital]

Good stuff

[@KenjiExplains]

Cheers!

[@TheHitessh]

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.