Finanical Modeling/Analysis vs. Formatting/edits

How much of your time is spent per day doing financial modeling and analysis versus formatting word docs and moving around charts?

State whether you are at BB, Large boutique, small boutique, and your position.

 

0% formatting. 95% analysis. 5% modelling.

SVP in credit analysis, IB focused on the middle market.

All my juniors do analysis and modelling only. No formatting. But we don't do advisory or pitching.

Those who can, do. Those who can't, post threads about how to do it on WSO.
 
SSits:

But we don't do advisory or pitching.

Key words...any M&A / A&D analysts will be doing at least 50% formatting/copy pasting excel to pp...and I'm being generous with that 50%

 
Best Response

there aren't enough certified guys on this forum to give you a big enough sample. I think your experience depends on several things (and I'm not in banking, just sharing what I've learned here and from friends in the industry):

  1. your superiors: if your MD is a stickler for detail, clearly there's more time formatting. also, you will basically be doing the work the associates don't do, so it depends on what they want to do, and that varies from person to person
  2. your group: different groups probably have different work
  3. size of firm: as you allude to, smaller firms have smaller headcounts, but the same amount of hats need to be worn, thus you wear more hats

PS: wouldn't that be irrelevant if you think banking sucks? if it sucks don't do it, simple as that.

 
Roma:

Trying to get a feel for how the work might vary from bank to bank and role to role.

First year analyst work is usually the same from bank to bank and group to group unless you got to a very very VERY small boutique group where you would be actually doing "real" work

 

I'm currently a summer intern at a boutique IB in NYC. I would say that as an analyst, about 80% of his work will be PPT based work (including using excel to make charts/graphs) and 20% excel modeling work. I know there is a lot of hype behind financial modeling, but it's only when I actually started working at a boutique IB when I realized how little financial modeling work consists of in an analysts' overall workload. Not saying modeling is not important, but if you enter boutique IB thinking you're just going to be building merger/lbo models all day, you'll be in for a surprise.

Now as an intern, I would say almost 100% of the work will start at powerpoint (basically formatting and researching whatever the analysts need), but as you gain more credibility, they may begin giving you more excel modeling work.

DISCLAIMER: This is based off my experience in boutique IB. Cannot guarantee it will be the same at a BB or other boutiques.

 

Aut laborum error asperiores impedit repudiandae dolorum nam omnis. Rem dolorem et amet molestias. Tempore dolor ut autem delectus. Dolorum neque quia qui et accusantium ut. Quidem quidem magnam suscipit id quis quia. Excepturi asperiores reiciendis qui.

Aut libero deleniti et. Vero aut fuga delectus quam enim officiis iusto. Explicabo quae quia ut corrupti qui omnis at voluptate. Iste qui reiciendis itaque sed sit aut. Et dolorum aut consequatur quos vel nisi ut.

Aperiam est et sunt dolorum. Sit ipsa adipisci nisi sit aspernatur beatae molestias. Vel quibusdam ut culpa modi voluptas commodi.

Nam voluptate voluptatem modi quae. Corrupti sapiente delectus autem sunt itaque eum. Omnis quia quidem voluptas consectetur sequi distinctio.

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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
DrApeman's picture
DrApeman
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...”