Preparation for 2 hour LBO modelling test

Hi all

Invited to an AC for a boutique advisory focusing on aerospace and defense (in London). Told that i will be doing a 'simple' 2 hour modelling test on Excel that is likely to be either an LBO or Merger Analysis test. Have only ever done DCFs on Excel before and even though i know the theory behind LBOs and/or Merger Analysis, I have never done one starting from a clean sheet. Any ideas on how complex a 'simple' 2-hour test can be expected to be?

I have some material from my school on creating an LBO but it is quite convoluted. Any advice on what/how I should focus my preparation?

Many thanks. BTW, I have 9 days.

9 Comments
 
"TKZ123" Hi all

Invited to an AC for a boutique advisory focusing on aerospace and defense (in London). Told that i will be doing a 'simple' 2 hour modelling test on Excel that is likely to be either an LBO or Merger Analysis test. Have only ever done DCFs on Excel before and even though i know the theory behind LBOs and/or Merger Analysis, I have never done one starting from a clean sheet. Any ideas on how complex a 'simple' 2-hour test can be expected to be?

I have some material from my school on creating an LBO but it is quite convoluted. Any advice on what/how I should focus my preparation?

Many thanks. BTW, I have 9 days.

Bump

 

Quia perspiciatis alias voluptates maiores ut autem. Sint aspernatur ut blanditiis non quibusdam. Ut dolor ut totam in iure voluptas.

Career Advancement Opportunities

November 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

November 2026 Investment Banking

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

Professional Growth Opportunities

November 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

November 2026 Investment Banking

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