The LBO modeling test

What the test looks like

Formats vary by fund size. Mega funds and many upper mid-market funds run a two to three hour Excel test from a short prompt or a real information memorandum. Smaller funds often use a sixty minute simplified build, and some replace it entirely with a paper LBO at the desk.

In every version the deliverable is the same: a working model that produces sponsor returns from stated assumptions, and a view on whether the deal is worth doing. The verbal walk-through of an LBO is the same sequence without the workbook. If you cannot say the five steps out loud, you will lose time hunting for structure inside Excel.

The 3-hour LBO modeling test format

Treat three hours as six blocks of thirty minutes. The first block is assumptions and sources and uses only. Do not open an operating tab until the equity check is locked. The last block is reserved for returns, a one-paragraph recommendation, and a quick sensitivity. Candidates who skip that reservation spend the last twenty minutes formatting and hand in a model with no IRR.

The table below is a default clock. If the prompt is a full CIM rather than a one-pager, steal fifteen minutes from the operating case, not from the debt schedule or the returns page.

What to put in each thirty-minute block

Block one is where most good tests are won. Write entry multiple, leverage, growth, margin, exit multiple, hold period, tax rate, and any fee in a single block. Then build enterprise value, debt, sponsor equity, and fees. If the equity check is wrong, every later number is theatre.

Blocks two and three are the operating case and the debt schedule. Keep the operating case simple unless the prompt asks for product-level detail. Reviewers do not reward a twelve-line revenue build that delays the sweep. The debt schedule is the section they check after returns. Interest on a sensible balance, mandatory amortisation if given, and a cash sweep that actually reduces principal are the three tells.

Blocks four through six are the tie, the exit, and the story. A model that does not balance can still pass if the cash plug is labelled and the returns are internally consistent. A model that balances and has no recommendation looks unfinished. Write one paragraph: the thesis in a sentence, the price you would pay, the return you underwrite, and what would make you walk away.

How it is scored

Reviewers open the returns page first, then trace backwards. If MOIC and IRR are plausible, they check the debt schedule, then sources and uses, then the operating case.

• Does the balance sheet or the cash flow tie, and does debt actually pay down.
• Is interest computed on a sensible balance rather than a hardcoded figure.
• Are assumptions visible in one place and clearly labelled.
• Is there a short written recommendation, even one paragraph, rather than numbers alone.

Where the clock is lost

Almost every failed test is a time management failure rather than a knowledge failure.

• Over-engineering the operating case before the debt schedule exists.
• Formatting and colour coding during the build instead of at the end.
• Circular reference errors from interest on average balances with no iterative calculation enabled.
• Leaving no time for the returns summary, which is the first thing the reviewer reads.

Practising under real time pressure

The only way to fix a timing problem is to practice against a clock. The free Paper LBO Challenge runs ten and fifteen minute modes over the same structural checkpoints, and grades each one so you can see exactly where the minutes went.

Once the mechanics are automatic, the full Super Simulator extends the exercise into a connected deal across sourcing, diligence, valuation, value creation, and exit.