LBO Model — Multi-Tranche Leveraged Buyout (Excel + Google Sheets) | Senior/Mezz/PIK · Cash Sweep · MoIC, IRR & Dated XIRR

All Industries, Financial Model, General Excel Financial Models

Excel, Financial Model, Financial Modeling, Financial modelling, IRR (Internal Rate of Return), LBO (Levered Buyout), LLCR (Loan Life Coverage Ratio)

The LBO Model is a self-contained, multi-tranche leveraged-buyout model for private-equity and corporate-development teams, investment-banking analysts, search-fund buyers, and finance students who need to determine — and defend — the returns on a debt-funded acquisition. Set the entry EV/EBITDA multiple and the leverage on each tranche, and the model builds Sources & Uses, projects five years of operations through a complete debt-paydown waterfall, and computes the sponsor’s exit equity, MoIC, an annualized IRR, and a dated XIRR. It ships pre-filled with a complete, tied-out worked deal and a 4-page methodology PDF.

The model is fully transparent and engineered to be robust: interest is charged on the beginning debt balance, so the waterfall — cash interest, PIK accretion, mandatory amortization, and a 100% cash sweep — resolves in a single pass, without a circular reference and without iterative calculation. It is built on arithmetic / MIN / MAX / IF / IFERROR / INDEX / EDATE / XIRR formulas and runs unchanged in Microsoft Excel and Google Sheets.

**How this compares** — Most downloadable LBO templates are single-tranche: one loan, a straight-line paydown, and an approximated IRR. This model carries a full senior / mezzanine / PIK / revolver stack with a genuine cash-sweep waterfall, accreting PIK, and a *dated XIRR* computed on the actual sponsor cash flows — the depth an underwriter would otherwise build from scratch. Every worked-example output has been recomputed cell-by-cell against an independent rebuild (Sources = Uses, balance check 0), so the numbers are defensible in diligence, not indicative. Built by hand, this depth is roughly a half-day of an analyst’s time; here it is done and independently tied out.

**Model Structure — Excel (7 tabs)**

1. **START HERE** — What the model does, the order to enter inputs, and the method in plain English
2. **Assumptions** — Entry and exit EV/EBITDA multiples, the debt stack (leverage and rate per tranche), operating drivers, and tax (all in $ millions)
3. **Sources & Uses** — Entry enterprise value, transaction fees, minimum cash, the three debt tranches, and sponsor equity as the funding plug (balance check ties to zero)
4. **Operating & Debt** — A 5-year, revenue-driven operating projection with the full multi-tranche waterfall and beginning-balance interest
5. **Returns** — Exit equity (exit EBITDA x exit multiple – net debt), MoIC, annualized IRR, and a dated XIRR on the sponsor cash flows
6. **Sensitivity** — A 2-way MoIC / IRR grid across entry and exit EV/EBITDA multiples
7. **Dashboard** — Headline returns and the deal summary at a glance

**Key Methodological Features**

– Entry on an EV/EBITDA multiple; each tranche sized off its leverage x entry EBITDA; sponsor equity as the plug
– Multi-tranche stack: senior term loan + mezzanine + PIK (accreting) + revolver, with a minimum-cash floor
– Full waterfall: cash interest, PIK accretion, mandatory senior amortization, then a 100% cash sweep (revolver -> senior -> mezzanine)
– Optional dividend recaps paid from excess cash; variable hold of 1-5 years
– Beginning-balance interest — no circular references, no iterative calculation required
– Sponsor returns as MoIC, annualized IRR, and a dated XIRR
– All inputs and outputs in $ millions
– Arithmetic-only — runs in both Excel and Google Sheets; no macros, no VBA, no add-ins

**Worked Example**

Pre-loaded with a complete deal (sample target “Northwind Components Inc.”, fictional; all figures in $M): entry enterprise value of $1,250 (10x on $125 EBITDA), funded with $625 of debt across three tranches — senior $375, mezzanine $187.5, PIK $62.5 — and $660 of sponsor equity. Over five years the waterfall amortizes and sweeps senior debt from $375 to $86.5 while PIK accretes; net debt at exit is $374. Exit equity reaches $1,462.5 — a 2.22x MoIC, a 17.3% annualized IRR, and a 17.2% dated XIRR. Replace the inputs with any deal’s figures and every output re-prices.

**Suitable For**

– Private-equity and corporate-development teams underwriting a buyout
– Investment-banking analysts and candidates preparing LBO analysis
– Search-fund and independent-sponsor buyers
– Finance and MBA students learning leveraged-buyout mechanics

**Technical Specifications**

– Format: .xlsx (Excel edition) + .xlsx (Google-Sheets-safe edition) + .pdf (methodology)
– Compatibility: Excel 2019, 2021, Microsoft 365 (Windows and Mac) and Google Sheets
– No macros, no VBA, no add-ins
– No circular references — beginning-balance interest
– Pre-filled worked deal; replace with your own
– 7 tabs · all inputs in $ millions · 5-year multi-tranche debt waterfall
– Delivery: instant digital download · single-user license

────────────────── ABOUT THE AUTHOR ──────────────────
Built by Hoda Elmorshidy — Financial Controller & Fractional CFO, 9+ years in
IFRS reporting, FP&A, commodity trading, CFO/board reporting, UAE VAT & Corporate
Tax, and finance automation. Practitioner-grade tools, not generic templates.

────────────────── DISCLAIMER ──────────────────
This template is an analytical and educational tool, not professional financial,
investment, tax, accounting, or legal advice, and its use creates no professional
relationship. All assumptions and figures are illustrative — verify against your
own data and current standards (IFRS/GAAP, tax rates) before relying on any
output. Past or modeled returns do not predict actual results.
Last reviewed: July 2026.

────────────────── LICENSE & LIABILITY ──────────────────
• License grant: Single-user license for your own or your organization’s internal
use. No resale, redistribution, sublicensing, or repackaging of the file or its
templates.
• As-is warranty: Provided “as is” without warranty of any kind, express or
implied, including merchantability or fitness for a particular purpose.
• Limitation of liability: To the maximum extent permitted by law, total liability
for any claim arising from this product is limited to the amount you paid for it.
The author is not liable for indirect, incidental, or consequential losses.
• Non-waivable rights: Nothing here limits rights that cannot be excluded under the
consumer-protection law of your jurisdiction.
• Governing law: This purchase is governed by the terms of the platform you bought
it on (e.g. Etsy, Gumroad) and by the consumer-protection law of your own country
of residence. Where those permit, the limitations above apply to the maximum
extent allowed.

You must log in to submit a review.