LBO Model Test (20 mins)

Excel-based LBO modelling assessment for candidates building fast and effective LBO valuation skills. Particularly relevant for Private Equity analysts on Super Days. 

Background: This test focuses on bottom-up LBO fundamentals: construct a Sources and Uses table, project the target company’s cash flows, and calculate IRR and MOIC based on an assumed entry and exit. It develops the technical precision and execution speed expected in professional investment roles.

Time Limit: 20 minutes

Usage: Downloadable file. Test may be completed multiple times

What's Included:

• Excel modelling template with input sheets

• Automated validation and grading

• Worked solution model showing correct approach 

Key Skills:

• Sources and Uses tables

• Cashflows and debt waterfall

• Returns calculation (IRR and MOIC)

Users:

• Investment banking analysts

• Private equity candidates