LBO Model: Step-by-Step Guide With Excel Template

An lbo model is the financial model that private equity firms use to estimate the equity return on a leveraged buyout: a transaction where most of the purchase price is funded with debt, the acquired company services that debt from its own free cash flow, and the sponsor exits five to seven years later by selling, recapitalizing, or taking the company public. This guide walks through the lbo model step by step, shows the math behind every line, cites the 2026 market data that drives the assumptions, and explains what makes a deal pencil at a 20% or higher sponsor IRR.

If you have ever opened a sponsor template from Wall Street Prep, Macabacus, or a megafund associate program and felt the model was deliberately mystifying, the goal here is to demystify it. We will build a working example around a $50 million EBITDA business at a 7.5x entry multiple, walk every tab from sources and uses through the equity waterfall, anchor pricing on the live Federal Reserve H.15 SOFR release and LSTA leveraged loan market data, and show how the same five levers determine whether the deal returns 23% IRR or breaks even. The full Excel companion to this guide is described at the end of Step 2.

What an LBO Model Calculates

An lbo model exists to answer one question: if a sponsor writes an equity check of X today, services debt with the target’s free cash flow for five years, and sells the business at an assumed exit multiple, what is the internal rate of return on that equity check? Everything else in the model is plumbing. The operating projection produces EBITDA and free cash flow. The debt schedule converts free cash flow into debt paydown. The exit assumption converts year-five EBITDA into enterprise value. The waterfall subtracts remaining debt and management equity to land on sponsor equity proceeds. The IRR formula compares sponsor equity at close to sponsor equity at exit.

What an lbo model does not do is predict the future. It is a sensitivity engine. The output any deal team cares about is not the base case IRR; it is the range of IRRs across a grid of entry multiples, exit multiples, EBITDA growth rates, and leverage assumptions. A model that returns 23% in the base case but 7% if the exit multiple compresses by one turn is a fragile deal, even if the central estimate looks attractive.

The leveraged buyout itself is a specific structure: the sponsor uses third-party debt for 50-70% of the purchase price, the target’s own balance sheet and cash flows secure that debt, and the equity check fills the gap. This is structurally different from a strategic acquisition (where the acquirer’s balance sheet funds the deal) or a growth equity investment (where new equity dilutes existing owners without adding debt). For background on adjacent structures, see our guides on the management buyout and the recapitalization, which uses an LBO-style debt raise without a full change of control.

The 7-Step LBO Model Framework

Every LBO model, from a one-tab paper exercise to a 40-tab Bain Capital working file, is built from the same seven steps:

1. Step 1. Transaction assumptions and entry valuation.
2. Step 2. Sources and Uses of funds.
3. Step 3. Operating projections (3-statement build).
4. Step 4. Debt schedule, SOFR-linked pricing, and covenants.
5. Step 5. Exit assumptions, IRR, MOIC, and the value-creation bridge.
6. Step 6. Sensitivity and scenario analysis.
7. Step 7. Management Incentive Plan and equity rollover.

The order matters because each tab depends on outputs from the prior. Sources and Uses fixes the equity check that anchors returns. The operating model produces the free cash flow that drives the debt schedule. The debt schedule determines the year-five debt balance that backs out of enterprise value to give sponsor equity at exit. Sensitivity tables sit on top and require live references back to every assumption tab.

Step 1: Transaction Assumptions and Entry Valuation

Step 1 fixes the inputs that drive everything downstream: LTM EBITDA, entry multiple, total enterprise value, premium over current trading or book value, and the close-date balance sheet adjustments (excess cash, existing debt to refinance, transaction expenses, financing fees).

For our worked example, the target generates $50 million of LTM EBITDA. The sponsor agrees to pay a 7.5x entry multiple, producing a $375 million purchase price for equity. The process attracted four sponsor bids and two strategic bids; the winning bid included a 35% premium to the unaffected share price for the public-to-private structure. Deal closes January 1, year one.

Entry multiples for sponsored mid-market LBOs in 2026 have settled at 7.0x-9.0x for industrial and business services, 9.0x-11.0x for healthcare services and consumer staples, and 12.0x-18.0x for software and recurring-revenue tech-enabled platforms, per the PitchBook LCD first-half 2026 review. The 7.5x here is consistent with a high-quality business-services platform at $250M of revenue and 20% EBITDA margins.

Entry valuation also fixes the assumed premium, the breakup fee mechanics, and the reverse termination fee. The CD&R take-private of Sealed Air announced in early 2026 priced equity at $42.15 per share, a 35% premium to the unaffected price, with an RTF of roughly 4% of equity value payable to the seller if the sponsor failed to close on its financing commitment, per the proxy filing on SEC EDGAR. The Silver Lake / PIF / Affinity Partners $55B take-private of Electronic Arts (the largest PE buyout in history) and the Sycamore Partners $23.7B take-private of Walgreens Boots Alliance set similar 30-40% premium ranges with RTFs scaled to deal size, per Cleary Gottlieb’s M&A 2025 in Review and Look Ahead to 2026.

For a fuller treatment of how operating projections feed sell-side valuation work, see how investment bankers value a business.

Step 2: Sources and Uses of Funds

The sources and uses table enforces a basic accounting identity: total dollars going into the deal (sources) must equal total dollars paying for the deal (uses). If the two sides do not tie, the rest of the model is broken.

For our worked example, the deal closes with the following structure:

Total debt is 5.5x EBITDA ($275M), at the upper end of what the leveraged loan market supports in mid-2026 for a middle-market industrial business. Per PitchBook LCD’s 2026 US Private Credit Outlook, average total leverage on US sponsored LBOs ran 5.0-5.5x through 1H 2026, with senior leverage rarely above 5.0x outside software and recurring-revenue verticals. The same report flagged $120B of private credit issuance for the year, down 15% YoY, with spreads forecast steady-to-wider as more deals print.

The 22.7% equity check ($85M / $375M) is on the lower end of post-2022 norm. Sponsors that wrote 30%+ during the 2023-2024 rate spike are back to 20-25% as base rates stabilized and spreads tightened, per LSTA tracking. Management rollover of 15% is typical for founder-owned businesses; sellers reinvesting 10-20% of proceeds signals confidence. The $10M minimum cash is a working capital cushion, covenant buffer, and liquidity source for unplanned capex or earnouts.

Transaction expenses of $8M (~2% of TEV) covers legal, M&A advisory, QofE, environmental, insurance, and tax structuring. Financing fees of $7M (~2.5% of new debt) covers the arranger fee, OID, credit-agreement legal, and ticking fees if committed months before close. Both get capitalized and amortized over the life of the debt.

Excel template: what gets shipped to a CT sell-side seller

Free Excel templates that walk through the same Sources and Uses build are hosted by University of Pennsylvania Career Services (one of the cleanest single-tab versions), A Simple Model (a per-lesson curriculum with five downloadable files), and Macabacus (short-form and long-form files, the long-form derived from models used by four bulge-bracket banks).

On CT Acquisitions sell-side mandates, sellers receive a private working file integrating these mechanics with their specific business: actual LTM EBITDA with quality-of-earnings adjustments, current capital structure ready for refinancing, an operating model built off the seller’s own forecast (not a generic template), and a buyer-perspective LBO build for each of the most likely sponsor bidders. The file gets used inside the M&A process, not posted publicly. Sellers who want to see how their business pencils at a range of entry multiples can request a walkthrough.

Step 3: Operating Projections (Revenue, EBITDA, Capex, Working Capital)

The operating model is the part that the analyst spends the most time on and the part that, paradoxically, matters the least to the final IRR. Most LBO returns come from leverage and multiple expansion, not from beating the operating plan. the operating model has to be defensible because the lender’s credit committee will stress test every line.

For our $50M EBITDA business, assume the following base case build:

Capex of roughly 3% of revenue assumes a light-asset business; an industrial manufacturer runs 4-6%, a hard-asset distribution platform or specialty contractor 5-8%, per operating benchmarks PitchBook LCD publishes by GICS sub-sector. Net working capital absorbs roughly 15% of incremental revenue, a defensible blended assumption for a B2B services or light-manufacturing business.

The margin expansion from 20.0% to 22.5% over five years is the single most contested assumption in any sponsor model. Sellers and bankers argue for it; lenders haircut it. The 250-bps pickup here is moderate, justified by pricing actions, fixed-cost absorption from volume growth, and one or two operational levers identified in diligence. A sponsor model that assumes 500-1,000 bps of margin expansion off identified levers alone is a red flag.

Cash interest in year one ($24.5M) ties to the debt schedule in Step 4. Cash taxes assume a 25% effective rate, slightly above the 21% federal statutory rate to account for state taxes, applied to EBIT less interest expense. The actual rate after the section 163(j) interest deduction limitation (capped at 30% of EBIT under TCJA changes effective 2022) can run higher for highly leveraged deals, covered in the modeling mistakes section below.

Step 4: Debt Schedule, SOFR-Linked Pricing, and Covenants

The debt schedule is where the leveraged buyout becomes a leveraged buyout. It is also the tab where most modeling errors hide, because the interaction between mandatory amortization, optional prepayment from the cash sweep, and PIK accrual is fiddly to get right.

Our deal has two tranches:

Senior secured term loan B ($250M). Priced at SOFR + 450 basis points with a 0.50% SOFR floor and 1.5% OID. With 1-month Term SOFR at roughly 5.32% per the Federal Reserve H.15 data download in early June 2026, the all-in cash coupon is approximately 9.82%. Mandatory amortization of 1.0% per year ($2.5M), 100% excess cash flow sweep above a $10M minimum cash balance with a step-down to 50% if first-lien net leverage falls below 4.0x, six-year maturity. For context on how the H.15 release is constructed and how the daily SOFR observation is calculated, the Fed’s H.15 About page documents the methodology.

Subordinated notes ($25M). Priced at SOFR + 950 basis points with a PIK toggle. The borrower can elect to pay interest in cash or accrue it to principal. Cash coupon is roughly 14.82% if paid in cash; if PIKed, principal grows at the same rate. Bullet maturity in year seven, structurally subordinated to the term loan B. Spreads on sponsor-backed second-lien and subordinated paper compressed roughly 100-150 bps from early 2024 highs as private credit funds raised fresh capital and competed harder for primary issuance, per the PitchBook LCD 2026 Outlook.

Here is the senior term loan schedule for the first three years:

By the end of year five, the term loan balance is roughly $137M, the sub debt sits at $25M (assuming cash-pay throughout), and total debt is $162M against $71.1M of year-five EBITDA, or 2.3x net leverage. That deleveraging is what creates the sponsor equity value at exit.

Covenant package: incurrence vs maintenance

Modern sponsored TLB documents in 2026 are largely covenant-lite: incurrence-based covenants (tested only on defined actions like new debt or dividend payments) with no quarterly maintenance test. The relevant ratios are total leverage, first-lien net leverage, secured leverage, and interest coverage. For our deal: total leverage 7.00x (incurrence, new debt), first-lien net leverage 5.50x (incurrence, new senior), fixed charge coverage 2.00x (incurrence, restricted payments), and a springing financial maintenance covenant at 7.00x first-lien net leverage tested only when revolver utilization exceeds 35%.

The springing covenant is the meaningful one: a sponsor that has not drawn the revolver faces no quarterly compliance test, but a sponsor that has drawn the revolver to fund working capital in a downside year suddenly faces a maintenance test that can trip on a bad quarter. LSTA covenant data shows excess cash flow sweep mechanics in over 80% of sponsored TLBs by deal count, and springing maintenance covenants in roughly 70%.

Three debt-schedule mechanics that trip up most analysts

First, the 100% cash sweep tier is what middle-market TLB documents typically negotiate to in 2026. Larger deals (over $500M of debt) can negotiate a 50% sweep that steps down to 25% as leverage falls below 4.5x; the step-down can swing year-three-to-five debt balances by $20-40M on a 5.5x deal. Second, interest expense should be calculated on the average balance, not the opening balance; using opening overstates interest by roughly half the year of amortization. Third, the PIK toggle on subordinated notes is genuinely optional: in a stressed year the sponsor can elect PIK to preserve liquidity; a sensitivity that PIKs the sub debt in years one and two adds roughly $4M to the year-five debt balance and trims sponsor IRR by 50-80 bps.

Private credit vs broadly syndicated term loan B

For a deal of this size ($275M total debt), the choice between a broadly syndicated TLB sold to a bank-led syndicate and a directly originated unitranche from a private credit fund is live in 2026. BSL pricing on our $250M senior tranche lands at roughly SOFR + 450 with 1.5% OID; a unitranche from a Blue Owl, Ares, or HPS-led club prices at SOFR + 525-575 with no OID but delivers speed (two to three weeks vs eight to twelve), covenant flexibility, and no public ratings requirement. PitchBook LCD’s 2026 outlook documents the BSL-to-private-credit pricing gap narrowing to roughly 75-125 bps from a 200-bps gap in 2023.

Step 5: Exit Assumptions, IRR, MOIC, and the Value-Creation Bridge

The exit is the second largest driver of sponsor returns after entry multiple. The convention in lbo model work is to assume the sponsor exits at the same EBITDA multiple as entry (multiple-neutral case), then sensitize one turn up and one turn down. For our base case, assume an exit at year five at 8.0x (0.5x of expansion off the 7.5x entry):

The two return metrics every lbo model produces are IRR (annualized compounded return) and MOIC (cash-on-cash multiple). IRR rewards speed; MOIC rewards size. A deal can have a great IRR and a mediocre MOIC (a quick flip at 2.0x in three years) or vice versa (4.0x in nine years). Base case math:

That is well above the 20-25% range most middle-market sponsors target. It lands so high because of 22.7% equity check (high financial gearing), 0.5x of multiple expansion at exit, and 42% cumulative EBITDA growth. Strip out either the expansion or the growth and the IRR falls to 23-24%, the more typical base case.

The value-creation bridge

Sponsors and LPs expect the model to decompose IRR into its three components: EBITDA growth, multiple expansion, and debt paydown. This is the value-creation bridge. For our base case:

For a flat-EBITDA, flat-multiple deal (pure financial engineering), 100% of returns come from debt paydown and the math caps out at 1.7-2.0x MOIC even at maximum leverage. For an operations-driven platform-and-build deal, EBITDA growth and multiple arbitrage typically account for 65-75% of value created, debt paydown for 25-35%.

Step 6: Sensitivity and Scenario Analysis

Every lbo model ends with sensitivity because no investment committee will approve a deal on a single base case. The standard output is a two-variable data table (in Excel: Data > What-If Analysis > Data Table) showing IRR (and a second showing MOIC) across pairs of the most important inputs. Here is IRR sensitivity for our worked example across entry and exit multiple, holding operating plan and debt structure constant:

Each 0.5x of entry multiple costs roughly 3 ppts of IRR; each 0.5x of exit multiple adds 3 ppts. The bid-ask spread between sponsor offer and seller reservation price is often just half a turn, which is why deal teams spend so much time arguing about the last 25 bps of an EBITDA multiple in LOI negotiations.

The five variables that move IRR most: entry multiple (linear; 7.5x vs 8.0x is worth 300 bps), exit multiple (same magnitude, opposite direction), EBITDA growth rate (200 bps of CAGR over five years moves IRR by 250-400 bps), leverage at close (each additional 0.5x adds roughly 150 bps, capped by what credit will support), and interest rate (each 100 bps of higher cost of debt costs 80-120 bps of IRR depending on leverage level).

Downside / recession scenario

Beyond the 5×5 grid, the model should run a recession scenario: revenue flat in year one, down 5% in year two, recovering to 3% growth from year three; EBITDA margins compressing 200 bps in the down year; PIK elected on sub debt in years one and two; exit multiple compressing 1.0x at year five. The base case 23% IRR / 2.6x MOIC drops to roughly 8% IRR / 1.4x MOIC, and year-three covenant headroom is at risk if revolver utilization triggers the springing maintenance test. PitchBook LCD’s 2026 outlook flagged spreads as steady-to-wider through the year, so any new-money refinancing in a stressed scenario would price 100-200 bps wider than the original deal.

Step 7: Management Incentive Plan and Equity Rollover

The Management Incentive Plan (MIP) is the equity pool reserved for the CEO, CFO, and senior operating team. It dilutes the sponsor and the rollover, vests over the hold period, and pays out at exit. The MIP is the single most important alignment mechanism in a sponsored LBO because it aligns the CEO’s economic incentives with the sponsor’s return target.

Standard MIP structuring in 2026: Pool size 8-12% of fully diluted equity at exit (CEO 30-40% of the pool, CFO 15-20%, COO and CRO 10-15% each, balance to the next layer of operating leaders). Vesting 50% time-based over five years (20% per year on the anniversary of close), 50% performance-based tied to MOIC hurdles (e.g. 50% at 2.0x MOIC, 75% at 2.5x, 100% at 3.0x). Strike price at the per-share equity price at close, so the MIP only has value if equity value grows. Hurdles in mezzanine-financed deals sometimes require an 8% sponsor IRR before common (including MIP) participates. Treatment on exit: unvested options accelerate at change of control; vested options cash out at the per-share exit price.

For our worked example, assume an 8% MIP pool issued at close with 50/50 time/performance vesting and 100% acceleration on change of control. At the year-five exit with $416.8M of pre-MIP equity value, MIP dilution is roughly $33.3M, reducing combined sponsor-and-rollover proceeds to $383.5M. Allocated 85/15, the sponsor receives $326.0M (vs $354.3M in the simpler model that omits MIP). IRR drops from 33.0% to 30.8%. MIP dilution is real and should be modeled; the headline IRR overstates by 200-250 bps if MIP is ignored.

Reps and warranties insurance as a deal line item

Older lbo model templates miss reps and warranties insurance (RWI). In 2026, virtually every sponsored LBO carries an RWI policy covering breaches of the seller’s reps. The cost runs 2.5-3.5% of policy limit (typically sized at 10% of TEV), with 0.5-1.0% retention. For our $425M TEV deal, a $42.5M policy at 3.0% costs roughly $1.3M up front plus $50K-$100K of underwriting fees. This sits inside the $8M transaction expenses bucket but deserves its own line in any model shown to an LP.

Paper LBO Worked Example (Four-Minute Walkthrough)

The paper LBO is the back-of-envelope calculation PE associates run during interviews and the first 24 hours of evaluating a new deal. It compresses the lbo model into a five-minute mental exercise. Classic prompt: “Walk me through an LBO of a $200M EV business at 6.0x EBITDA, 50% debt, five-year hold, exit at the same multiple.” The answer:

Entry math. $200M EV at 6.0x implies $33M LTM EBITDA. 50% debt = $100M; 50% equity = $100M. Sponsor writes a $100M check.

Operating projection. Assume 5% revenue growth, flat margins. EBITDA grows from $33M to $42M over five years (1.05^5 = 1.276).

Free cash flow and debt paydown. Interest at 9%, so $9M of year-one cash interest declining as debt amortizes. Cash taxes 25% on EBIT (EBITDA less ~$5M of D&A). Capex roughly equal to D&A. NWC roughly neutral. Annual FCF averages $18M, cumulative roughly $90M, all of which pays down debt. Year-five debt is roughly $10M.

Exit and returns. 6.0x x $42M = $252M EV. Less $10M debt = $242M equity value. $100M check produced $242M of proceeds: MOIC = 2.42x, IRR = (2.42)^(1/5) – 1 = 19.3%.

That math takes 90 seconds to recite. The interviewer is testing whether you understand the levers, not whether you can build a model. For a fully worked-out version see paper LBO example walkthrough.

What Makes a Great LBO Target?

Not every business pencils as an LBO. The debt service requirement filters out anything cyclical, capital-intensive, or unpredictable. The textbook ideal LBO candidate has stable recurring revenue (subscription, contract, repeat-customer, with year-over-year revenue 90%+ predictable); strong free cash flow conversion (60%+ of EBITDA after capex, working capital, and taxes; software hits 70-80%, industrial services 50-65%); low capex intensity (under 3-4% of revenue for maintenance); a defensible market position (pricing power, switching costs, regulatory or technical moat); a fragmented industry that supports buy-and-build (largest player at $50M EBITDA in a $5B market with hundreds of $5-10M competitors); asset coverage (tangible assets that secure lender collateral); and a management team willing to roll over 15-25% of their proceeds.

Businesses missing one criterion can still be LBO-able with structural mitigants: a cyclical business with strong asset coverage and lower leverage, a high-capex business with a contracted-revenue model and an asset-based loan. The more boxes the business ticks, the more sponsors will compete for it and the higher the multiple it will command.

Real 2025-2026 LBO Case Studies

The conventional case studies used in lbo model teaching are RJR Nabisco (1989), TXU Energy (2007), and HCA (2006). Those deals taught the industry what worked and what blew up, but they are 20+ years old and reflect a financing market that no longer exists. Three 2025-2026 deals give a much better picture of how the modern LBO actually structures.

Silver Lake + PIF + Affinity Partners take-private of Electronic Arts ($55B, 2026)

Announced in 2026 and widely reported as the largest PE buyout in history, the Silver Lake-led consortium take-private of Electronic Arts illustrates the modern megadeal financing stack: common equity from three sponsors, preferred equity, syndicated term loans, high-yield bonds, and direct loans from private credit. The capital structure shifted the boundary between public and private markets for a business with $7.5B+ of annual revenue, predictable subscription-and-services cash flow, and a deep franchise IP portfolio. The deal is the clearest evidence of the structural trend Cleary Gottlieb flagged for 2026: ample sponsor dry powder meeting public-market dislocation produces the conditions for record take-privates.

Sycamore Partners take-private of Walgreens Boots Alliance ($23.7B, 2025)

The Sycamore Partners take-private of Walgreens Boots Alliance, announced in 2025 at roughly $23.7B including assumed debt, is a case study in retail-and-pharmacy LBO mechanics. The deal contemplated a post-close split into separately financed pharmacy and pharmacy-benefit-management businesses, with divisional cash flows ring-fenced to support tranche-specific leverage. The structure used the OpCo / PropCo / IPCo carve-out architecture that allows a sponsor to apply different leverage multiples to different cash flow streams within a single platform. Sycamore’s reverse termination fee, payable to Walgreens if the deal failed to close on its financing commitment, ran into the high hundreds of millions per the proxy filings available on SEC EDGAR.

Clayton, Dubilier & Rice take-private of Sealed Air (2026)

The CD&R take-private of Sealed Air at $42.15 per share announced in early 2026 is the cleanest mid-cap take-private case study available. The deal priced at a 35% premium to the unaffected stock price, used roughly 6.0x total leverage with senior secured term loans and second-lien notes, and carried CD&R’s operating-partner playbook focused on commercial excellence and SG&A. The proxy filed on SEC EDGAR documents the financing commitments, the sources-and-uses, and the management retention plans, which is rare for a deal of this size.

Capital Structure: Senior vs Sub Debt vs PIK vs Preferred

The capital structure determines how much debt the deal can carry, what it costs, and how the cash flow waterfall sequences. Modern sponsored LBOs in 2026 use one of four configurations: single-tranche TLB (4.0x or below, SOFR + 350-500 bps per PitchBook LCD), TLB plus subordinated notes (5.0-6.0x, our example), TLB plus mezzanine (6.0-7.0x, mezz priced 11-14% cash plus 2-4% PIK plus warrants for 1-3% of common equity at exit), or TLB plus preferred equity (preferred at 10-13% PIK dividend, sits between debt and common in the waterfall).

The choice is a tradeoff between cost of capital, covenant flexibility, and equity dilution. PIK and preferred preserve cash flow during the hold (good for covenant compliance and for sweeps redirected to TLB paydown) but compound over time and reduce equity proceeds at exit. Cash-pay structures cost more during the hold but leave a larger sponsor stake at exit.

Modeling Add-On Acquisitions and Roll-Up Multiple Arbitrage

The buy-and-build (or platform-and-add-on) strategy is the dominant sponsor playbook in the middle market in 2026. The model needs to handle add-ons cleanly, because failing to do so either understates returns (by ignoring the value creation from add-on multiple arbitrage) or overstates returns (by assuming add-ons are free).

A clean add-on model includes a separate section per add-on with inputs for timing, purchase price (multiple of the add-on’s standalone EBITDA), financing (accordion or delayed-draw term loan plus sponsor equity contribution), revenue and cost benefits (phased in over 12-24 months), and integration costs.

The value creation thesis rests on three legs. Multiple arbitrage is usually the largest: the platform was acquired at 8x and each add-on at 5-6x because smaller businesses trade at a discount; at exit the combined entity is valued at 8-9x, so 2-3 turns of arbitrage on each add-on flow directly to sponsor equity. A platform that acquires three $10M EBITDA add-ons at 5.5x and exits the combined entity at 8.5x captures roughly $90M of multiple arbitrage value, independent of any operational improvement. Cost takeouts from procurement consolidation, SG&A overlap removal, IT system consolidation, and cross-sell typically run 5-15% of add-on revenue, achieved 12-24 months after close, with one-time integration costs of 0.5-1.0x the run-rate figure. Strategic scale benefits at exit (a larger buyer universe and more bargaining power with customers and suppliers) compound on top.

For sellers thinking about how their business fits into a sponsor’s add-on pipeline, our guide on business valuation services cost walks through the diligence and valuation process from the seller side.

Dividend Recaps as Return Enhancers

A dividend recapitalization is a hold-period transaction where the sponsor refinances existing debt with a larger new facility and distributes the incremental proceeds as a special dividend to equity holders. It crystallizes a partial return of capital ahead of the eventual exit, which improves IRR (by pulling forward cash flows) without changing MOIC.

Typical profile: completed in year three of a five-year hold, after EBITDA growth has paid down original debt to 4.0x or below; the recap pushes leverage back to 5.0-5.5x via a new TLB, with incremental proceeds (1.0-1.5x EBITDA) flowing as a dividend. For our worked example, a year-three recap pushing leverage back to 5.0x distributes roughly $50M to equity ($42.5M to sponsor, $7.5M to rollover). The IRR effect: $42.5M of pulled-forward cash arrives two years earlier, lifting IRR by 200-300 bps without changing the year-five MOIC of 2.6x.

LBO Model vs DCF vs M&A Merger Model

The lbo model, the discounted cash flow (DCF) model, and the M&A merger model are the three workhorse valuation models in corporate finance. They solve different problems.

The three are complementary. A sell-side advisor running a competitive process on a $300M business builds all three: a DCF to anchor the seller’s reservation price, an LBO to estimate what sponsors will pay, and an accretion-dilution to estimate what each strategic can pay. The final negotiation range is the intersection.

Common LBO Model Mistakes That Crush Returns

After reviewing hundreds of sponsor models on sell-side mandates, the same errors show up. None are exotic; they are the everyday mistakes that make a model overstate returns by 200-500 bps.

1. Using opening debt balance for interest expense. Inflates year-one interest by half of the year’s amortization. Fix: use average balance, or accept the conservatism of ending balance.

2. Forgetting to capitalize and amortize financing fees. The $7M of financing fees in our example sits on the balance sheet and amortizes over the life of the debt. Skipping this overstates EBITDA and understates the closing leverage ratio.

3. Ignoring the 163(j) interest deduction limitation. Interest deductibility is capped at 30% of EBIT (not EBITDA, after TCJA changes effective 2022). For highly leveraged deals this defers or eliminates a meaningful share of the interest deduction; a model using 25% effective taxes when the actual post-163(j) rate is 32% overstates free cash flow by 7-10%.

4. Modeling cost takeouts with no execution cost. Every dollar of run-rate cost takeout on an add-on requires 50-100 cents of one-time integration cost in the year achieved.

5. Assuming working capital is linear. Most middle-market businesses have lumpy working capital cycles tied to seasonality, customer concentration, or supplier payment terms. A flat 15% of incremental revenue is a placeholder. Lenders will stress test with a 30-day shock to DSO and DPO.

6. Missing management rollover dilution at exit. The 15% rollover at entry stays 15% at exit. Add 8-12% MIP dilution on top and the sponsor share at exit is often 73-77%, not 100%.

7. Using a flat exit multiple equal to entry without sensitivity. A sponsor that cannot articulate why the business will trade at the same or higher multiple in five years is making an unstated assumption.

8. Including a covenant cushion that the credit agreement does not provide. Modern TLB documents are largely covenant-lite, but many 5.5x+ deals carry a springing financial maintenance covenant tied to revolver utilization. Assuming fully covenant-lite when a 7.0x springing test exists underestimates downside-case default risk.

9. Ignoring RWI premium and ticking fees. RWI is 2.5-3.5% of policy limit; ticking fees on committed financing accrue between signing and close at 50-100 bps per year of the unfunded commitment. Together $2-5M of cost on a $400M deal that older templates miss.

10. Underweighting the reverse termination fee on regulated deals. For deals requiring antitrust or sector-specific approval, the RTF runs 4-8% of equity value vs the 2-3% baseline. Cleary Gottlieb’s 2025 M&A year-in-review documents the upward drift in RTF size on take-privates of regulated assets.

How CT Acquisitions Uses LBO Models in Sell-Side Mandates

On sell-side engagements, CT Acquisitions builds an lbo model from the buyer’s perspective for every PE-led process. The point is not to share it (we keep our work private) but to know what the sponsor will build before they build it, anticipate the bid that will result, and prepare the seller for the range of offers we expect.

The workflow: Step 1. Reverse-engineer the sponsor’s IRR target. Middle-market sponsors target 20-25% gross IRR; lower-middle-market sponsors push 25-30%. Anchor on 23%. Step 2. Build the sponsor’s model with realistic assumptions, tuning EBITDA margin expansion, capex, and working capital to the business’s actual profile and using the debt structure current market supports (5.0-5.5x for industrial and services, 6.0-6.5x for healthcare and tech-enabled, per PitchBook LCD sector benchmarks). Step 3. Solve backward for the entry multiple that produces the target return; that is the sponsor’s stretch bid. Initial bid comes in 0.5-1.0x lower, final bid 0.25-0.5x lower. Step 4. Compare against strategic bidders, who typically pay 0.5-1.5x above the sponsor stretch because they have cost takeouts the sponsor does not, lower cost of capital, and strategic value beyond pure financial return.

The output goes to the seller, in the form of a valuation range defended with bottom-up math rather than just a comparable-multiples table. For the broader sell-side process, see our overview of top private equity firms you should know, which covers the buyer universe we engage in competitive processes. For the mechanics of how investment bankers approach valuation across DCF, comparable-company, and precedent-transaction methods, see how investment bankers value a business.

LBO Model: Frequently Asked Questions

What is an LBO model in simple terms?

An LBO model is a spreadsheet that calculates what a private equity firm will earn on its equity investment in a leveraged buyout. The firm borrows most of the money to buy the company, uses the company’s own cash flow to pay down that debt for five years, then sells the company. The model shows the equity return (IRR and MOIC) across a range of operating, financing, and exit assumptions. It is built in seven linked tabs: transaction assumptions, sources and uses, operating projection, debt schedule, returns, sensitivity, and management equity.

How do you build an LBO model step by step?

Build it in seven steps. Step 1: fix the entry valuation (LTM EBITDA times entry multiple). Step 2: build sources and uses (debt plus equity equals purchase price plus fees plus minimum cash). Step 3: project five years of revenue, EBITDA, capex, working capital, and free cash flow. Step 4: build the debt schedule with mandatory amortization, cash sweep, and PIK accrual for each tranche, priced off live SOFR per the Federal Reserve H.15 release plus the appropriate credit spread. Step 5: exit enterprise value (year-five EBITDA times exit multiple) minus remaining debt and management equity, then solve for sponsor IRR and MOIC. Step 6: sensitivity tables across entry multiple, exit multiple, EBITDA growth, and leverage. Step 7: layer in MIP dilution and equity rollover.

What is the difference between LBO and DCF?

An LBO solves for the IRR a sponsor earns on its equity given a defined hold and exit multiple. A DCF solves for intrinsic value by discounting projected free cash flows at WACC to perpetuity. LBOs use heavy debt schedule mechanics and short hold periods; DCFs use lighter financing detail and perpetuity terminal values. The LBO tells you what a sponsor will pay; the DCF tells you what the business is worth standalone. Sell-side advisors build both as bookends on a valuation range.

What is a good IRR for an LBO?

Sponsors underwrite to a 20-25% gross IRR base case before fund-level fees. Lower-middle-market sponsors push 25-30% on smaller, riskier platforms. Megafund deals over $1B equity check underwrite to 18-22% because absolute dollar returns at scale drive fund performance. Realized gross IRRs on US PE buyout funds vintages 2015-2019 came in around 17-22% after fund-level dilution, per PitchBook benchmarks. A 23% IRR base case with 17-18% downside and 30%+ upside is the typical IC-ready profile.

What is a typical LBO debt-to-equity ratio?

Sponsored LBOs in 2026 capitalize at 70-80% debt and 20-30% equity at close. A 5.5x total leverage / 8.0x TEV deal lands at 69% debt and 31% equity. A 6.5x / 9.0x deal lands at 72% / 28%. Software and recurring-revenue businesses with 7.0-8.0x leverage and 12-15x multiples land at 50-60% debt and 40-50% equity by dollar value even though the leverage multiple is higher. LSTA data tracks the median sponsored deal at roughly 70% debt by dollar value in mid-2026.

How does the debt schedule work in an LBO?

The debt schedule tracks each tranche through the hold period. For each tranche and year it shows opening balance, mandatory amortization, optional prepayment from the cash sweep, PIK accrual if applicable, and ending balance. Interest is calculated on average balance at the applicable rate, which for senior debt in 2026 is SOFR plus 350-500 bps for sponsored TLBs (sourced live from the Fed H.15 release). The cash sweep takes 100% of excess cash flow above a $10-20M minimum and applies it to the senior tranche until step-down triggers kick in. Sub debt and mezz typically receive no sweep and are bullet-maturity.

What is the difference between MOIC and IRR?

IRR is the annualized compounded return on invested equity, expressed as a percentage. MOIC (multiple on invested capital, sometimes called cash-on-cash multiple) is total cash returned divided by cash invested, expressed as a multiple. A 2.5x MOIC over five years is roughly a 20% IRR; 3.0x over five years is roughly 25% IRR. IRR rewards speed (a quick flip at 2.0x in two years is 41% IRR); MOIC rewards total return regardless of time. Most LP reporting shows both because they capture different dimensions of fund performance.

Walk me through an LBO (interview answer)?

“Sure. The sponsor buys the company at X times LTM EBITDA, funding 60-70% with debt and 20-30% with equity. The business runs for five years, growing EBITDA from Y to Z and using its free cash flow to pay down debt. At year five the sponsor sells at the same or higher EBITDA multiple, repays remaining debt, and equity proceeds split between sponsor and rollover. Sponsor IRR is (exit equity over entry equity) to the one-fifth power minus one. For a $200M EV deal at 6x with 50% debt, growing EBITDA at 5% a year and exiting at 6x, the sponsor earns roughly a 2.4x MOIC and a 19% IRR.” Practice this until it is automatic. It is the most asked PE interview question.

What is a paper LBO?

A paper LBO is a back-of-envelope calculation performed on paper or in your head, without Excel. It compresses the full lbo model into a four-to-five-minute exercise: entry EV, entry EBITDA, multiple, equity check, year-five EBITDA, exit multiple, debt paydown, sponsor equity at exit, MOIC, IRR. PE interviews use paper LBOs as a screen for whether the candidate understands the levers that drive returns. Full worked example: paper LBO example walkthrough.

What makes a good LBO candidate?

A good LBO candidate has stable recurring revenue, strong free cash flow conversion (60%+ of EBITDA after capex, working capital, and taxes), low capex intensity (under 4% of revenue), a defensible market position, a fragmented industry that supports buy-and-build, asset coverage to backstop lender recovery, and a management team willing to roll over 10-20% of proceeds. Textbook example: a B2B services platform with 90%+ retention, 20%+ EBITDA margins, and add-on M&A runway. Cyclical and capital-heavy businesses can still be LBO-able but require lower leverage and lower entry multiples.

How much equity do PE firms put into an LBO?

Sponsors in 2026 put in 20-30% of the purchase price as equity, balance funded by debt. A 5.5x leverage / 7.5x entry deal requires 27% equity; a 6.5x / 9.0x software deal requires 28%. Equity checks ran higher in 2023-2024 (30-35%) when rates spiked and spreads widened, then compressed back to the 20-25% range as the market normalized, per LSTA tracking of new-issue sponsored deals.

What is a dividend recap?

A dividend recapitalization is a hold-period transaction where the sponsor refinances existing debt with a larger new facility and distributes the incremental proceeds to equity holders as a special dividend. Typical profile: year three of a five-year hold, after EBITDA growth has paid down original debt to 4.0x or below; the recap pushes leverage back to 5.0-5.5x and distributes 1.0-1.5x of EBITDA. IRR effect: 200-300 bps of uplift because cash returns are pulled forward, even though MOIC does not change.

Why use bank debt vs high-yield in an LBO?

Senior secured term loan B (institutional bank debt sold to CLOs, mutual funds, and credit funds) is the workhorse because it is the cheapest debt available and offers the most prepayment flexibility (callable at par after a 12-month soft-call). High-yield bonds are unsecured, priced 100-200 bps wider than equivalent secured paper, and carry no-call periods of 3-5 years that lock in cost of debt. Sponsors use HY when they want longer-dated maturities (7-10 years), no maintenance covenants, and public-bond refinancing optionality. Most middle-market deals are entirely TLB-financed; large-cap take-privates blend TLB plus HY plus private credit, per the 2025 mega-deal vintage.

How long do PE firms hold an LBO investment?

The median hold for US sponsored buyouts has run 5.5-6.5 years over the past decade, per PitchBook tracking of realized funds. Holds extended to 7+ years for 2018-2020 vintages because the exit window was disrupted by COVID and the rate cycle, then compressed back toward 5 years as exits opened up. Sponsors with a three-year flip thesis (typically opportunistic carve-outs) hold shorter; seven-year platform-and-build sponsors hold longer. Five years remains the convention in lbo model templates because it aligns with the typical fund investment period and produces clean math.

Build Your Own LBO Model: Next Steps

The model above runs the math for any private-equity-style buyout. The Excel companion CT Acquisitions builds for sell-side clients integrates the same seven steps with company-specific operating data, current 2026 market pricing (live SOFR from the Fed H.15 release and spreads from LSTA data), and the buyer universe likely to bid. Sellers can request a sell-side consultation for a valuation range with bottom-up math behind every number.