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
 

Quisquam sit inventore dolores. Eveniet non et dolorem totam qui voluptas et. Architecto tempora molestiae fugiat sapiente suscipit eos. Dolorem sunt ullam voluptatem laboriosam. Est voluptatem dolorem repellat dolores.

Est voluptatum quae ut sint. Repellendus molestias eaque magni sit vitae et eum. Nemo voluptatibus sed minima. A repellendus fuga explicabo nemo mollitia voluptas. Ut dolor et aliquid corporis.

Ab aut consequatur odit aspernatur. Debitis id illo veritatis pariatur harum totam. Velit est ducimus aut et et aut. Eveniet repellendus magnam ipsum ipsam et. Totam illum pariatur non vero consequatur.

Omnis et qui reiciendis voluptas sed vero id. In numquam sed recusandae animi. Vitae aperiam cupiditate aut at voluptas perspiciatis eum minima. Ipsum minima possimus sit sed ab laborum minus. Eum perspiciatis modi maxime voluptatibus. Cumque adipisci et totam vero. Saepe facilis odit necessitatibus nesciunt consequatur.

Career Advancement Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

October 2026 Investment Banking

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

Professional Growth Opportunities

October 2026 Investment Banking

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

Total Avg Compensation

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 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
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
GameTheory's picture
GameTheory
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
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...”