IB duties for Intern - more modeling or pitchbooks?

How does an IB intern generally spend his time? Do they do actual modeling? Or is it more Powerpoint stuff such as pitchbooks? Just trying to figure out what banks might have their interns doing in general, and what it is interns might do if they have to work from home this summer.

 

London BBs, my experience + friends = 40% research, 40% ppt, 20% basic stuff in excel.

 

Newsrun Company, sector, industry research PIBs Relevant peers for the company and explanation

etc

 

This split is accurate. Lots of time spent digging through Google for ANY information at all on private companies, or for publics you're looking for projections, production numbers, supply chain, etc. Also industry-specific research platforms. Similarly, time combing through 10Q/K and earnings calls.

Intern WFH is not logistically hard (would recommend you get a comfortable desk/chair and maybe a monitor) but much of what is learned is just from passively being there/watching FTs. I think the intern program will be much less intense if online.

 

This is the most applicable in my experience. Crap interns will never really reach excel (if you don’t touch excel your entire summer it’s quite a red-flag), decent interns will do basic excel tasks and comps, and top interns would properly touch models and do more interesting stuff. I think that it depends on the bank as well (ie are you doing rotations or not?), but this should more or less apply.

 

From my internship experience: 60% PPT, 40% Excel

PPT Segment:
1. 60% pitches
2. 40% CIMs / management presentations

Excel Segment:
1. 45% building buyer buckets / tier lists
2. 30% spreading comps / precedent transactions
3. 15% miscellaneous
4. 10% touching the model

My two cents as an intern (so take it with a grain of salt): an analyst will only let you work on a model if they think you can do the job well. That being said, you can build the reputation of a reliable, hardworking intern by nailing down all the other tasks, such as making slides or spreading comps. As long as you're making your analysts' lives easier and show that you have a high capacity for learning and work, they may be more inclined to letting you take a stab at the model.

Also, the deal process (I'm just going to assume M&A) can take anywhere from several months to years. Even if you're a modeling rockstar, it's going to be hard for the team to refer back to your inputs / assumptions when you're done with your internship by mid-August. Personally, my analyst asked me halfway through the summer to build out an initial three-statement for a new client and work on a small section of another existing model. But I never got to see what happened to either of them after I left for school.

Hope this helps!

 

Yep, very thorough and helpful... thanks a bunch!

Quick question -- in the months leading up to internship, what would you say would be the best use of my time regarding preparation -- learning Powerpoint in general, or a specific skill that might help me with what you referred to as "pitches?"

Thanks!

 
Most Helpful

Sure thing. Sometimes, the client has an existing relationship with your MD. Other times, your bank needs to pitch to new clients and persuade them 1) why it's a good time to sell their business (e.g. lower middle market business owner wants to retire and cash out) and 2) why they should choose your bank to work with (e.g. your bank has experience doing deals in the space and large network of potential buyers).

M&I Pitch Examples: www.mergersandinquisitions(dot)com/investment-banking-pitch-books/

This is a good starting point if you ever want to practice putting the financial model / valuation of your favorite stock into a pitch. Although the examples are pretty bare-bones, you'll find that most banks follow a similar structure with their pitches.

M&I PPT Shortcuts Setup: www.youtube(dot)com/watch?v=tnJ1e2xJmFc&list=PL5hdd9oiuWS8LWdrxu5k4P0K2…

The best way to brush up your PPT skills is just practice. Set up your Quick Access Toolbar for functions that you expect to use a lot. Insert shape, insert text box, align, text color / size, fill color. Try to replicate an existing pitchbook or your own template from scratch. What font, size, RGB, layout, line spacing and margin would be most presentable to a potential client?

Do this enough times, and you'll find several things: 1) you will make slides faster, 2) you will catch mistakes more easily (misalignment, spelling, color) and 3) when you join your bank, you'll be able to learn their style preferences more quickly.

Good luck!

 

would interns at EBs chime in? were u given more modeling work than ur friends at BBs?

 

Here's how my summer at a BB product group went back in the day:

  • Started off 100% PowerPoint, staffed on pitchbooks, formatting Excel outputs, pulling comps from Bloomberg etc

  • Staffed on deals with analyst mentors, first in a passive/observer role. Asked to do research, market updates, etc – PowerPoint

  • CCd on an email where VP asked analyst to adjust the model for some minor shit (new commodity price forecast or sm), analyst was busy with other stuff so took initiative and implemented well

  • From then on my summer slowly shifted from 100% PowerPoint to pretty 50/50, and at times 100% Excel. Was staffed on one easy deal (refinancing) with just VP and Analyst, the analyst dipped for a week to Europe, so VP had me run with the model updates. Went well, got props

  • Staffed on a big acquisition 2/3rds through the summer with different analyst. She let me run with it as long as I was proactive with making sure I don't fuck up. Went well, presented model outputs in internal meetings – but not with heads of desk/division (big $$$ deal) because they didn't want to let people know an intern did the model lol, but who cares still got creds within the grou

All that is to say if you take initiative you model. If you don't you'll be stuck updating tombstones like some of the other interns, who didn't get a return.

Since I was in a product group we didn't touch the operating model much, but would be responsible for the financing/post-transaction tabs. Think LevFin.

 

Thanks so much and that was super helpful! Was wondering if you have any tips for incoming summers in terms of brushing up on technicals / excel modelling before the internship? Also wondering if you have any advice on 'not fucking things up?'

 

I don't think there's a need to study stuff before the summer. When you hit the desk the assumption will be you know nothing, and in all likelihood you do know nothing when it comes to the product or industry-specific modeling. I guess knowing your accounting helps, but don't overdo it – nobody cares if you can recite how to debit DTLs

Pay attention during the real training sessions your analysts/associates will hopefully hos once you hit the desk (the one week with everyone is pretty useless – I spent most of it on instagram bullshitting with otherinterns and raiding the Bloomberg pantry) and be comfortable with basic Excel (shortcuts, how to troubleshoot, efficiency).

The advice people give on this board is pretty good when it comes to how to not fuck up. Double check your work, print out your slides for a final check with pen in hand, don't make the same mistake twice, don't ask stupid questions ("how do I build this Factset formula"), do ask smart questions that prevent you from spinning your wheels ("our consultant has x revenue forecast, while the client claims y, which would you like me to use? happy to build in both"). Expectations are incredibly low at the beginning of the summer, it's the basic stuff that'll get you the interesting work.

 

For cap markets:

Running tickets (30-40%), sitting in calls and taking notes / providing initial research for the call (20-30% - involving macro research, comps research, sector research, bbg graphs etc) general project work (eg research, chart formation, econometric stuff) (30%) faff (0-10%). Depending on the staffer, also had a lot of ppt to go over eg pitchbooks and general presentations.

M&A

Boutique: Loads of research (sector, comps, geography, products) (40-50%) deck building (20-30%) for me i attended 2 client meetings and also assisted on the model so depends.

BB: Research, VDR bitch, Landscaping, deck building, note taking, general bitch (ie setting up calls, running copies/bindings etc)

 

Quas similique repellat necessitatibus et harum hic. Et eum possimus dignissimos. Reprehenderit odio maiores soluta. Sed qui ipsa vero ullam molestias culpa. Quod ea eveniet quae perferendis aut sed. Nam numquam ullam et provident.

Voluptas eius aut error sunt laboriosam voluptatem et saepe. Ullam nemo suscipit dolor molestiae sit. Modi expedita quibusdam praesentium sed enim. Dicta sapiente sapiente aut nihil dolores.

Eos quia dignissimos rerum totam et suscipit ducimus et. Dicta quasi qui sed aspernatur alias laborum alias eum.

Est veniam voluptatem est ad tenetur. Ab commodi accusantium tenetur et. Laborum consectetur earum autem nihil quae. Qui voluptatem debitis explicabo necessitatibus unde temporibus corporis. Dolorum odit ea autem vitae ut. Aspernatur consequatur omnis qui in.

 

Id eos deserunt tempore molestiae autem explicabo. Debitis id voluptatem velit quod at sint minima. Dolorem tenetur atque qui est officia aut ratione. Voluptatum et cupiditate et. Ratione et aut dolores dolores est enim esse in. Iure nulla consectetur sunt omnis est.

Voluptas culpa non minima pariatur sunt nihil. Eligendi maiores quisquam ut omnis blanditiis sunt. Cum consequatur nobis accusantium fugit. Repudiandae quos libero aut sed.

Voluptatem eos velit totam quae. Sit dignissimos voluptas eius. Accusamus accusantium voluptas ab. Voluptatem nam commodi ut ducimus rerum asperiores. Odio provident eum in. Suscipit dolor qui eveniet excepturi eum laborum quibusdam molestiae. Omnis minima cumque eligendi similique rerum eaque id.

Tempore inventore qui assumenda tempora hic nostrum. Sint odit non sapiente. Ullam id non veniam quo et sequi. Illum consequatur enim enim. Fugiat velit in est cum.

What concert costs 45 cents? 50 Cent feat. Nickelback.

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 (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $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
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
kanon's picture
kanon
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
bolo up's picture
bolo up
98.8
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...”