12 Hours Till Deadline: The All Nighter, Part 1

Mod Note (Andy): #TBT Throwback Thursday - this was originally posted on 8/23/12. You can read part 2 here.

Since I’ve been writing for WSO, my most popular posts have been about banking experiences. The All Nighter is perhaps one of the most quintessential experiences of investment banking. While I agree with bankerella in that you can assuage some of the pain of working through an all-nighter with attitude adjustments generally involving ‘sucking it up,’ for most of us, there’s something about that very raw blend of stress and fatigue that just won’t go quietly. And so every year, generations of junior investment bankers – some of the most elaborate whiners on the planet – pass on their legendary tales of brutal nights spent at the office. Relive the horror of yesteryear (or yesterday).

7:45 pm

Not a bad Wednesday night. You got in a little late, you had a productive day finishing up a heavy turn on a massive Strategic Alternatives deck for a client. You sent the last draft to your VP a moment ago, and he responded immediately that he’d look at the turn tomorrow. We’re in great shape, the meeting isn’t till next Monday and we’ve got the rest of this week to turn through the document with the MD on the pitch. You’re further comforted by the fact that he’s already seen one draft. You decide to stick around for another hour or so to catch up on some personal stuff and snag a free cab ride to dinner on the LES.

8:48 pm

You’re cheerfully doing a little tidying up before you leave to head out to dinner with the girl you’ve just started seeing, when you hear a familiar beep.

Your skin crawls a bit, but you immediately shake it off – probably a stupid firmwide market update, or one of your idiot college friends who mistakenly looped in your work email on a long chain.

8:49 pm

Nope.

It’s not a firmwide blast.

It’s not a fantasy football league invitation.

It’s a message from your VP.

And the subject line says Fire Drill.

...
.....
.......

10:01 pm

The last hour has been a blur – a frantic flurry of emails zipping around. Tuesday’s pitch was moved up to tomorrow morning, since the CEO and CFO of the company you’re pitching will be in New York for another meeting and it’s more convenient to meet them then, in your offices. Plus, this way, your MD can go on vacation a few days earlier. Makes sense for everyone, right?

Well, not really. But still, it wouldn’t be so bad if there weren’t a few new developments…


From: Jon Vepee
To: Aaron Burr
Time: Tue 8/21/2012 8:48 PM
Subject: Fire Drill

Aaron, pls see below. Fire drill. Bluestar mgmt coming in tmrw morning, need to update deck asap. I will send comments on last draft soon, but pls start working on below Embdee requests. Need to add sections to book. Call me w questions. Thx

----------------------------------------------------------------

From: Joe Embdee
To: Jon Veepee
Time: Tue 8/21/2012 7:45 PM
Subject: Fw: Fw: Bluestar materials

Pitch moved to tomorrow. Need to incl IPO scenario – co is optimistic about public option. Pls also add loan/pik bonds financing scenario to LBO analysis. Co also sent me new model attached. Pls update projections, add following analyses and send me latest deck. Thx

----------------------------------------------------------------

From: Frank Bluestar, CEO
To: Joe Embdee
Time: Tue 8/21/2012 4:45 PM
Subject: Fw: Bluestar materials

Joe, good catching up over the phone today. Glad you can accommodate our schedule and do the meeting in NY tomorrow. Attached are our latest projections. We’re looking forward to hearing your thoughts. While we’re not that jazzed at the thought of being a public company, you’re right in that it probably makes sense to at least look at the analysis.

10:45 pm

After spending five minutes wavering between extreme self-pity and pure, unadulterated hatred for your MD and VP, who were kind enough to give you a minus-4 hour heads-up regarding the impending fire drill, you opened the attachment containing the company’s new model. It’s likely that every number in the deck will now have to change.

The attachment was in pdf. That was the first bad sign. For some god-awful reason, the good folks at Bluestar decided that sending the bankers the Excel model was just too easy. Adding insult to injury, the attachment was a secured pdf, which meant you could not copy-paste any of the numbers. So you spent about an hour typing everything in, then the next hour tying all the numbers up to avoid rounding errors and fixing typos. This is what you went to college for.

Time to start building in new model functionality into your model.

11:30 pm

Your VP sends his markup on the draft you sent earlier in the evening. He’s a thorough guy, and he usually checks most of the numbers, so you’re happy to read that most of his changes thus far are formatting-related.

The only problem is, you’ve just loaded new projections into the model – and all of the numbers are about to change. You kick yourself for forgetting to remind the VP to hold off on looking at any numbers-related pages (basically, the whole deck).

You email him back, letting him know you’ve started on building in a proper IPO analysis and reminding him that due to the new projection set, most of the forward numbers will be changing.

12:20 am

Excel crashes while you’re saving, and you lose 20 minutes of work. You scream horrible obscenities. The cleaning lady scurries to the other side of the floor.

12:25 am


From: Jon Vepee
To: Aaron Burr
Time: Wed 8/22/2012 12:25 AM
Subject: Timing

How’s it coming - ETA? Embdee emailing me


You consider responding something along the lines of “how the fuck do you think it’s coming” – but decide against it and opt for the no-respond. Now that it’s past midnight, suddenly everyone above the analyst level is laser-focused on timing and efficiency. Funny how that works.

1:05 am

After cranking through the additional analysis, you send the latest draft to your VP. You feel so-so about it. Obviously, you didn’t have time to check any of the numbers, and nobody gave you any real guidance regarding assumptions for the new scenarios, so you just went with what you thought was reasonable. You always bitch about being relegated to processing and never being asked to provide your own input, and now that you’ve been forced to come up with your own assumptions on the fly, you realize it’s not as fun as you’d imagined.

Starving, you dial up some Seamless and wait for your VP to respond. You’re 4 Red Bulls deep and this night’s just getting started.



To be continued...


Aaron Burr is a retired investment banking analyst and currently works as an associate at a private equity fund. He has pulled way too many all nighters – share your horror stories in the comments section or send them to [email protected]

 

Would just like to let you know that there are some programs that will allow you to pull data from PDF into excel. Formatting isn't in issue as you can align rows and columns before the conversion is done. The name of the program I use is called "PDF to Excel." Completely free and very effective. Could have had you home at 5am instead of 6am, good luck and hang tight.

 
ThatGuyBalls:
Would just like to let you know that there are some programs that will allow you to pull data from PDF into excel. Formatting isn't in issue as you can align rows and columns before the conversion is done. The name of the program I use is called "PDF to Excel." Completely free and very effective. Could have had you home at 5am instead of 6am, good luck and hang tight.

givin that banks are like droppin their bloombergs and gettin shiny new factsets and other such mickey mouse moves, really dont see too many places shelling out the big bucks for specialized soft-ware...

plus i would be willing to bet most if not all of my bananas that none of these progs are 100% accurate so you're just generating more work for yourself

the name of the game is...BRUTE FORCE

 
Going Concern:
ThatGuyBalls:
Would just like to let you know that there are some programs that will allow you to pull data from PDF into excel. Formatting isn't in issue as you can align rows and columns before the conversion is done. The name of the program I use is called "PDF to Excel." Completely free and very effective. Could have had you home at 5am instead of 6am, good luck and hang tight.

givin that banks are like droppin their bloombergs and gettin shiny new factsets and other such mickey mouse moves, really dont see too many places shelling out the big bucks for specialized soft-ware...

plus i would be willing to bet most if not all of my bananas that none of these progs are 100% accurate so you're just generating more work for yourself

the name of the game is...BRUTE FORCE

As mentioned above the software is free. I am an SA at small boutique and have used it effectively without any error (dealing with some extremeky spotty documents). I am all about brute force, but I also like to work smart, not hard whenever possible.

 

I love the part about finally getting the chance to make your own assumptions -- first time I was left to do this it was some scary stuff. 3 MD's were waiting on me to do a model, were all traveling and my associate was too busy to even look at it. I should add it was compounded by the fact that all the company's financials were real crappy and in an Asian currency too.

You just do the best you can, make the model as easy to change around as possible and wait for revisions haha.

"If you want to succeed in this life, you need to understand that duty comes before rights and that responsibility precedes opportunity."
 

I knew reading this was bad luck - literally just got a fire drill e-mail 5 minutes ago....

"If you want to succeed in this life, you need to understand that duty comes before rights and that responsibility precedes opportunity."
 
<span class=keyword_link><a href=/resources/skills/finance/going-concern>Going Concern</a></span>:
TheBigBambino:
I knew reading this was bad luck - literally just got a fire drill e-mail 5 minutes ago....

hahahahahaha

if you want to succeed in this life, you need to understand that duty comes before rights and that responsibility precedes opportunity

Or as they say where I work..."No good deed goes unpunished."

"Now go get your f'n shinebox!"
 
TheBigBambino:
I knew reading this was bad luck - literally just got a fire drill e-mail 5 minutes ago....

Hah, there are fire drills in VC land? Don't believe it.

Ace all your PE interview questions with the WSO Private Equity Prep Pack: http://www.wallstreetoasis.com/guide/private-equity-interview-prep-questions
 
Stringer Bell:
TheBigBambino:
I knew reading this was bad luck - literally just got a fire drill e-mail 5 minutes ago....

Hah, there are fire drills in VC land? Don't believe it.

Not usually. However we do an annual portfolio review and exit analysis for our LP's each year. This is coming up soon for my team. However at 6pm last night one of the larger LP's in our fund asked to have it two weeks early. If pulling public comps, precedent transactions, updated cap tables, financial models and creating finalized exit analysis scenarios for the next 4 years for 14 private portfolio companies by this morning isn't a fire drill I don't know what is. I finished up at 5:30 this morning.

The real kicker is I know the guys there won't even look at it until Monday...

"If you want to succeed in this life, you need to understand that duty comes before rights and that responsibility precedes opportunity."
 
TheBigBambino:
"If you want to succeed in this life, you need to understand that duty comes before rights and that responsibility precedes opportunity."

First signature quote that I liked! Not ridiculously arrogant like most of them.

-No comment-
 
Aaron Burr:

"While we’re not that jazzed at the thought of being a public company, you're right in that it probably makes sense to at least look at the analysis."

"Need to incl IPO scenario – co is optimistic about public option."

best part...

also excel crash and profanity. did you then smack keyboard hard enough to bust the little legs off it (maybe some keys) and then swap it out with shitty associate and/or shitty intern/first year analyst that peaced from office at 8?

these posts are awesome and so dead on.

 

Its it wrong for me to be erect? Great stuff so far. This is vaguely reminiscent of my IB student experience, except that my ass, as well as large sums of money aren't completely on the line. You just found yourself a new follower.

Benjamin A Gilman Scholar Economics & Finance, Mandarin Chinese & Japanese Small Business VP
 

Aspernatur ea facere dolor ullam deserunt mollitia nobis. Sit vero ipsam est quae voluptates rerum incidunt sit. Porro cum laboriosam ut dicta accusantium. Fugit sed ut accusamus porro sint in. Inventore aliquam in repellat tempora placeat nihil.

Magni rem totam aut id. Debitis saepe cumque aut ratione. Consequatur dolores itaque exercitationem vitae quo saepe.

Ut similique quos autem ullam molestias molestiae corporis. Quae explicabo voluptatem aut repellat adipisci. Delectus minima amet consequuntur quod et ea. Necessitatibus architecto voluptatum reprehenderit inventore vero.

 

Qui commodi ducimus illo quos ratione. Est enim atque quibusdam odit aut.

Quas sed laborum ratione voluptate. Est velit et ut sed ipsa sunt ipsa eum. Recusandae ipsam quia id illo ipsam non perferendis. Maxime sit molestias molestias dolorem. Ratione consequuntur autem non minima qui.

Magni qui voluptas aliquam sed voluptatum. Accusantium magnam aut autem sed qui iure nobis. Dolor porro vero vel laborum dolorum doloremque. Sapiente est dolorem quia aperiam. Ut ad vel sunt qui aliquid.

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.

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
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
numi's picture
numi
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...”