An LBO model evaluates a leveraged buyout, where a business is acquired using a significant amount of debt alongside equity. It combines the entry price, sources and uses, an operating forecast, a debt schedule and an exit assumption to calculate the equity investor’s returns, usually IRR and multiple on invested capital (MOIC).
Private equity buyers rarely pay for a business with equity alone. They borrow against its cash flows, use those cash flows to repay debt, and sell the business a few years later. It is one of the most common forms of deal modelling.
The LBO model is the tool that tests whether that plan works. It shows how much debt the business can carry, how quickly it can be repaid and what return the equity earns at exit.
Key terms
- Leveraged buyout (LBO): The acquisition of a company funded with a significant proportion of debt.
- Sources and uses: A table showing how the purchase is funded and where the money goes.
- MOIC: Multiple on invested capital, total equity proceeds divided by equity invested.
- IRR: Internal rate of return, the annualised return on the equity investment.

How does an LBO model work?
An LBO model works by projecting the acquired business’s cash flows, using them to service and repay acquisition debt, and calculating equity returns when the business is sold. Returns come from three sources: earnings growth, debt repayment and any change between the entry and exit multiple.
How do you build an LBO model?
Six steps cover the core structure.
- Entry assumptions: Purchase price, usually as a multiple of EBITDA, plus fees and timing.
- Sources and uses: Debt tranches and equity against purchase price, refinancing and costs.
- Operating forecast: Revenue, EBITDA, capital expenditure, working capital and tax.
- Debt schedule: Interest, scheduled repayments, cash sweeps and covenant tests.
- Exit assumptions: Exit year and exit multiple, giving enterprise value and equity value at sale.
- Returns: IRR and MOIC for the equity, with sensitivities on price, leverage and exit multiple.
What is a worked LBO model example?
A business with EBITDA of $12.5 million is acquired for $100 million, or 8 times EBITDA, funded with $60 million of debt and $40 million of equity.
| Item | Entry | Exit (year 5) |
|---|---|---|
| EBITDA | $12.5m | $16.0m |
| Multiple | 8.0x | 8.0x |
| Enterprise value | $100m | $128m |
| Net debt | $60m | $30m |
| Equity value | $40m | $98m |
Equity grows from $40 million to $98 million, a MOIC of about 2.45 times and an IRR of about 19.6% over five years. Earnings growth and debt repayment each contribute, with no change in the multiple.
Which assumptions matter most in an LBO model?
The exit multiple, EBITDA growth, entry price and amount of debt usually drive most of the result. Small changes in the exit multiple can move returns sharply, so an LBO model should always show sensitivity tables on entry and exit multiples, leverage and growth, and test whether the business can meet interest and covenants in a downside case.
What are common LBO model mistakes?
Common mistakes include assuming the exit multiple rises without evidence, ignoring working capital and capital expenditure needs, mis-timing debt repayments, and leaving circular interest calculations unmanaged. A clear structure, a balancing balance sheet and integrity checks keep the LBO model reliable as terms change during negotiation.
Can AI build an LBO model?
AI can draft the main schedules of an LBO model, but the debt and balance sheet logic is where it is weakest. In our evaluations, AI matched operating results closely while missing the balance sheet badly, and an LBO’s returns depend on exactly that: debt repayment, cash sweeps and closing equity.
Treat any AI-drafted LBO as a first draft. Check that the balance sheet balances without plugs, that interest and repayments flow correctly and that returns trace to cash flows. See how to check an AI-built financial model, or talk to us about our financial modelling services.
For the operating forecast that sits under a valuation, we use EXL Cloud, our own SaaS modelling platform: driver-based 3-way models in Excel, connected to Xero, with a DCF and valuation block and Claude skills that help check the outputs.
Frequently asked questions
What is an LBO model?
An LBO model is a financial model that evaluates a leveraged buyout, where a company is acquired with a mix of significant debt and equity. It projects the business’s cash flows, schedules debt repayment and calculates equity returns at exit, usually as IRR and MOIC, to test whether the deal meets the investor’s return targets.
What drives returns in an LBO?
Returns come from three sources: growth in earnings, repayment of debt from operating cash flow, and any increase between the entry and exit valuation multiple. Strong deals rely mainly on earnings growth and debt paydown, because multiple expansion depends on market conditions the buyer cannot control.
What is a cash sweep in an LBO model?
A cash sweep uses excess cash flow, after operating costs, capital expenditure, tax and scheduled debt payments, to repay debt early. It reduces interest costs and leverage faster, increasing equity value at exit. In the model, the sweep percentage and the order in which tranches are repaid are key assumptions.
How is an LBO different from a DCF?
A DCF values a business based on the present value of its future cash flows at a chosen discount rate. An LBO model starts with a price and capital structure and calculates the return an equity investor earns. Buyers often use both: the DCF to estimate value and the LBO model to test affordability and returns.
Why do LBO models have circular references?
Interest depends on the debt balance, the debt balance depends on cash available for repayment, and cash depends on interest paid. This loop creates a circular reference. Modellers manage it by calculating interest on opening balances, using a controlled iteration switch or using a copy-paste macro, so the model stays stable and auditable.
What is MOIC?
MOIC, or multiple on invested capital, is total equity proceeds divided by equity invested. A deal that turns $40 million of equity into $98 million has a MOIC of about 2.45 times. MOIC ignores timing, so it is read alongside IRR, which shows the annualised return and rewards faster realisations.
Need a buyout model built for negotiation? See our Financial and Business Modelling services.
Related reading: Deal model vs operational model and Error checks in Excel.
Further reference: Financial Modelling Institute.
About the Author
Lance Rubin is CEO and Founder of Model Citizn, and founder and Chief Excel Officer of EXL Cloud, the SaaS platform that connects Xero to Excel with driver-based financial models, dashboards and Claude AI skills. He is a Chartered Accountant, FMI Certified Trainer, co-author of the CA ANZ Financial Modelling Study Guide, and creator of the AI-Powered Accountant programme on Maven, currently live at Level 1 with Level 2 in design, and author of the companion book “AI-Powered Accounting with Excel and Power BI” (Packt). He has worked at PwC, KPMG, Investec, and NAB, and is based in Melbourne, Australia.

