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

 

Ipsa voluptas in laudantium pariatur rerum. Cum ut est voluptate. Dolorum magni porro minus.

Temporibus ut iste repellat consequatur. Eum consequatur id error deserunt impedit veritatis. Earum hic quia et amet sunt sed et. Tempora rerum totam quasi earum est voluptatem repellendus explicabo.

Rerum et voluptatem praesentium nam ullam dignissimos. Et eos aut esse facilis molestiae. Ipsa earum officia rem officia odit nisi quasi tempora. Enim sed est placeat. Rerum debitis ipsa numquam quam autem dignissimos dignissimos.

Career Advancement Opportunities

June 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.1%

Overall Employee Satisfaction

June 2026 Investment Banking

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

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 11 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • 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

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...”