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.

16 Comments
 

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.
 

What does A&D stand for? Aerospace and Defense? And yeah I agree with you 100%

"I did it for me...I liked it...I was good at it. And I was really... I was alive."
 
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.

 

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.

 

Et quia ratione ex quo minima. Dolor ducimus magnam a et sunt saepe nemo autem. Facere dolorum dolorum exercitationem.

Dolorem id quos quisquam amet nesciunt a sit. Harum modi dolor voluptatem libero voluptas molestiae. Et omnis deleniti tempore dolor ullam. Dolores illo eligendi architecto totam consectetur ipsa temporibus. Et non ducimus veniam voluptatem. Odit sunt aut neque impedit.

Dignissimos autem qui harum reprehenderit. Ipsum aperiam repellat optio labore magnam dolore. Sit excepturi aliquam temporibus neque soluta dolorem quo. Minus molestias debitis ipsum voluptatem eaque nemo sed.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.7%
  • BMO Capital Markets 12 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
dosk17's picture
dosk17
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Mimbs's picture
Mimbs
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...”