LBO Modeling Test: The No-Fluff Guide to Passing

The lbo modeling test is the part of private equity recruiting most candidates underestimate until they're staring at a blank Excel sheet with a ticking clock. By the time you're sitting for one, the firm assumes you understand leverage, debt, and exit math. The test exists to see whether you can execute under pressure and produce a clean, auditable model in 60 to 90 minutes. If you're still building the technical foundation underneath this, our finance interview prep guide covers the wider arc.

Knowing how the model works is not the same as building one cold in front of a partner. The candidates who pass aren't the ones who memorized the most concepts. They're the ones whose Sources & Uses takes three minutes instead of fifteen and who don't panic when the balance sheet doesn't tie on the first pass. This guide walks through what graders actually score, the moves that have to be automatic, and the assumptions interviewers will probe in the follow-up. For the path that lands most candidates in this seat, our breakdown of how to get into investment banking maps the route.

What the LBO modeling test actually is

It's a timed, hands-on case where you build a leveraged buyout model from scratch (or from a skeleton template) in 60 to 90 minutes, usually in a later round of a private equity interview. The prompt gives you a target company, assumptions, and a deal structure. You produce a working model that calculates sponsor returns (IRR and MOIC), plus a short writeup or verbal walkthrough on whether you'd do the deal.

Format varies by firm. A paper LBO is the earliest screen: pen, paper, five to ten minutes, no Excel. A basic lbo model test runs 30 to 45 minutes with simplified assumptions. The standard 90-minute lbo test is the most common version at middle-market and upper-middle-market firms. Mega-funds sometimes push to three or four hours with a full prompt packet. The mechanics are the same; the difference is how much detail you're expected to add.

What's being graded isn't whether you can describe an LBO. It's whether you can build one without breaking it. Most candidates Google this test after they get the invite, only to realize the free walkthroughs don't prep them for the speed required.

What graders actually care about

Interviewers grade four things, in roughly this order of weight: structural correctness, instruction-following, modeling hygiene, and commercial insight. A clean, simple, correct model beats an overbuilt, complex model with errors every time.

• Structural correctness. Sources and uses balance. Debt rolls forward properly. Free cash flow flows where it should. Exit equity reconciles to enterprise value minus net debt. If any of these break, the model is broken, and graders notice fast.
• Instruction-following. The prompt isn't a suggestion. If it says 50% cash sweep, you don't sweep 100%. If it specifies PIK on the mezzanine tranche, you accrete it. Candidates who freelance on instructions get marked down even when the math is right.
• Modeling hygiene. Inputs hardcoded in one place. Formulas consistent across rows. No mystery cells, no hidden values, no fudge factors. A grader should be able to audit your model by following the trail.
• Commercial insight. Can you explain whether this is a good deal? What's the return sensitive to? Where's the risk? Most candidates run out of time before they get here, which is exactly why the candidates who finish with five minutes to spare and a clean writeup stand out.

Build for the first two. Earn the third through reps. The fourth is where the offers get decided.

The core moves that have to be automatic

Five moves do most of the work. None of them are conceptually hard. All of them have to be fast.

Sources and uses in five minutes or less

The first thing you build, and the thing most candidates spend too long on. Uses include the purchase price (enterprise value), transaction fees, financing fees, and any refinanced debt. Sources include the new debt tranches (term loan A, term loan B, mezzanine, revolver), management rollover equity if applicable, and sponsor equity as the plug. Sources must equal uses to the dollar. If they don't, every downstream number is wrong.

The trick is that sponsor equity is the balancing figure. Build everything else first, then plug equity. Candidates who try to start with equity and work backward burn time and introduce errors. Hardcode the entry multiple, the EBITDA, and the leverage ratios. Let formulas do the rest.

A debt schedule that doesn't break the model

The debt schedule is where most LBO models fall apart. Each tranche needs an opening balance, mandatory amortization, optional prepayment (if the prompt allows a cash sweep), interest expense, and a closing balance. The closing balance of one period is the opening balance of the next. Interest is typically calculated on the average of opening and closing balances to avoid the worst of the circular reference problem.

Two things to lock down before you start typing formulas. First, decide whether interest is calculated on the average balance or the opening balance. Most prompts will tell you; if not, average is the cleaner choice and signals more sophistication. Second, build the cash sweep logic with a MIN function: the prepayment is the lesser of available cash and the outstanding balance. Without that, the model can prepay more than it owes, and graders will see it instantly.

Free cash flow without circular reference hell

Circular references are the silent killer of LBO models. They show up when interest expense feeds into net income, which feeds into cash flow, which feeds into the debt balance, which feeds back into interest expense. Excel handles them poorly, especially under time pressure when iterative calculations sometimes don't converge.

Two ways to avoid the trap. Calculate interest on opening balance instead of average. It slightly underestimates interest but removes the circularity entirely. Or use a circ breaker switch: a cell that toggles between zero and one, where zero zeros out the calculated interest temporarily. If you go with iterative calc, enable it before you start and set the iteration limit high. Whatever you do, don't fight the circ in the last fifteen minutes. Fix it once, early, and move on.

A clean IRR and MOIC at exit

Exit math is mechanical. Take exit-year EBITDA, multiply by the exit multiple to get enterprise value, subtract net debt at exit to get equity value, then run IRR on the equity cash flows. Sponsor equity invested at year zero is a negative; equity value at exit is a positive. MOIC is exit equity divided by entry equity.

The mistake to avoid: forgetting that the debt outstanding at exit reduces equity value. The deal generates returns through three levers (EBITDA growth, multiple expansion, and debt paydown), and the debt paydown only shows up in returns because exit debt is lower than entry debt. Wire it correctly and the math takes care of itself.

A short commercial writeup or verbal answer

If the prompt asks for a writeup, write three to five sentences. What's the base case IRR and MOIC? What's the deal sensitive to? What would you flag to the investment committee? This is where many candidates leave points on the table because they used the full 90 minutes on the model and left no time to think. Block off the final 10 minutes for the writeup before you start building.

The assumptions interviewers actually pressure-test

After you submit, the conversation moves to the model. Interviewers don't probe randomly. They press on the assumptions that drive returns most heavily, because they want to see whether you understand which inputs matter and which don't.

• Exit multiple. "Why did you exit at the same multiple as entry?" The cleanest answer is that entry multiple equals exit multiple is the conservative base case, and you'd want to sensitize for both multiple compression and expansion. Candidates who can't articulate why they chose their exit multiple get marked down.
• Leverage and capital structure. "Why this leverage level? Could you have used more debt?" The answer depends on the company's free cash flow coverage and the credit market context, but you should know roughly what the deal could support. Standard middle-market deals run 5x to 6x EBITDA total leverage; mega-fund deals can push higher.
• Cash sweep and debt paydown. "How much of the IRR comes from debt paydown versus operational improvement?" Have a number ready. If most of your IRR comes from debt paydown, the deal is leverage-driven, which is fine, but you should know it. If most comes from EBITDA growth, you should be ready to defend the growth assumption.
• EBITDA growth and margins. "How aggressive is your operating case?" Margin expansion from 20% to 25% over five years is at the edge of plausible for most industries. Anything more and you should have a specific operational thesis (cost takeout, pricing, mix shift) to back it.
• Sensitivities. "What's the IRR if exit multiple is 1.0x lower?" If you didn't build a sensitivity table, the answer is "I'd have to rebuild." If you did, the answer is a number you can quote. Building a two-axis sensitivity (exit multiple by EBITDA growth) in the final five minutes is one of the highest-leverage moves in the test.

The five mistakes graders see most often

These are the patterns that consistently cost candidates offers. None of them are conceptual. All of them are execution failures under time pressure.

1. Sources and uses don't balance. Off by a small amount, usually a fee that got missed or a transaction cost that got double-counted. Every downstream number is wrong. Graders catch this in thirty seconds.

2. The balance sheet doesn't tie. Assets don't equal liabilities plus equity at the end of year one (or year two, or year five). Almost always a sign that something in the cash flow statement isn't flowing correctly to retained earnings or the cash line.

3. Debt schedule prepays more than allowed. Cash sweep set to 100% when the prompt said 50%. Or prepayment isn't bounded by remaining balance, so debt goes negative. Both are instruction-following failures, which is the most heavily-weighted grading category.

4. Circular reference left unresolved. The model shows #REF! or zero in interest expense. The candidate noticed it, didn't know how to fix it, and submitted the model with the error visible.

5. IRR is calculated wrong. Usually because the sign convention is off (sponsor equity entered as positive instead of negative) or because the exit cash flow includes management equity that should have been excluded. The IRR number is the headline result. Getting it wrong is the worst possible thing to get wrong.

How to prep so the lbo modeling test is execution, not discovery

Most candidates prep by reading. YouTube walkthroughs, $400 paywalled courses, Wall Street Oasis threads. Recognizing the concepts isn't the same as building them. The test rewards muscle memory, and muscle memory only comes from reps.

Here's what a real practice cycle looks like.

• Build from scratch, ten times. No template, no notes.
• Add the timer. Run it again under a 90-minute clock.
• Vary the prompt. Change the cash sweep, swap the exit multiple, add a PIK tranche.
• Get it graded. Audit against the four things interviewers score: correctness, instructions, hygiene, commercial insight.

By the time you sit for the real test, your fingers should know where the Sources & Uses goes and how to wire the IRR without thinking. If your prep is mostly reading and watching, you're prepping for the wrong thing. The exercise isn't a knowledge check. It's an Excel speed check with commercial judgment on top. A mock lbo under a strict timer, with a clean prompt and an outside grader, exposes the gaps faster than any course can.

Stop reading about LBOs. Start building them with Cook'd AI.

Most candidates prep by watching. YouTube walkthroughs, $400 paywalled courses, Wall Street Oasis threads scrolled at 1am. Recognizing the concepts isn't the same as building them under a 90-minute clock. The test rewards muscle memory, and muscle memory only comes from reps against real prompts, graded against the four things interviewers actually score.

Cook'd AI runs the reps for you. Timed LBO prompts calibrated to the firm tier you're targeting, structured feedback on correctness, instruction-following, modeling hygiene, and commercial insight, and the kind of repetition that turns the Sources & Uses table into something your fingers build without thinking. Less time watching someone else model. More time becoming the candidate who finishes with five minutes to spare.

→ Try Cook'd AI free