Best Response

When a PE, just for fun, says "give me the sales, EBITDA, EBIT, P/E multiples for 50 comparable companies over the past 10 years on a monthly basis". Of course they don't want multiples based on actual financials but broker forecasts which were published in the past. Objective being of course to spot the trends beyond 1 industry cycle.

We have databases for these figures but it's not just about downloading them. Ideally you want to readjust the crap output you get based on: - How long the results were published after they actually occured (ie sales for year ending 31 Dec will be published 3/4 months later, and the brokers publish their revised forecasts a few days after that) - Random significant mistakes the database makes (eg. multiplying buy 10 some EBITDA figures for no reason or forgetting data all together) - Exceptionals (eg a random one-off charge to a company) - The accounting standards (ie in Europe may not be able to compare numbers published in 2000 with those from 2005 if the company switched from UK GAAP to IFRS accounting standards) - When the company either made a large disposed or acquisition since brokers don't all reflect these changes at the same time in their publications

This probably doesn't mean anything if you haven't done it before.

Basically you end up with sometimes well over 50Mb of data (in several spreadsheets because excel can't cope with all of that at once) which you've readjusted in all sorts of ways based on some kind of dodgy logic. Fascinating stuff.

The output is a few graphs which don't mean much because the source data is incomplete (hey, not all comps were quoted and well covered by brokers over the last 10yrs) and inaccurate, and may not be used anyway.

I think this confused and longish response gives you a vague idea of how frustrating this shit is, and that I happen to have been through the process...

Bottom line answers a question that has been floating around on this forum: don't be the bitch (IB), be the master (PE)

 

FactSet is great, except when it's wrong. CapIQ is also great, except when it sucks. Unfortunately, no one has yet created a database that is the equal of an intelligent analyst scouring 10-Ks with a highlighter pen.

So sad. I got a stack of them a foot high on my desk.

 

Dolorem adipisci dolores eum sequi. Sunt animi mollitia neque sapiente. Nobis impedit in aliquid quasi dolores id.

Similique dolore non repellat suscipit similique autem. Qui enim eius eum.

Dolorum exercitationem aliquid esse quas ea. Veritatis quae consectetur nulla et ipsum. Est omnis voluptas quasi adipisci autem.

Omnis voluptas sapiente nesciunt alias omnis itaque. Pariatur itaque velit laborum earum veniam. Suscipit aliquam rerum maxime autem.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”