PE Modeling Tests: Formats, Timing, and How to Prepare

The PE modeling test is where many processes are decided. You get a prompt, a laptop or desktop, and a clock. The output is an LBO that hangs together: sources and uses, operating case, debt schedule, exit, returns, and usually a couple of sensitivities. This guide is the deep prep map for banking analysts and advanced undergrads who want to know what "good" looks like under time.

Common formats

On-cycle processes skew shorter and more templated. Off-cycle can be longer and more open-ended. Always read the prompt like a legal document.

What "done" means

You are done when:

1. Sources = uses
2. Debt rolls without absurd ending balances
3. Interest and FCF are coherent
4. Exit equity, MoIC, and IRR calculate
5. At least one sensitivity they care about works
6. A stranger can audit assumptions in under two minutes

Pretty charts are optional. A wrong IRR with blue headers still fails.

Suggested tab layout under time

Mechanics that eat the clock

Cash sweep / optional prepay

Excess cash after minimum cash and mandatory amort often prepays the revolver first, then senior term debt per the credit agreement order. If you ignore the sweep, ending debt stays too high and returns look worse than the case intends (or better, if you accidentally double count cash).

Interest circularity

Interest depends on debt; debt depends on cash; cash depends on interest. In a timed test, use a simple toggle or iterative calculation carefully. Hardcoding interest to "make it finish" is obvious in review.

Fees

Transaction fees and financing fees show up in uses. Financing fees may be amortized for book purposes in fuller tests. If the prompt is silent, keep it simple and label the assumption.

Rollover equity

Management rollover reduces the sponsor check and changes ownership percentages. Returns may be shown for the sponsor only. Clarify whose MoIC you are quoting.

Error checklist before submit

Timed strategy

If you are not close to a working IRR at the 60% mark, simplify the ops case. A complete simple model beats a half-built complex one.

Weak vs strong test habits

How this ties to interviews

Modeling tests and "walk me through an LBO" are the same content. If you can build it, you can narrate it. If you can only narrate it, the test will expose you. Paper LBOs are the bridge: same returns spine without Excel.

Multi-week prep plan

Week 1: one basic LBO daily untimed from a template.
Week 2: blank-sheet basic LBO three times; add sweep.
Week 3: timed 90-minute tests; review error log after each.
Week 4: mixed prompts (rollover, PIK, flat vs compressed exit); full mock under fatigue.

Keep an error log. The same five mistakes usually repeat until you write them on a sticky note beside the keyboard.

Practice on SheetRank

Use graded LBO cases to verify your economics against an answer key, then recreate the case blank with a timer. Apollo-style deals are built for that loop: correctness first, then speed.