How a PE Associate Builds an LBO Model: NYIF Faculty Walkthrough

The LBO model is the single most important technical artefact in private equity. It is what associates build on every live deal. It is what PE candidates are tested on in interviews and modelling exercises. It is what fund partners ultimately rely on, in some form, to decide whether to commit capital to a transaction. This walkthrough, drawn from how NYIF faculty teach the model on live training engagements, takes the reader through the build from first input to final return analysis.

The architecture, before any numbers go in

A clean LBO model is built in seven distinct sections, in a specific order. Assumptions and operating drivers first. Then the operating model: revenue, costs, EBITDA, capital expenditure, working capital, and free cash flow. Then the transaction structure: sources and uses of funds, purchase price, equity and debt funding. Then the debt schedule: interest expense, mandatory amortisation, and cash sweep. Then the integrated three-statement build. Then the returns analysis: exit multiple, exit value, equity proceeds, IRR, money-on-money. Finally the sensitivity tables. Building the model in this order is what allows each section to depend cleanly on the section above it without circular references or hidden assumptions.

Operating drivers and the discipline of the forecast

The most common modelling mistake is to forecast revenue and costs at too high a level of aggregation. A serious model breaks revenue into volume and price by product line or by segment. It builds cost of goods sold from variable and fixed components. It treats selling, general, and administrative expenses with the same discipline. The point is not precision for its own sake; the point is that an LBO model is a stress-testing tool, and a stress test only works if the operating levers that matter are explicit and adjustable. A model where revenue is just “five percent growth” cannot answer the question “what if pricing power weakens and volume holds flat.”

The sources and uses table

This is the small but consequential table that defines the entire transaction. On the uses side: the equity purchase price for the target’s shares, refinancing of existing debt, transaction fees, financing fees, minimum cash. On the sources side: new debt across the capital structure (revolver, term loan A, term loan B, senior notes, subordinated notes, mezzanine), equity contribution from the PE fund, and any rollover equity from existing shareholders or management. The two sides must balance exactly. This is the discipline that forces the model to be coherent.

The debt schedule, in detail

The debt schedule is where most amateur LBO models fall apart. A complete schedule tracks each tranche of debt separately: opening balance, mandatory amortisation, cash sweep against excess free cash flow, prepayments, and interest expense at the applicable spread over the relevant base rate (SOFR for most US deals in 2026). The cash sweep, which is the rule that says any free cash flow above a defined level is used to pay down debt, is what creates the deleveraging story that drives PE returns. Building the cash sweep correctly, with appropriate ordering across tranches and correct treatment of prepayment penalties, is the test that most modelling exercises in PE recruiting are really evaluating.

The integrated three-statement build

The operating model and debt schedule feed into a full three-statement build. The income statement runs from revenue through EBITDA, EBIT, interest, taxes, and net income. The cash flow statement reconciles net income to operating cash flow, capital expenditure, debt movements, and ending cash. The balance sheet rolls forward assets, liabilities, and equity. The test of the build is that the balance sheet balances on its own (without a hard-coded plug) and that the cash flow statement reconciles exactly to the change in cash on the balance sheet. When the model balances under the base case and under several sensitivity scenarios, the build is structurally sound.

Returns analysis

The exit assumption is typically modelled as a multiple of exit-year EBITDA, calibrated to the entry multiple and the operating improvement projected during the hold. Exit value flows through to debt repayment at exit, then to equity proceeds. From the equity proceeds the model derives the gross IRR to the fund, the money-on-money multiple, and the carried interest split. A complete model presents these returns under base, upside, and downside operating scenarios, against sensitivity tables for entry multiple, exit multiple, leverage, and operating performance.

Where most candidates struggle

The technical mistakes that disqualify candidates in modelling tests are almost always the same. Balance sheet imbalances after the cash sweep is applied. Interest expense not resolved correctly through the circular reference between debt balance, interest, and free cash flow. Working capital treated inconsistently between the operating model and the cash flow statement. Deferred tax treatment ignored. Capital structures that double count or omit amounts in the sources and uses. Practising the model end-to-end multiple times, against multiple deal scenarios, is the only reliable way to internalise the discipline.

The interview shortcut: paper LBO

Interviewers frequently ask candidates to build a “paper LBO” in their head. The shortcut is to memorise the structure: entry equity, exit equity, IRR. Entry equity equals purchase EBITDA times entry multiple, minus net debt assumed. Exit equity equals exit EBITDA times exit multiple, minus remaining debt. IRR is approximated from money-on-money over the hold period using simple compounding tables candidates are expected to know. Candidates who can do this fluidly in conversation outperform those who freeze when Excel is not available.

Continue Your Finance Education

• How to Become an Investment Banker
• What Is Investment Banking