The Private Equity Modeling Test
What the PE modeling test actually is, where it sits in the process, the four formats you'll see, what graders check line by line, and how to prepare so you finish a clean build before the timer runs out.
The setup
What a PE modeling test is — and where it sits
A private equity modeling test is the round where a fund stops asking what you know and watches you build. You're handed a prompt — anything from a one-page fact set to a full data pack — and asked to produce a working LBO (and sometimes a full three-statement model) that gets to a return. It exists because talking fluently about deals and actually constructing a model that ties are different skills, and the fund is buying the second one.
In a typical buyout process it comes after the first-round technicals and before the final case discussion. The verbal round screens intuition; the modeling test is where most candidates are actually made or broken; the case discussion then pressure-tests whether you understand the model you just built rather than having pattern-matched your way through it.
- 01
First-round technicals
A verbal screen of accounting, valuation, and LBO intuition — often including a paper LBO you talk through out loud. This gates who gets to the modeling stage.
- 02
The modeling test
Either an in-office timed build (commonly ~1 hour from a one-page prompt) or a take-home case over one to three days. This is the round that most often decides the outcome.
- 03
Case discussion
You walk an interviewer through your model and defend the assumptions — would you do the deal, at what price, with how much leverage, and where does the return come from.
Know the format
The four common formats
Which one you get tracks loosely with fund size and how much time the team has. Know the time target and what the grader is checking before you sit down — the biggest mistakes are format mistakes, not finance mistakes.
Paper LBO
No Excel — mental math on paper or a whiteboard.
Graders check
- ›Clean EV → debt → equity structure
- ›Debt paydown from free cash flow
- ›MOIC, then IRR by rule of thumb
The screen. Common at smaller and middle-market funds and as a first-round filter almost everywhere.
1-hour timed LBO
A one-page prompt; build a working LBO in Excel against a timer.
Graders check
- ›Sources & uses that balances (fees in uses)
- ›Debt schedule with interest and a cash sweep
- ›Sane returns and a layout the grader can follow
The workhorse test — standard at many middle-market and upper-middle-market funds.
2–3 hour full model
Three statements linked to a debt schedule and a returns build, from a richer prompt.
Graders check
- ›Income statement, balance sheet, and cash flow that tie
- ›Circularity handled (interest ↔ cash) without breaking
- ›Returns driven off actual ending balances
More common in larger upper-middle-market and megafund processes.
Take-home case + deck
A prompt plus data; deliver a model and a short deck or investment write-up.
Graders check
- ›Defensible assumptions, not just a working model
- ›A clear recommendation with sensitivities
- ›Presentation quality — the deck is graded too
Weighted toward judgment; often used alongside or instead of a live build.
How to prepare
Reps beat videos
The single fastest way to close the gap is doing full, graded builds — repeatedly. Watching a walkthrough teaches you what a finished model looks like; it does not teach your hands to produce one from a blank sheet with the clock running. Those are different skills, and only the second one is tested.
A useful loop: build a complete LBO end to end, time it, check the answer against a key, write down exactly what broke, then rebuild with different numbers until the sequence is automatic. Ten timed reps will do more for you than ten hours of video. The goal is to reach the point where sources & uses, the debt schedule, and the returns build feel like muscle memory — so your scarce test-day attention goes to judgment, not to remembering which row comes next.
Common failure modes
EV vs. equity value confusion
Measuring returns off enterprise value instead of the sponsor's equity check — or dividing exit equity by the wrong base. MOIC is exit equity over the equity actually invested (fees included), not over EV or the purchase price.
Forgetting fees in uses
Transaction and financing fees are real cash out the door and belong in total uses. Leave them out and you understate the equity check and overstate returns — one of the first things a grader checks.
Sign errors in the debt schedule
A paydown entered as a positive, interest with the wrong sign, or a sweep that adds to debt instead of reducing it. These quietly corrupt the ending balance the returns are built on, so the whole answer drifts.
Running out of time on formatting
Over-polishing early sections and never reaching the returns is the classic timed-test failure. Get a rough, correct, end-to-end model first; make it pretty only if time remains. An unfinished model can't be graded on returns.
The structure
A one-hour LBO, section by section
This is the shape of the workhorse timed test — the sections and the order to build them in, not a full spreadsheet. Build top to bottom so each block feeds the next, and get a rough, correct version of all five before polishing any one of them.
- 01
Sources & uses
Uses: purchase EV + fees. Sources: debt raised + sponsor equity (plug).
Start here because everything downstream depends on the equity check. Total the uses, fix the debt quantum from the leverage assumption, and let sponsor equity fall out as the balancing plug so sources equal uses.
- 02
EBITDA bridge
Entry EBITDA → annual growth → exit EBITDA, plus margin if given.
A short operating build projecting EBITDA across the hold. Keep it simple unless the prompt asks for a full revenue-to-EBITDA build; the grader wants a defensible trajectory, not a ten-driver forecast.
- 03
Debt schedule
Opening balance → mandatory amortization → cash sweep → interest → closing balance.
The engine of the LBO. Each year, reduce debt by mandatory amort plus the free-cash-flow sweep, accrue interest on the balance, and carry the closing balance forward. Watch the signs and confirm the balance can't go negative.
- 04
Exit
Exit EBITDA × exit multiple = exit EV; less net debt = exit equity.
Apply the exit multiple (default to the entry multiple unless told otherwise) to get exit EV, then subtract the ending debt from the schedule to reach the equity available to the sponsor.
- 05
Returns
MOIC = exit equity ÷ sponsor equity; IRR from MOIC and the hold.
Divide exit equity by the sponsor's invested equity for MOIC, then annualize to IRR. Sanity-check against the band interviewers expect (~2.0–3.0x and ~15–25% over five years); numbers far outside it usually signal an upstream error.
Want the numbers?
For a fully worked version with dollars — a balanced sources & uses, capitalized fees, a swept debt balance, and the MOIC/IRR that falls out — see the LBO modeling test example. For the mental-math warm-up that the paper-LBO screen is built on, see the paper LBO example.
FAQ
PE modeling test questions
How hard is a private equity modeling test?
The hard part is rarely the finance — it's doing correct work quickly under a clock. The concepts (sources & uses, a debt schedule, exit equity, MOIC/IRR) are learnable in a weekend. What separates candidates is speed and cleanliness: building a balanced model in 45–60 minutes without sign errors, broken links, or a layout the grader can't follow. Candidates who have done a dozen full graded builds find it manageable; candidates relying on having watched walkthroughs usually run out of time.
How long is a PE modeling test?
It depends on the format. A paper LBO is 5–15 minutes of mental math with no Excel. An in-office timed LBO from a one-page prompt is typically about 60 minutes and is standard at many middle-market and upper-middle-market funds. A full three-statement build with a debt schedule and returns runs 2–3 hours. A take-home case can be given over 24–72 hours and usually includes a short deck or write-up on top of the model.
What do PE firms look for in a modeling test?
Correct mechanics first: a sources & uses that balances, fees included in uses, right treatment of interest and cash sweep, a debt schedule that ties, and returns that make sense. Then judgment: are your assumptions defensible and are your returns in a sane band rather than a fantasy 40% IRR? Then presentation: clean layout, labeled rows, no hardcodes buried in formulas, and the ability to explain any cell. Graders reward a slightly less ambitious model that is correct and readable over an elaborate one that breaks.
How do I practice for an LBO modeling test?
Do full graded builds repeatedly — reps beat videos. Watching someone else model teaches you what a finished model looks like, not how to produce one under pressure. Build a complete LBO from a blank sheet, time yourself, check your answer against a key, note what broke, and do it again with different numbers. Prova's modeling-test drills run this loop: you fill in a full-model grid, it grades line-by-line, and the inputs regenerate each attempt so you can't memorize the answer.
What is the difference between a paper LBO and a modeling test?
A paper LBO is a fee-free mental-math exercise: purchase price, one slug of debt, cash flow to paydown, exit, returns — done in your head in a few minutes. A modeling test is the fuller build the interviewer watches you do in Excel: a real sources & uses with capitalized fees, sponsor equity as the balancing plug, a debt schedule with interest and a cash sweep, and returns driven off the actual ending balances. The paper LBO tests intuition; the modeling test tests whether you can build.
Do all PE firms give modeling tests?
Most buyout funds test modeling in some form, but the depth varies with fund size. Smaller and middle-market funds lean on a paper LBO or a roughly one-hour timed build. Larger upper-middle-market and megafund processes more often include a longer in-office model or a take-home case with a deck. Some growth-equity and minority-investment processes weight the qualitative case and market work more heavily and keep the modeling lighter. Assume you'll be tested and prepare for the timed one-hour build as the baseline.
Practice the way you'll be tested
Prova's modeling tests now run as a fill-in-the-full-model tabular grid, graded line by line — a balanced sources & uses, a debt schedule, and returns, with fresh numbers every attempt. Build it under a timer instead of watching someone else build it.
Free download
The Finance Interview Modeling Cheat Sheet
Every formula and mental-math shortcut you need for the interview — paper LBO, DCF, accretion/dilution, comps, returns attribution, and the three-statement links — on one page. Drop your email and it's yours.
No spam — just the cheat sheet and the occasional interview-prep tip. Unsubscribe anytime.