LBO Model Guide: How to Build a Leveraged Buyout Model Step by Step
What Is an LBO Model?
An LBO model is the core analytical tool in private equity. It answers one question: if a PE firm buys this company at a given price with a specific debt structure, what internal rate of return (IRR) and money-on-money multiple (MOIC) can it expect at exit?
Unlike a DCF model that focuses on intrinsic value, an LBO model focuses on achievable returns given real financing constraints. The heavy use of leverage amplifies equity returns — but also amplifies risk.
Key Components of an LBO Model
| Component | What It Covers | Why It Matters |
|---|---|---|
| Sources & Uses | How the deal is financed (debt, equity) and where the money goes (purchase price, fees) | Determines the equity check and initial leverage |
| Operating Model | Revenue, expenses, and EBITDA projections over the hold period | Drives free cash flow available for debt paydown |
| Debt Schedule | Tranches, interest rates, mandatory amortization, cash sweeps | Shows how quickly debt is repaid |
| Returns Analysis | IRR and MOIC at various exit multiples and years | The bottom line — does the deal meet the fund’s hurdle rate? |
| Sensitivity Tables | IRR across different entry multiples, exit multiples, and leverage levels | Stress-tests the deal under different assumptions |
Step-by-Step: Building an LBO Model
Step 1 — Set Up Sources and Uses
Start with the purchase price. The uses side includes the equity purchase price (typically enterprise value based on an EBITDA multiple), transaction fees, and financing fees. The sources side shows how you fund it: senior debt, subordinated debt, mezzanine, and sponsor equity.
Step 2 — Build the Operating Forecast
Project revenue, COGS, and operating expenses over 5 years. Use the three-statement model framework: income statement flows into the balance sheet and cash flow statement. Focus on revenue growth and margin expansion — these are the key value drivers.
Step 3 — Build the Debt Schedule
Model each debt tranche separately. Senior debt typically amortizes (mandatory repayment), while subordinated debt may be bullet (repaid at maturity). Include a cash sweep mechanism where excess free cash flow pays down debt. Link interest expense back to the income statement — this creates a circular reference you’ll need to handle.
Step 4 — Calculate Free Cash Flow to Equity
After interest, taxes, working capital changes, and capex, determine how much cash is available for debt repayment each year.
Step 5 — Model the Exit
Apply an exit EV/EBITDA multiple to the projected EBITDA in the exit year. Subtract remaining net debt to get equity value at exit. Compare that to the initial equity investment to calculate IRR and MOIC.
Step 6 — Build Sensitivity Tables
Use Excel data tables to show IRR across a matrix of entry multiples vs. exit multiples, or leverage levels vs. EBITDA growth rates. This is what PE partners actually look at.
Typical Debt Structures in an LBO
| Debt Tranche | Typical Rate | Repayment | Seniority |
|---|---|---|---|
| Revolver | SOFR + 200–300 bps | Drawn/repaid as needed | Most senior |
| Term Loan A | SOFR + 200–350 bps | Amortizing (5–7 years) | Senior secured |
| Term Loan B | SOFR + 300–500 bps | Minimal amortization, bullet | Senior secured |
| High-Yield Bonds | 6%–10% fixed | Bullet at maturity | Senior unsecured |
| Mezzanine / Sub Debt | 10%–15% (incl. PIK) | Bullet, often with PIK toggle | Subordinated |
Value Creation Levers in an LBO
PE firms create value through three main levers, and your model should capture all of them:
EBITDA growth — Revenue growth and margin improvement increase the numerator of the exit valuation. Even modest operational improvements compound over a 5-year hold.
Debt paydown — As the company generates cash and pays off debt, a larger share of enterprise value accrues to equity holders. This is “forced savings” — the company’s own cash flow repays the acquisition debt.
Multiple expansion — If you buy at 8x EBITDA and sell at 10x, that alone creates significant returns. But smart analysts never underwrite multiple expansion — it’s a bonus, not a plan.
Common LBO Modeling Mistakes
Ignoring working capital. Many first-time modelers forget that growing revenue ties up cash in working capital. A fast-growing company may generate strong EBITDA but weak free cash flow.
Unrealistic margins. Don’t assume 500 bps of margin expansion without a clear operational plan. Diligence teams will challenge every assumption.
Forgetting transaction fees. Advisory fees, financing fees, and legal costs typically add 2–4% to the total uses. Missing them inflates your returns.
Static interest rates. If the debt is floating-rate, your model should reflect rate changes. Link to a rate assumption cell, not a hard-coded number.
Key Takeaways
- An LBO model tests whether a PE deal generates acceptable returns (typically 20%+ IRR) given a specific debt structure and operating plan.
- The five building blocks are: sources & uses, operating model, debt schedule, cash flow, and returns analysis.
- Value creation comes from EBITDA growth, debt paydown, and (sometimes) multiple expansion.
- Always stress-test with sensitivity tables — PE partners want to see how returns hold up under adverse scenarios.
- The best LBO candidates have stable cash flows, low capex needs, and defensible market positions.
Frequently Asked Questions
What IRR do PE firms typically target in an LBO?
Most PE firms target a gross IRR of 20–25% and a MOIC of 2.0–3.0x over a 3–7 year holding period. The actual hurdle rate varies by fund strategy, but 20% is the standard benchmark for a “good” deal.
How is an LBO model different from a DCF model?
A DCF model estimates intrinsic value by discounting future cash flows at the WACC. An LBO model estimates achievable returns for a financial buyer using leverage. The DCF asks “what is this worth?” while the LBO asks “what can I pay and still hit my return target?”
What makes a company a good LBO candidate?
Ideal LBO targets have stable, predictable cash flows, low capital expenditure requirements, strong market positions with pricing power, opportunities for operational improvement, and manageable existing debt levels. Asset-heavy businesses with tangible collateral also help secure favorable debt terms.
How do you handle circular references in an LBO model?
The circularity arises because interest expense depends on debt balances, which depend on free cash flow, which depends on interest expense. Enable iterative calculations in Excel (File → Options → Formulas → Enable iterative calculation) or use a circuit breaker toggle. See our circular references guide for details.
What is a cash sweep in an LBO model?
A cash sweep is a mechanism where excess free cash flow (after mandatory debt payments and minimum cash requirements) is used to prepay debt. It accelerates deleveraging and improves equity returns. Most senior credit agreements include a cash sweep provision — typically 50–75% of excess cash flow.