The joys of earnings season

Ah, earnings season. Thereâ€s nothing like it.

Earnings season is the two-week period when, one after another, all the companies youâ€ve been assigned to cover announce their quarterly results, slamming you with extra work and causing no end of trouble with the summary sheets. Itâ€s a delightful experience, let me tell you.

This time, thereâ€s a new associate in the office... and heâ€s been assigned to scrub half my comps. Now, comps are a fairly ad hoc business in this group – theyâ€re frequently not scrubbed, not correct, or just not updated at all. (Of course, weâ€re shining bastions of accuracy compared to the groupâ€s London analysts. A few months ago, when I requested four of the comps theyâ€re supposed to cover, the comps they sent ranged from eleven months old to three years old.)

Well, Iâ€ve rarely been asked by a scrubber to actually turn in comps and backup, and even when I do, no one has actually ever scrubbed a comp of mine in the normal course of business. (I am not kidding.) Unfortunately, the new associate now has to prove himself, and that means lots of extra work for both of us. Expecting the comps to be gone over with a fine-toothed comb, I took extra care to make everything flawless, fill out all the extraneous data (beta, dividend yield, the full range of options, and so forth), and highlight/sticky flag the hard copy backup. I did the whole nine yards. I penciled in notes to show which charges I put in the “unusual” line. I labeled everything neatly, stapled and stacked them, and saved everything in two separate locations.

Letâ€s be honest, folks – comps are not exactly rocket science. You can only do them so well… and thatâ€s how well I did them. So when I dropped by his desk today to see how he was getting along, I was shocked to see him staring at my comps and making a long list of notes.

“Where did you get the template for this one,” he asked.

Huh? What has that got to do with anything? “I didnâ€t build the comps from scratch; I updated the ones that were already in use.”

“Hmm. Well, itâ€s completely different. Look at it.”

I looked. I saw nothing unusual. “Whatâ€s wrong?”

“Whatâ€s wrong is that all the fonts are different – the formatting is completely different.”

Little pause here while I try to figure out whatâ€s going on. Fonts are meaningless in a comp because only the data gets pulled. What the hell? “Okay,” I say. “No problem. Would you like me to change the fonts and formatting to match all the other comps?”

“Itâ€s not just that. See, this tab is named something different.”

“Yes, I see. Okay.”

“So if someone has a model pulling from this comp and the tab is named something different then it wonâ€t pull.”

“… Right. Well, Iâ€ve never seen anyone use something other than the individual cell names when it comes to comps. But itâ€s no big deal; would you like me to change the name of the tab?”

“I would prefer if you just went back and used the standard format.” Heâ€s getting testy now.

Longer pause here. “Okay, no problem. Just give me an example of the format you want to use and Iâ€ll go cell-by-cell to make sure I make all the changes.”

He leans forward and slows down his speech. “I want you to use the firm standard format. The one that all the other comps use.”

All the other comps? Jesus… what fantasy land is this guy living in? “Um, there are a lot of different formats. If youâ€ll look in the folder youâ€ll see all sorts of weird stuff – comps that pull from ticker sheets, comps that pull from industry summary sheets, comps that source data from FactSet, comps that pull from IDD, which we donâ€t have access to any longer, manual comps, comps with different firm names on them. The firm standard comp template that you can download is a year and a half old and it doesnâ€t work with any of the summary sheets or models that we use these days. So Iâ€ll be happy to reformat this comp in any way you want. Just let me know.”

He shakes his head angrily. Then he pulls up some other comps and checks them out. Then he scowls even more angrily. He doesn't like what he sees. “Iâ€ll have to get back to you on this.”

Hah. “Sure, no problem. Just let me know if you have any more—“

“In the meantime, I want you to go back and pull all the currency conversion data yourself.”

“… Sure, no problem. But the currency data on our standard comp pulls automatically – the numbers are very trustworthy – and if I hard-code that cell, then people who are using it wonâ€t know to update the conversion rates when they—“

“Then add a note to the individual cells.”

Of course, nobody checks the notes in the cells before using a comp, so these comps are going to be working off old conversion rates. But you know, Iâ€ve learned that this kind of talk is rarely welcome with associates. The guy was slightly wrong about something in front of me, he feels bad because of it, and he's got to deliver a little poke to restore the natural order of things -- to assert that he's there to guide me and fix my mistakes. Thereâ€s nothing left to say. “Sure," I say. "No problem. Iâ€ll take care of that now.”

Now, that brings me to the first four phrases an analyst should learn:

Got a minute? (Never just walk into someoneâ€s cube and start talking. You gotta be big before you can get away with that. “Got a minute?” gives them an out; it means they can say no. And frequently they will.)

Sure, no problem. (Even if youâ€re about to say something that means “Thatâ€s not a good idea,” or “I canâ€t do that until tomorrow.” Rule 1 of salesmanship and analysthood: always say yes before you say anything that sounds even vaguely like no.)

Iâ€ll take care of that right now. (In other words: I acknowledge the importance of both you and your project. This is especially nice for associates to hear, because it means that at least SOMEone is listening and responding.)

Would you like me to…. (Print and bind you a special color copy just for proofing? Use color-coded highlighters and sticky flags? Hand-carry it to your summer home in Bridgehampton at 10 PM on a Saturday night? Gift-wrap it with handmade washi paper and a dupioni silk bow? Whatever it is, no matter how off the wall the service you are offering, they WOULD like you to do it, of course. All you can do is hope they remember that extra effort at bonus time.)

 
Best Response

Yes, hi, I'm looking at your comps right now...yeaaah...would you mind aligning the decimals on the input page? Thanks. And, also, could you see if you could find the historic earnings estimates going back to, say, 1997? Oh, the database only goes back to 98? That's okay, we can still do that, thanks. Also, one other thing, in case they want to take a look at gross profit multiples, can you go through the line items for each company and make sure they account for gross profit the same way, and make pro forma adjustments to your spreads...we want to look at this apples-to-apples, you know. Thanks. Don't forget to footnote that stuff. Also, I've gone ahead and classified each company into one of four buckets...can you show the medians for each bucket, and the composite? I know the prospect only operates in that one segment, but it can't hurt to look at other segments in case they start pursuing a diversification strategy. We'll get started on the market map tomorrow. It's best to just cover all our bases. Oh hey listen, FYI, I've got to run out to dinner, but just give me a call if you've got any questions. Let's plan to circle up with the pitch team first thing in the morning to go through this stuff again.

You'll be taking care of that right now? Thanks.

Once more into the breach, dear friends.
 

Indeed, you're giving me flashbacks. You and I apparently work for the same associate.

Especially the buckets. Oh, the freaking buckets. First two. Then three. Now means and medians for both. Move this guy from bucket A to bucket B. Take these three guys and make them into a fourth. Now combine buckets one and three. Oh, wait, nevermind, the MD doesn't want buckets. Can we just start again from version 37?

 
ibkarmino:
bet you are.

and bankerella, wouldn't it be nice that your associate is reading your post as well? hehe.

Highly unlikely. Said associate sounds more like the type that will be killing time by trying to get into aSmallWorld :)

____________________________________________________________ "LIVING THE DREAM 24/7 ON http://THEALLNIGHTER.BLOGSPOT.COM" ____________________________________________________________
 

Oh indeed, when I was an Analyst, in my first year I worked with a sociopath first year Associate that we dubbed Bucket Brigade from time to time. Why? Because he was completely incapable of creating a comp set without at least 3 buckets, to "triangulate" valuation--a term he used so frequently and with such glassy-eyed zeal that we were absolutely convinced he whispered it in his wife's ear during intimate moments. And after creating the buckets, then, THEN! Then take the median. Then the average. Then subtract the highest and lowest values and take the median and average. Then change the floors and ceilings on the "NA" multiples 20,000 times. The change the "NA" to "n.m.," because THAT'S going to win us the deal. Then the footnotes...jesus the footnotes. The TEXT function is proof there is a God and He is merciful, as far as I'm concerned.

Okay, I've got to stop this flashback before I get a nosebleed.

Once more into the breach, dear friends.
 

Well, I do admit I've been known to get into the alignment of decimal points and font. That's important stuff! At my worst I scrutinize spacing between paragraphs, full justifications and L/R, Top/Bottom margins... but I don't bring out the ruler to measure these as a crazy old boss used to do!! He was weird.

 

Guys, I'm talking about the comp inputs themselves, not the comp summary sheets. Of course all decimals must be aligned and all fonts consistent on output pages. Comp input pages usually look like hell, though. Indeed was initially referring to input pages.

 

You learn to be hyper critical with these things. They sound superficial, but it's not just summary sheets and presentations... it's the attention to detail throughout, e.g. footnotes, citations etc. When you're staring at models all day, it's straining on the eyes and it's easy to overlook details.

Last week on a QC of a model, we caught a mistake in a stub period calculation, as well as a mistake in how we were linking to a line item. Sounds like minor stuff, nothing to sweat over, but in reality these mistakes in tandem have an impact. I make these mistakes, as does everyeone else. No one is perfect.

That's why it's important to always have a separate set of eyes on a deliverable... or even WIP for that matter. Usually I'll have a junior person do a read through and general QC...

 

Qui est maxime sunt quas sit rem sunt. Sint laboriosam incidunt officiis enim.

Career Advancement Opportunities

April 2024 Investment Banking

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

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
CompBanker's picture
CompBanker
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.8
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...”