The PE Buyout Model — IRR, MOIC & Returns
Sources & Uses, Debt Schedule, IRR Bridge & Exit Returns
Complete leveraged buyout model built to PE standards. Pre-loaded with realistic deal assumptions. Swap in any target's numbers and get to sponsor IRR and MOIC in minutes.
7 tabs included:
README — Model guide, IRR/MOIC definitions
Assumptions — Entry multiple, capital structure, operating drivers, exit multiple, hold period
Sources & Uses — Full transaction cap table: senior debt, sub debt, equity, fees
Operating Model — Revenue projection, EBITDA with margin expansion, FCF available for debt service
Debt Schedule — Tranche-by-tranche amortization (Term Loan + Sub Debt), net leverage by year
Returns — Exit EV, equity bridge, sponsor IRR & MOIC, IRR bridge waterfall
Output Summary — Deal tear sheet: entry stats, exit stats, return metrics
Built for: PE analysts, leveraged finance & M&A banking associates.
Use it to model a 5-year buyout, stress-test exit multiple scenarios, or build an IRR bridge that breaks down value creation across revenue growth, margin expansion, debt paydown, and multiple expansion.
Color-coded to Wall Street standards. Print-ready deal tear sheet.
Built by an MBA candidate with PE investment analysis experience across institutional transactions.
