How to do Comps Valuation like a Banker

[@RandageJr]

I can see Rosenbaum & Pearl influenced this video. Great content!

[@PeakFrameworks]

Gotta learn from the best!

[@kanwalsingh4154]

Great video. I hope you can also do a video on small (main street) business so we as investors can assess how the local business are doing in the markets. Thanks for posting it -really liked it!

[@Wacc1611]

Personal advice : become a voice artist you'll definitely rock!!!!! People have no idea how much money they can actually save via youtube... Thanks buddy.....

[@karimtawbeh8793]

This was a great video. Nice one 👍🏼

[@John-thinks]

Good general format though, think that's a very common general approach to showing comps

[@hopskops222]

Short and sweet! Very helpful, thank you!

[@jyoung5256]

Straight out of rosenbaum & pearl lmao; love it. It’s great using templates on the job

[@justincheung1454]

Thanks for the walkthrough!

[@veljkopetkovic5256]

Great video. I was wondering, when you press Ctrl 1 to format a cell. How do you so quickly move around the menu using your keyboard?

[@PeakFrameworks]

Years of practice and memorizing different alt codes. You can also toggle different option / menus by pressing the underlined letter in the window pane.

[@ambergray957]

Where did the (-8.5 B) come from in the equation to get the implied value?

[@johnnyies]

can you do an excel keystrokes video?

[@PeakFrameworks]

Oh good call! Yes.

[@1rasha]

from where you got these ebitda and revenue multiples? how are they calculated? not clear at all

[@ReptiliaOnFire]

Nice video, very useful!!

[@Anonymous-rp4hn]

Why are you using NTM and not LTM??

[@shahzebhyder1994]

Amazing can you do DCF and precedent transactions example as well thanks

[@PeakFrameworks]

We have a DCF video on our channel! kzbin.info/www/bejne/hYrChpx3ZqqEp80 Precedents video not in the pipeline, but mechanically very similar to comps.

[@merazmamun4261]

Do you have to calendarize your comparable companies and find the last 12 months figure for them? If so, how do you do it? I am a bit lost on those parts.

[@PeakFrameworks]

You don't have to do last twelve months for simple analyses, but you will have to on the job. You essentially have to go through the filings and type out what the company did each quarter, then sum it up. So you have to go through a company's last couple of 10-Q's.

[@merazmamun4261]

@@PeakFrameworks another question. Do you calendarize each company first, then find the last 12 months. For example, if I'm evaluating Chegg and its fiscal year ends January 31st, do I have to make other company's with different fiscal year endings have the same fiscal year ending as chegg. Then I can calculate the last twelve months figures for all comparables? Also, can I just pull out the last 12 months figure from sites like Yahoo Finance and Morningstar instead of calculating them? I want to be in equity research analysis, so I probably need to know the proper way to do comparable analysis.

[@marknovikov5732]

More videos like this!

[@KR-ln5qw]

Good stuff

[@chunng1181]

I have a question, whether tiktok is an app or a company. whether tiktok now in united states is an independent company or not. last question, if tiktok is an app, is it suitable to use comps to value an app?

[@PeakFrameworks]

TikTok is an app and is owned by ByteDance. I don't think TikTok ended up becoming independent in the U.S. Yes, you can use comps to value an app.

[@justenhoward8304]

Have you all released an Investment Banking course yet?

[@PeakFrameworks]

Probably on the calendar for 2022, this year our upcoming course is focused on university students and valuation.

[@JordaanFPS]

Great video, any HF lessons coming soon? (EB analysts trying to move to HF)

[@PeakFrameworks]

I never worked or interviewed for HF, so I'm a bit hesitant to post anything too specific. I can do general skills like screening for companies and this, etc., but hard to do anything too detailed.

[@tuslmusic7244]

Please explain how you were able to take the median and average of the valuation x multiples. My excel keeps giving errors!

[@PeakFrameworks]

You should be able to multiply directly. Make sure you convert the data to numbers, as it's exported in text. This fix is covered in the video.

[@tuslmusic7244]

@@PeakFrameworks oddly enough it is converted to numbers... weird

[@zakkhan6054]

at the end why did you use the median ebitda multiple and not the the avg?

[@PeakFrameworks]

Both would be perfectly reasonable. I like median more if there's a wide spread between multiples. I went with median here because it's a bit lower so I get a more conservative result.

[@merved2083]

Hi! Great content, appreciated it; THANKS! I have a question: While doing the valuation for a startup searching for a VC, do you think I should use market data, share price, etc. as you do in the video? Cause neither the startup nor its competitors/comps are private equity firms, thus they don't have any share prices yet. Do you think its competitors' valuations or investments would be enough as a metric?

[@PeakFrameworks]

As you said, you won't be able to imply a share price of a private company. You can still use a public comps table to approximate what the value of the private company will be though. E.g. you'll get an EBITDA multiple from the public comps and you apply that to the private company. This is the analysis IB analysts do when seeing what a private company can IPO at. Good question!

[@merved2083]

@@PeakFrameworks Thanks for your reply!

[@ernestuxpc]

Can we have access to the excel file please?

[@PeakFrameworks]

It's in our Valuation and Finance Starter Kit course, but not publicly available.

[@piec1]

are there any tools that you use for Canadian stocks

[@PeakFrameworks]

I use Atom Finance for Canadian stocks too! I don't invest as much in TSX companies maybe as I should though, mostly just do ETFs.

[@ryanlee2734]

why don't you include the P/E multiple

[@PeakFrameworks]

I didn't here because the P/E multiples for a lot of these companies were crazy high and these fast growing tech businesses don't always trade on P/E.

[@elontusk9123]

Why not use the revenue multiple?

[@PeakFrameworks]

It seemed a bit too aggressive for the valuation. Estimated ~$50B of TikTok revenue in 2021 and a 6-7x revenue multiple = ~$300B+ EV, which is is more than all of ByteDance was rumored to be valued. I think a lot of growth tech is valued off of EV / Revenue, so definitely good to be aware of what it is.

[@John-thinks]

You are using the wrong green

[@Daily_Conversations]

A week pasted by, I am still waiting for new video , video about hedge fund :)

[@PeakFrameworks]

Unfortunately I'd say to not count on it, I haven't worked in the HF industry so there's nothing in the pipeline about them

[@PeakFrameworks]

Try Atom Finance premium for free to get analyst estimates and market data: imp.i223396.net/PeakFrameworks

[@Corpfinbro]

Please explain to me why you are dividing an equity value by revenue and ebitda. Equity value should only be divided by bottom line net income as it is after debt. On the other hand, Enterprise value should be divided by revenue & ebit or ebitda, as it is before debt in the cap structure.

[@PeakFrameworks]

I am not dividing equity value by revenue or EBITDA. EV stands for enterprise value.

[@TrashPanda.Garage]

atom finance is no longer useable by retail investors :(