London MM IB Modeling Test (Analyst)

Hi,

I have an upcoming 3 statement + DCF modelling test/case study coming up for a London boutique analyst role. Does anyone have any experience in these and what the format looks like/whether we are expected to conduct sensitivity analysis via data tables etc.?

Any insights would be much appreciated.

Thanks

2 Comments
 

standard format at london mm/boutiques: 1-2 hours timed, they hand you an assumptions sheet and a blank or partially built excel, you build the 3 statements linked and a dcf on top. sometimes a quick lbo at the end if time allows.

the thing that kills people isn't the concepts, it's speed and hygiene. practice building from a blank sheet under a clock. know the dcf cold - unlevered fcf, wacc, terminal value both ways (exit multiple and gordon) - and be ready to defend every assumption out loud after. they always ask you to walk through it.

don't hardcode anything, they check the formulas. and keep formatting clean - half the grade is whether an associate could pick your model up and use it.

Past IB & PE interview questions - ledgershelf.com
 

Minima iste recusandae nihil qui. Qui exercitationem necessitatibus facilis animi ab ab. Fugiat et non vitae a quidem aut.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 07 97.9%
  • Goldman Sachs 02 97.4%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 12 97.4%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (56) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
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...”