# Leveraged Buyout Model: Build an LBO in 7 Steps

Published: 2026-04-19
Author: Warren Team
URL: https://www.heywarren.com/blog/leveraged-buyout-model

---
A KKR analyst opens a blank Excel sheet at 9 AM. By midnight, she has built a fully working leveraged buyout model, projecting five years of cash flows, sizing each debt tranche, and calculating the IRR a PE fund could earn on a $1 billion buyout. The leveraged buyout model is the bedrock financial workbook of every private equity firm, and learning to build one is the gate to a PE career.

The trouble is that most online tutorials skip the parts that actually matter on the job. They teach you how to plug a multiple into a cell, but not how a sources and uses table actually balances, how a cash sweep paydown waterfall ties to the debt schedule, or why a 20% IRR can disappear when capex assumptions slip 1%. This guide walks through the LBO model end-to-end, the seven core build steps, the three return drivers, debt structure conventions, sensitivity tables, and the worked example PE associates use to pressure-test deals. By the end, you'll know what every cell does, why it's there, and what the numbers tell a deal team about whether to write the check.

## What Is a Leveraged Buyout Model?

A leveraged buyout model is a financial workbook that values an acquisition target by simulating a debt-financed purchase, projecting several years of operating cash flow, paying down the debt over the hold period, and calculating the IRR and MOIC a private equity sponsor would earn at exit. It's the core analytical tool of buyout investing.

Unlike a discounted cash flow valuation, which solves for intrinsic value, the LBO model solves for the maximum price a sponsor can pay while still hitting a target return, typically a 20-25% IRR over five years. That return-driven framework makes it commercial: the model tells you what to bid, not just what something is "worth."

### Why PE Firms Rely On It

LBO models force discipline around three variables sponsors actually control: leverage, operating improvement, and exit timing. Every assumption maps to a deal-team accountability, the deal partner owns the entry multiple, the operating partner owns EBITDA growth, and the [capital markets](/blog/capital-markets-def) desk owns the debt structure.

### When the Model Gets Built

Sponsors build a quick paper LBO at the teaser stage, a full model in due diligence, and a final committee model before signing. Each version refines the same architecture, adding granularity to the debt schedule, working capital build, and management projections.

## The Seven Core LBO Model Steps

Every LBO model, whether for a $50 million tuck-in or a $25 billion mega-deal, follows the same seven-step build. Master this sequence and you can model any buyout. The steps move from transaction setup, through operating projections and the debt waterfall, to the returns analysis that drives the investment decision.

![The seven sequential steps every leveraged buyout model follows, from transaction assumptions through returns analysis.](data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201090%20125%22%20width%3D%221090%22%20height%3D%22125%22%20role%3D%22img%22%3E%3Ctitle%3EFlow%20diagram%3C%2Ftitle%3E%3Crect%20width%3D%22100%25%22%20height%3D%22100%25%22%20fill%3D%22%23f8fafc%22%2F%3E%3Crect%20x%3D%2230%22%20y%3D%2225%22%20width%3D%22170%22%20height%3D%2275%22%20rx%3D%2210%22%20fill%3D%22white%22%20stroke%3D%22%232563eb%22%20stroke-width%3D%222%22%2F%3E%3Ctext%20x%3D%22115%22%20y%3D%2258.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3ETransaction%20Assumptio%E2%80%A6%3C%2Ftext%3E%3Ctext%20x%3D%22115%22%20y%3D%2278.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2211%22%20fill%3D%22%2364748b%22%3EPrice%2C%20multiple%2C%20fees%3C%2Ftext%3E%3Cline%20x1%3D%22205%22%20y1%3D%2262.5%22%20x2%3D%22237%22%20y2%3D%2262.5%22%20stroke%3D%22%2364748b%22%20stroke-width%3D%222%22%2F%3E%3Cpolygon%20points%3D%22244%2C62.5%20235%2C57.5%20235%2C67.5%22%20fill%3D%22%2364748b%22%2F%3E%3Crect%20x%3D%22245%22%20y%3D%2225%22%20width%3D%22170%22%20height%3D%2275%22%20rx%3D%2210%22%20fill%3D%22white%22%20stroke%3D%22%232563eb%22%20stroke-width%3D%222%22%2F%3E%3Ctext%20x%3D%22330%22%20y%3D%2258.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3ESources%20%26amp%3B%20Uses%3C%2Ftext%3E%3Ctext%20x%3D%22330%22%20y%3D%2278.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2211%22%20fill%3D%22%2364748b%22%3ECap%20structure%20balance%3C%2Ftext%3E%3Cline%20x1%3D%22420%22%20y1%3D%2262.5%22%20x2%3D%22452%22%20y2%3D%2262.5%22%20stroke%3D%22%2364748b%22%20stroke-width%3D%222%22%2F%3E%3Cpolygon%20points%3D%22459%2C62.5%20450%2C57.5%20450%2C67.5%22%20fill%3D%22%2364748b%22%2F%3E%3Crect%20x%3D%22460%22%20y%3D%2225%22%20width%3D%22170%22%20height%3D%2275%22%20rx%3D%2210%22%20fill%3D%22white%22%20stroke%3D%22%232563eb%22%20stroke-width%3D%222%22%2F%3E%3Ctext%20x%3D%22545%22%20y%3D%2258.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3EOperating%20Projections%3C%2Ftext%3E%3Ctext%20x%3D%22545%22%20y%3D%2278.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2211%22%20fill%3D%22%2364748b%22%3ERevenue%2C%20EBITDA%2C%20capex%3C%2Ftext%3E%3Cline%20x1%3D%22635%22%20y1%3D%2262.5%22%20x2%3D%22667%22%20y2%3D%2262.5%22%20stroke%3D%22%2364748b%22%20stroke-width%3D%222%22%2F%3E%3Cpolygon%20points%3D%22674%2C62.5%20665%2C57.5%20665%2C67.5%22%20fill%3D%22%2364748b%22%2F%3E%3Crect%20x%3D%22675%22%20y%3D%2225%22%20width%3D%22170%22%20height%3D%2275%22%20rx%3D%2210%22%20fill%3D%22white%22%20stroke%3D%22%232563eb%22%20stroke-width%3D%222%22%2F%3E%3Ctext%20x%3D%22760%22%20y%3D%2258.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3EDebt%20Schedule%3C%2Ftext%3E%3Ctext%20x%3D%22760%22%20y%3D%2278.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2211%22%20fill%3D%22%2364748b%22%3ETranches%20%26amp%3B%20cash%20sweep%3C%2Ftext%3E%3Cline%20x1%3D%22850%22%20y1%3D%2262.5%22%20x2%3D%22882%22%20y2%3D%2262.5%22%20stroke%3D%22%2364748b%22%20stroke-width%3D%222%22%2F%3E%3Cpolygon%20points%3D%22889%2C62.5%20880%2C57.5%20880%2C67.5%22%20fill%3D%22%2364748b%22%2F%3E%3Crect%20x%3D%22890%22%20y%3D%2225%22%20width%3D%22170%22%20height%3D%2275%22%20rx%3D%2210%22%20fill%3D%22white%22%20stroke%3D%22%232563eb%22%20stroke-width%3D%222%22%2F%3E%3Ctext%20x%3D%22975%22%20y%3D%2258.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3EFree%20Cash%20Flow%3C%2Ftext%3E%3Ctext%20x%3D%22975%22%20y%3D%2278.5%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2211%22%20fill%3D%22%2364748b%22%3EFCF%20to%20debt%20paydown%3C%2Ftext%3E%3C%2Fsvg%3E)

*The seven sequential steps every leveraged buyout model follows, from transaction assumptions through returns analysis.*

### Step 1: Transaction Assumptions

Start with purchase price, entry EV/EBITDA multiple, and pro-forma capital structure. A $1 billion enterprise value at 10x trailing EBITDA implies $100 million of LTM EBITDA. Set the closing date, the assumed financing fees (1-2% of debt), and transaction fees (2-3% of EV) here so they flow into sources and uses cleanly.

### Step 2: Sources and Uses Table

Sources show where money comes from: senior secured term loan B, mezzanine debt, high yield bonds, sponsor equity, and any rollover equity from management or the seller. Uses show where it goes: equity purchase price, refinanced existing debt, transaction fees, and financing fees. Sources must equal uses to the dollar.

### Step 3: Operating Projections

Project five years of revenue, [EBITDA margin](/blog/ebitda-margin), capex, working capital, and taxes. Most sponsor models assume 4-7% revenue growth, modest margin expansion (50-100 bps a year), capex at 3-5% of revenue, and net working capital scaling with revenue. Tax rate sits at the statutory 21% federal plus state.

### Step 4: Debt Schedule

Build a row for each tranche showing beginning balance, mandatory amortization (typically 1% annual on a TLB), interest expense based on the rate grid, and a cash sweep that uses excess [free cash flow](/blog/cashflow-free) to prepay the senior debt. Track covenant ratios, leverage and interest coverage, at each period.

### Step 5: Cash Flow Statement and Free Cash Flow

Roll EBITDA down to free cash flow available for debt paydown by subtracting cash taxes, cash interest, capex, and changes in working capital. This number feeds directly into the debt sweep in Step 4. Iterative calc warning: interest depends on debt balance, which depends on sweep, which depends on cash flow.

### Step 6: Exit Assumptions

Pick an exit year (usually Year 5) and an exit EV/EBITDA multiple. Conservative practice assumes the exit multiple equals entry minus 0.5-1.0x to bake in mean reversion. Multiply exit-year EBITDA by the exit multiple, subtract net debt at exit, and you have the equity value at sale.

### Step 7: Returns Analysis

Calculate IRR and MOIC on the sponsor's equity check. IRR captures annualized return; MOIC (also called money multiple) captures total return, exit equity divided by initial equity. PE funds target 20-25% IRR and 2.5-3.0x MOIC for a five-year hold.

## How to Build an LBO Model: A Worked Example

Walk through a concrete deal. Assume a $1 billion target acquired at 10x EBITDA, financed with $400 million of sponsor equity and $600 million of debt, 60% leverage, a typical mid-market structure. The five-year build below shows exactly how the LBO model produces a 20% IRR.

![Sponsor equity invested at entry versus equity value recovered at exit in the worked example, producing a 2.5x MOIC.](data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20210%22%20width%3D%22800%22%20height%3D%22210%22%20role%3D%22img%22%3E%3Ctitle%3EComparison%3C%2Ftitle%3E%3Crect%20width%3D%22100%25%22%20height%3D%22100%25%22%20fill%3D%22%23f8fafc%22%2F%3E%3Ctext%20x%3D%22230%22%20y%3D%2257.5%22%20text-anchor%3D%22end%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3EEntry%20Equity%3C%2Ftext%3E%3Crect%20x%3D%22240%22%20y%3D%2225%22%20width%3D%22180%22%20height%3D%2255%22%20rx%3D%226%22%20fill%3D%22%232563eb%22%2F%3E%3Ctext%20x%3D%22432%22%20y%3D%2257.5%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22700%22%20fill%3D%22%232563eb%22%3E%24400%3C%2Ftext%3E%3Ctext%20x%3D%22230%22%20y%3D%22152.5%22%20text-anchor%3D%22end%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3EExit%20Equity%3C%2Ftext%3E%3Crect%20x%3D%22240%22%20y%3D%22120%22%20width%3D%22450%22%20height%3D%2255%22%20rx%3D%226%22%20fill%3D%22%237c3aed%22%2F%3E%3Ctext%20x%3D%22702%22%20y%3D%22152.5%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22700%22%20fill%3D%22%237c3aed%22%3E%241.0K%3C%2Ftext%3E%3C%2Fsvg%3E)

*Sponsor equity invested at entry versus equity value recovered at exit in the worked example, producing a 2.5x MOIC.*

### Sources, Uses, and Entry

Year 0 LTM EBITDA is $100 million. Sources: $400M sponsor equity plus $600M term loan B at SOFR + 450 bps. Uses: $1,000M equity purchase price (assume no existing debt to refinance), $20M financing fees, $25M transaction fees, funded by a slightly larger debt tranche or equity gap.

### Operating Build to Year 5

EBITDA grows from $100M to $130M by Year 5, roughly 5.4% annual growth from a mix of organic revenue gains and a small bolt-on acquisition. Free cash flow after capex, interest, taxes, and working capital averages $60M per year, allowing the company to sweep $300M of debt over the hold.

### Exit and Returns

At exit, debt has been paid down to $300M. Apply a 10x exit multiple (no multiple expansion assumed) to $130M of EBITDA: enterprise value is $1.3B. Subtract $300M of net debt and equity value at exit is $1.0B. Sponsor invested $400M and exits at $1.0B, that's a 2.5x MOIC and roughly a 20% IRR over five years.

## Drivers of LBO Returns

Three forces drive every LBO return: multiple expansion, EBITDA growth, and debt paydown. The best deals stack all three; the worst ones rely on a single lever. Sophisticated PE shops attribute returns post-mortem to each driver to learn which value-creation playbook actually worked.

![The three forces that drive every leveraged buyout return, with the worked example's dollar contribution from each.](data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20600%20211%22%20width%3D%22600%22%20height%3D%22211%22%20role%3D%22img%22%3E%3Ctitle%3EHierarchy%3C%2Ftitle%3E%3Crect%20width%3D%22100%25%22%20height%3D%22100%25%22%20fill%3D%22%23f8fafc%22%2F%3E%3Crect%20x%3D%22220%22%20y%3D%2220%22%20width%3D%22160%22%20height%3D%2258%22%20rx%3D%228%22%20fill%3D%22%232563eb%22%2F%3E%3Ctext%20x%3D%22300%22%20y%3D%2254%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2214%22%20font-weight%3D%22700%22%20fill%3D%22white%22%3ELBO%20Returns%3C%2Ftext%3E%3Cpath%20d%3D%22M%20300%2078%20L%20300%20105.5%20L%20120%20105.5%20L%20120%20133%22%20stroke%3D%22%23cbd5e1%22%20stroke-width%3D%222%22%20fill%3D%22none%22%2F%3E%3Crect%20x%3D%2240%22%20y%3D%22133%22%20width%3D%22160%22%20height%3D%2258%22%20rx%3D%228%22%20fill%3D%22white%22%20stroke%3D%22%230891b2%22%20stroke-width%3D%222%22%2F%3E%3Ctext%20x%3D%22120%22%20y%3D%22158%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2213%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3EMultiple%20Expansion%3C%2Ftext%3E%3Ctext%20x%3D%22120%22%20y%3D%22176%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2210%22%20fill%3D%22%2364748b%22%3E%2B%240%20%28held%20flat%29%3C%2Ftext%3E%3Cpath%20d%3D%22M%20300%2078%20L%20300%20105.5%20L%20300%20105.5%20L%20300%20133%22%20stroke%3D%22%23cbd5e1%22%20stroke-width%3D%222%22%20fill%3D%22none%22%2F%3E%3Crect%20x%3D%22220%22%20y%3D%22133%22%20width%3D%22160%22%20height%3D%2258%22%20rx%3D%228%22%20fill%3D%22white%22%20stroke%3D%22%230891b2%22%20stroke-width%3D%222%22%2F%3E%3Ctext%20x%3D%22300%22%20y%3D%22158%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2213%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3EEBITDA%20Growth%3C%2Ftext%3E%3Ctext%20x%3D%22300%22%20y%3D%22176%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2210%22%20fill%3D%22%2364748b%22%3E%24100M%E2%86%92%24130M%20EBITDA%3C%2Ftext%3E%3Cpath%20d%3D%22M%20300%2078%20L%20300%20105.5%20L%20480%20105.5%20L%20480%20133%22%20stroke%3D%22%23cbd5e1%22%20stroke-width%3D%222%22%20fill%3D%22none%22%2F%3E%3Crect%20x%3D%22400%22%20y%3D%22133%22%20width%3D%22160%22%20height%3D%2258%22%20rx%3D%228%22%20fill%3D%22white%22%20stroke%3D%22%230891b2%22%20stroke-width%3D%222%22%2F%3E%3Ctext%20x%3D%22480%22%20y%3D%22158%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2213%22%20font-weight%3D%22600%22%20fill%3D%22%230f172a%22%3EDebt%20Paydown%3C%2Ftext%3E%3Ctext%20x%3D%22480%22%20y%3D%22176%22%20text-anchor%3D%22middle%22%20font-family%3D%22system-ui%2C-apple-system%2Csans-serif%22%20font-size%3D%2210%22%20fill%3D%22%2364748b%22%3E%24300M%20swept%20down%3C%2Ftext%3E%3C%2Fsvg%3E)

*The three forces that drive every leveraged buyout return, with the worked example's dollar contribution from each.*

### Multiple Expansion

Selling at a higher EV/EBITDA than you bought for. A 1x expansion on $130M of EBITDA adds $130M to enterprise value, pure equity uplift. Multiple expansion was the dominant return driver from 2010-2021 when interest rates compressed; it's hostile to assume in today's higher-rate environment.

### EBITDA Growth

The most defensible return source. Growing EBITDA from $100M to $150M instead of $130M adds $200M of enterprise value at a 10x exit. Operational levers include pricing, cost takeout, and accretive add-on acquisitions ("buy-and-build" platforms).

### Debt Paydown (Deleveraging)

Every dollar of debt repaid is a dollar of equity created at exit. Sweeping $300M of cash flow into debt paydown directly converts to $300M of equity value, since enterprise value stays the same but net debt falls. Mathematically equivalent to multiple expansion on the equity portion of the cap stack.

## Typical LBO Debt Structures

Most leveraged buyouts use a layered capital structure that balances cost of capital, flexibility, and covenant package. A typical mid-market deal uses 5.5-6.5x EBITDA of total debt across two or three tranches plus sponsor equity.

- **Senior secured term loan B:** 40-50% of capital, SOFR + 350-500 bps, 1% annual amortization, 7-year maturity, leverage covenant
- **Subordinated/mezzanine debt:** 10-20% of capital, 10-13% coupon (often part PIK), bullet maturity, looser covenants
- **High yield bonds:** Alternative to mezz for larger deals, fixed coupon 7-10%, no maintenance covenants, deeper investor base
- **Sponsor equity:** 30-40% of capital, the "skin in the game" the LP base demands

The interest tax shield from this leverage is a real source of value, but Section 163(j) caps deductibility at 30% of EBITDA (post-2022, EBIT), a constraint that bites in highly levered deals and one every modeler must build into the tax line.

## Common LBO Model Conventions

Get these conventions right and your model will look like it came from a top-tier shop. Get them wrong and an interviewer will spot it in 30 seconds.

- **Mid-year discounting convention** for IRR, assumes cash flows arrive uniformly through the year, not on December 31
- **Transaction fees** of 2-3% of enterprise value (advisory, legal, accounting)
- **Financing fees** of 1-2% of debt raised, capitalized and amortized
- **Mandatory amortization** of 1% per year on term loans, with a 75-100% excess cash flow sweep
- **Interest tax shield** modeled explicitly, capped by Section 163(j) where applicable
- **Management equity rollover**, typically 10-20% of equity stub, often with a strip plus options package

## Sensitivity Analysis: The Football Field

A single-point IRR estimate is meaningless. Investment committees demand sensitivity tables, usually a two-way data table showing IRR across exit multiples (rows) and Year 5 EBITDA (columns), plus bear/base/bull scenarios. The full output is called a "football field" because it visually resembles one.

Sponsors also build a tornado chart ranking which assumptions move IRR the most, typically exit multiple, EBITDA growth rate, and entry multiple, in that order. The base case might show 20% IRR; the bear case (exit at 8x, 3% EBITDA growth) might show 8%; the bull case (12x exit, 7% growth) might show 32%. If the bear case still clears your fund's hurdle rate, you have a margin of safety.

## Key Metrics in an LBO Model

Sponsors report returns in three ways, each capturing a different dimension of performance.

- **IRR ([Internal Rate of Return](/blog/how-is-irr-calculated)):** the annualized [return on equity](/blog/calculate-roe), the most quoted PE metric
- **MOIC (Multiple on Invested Capital) / Money Multiple:** total distributions divided by total equity invested, captures absolute dollars made
- **DPI (Distributions to Paid-In):** at the fund level, cash actually returned to LPs, distinguishes paper gains from realized cash
- **Cash-on-cash multiple:** simple ratio of cash returned to cash invested, ignoring time

A 2.5x MOIC over five years equals roughly a 20% IRR; a 2.0x over four years also equals roughly a 19% IRR. Time is the silent variable that makes IRR diverge from MOIC.

## Famous LBOs and Their Model Structures

History's landmark buyouts illustrate how LBO model assumptions translate into outcomes.

- **RJR Nabisco (1989):** KKR's $25B leveraged buyout, the largest LBO of its era, chronicled in *Barbarians at the Gate*. Junk-bond financed, ultimately a modest return for KKR
- **HCA (2006):** $33B Bain/KKR/Merrill take-private; later refloated; a textbook case of leverage + operational improvement + [dividend recap](/blog/dividend-recapitalization)
- **Hilton Hotels (2007):** Blackstone's $26B deal closed at the cycle peak, looked dead in 2009, ultimately delivered a $14B profit, multiple expansion plus EBITDA recovery
- **Dell (2013):** $24B founder-led take-private with Silver Lake; used the LBO to restructure away from public-market scrutiny

## Common LBO Model Mistakes

The errors below show up in 80% of student and junior-analyst LBO models.

- Over-aggressive entry/exit multiples (assuming you'll always sell at a premium)
- Underestimating capex, especially maintenance capex on capital-intensive businesses
- Ignoring working capital growth as revenue scales
- Not stress-testing with a real downside case (revenue down 10%, margins down 200 bps)
- Forgetting Section 163(j) interest deductibility limits in highly levered deals
- Mismatching the debt sweep with the cash flow waterfall, circular reference errors
- Booking transaction fees as expense rather than capitalized

## The Paper LBO and Interview Prep

The paper LBO is the classic PE interview test, build a simplified leveraged buyout model on paper or in your head in 5-10 minutes. Standard prompt: "Sponsor buys a company for $500M at 10x EBITDA, finances 60% with debt, holds for five years, exits at 10x. EBITDA grows from $50M to $80M. What's the IRR?"

Walk the interviewer through entry equity ($200M), exit EV ($800M), debt paid down (estimate $150M), exit equity ($800M minus remaining $150M = $650M). $200M to $650M over five years is roughly 3.25x MOIC, or about 27% IRR. Practice this until it's reflex. Modern modeling tools, Excel still dominates, but Causal, Pigment, and AI-assist plugins are gaining ground, won't help you in the interview room.

## Authoritative Sources

For deeper background and primary-source data on this topic, the following authoritative sources are useful starting points:

- [IRS](https://www.irs.gov/)
- [SEC](https://www.sec.gov/)
- [Federal Reserve](https://www.federalreserve.gov/)

## Conclusion

The leveraged buyout model is more than a spreadsheet, it's the analytical engine of an entire asset class. Master the seven-step build, internalize the three return drivers, and you can pressure-test any buyout thesis on a Saturday morning.

Five takeaways for anyone learning to model LBOs:

1. The model exists to solve for return, not value, sponsors back into the price that delivers a 20%+ IRR
2. Multiple expansion, EBITDA growth, and debt paydown are the only three return drivers that matter, every value-creation plan maps to one of them
3. The debt schedule is where junior modelers get tripped up; build it tranche-by-tranche with a clean cash flow waterfall
4. Sensitivity tables are not optional, investment committees want to see the bear case clear the hurdle rate
5. Section 163(j), capex, and working capital are the three line items that quietly destroy IRR if you ignore them

LBO modeling is converging with AI-assisted scenario generation and real-time data feeds, but the underlying logic, sources and uses, debt waterfall, exit math, has not changed since the 1980s and won't anytime soon. Whether you're prepping for a PE interview, evaluating a take-private, or just learning how the buyout industry thinks about money, fluency in the LBO model pays dividends for an entire career.

Ready to put this knowledge to work? Try Warren, your AI financial advisor, get personalized, conflict-free guidance at heywarren.com

---


## Related Reading

**More from Warren**:
- [Corporate Debt Restructuring Meaning: How Companies Renegotiate Debt to Survive Financial Distress](/blog/corporate-debt-restructuring-meaning)
- [Leveraged Gold ETF: How They Work, Top Funds, and Key Risks](/blog/leveraged-gold-etf)
- [APY vs. APR: The Critical Difference in Interest Rate Calculations](/blog/apy-vs-apr)

**Authoritative sources**:
- [SEC, Mergers & Acquisitions](https://www.sec.gov/fast-answers/answersmergershtm.html)
- [SEC EDGAR, Company Filings](https://www.sec.gov/edgar/searchedgar/companysearch)
- [Federal Trade Commission, Premerger Notification](https://www.ftc.gov/enforcement/premerger-notification-program)