Trending Content
+242 | My chaotic IB journey | 27 | 8h | |
+211 | MS M&A vs GS HC | 48 | 16h | |
+176 | Ending My Life if I don't get an SA 2025 Offer | 63 | 1d | |
+115 | Anyone live in a different country before? What’s it like? | 43 | 19h | |
+74 | Hazing in the Bullpen. What to do? | 15 | 10h | |
+53 | MD shoved food down my throat. Is this normal? | 16 | 22h | |
+41 | Improving in TMT | 14 | 2m | |
+35 | Basically necessary to be a varsity athlete to get BB IB from Bowdoin? | 22 | 1d | |
+35 | Later Chodes - I'm Taking My Talents to The Mega Fund Leagues | 10 | 18m | |
+19 | Too late to be Analyst 1 with 5 years of experience? | 16 | 2d |
Career Resources
send that shit to india!
Enlighten us newbies - what are precedents and historical comps?
Seriously I love staffing Mumbai.
I love CapIQ...ever since I switched to PE...no more comps by hand. most bankers make you read through the financials for adj. = painful.
I think this thread is about to really piss me off!
But by all means, keep the comments and answers coming.
That was fucking hillarious. Thanks for the good laugh.
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)
Oh, god CapitalIQ is one of the best inventions out there, along with TheMarkets.com. I love it.
FactSet bitches =FDSC(.....
i need an intern
Yeah, luckily I don't do much of this stuff directly anymore. Got used to fighting for a special taskforce of interns.
yea capiq is sick
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.
Got the email..."hold off on the comps"
Gonna be BALLIN tonight.
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.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...