LBO Modeling Test: A Full Build with Sources & Uses
A paper LBO lives in your head. A modeling test lives on the page — with a real sources & uses, capitalized fees, and a sponsor-equity plug. Here's the whole build, one clean example, start to finish.
Why this matters
Beyond the paper LBO
The paper LBO is the warm-up: purchase price, one slug of debt, cash flow to pay it down, exit, returns. A modeling test is what interviewers actually put in front of you when they want to see whether you can build, not just recite. The new muscle it exercises is the sources & uses — the funding schedule that has to balance.
Two things trip candidates up. First, transaction fees are a real use of cash, so they belong in total uses alongside the purchase price — not ignored. Second, sponsor equity isn't an input you guess; it's the plug that makes sources equal uses. Get those two right and the rest is the same entry-to-exit arithmetic as a paper LBO.
This guide walks one clean deal all the way through, then hands you a graded modeling-test drill that regenerates the numbers every attempt.
Worked example
One modeling test, start to finish
The inputs
- LTM EBITDA$100M
- Entry multiple10.0x
- Transaction fees2% of EV
- Debt raised5.0x EBITDA
- Hold period5 years
- EBITDA growth+$10M / year
- FCF swept to debt$50M / year
- Exit multiple10.0x
Step 1 — Entry enterprise value
The purchase price at the top of the uses column:
Step 2 — Total uses (capitalize the fees)
Fees are a use of cash, so they sit alongside the purchase price:
Total uses = $1,000M + $20M = $1,020M
Step 3 — Sponsor equity (the plug)
Debt is fixed at 5.0x EBITDA; sponsor equity is whatever balances sources to uses:
Sponsor equity = uses − debt = $1,020M − $500M = $520M
Notice the fees pushed the equity check to $520M, $20M above the fee-free paper-LBO answer. That gap is the whole point of the test.
Step 4 — Exit enterprise value
Exit EV = $150M × 10x = $1,500M
Step 5 — Exit equity
Free cash flow sweeps the debt down over the hold:
Exit equity = $1,500M − $250M = $1,250M
Step 6 — MOIC and IRR
IRR = 2.40^(1/5) − 1 ≈ 19.1%
A 2.40x over five years lands just under a 20% IRR — solid, and slightly below the fee-free version because those capitalized fees quietly enlarged the equity you had to put in.
The intuition
Why sources & uses has to balance
Every dollar the deal spends has to be funded by a dollar raised — that's the entire logic of a sources & uses. On the uses side you have the purchase enterprise value plus any fees and expenses that get capitalized into the transaction. On the sources side you have the debt you raise and the equity the sponsor writes.
Because those two columns must be equal, sponsor equity is never a free input — it's the residual. Fix the debt quantum (here 5.0x EBITDA), total up the uses, and the equity check falls out as the difference. That's why raising more debt lowers the equity you need (and juices returns), and why adding fees raises it. Interviewers watch this step closely because it's where a candidate either understands the funding of a deal or just memorized a formula.
Watch out
Common mistakes
Leaving fees out of uses
Transaction and financing fees are real cash out the door. Forgetting to capitalize them understates uses, which understates the equity check and overstates returns. If the prompt gives you a fee percentage, it belongs in total uses.
Treating sponsor equity as an input
Sponsor equity is the plug that balances sources to uses, not a number you assume. Compute total uses, subtract the debt raised, and take what's left. Guessing the equity and letting sources drift away from uses breaks the schedule.
Forgetting to sweep FCF to debt
The whole engine of an LBO is paying debt down with free cash flow. If you exit on the same debt balance you entered with, you've dropped the debt-paydown bucket of returns entirely. Ending debt = starting debt minus cumulative FCF (floored at zero).
Dividing exit equity by the wrong base
MOIC is exit equity over sponsor equity — the money the sponsor actually invested, fees included. Dividing by the fee-free purchase equity, or by enterprise value, gives a MOIC that doesn't reconcile to the cash the fund put in.
FAQ
Frequently asked questions
How is an LBO modeling test different from a paper LBO?
A paper LBO is a fee-free mental-math exercise: purchase price, a single debt tranche, cash flow to paydown, exit. A modeling test is the fuller build the interviewer actually watches you do — it adds a real sources & uses (with transaction fees capitalized into the purchase), and sponsor equity is the plug that balances sources against uses. The extra structure is where candidates slip.
How do transaction fees affect the returns?
Fees are a use of funds, so they raise total uses above the purchase enterprise value. With debt fixed, that extra cost is funded by more sponsor equity — which lowers MOIC and IRR versus an otherwise identical fee-free deal. In the worked example, 2% fees on a $1,000M purchase add $20M of uses, pushing the equity check from $500M to $520M.
What is a sources & uses schedule?
It's the funding bridge for the deal. Uses are what you spend — the purchase enterprise value plus fees. Sources are how you pay — debt raised plus sponsor equity. Sources must equal uses, so once you know uses and the debt quantum, sponsor equity is simply the difference (the plug).
Why does sponsor equity equal total uses minus debt?
Because sources must equal uses. If total uses are $1,020M and you raise $500M of debt, the remaining $520M has to come from the sponsor's equity — there is no other source of cash in a simple structure. That plug is the invested capital the MOIC and IRR are measured against.
What returns do interviewers expect from an LBO?
Sponsors typically target a 20%+ IRR and roughly a 2.0–3.0x MOIC over a five-year hold. Use the mental-math bridge over five years: a 2.0x MOIC is about a 15% IRR, 2.5x is about 20%, and 3.0x is about 25%. If your build lands far outside that band, sanity-check your entry multiple, leverage, and exit assumptions.
Now build one under a timer
Reading a build is one thing — doing it against the clock, with fresh numbers, is another. Run the graded LBO modeling test, or open the full LBO model with live data.