60-Minute LBO Modeling Test (Finance Guide)
A 60-minute LBO test asks you to build a compact, linked buyout model and explain what drives the sponsor’s return. Start with the transaction, project cash flow, model debt repayment, and calculate exit value, MOIC, and IRR. Prioritize correct links and checks over polish, follow the test’s stated assumptions, and reserve time to audit your work.
If you are preparing for finance recruiting, the challenge is not just remembering formulas. You need to turn a short prompt into a working model, make sensible use of the assumptions provided, and spot errors before time runs out. There is no single industry-wide LBO test template or scoring rule, so the employer’s instructions take priority.
I recommend learning the sequence and the checks, not memorizing one fixed spreadsheet. That makes it easier to adapt when a prompt changes the debt structure, holding period, or operating assumptions.
What a 60-minute LBO test assesses
A timed LBO test is a practical exercise in transaction modeling. It checks whether you can connect purchase price, funding, business performance, debt repayment, and sponsor returns in a short period. The goal is a model that works and can be explained, not a perfect presentation.
A leveraged buyout, or LBO, is a purchase funded with a mix of debt and investor equity. The model estimates whether the business can support that debt and what the investor might receive at exit. Tests commonly ask you to build the core transaction and return calculations, but the exact scope varies by employer.
Your work should answer three questions:
- What does the buyer pay, and how is the deal funded?
- How much cash can the business generate and use to repay debt?
- What proceeds might the sponsor receive when it sells the business?
A model can look neat and still give a wrong answer. For example, treating enterprise value as equity value, or forgetting debt at exit, can overstate sponsor proceeds. I advise candidates to check the mechanics before refining the layout.
Build the model in a reliable order
The model sequence is the set of steps that connects deal inputs to returns. Use it to avoid jumping between tabs or calculations. A clear order also helps you decide what to complete first if time becomes tight.
1. Set up the transaction and sources & uses
Sources & uses shows where the money comes from and where it goes at closing. Sources must equal uses. The prompt may include purchase consideration, refinancing of existing debt, fees, and minimum cash; include only items supported by the instructions.
Typical sources include new debt and sponsor equity. Typical uses include equity purchase price, repayment of old debt, transaction fees, and any required cash balance. If total uses exceed debt sources, sponsor equity usually funds the difference.
Basic check: Total sources = Total uses.
Do not assume that purchase price is the only use. Read the prompt for debt refinancing, fees, and cash requirements. If an input is missing, do not invent it; use a clearly stated assumption only if the instructions allow one.
2. Project operating performance and cash flow
The operating case forecasts how the business performs during the holding period. Use the prompt’s revenue growth, margins, tax, and spending assumptions to calculate cash available for debt service. Keep units and time periods consistent across the model.
A simple forecast may include revenue, EBITDA, capital spending, taxes, and changes in working capital. EBITDA is earnings before interest, taxes, depreciation, and amortization. It is often used to describe operating performance, but it is not the same as cash flow.
A simplified cash flow bridge might be:
- EBITDA
- Less cash interest, cash taxes, capital spending, and increases in working capital
- Equals cash available for debt repayment, subject to the prompt’s structure
Follow the exact cash-flow definition given. Some tests provide a simplified free cash flow assumption. Others ask you to calculate it. Do not deduct an item twice or treat EBITDA as cash available to repay debt.
3. Build the debt schedule
A debt schedule tracks how borrowing changes over time. It links cash flow to debt repayment and then feeds interest expense back into the model. The prompt determines the debt types, repayment rules, interest rates, and any required minimum cash.
For each debt tranche, show beginning balance, repayments or borrowings, and ending balance. A basic roll-forward is:
Ending debt = Beginning debt + New borrowing − Repayment
Calculate interest using the convention specified in the prompt. If no convention is given, avoid presenting a guess as a fact. Depending on the test, interest may use beginning debt, average debt, or another stated method.
Some models have circularity: cash flow affects repayment, repayment affects interest, and interest affects cash flow. If the test provides a circularity setting or instructions, follow them. If not, use a straightforward method you can explain, rather than losing time on a complex feature.
Calculate exit value and sponsor returns
Exit value is the estimated business value at sale. Sponsor proceeds are what remains for equity after accounting for debt and other specified claims. MOIC and IRR summarize the return, but they answer different questions.
A common approach is to estimate exit enterprise value using the exit EBITDA and exit multiple:
Exit enterprise value = Exit EBITDA × Exit multiple
Then bridge to equity value. In a simplified case with no other adjustments:
Exit equity value = Exit enterprise value − Exit debt + Exit cash
Apply the prompt’s treatment of cash, fees, or other claims. Do not subtract debt from equity value twice. The key distinction is that enterprise value reflects the value of the business before net debt, while equity value reflects value for equity holders after the relevant adjustments.
MOIC, or multiple on invested capital, is total sponsor equity proceeds divided by sponsor equity invested. A 2.0x MOIC means proceeds equal twice the invested amount; it does not state how long the investment took.
IRR, or internal rate of return, accounts for the timing of cash flows. Use the holding period and timing convention in the prompt. Do not substitute a guessed annual return for the model’s actual cash-flow timing.
| Measure | Basic calculation | What it tells you |
|---|---|---|
| Entry enterprise value | Entry EBITDA × entry multiple, if provided | Purchase value before net debt adjustments |
| Exit enterprise value | Exit EBITDA × exit multiple | Estimated business value at sale |
| MOIC | Sponsor proceeds ÷ sponsor equity invested | Total return relative to invested equity |
| IRR | Return calculated from dated cash flows | Annualized return that reflects timing |
A timed build and audit plan
A time plan is a way to protect the essential calculations from getting crowded out. These intervals are a practical guide, not a required test standard. Adjust them to the prompt and follow any instructions about spreadsheet format or permitted tools.
| Minutes | Focus | Completion check |
|---|---|---|
| 0–5 | Read prompt; identify assumptions and required outputs | Units, years, and conventions are clear |
| 5–15 | Transaction inputs and sources & uses | Sources equal uses |
| 15–30 | Operating forecast and cash flow | Cash flow links to operating assumptions |
| 30–42 | Debt schedule and interest | Debt roll-forward is consistent |
| 42–52 | Exit value, equity proceeds, MOIC, and IRR | Debt and cash treatment is clear |
| 52–60 | Audit, fix errors, and prepare a short explanation | Key links and outputs are checked |
In the first few minutes, mark the entry and exit assumptions, holding period, debt terms, and required outputs. Then build in order. If you fall behind, finish the linked core model before adding sensitivities or formatting.
Use the final minutes for these checks:
- Does sources equal uses?
- Does each debt balance roll forward correctly?
- Does cash flow feed into repayments as intended?
- Does ending debt flow into exit equity value?
- Are MOIC and IRR based on sponsor equity and the stated cash-flow timing?
- Do formulas link to inputs, rather than relying on unexplained hard-coded values?
Worked scenario: follow the links, not the formatting
This simplified example shows how a test model connects its main steps. The figures are illustrative only, not market benchmarks or a recommended deal structure. In a real assessment, use the prompt’s figures and conventions.
Assume a company has entry EBITDA of 100 units and an entry multiple of 8.0x. Entry enterprise value is therefore 800 units. Suppose the prompt adds 20 units of fees and requires 10 units of minimum cash. Those items belong in uses if specified, while the funding sources must cover the full total.
Next, project operating results for the stated holding period. If exit EBITDA is 130 units and the prompt gives a 9.0x exit multiple, exit enterprise value is 1,170 units. If exit debt is 400 units and cash is 10 units, simplified exit equity value is 780 units.
That 780 is not automatically the sponsor’s return. The model must account for ownership and any other claims or adjustments stated in the prompt. Divide sponsor proceeds by sponsor equity invested to calculate MOIC. Then calculate IRR using the actual cash-flow dates or timing convention requested.
The lesson is practical: a reasonable-looking exit multiple cannot fix a broken sources-and-uses schedule or an omitted debt balance. Audit the bridge from entry funding to exit proceeds.
Common mistakes and how to prevent them
Common errors are usually linkage or interpretation problems, not difficult math. A short final audit can catch many of them. I encourage candidates to state what a number represents before using it in another calculation.
- Mixing enterprise value and equity value: Label each clearly and bridge between them using debt and cash as instructed.
- Leaving sources and uses out of balance: Recheck transaction uses and the sponsor equity plug.
- Treating EBITDA as cash flow: Deduct the cash items required by the prompt.
- Breaking the debt schedule: Check beginning debt, new borrowing, repayments, and ending debt.
- Ignoring debt at exit: Use ending debt in the exit equity bridge.
- Misstating IRR timing: Use the stated holding period and cash-flow timing.
- Adding unsupported assumptions: Flag missing information and follow the test’s instructions rather than inventing inputs.
- Spending too long on formatting: Make labels readable, but finish and audit the calculations first.
Preparation and career relevance
Practice is most useful when it builds speed and judgment, not just formula recall. Try timed builds from different prompts, then review where your links broke and which calculations took too long. The required format and difficulty differ across employers, so no template guarantees a particular result.
Before a test, review enterprise-to-equity value, sources & uses, debt roll-forwards, cash-flow mechanics, MOIC, and IRR. After a practice attempt, note one technical error and one time-management change to address next time. I have found that explaining each model link aloud is a useful way to reveal whether a calculation is understood or merely copied.
These skills are relevant to investment banking and private equity recruiting, where candidates may need to demonstrate transaction and valuation knowledge. They can also support work in corporate finance and related roles. A test is one part of a hiring process; it does not by itself determine a candidate’s career path or predict a specific employment outcome.
Frequently asked questions
These answers cover common points candidates need to settle before or during a timed LBO exercise. Always follow the employer’s prompt where it differs. The central priority is a complete, consistent model whose assumptions and return calculations you can explain.
What should I finish first in a 60-minute LBO test?
Complete sources & uses, the operating case, debt schedule, exit bridge, and sponsor returns in that order.
Are all LBO tests built from the same template?
No. Employers can vary the format, assumptions, debt terms, and required outputs. Follow the test instructions.
What does sources equal uses mean?
It means total funding sources match total transaction uses at closing.
How do I calculate MOIC?
Divide sponsor equity proceeds by sponsor equity invested, using the prompt’s treatment of proceeds.
How is IRR different from MOIC?
MOIC measures total proceeds against invested capital. IRR also reflects when the cash flows occur.
Should I include transaction fees?
Include them when the prompt specifies them. Do not invent a fee assumption when none is given.
What if the prompt does not state an interest convention?
Do not claim an unstated convention is universal. Use the test’s directions or a clearly explained, simple assumption if permitted.
Should I build a sensitivity table?
Only after the core model works and the test allows enough time. A sensitivity cannot replace a correct base case.
What is the most important final check?
Check the links from sources & uses through cash flow and debt to exit equity value and sponsor returns.
Do I need elaborate formatting?
No. Keep labels and units clear, but prioritize a functioning, auditable model over cosmetic detail.
(This article was written by one of our staff writers, James Holloway. Visit our Meet the Team page.)
