Timed LBO modeling test

Read the prompt as a contract

Before modeling, identify required outputs, time period, available data, assumptions, formatting requirements, and whether a written recommendation is needed. Mark missing information and decide which assumptions must be made.

Time allocation

A practical sequence is:

• first 10–15%: read, plan, and set up;
• next 55–65%: build core mechanics;
• next 15–20%: sensitivities, downside, and summary;
• final 10–15%: checks, formatting, and written conclusion.

The exact allocation changes with the test. Reserve review time deliberately.

Build order

1. historical and assumptions;
2. entry valuation and sources and uses;
3. operating forecast;
4. debt schedule and interest;
5. exit and returns;
6. sensitivities and downside;
7. checks;
8. recommendation.

Core model first

A complete simple model is stronger than an unfinished elaborate one. Build one working debt tranche before adding layers. Ensure sponsor equity balances and returns work before adding optional schedules.

Debt and cash

Model minimum cash, revolver, mandatory amortization, optional repayment, cash interest, PIK, and priority. Use average balances where appropriate. Control circularity rather than ignoring it.

Summary output

Show entry multiple, purchase price, leverage, sponsor equity, EBITDA and cash growth, debt repayment, exit assumptions, MoM, IRR, and downside liquidity. Make the main drivers visible without searching every tab.

Written recommendation

State whether to proceed, maximum or proposed price, expected returns, decisive thesis, principal risks, and remaining diligence. Don't call the deal attractive solely because the base-case IRR exceeds a threshold.

Review

Check signs, units, dates, formulas, copied ranges, debt repayment, terminal period, and sensitivities. Change one major assumption and confirm the result flows through every relevant schedule.

Tool use

Unless permitted, don't use external AI, copied templates, or code that violates the test conditions. In professional work, approved tools can assist but every formula and assumption remains the analyst’s responsibility.

A practical three-hour build sequence

A common three-hour test can be divided into five blocks.

Minutes 0–15: read and map the prompt

Read the entire prompt before building. Write down required outputs, assumptions supplied, missing information, expected sensitivities, and the format of the final recommendation. Inspect every source tab. Confirm whether historical statements are already standardized or must be rebuilt.

Minutes 15–45: establish the transaction

Build purchase price, diluted share count if relevant, enterprise-to-equity bridge, fees, minimum cash, debt refinancing, financing sources, and sponsor equity. The sources-and-uses schedule should balance before the operating forecast becomes detailed.

Minutes 45–105: forecast the business

Forecast revenue and margins from the drivers provided. Build working capital, capital expenditure, depreciation, taxes, and other recurring cash items. The purpose is to derive cash available for debt repayment, not to reproduce every line in a public filing.

Minutes 105–145: build debt and returns

Model each debt tranche separately. Include opening balance, mandatory amortization, optional repayment, cash interest, PIK interest, fees, maturity, and minimum cash. Calculate exit enterprise value, remaining debt, sponsor proceeds, MoM, and IRR.

Minutes 145–180: sensitivity, audit, and recommendation

Run at least one downside case and the sensitivities requested. Confirm that the balance sheet balances if a three-statement model is required, cash doesn't fall below the minimum, debt doesn't repay beyond the amount outstanding, and returns respond logically to changes in price, leverage, growth, and exit multiple. Use the final minutes to write the investment conclusion.

Minimum model architecture

A clean test normally needs:

• assumptions and transaction overview;
• historical operating information;
• operating forecast;
• sources and uses;
• debt schedule;
• returns calculation;
• sensitivities;
• summary or IC output;
• visible checks.

More complex prompts may require a full three-statement model, management rollover, add-on acquisitions, earnouts, PIK securities, multiple debt tranches, tax attributes, or a dividend recapitalization. Add complexity only after the core model works.

What the written recommendation should contain

The summary should state the proposed investment, entry valuation, financing, base-case return, downside return, main return drivers, principal risks, and unresolved diligence. It should answer whether to proceed and, when relevant, the maximum price or conditions under which the recommendation changes.

A strong conclusion might say that the investment meets the return threshold at the proposed price because EBITDA growth and cash conversion drive most of the outcome, but that customer concentration and refinancing risk require a lower price or specific diligence before approval. That is more useful than a page of unlabeled output tables.

Model checks that should be visible

Visible checks reduce the chance that an apparently finished model contains a silent error:

• sources equal uses;
• beginning debt plus draws, PIK, and other additions minus repayments equals ending debt;
• cash available for repayment can't exceed cash generated;
• ending cash respects the minimum-cash assumption;
• interest responds to debt balances;
• exit equity equals exit enterprise value less debt and other claims;
• sponsor MoM and IRR use the correct dates and cash flows;
• sensitivity tables point to the intended assumptions;
• downside changes flow through operations, cash, debt, and returns.

What evaluators can infer from the file

Formatting isn't the central skill, but model design reveals judgment. A readable file shows that the candidate can separate assumptions from calculations, maintain consistent units and signs, use one source for each input, create checks, and make the decision visible. A complicated file with hidden hardcodes, overwritten checks, or unexplained plugs suggests that the candidate can't yet hand work to another person safely.

Variants by firm and strategy

A middle-market buyout test may emphasize a straightforward operating model, debt paydown, and an actionable value-creation plan. A large-cap or sector-specialist process may require more detailed financing, carve-out, add-on, or segment assumptions. Growth-equity cases may use less leverage and focus more on cohort economics, dilution, and exit scenarios. Credit-oriented cases may emphasize downside liquidity, covenants, and recovery. The prompt and strategy should control the model rather than one memorized template.