PE/LBO Financial Model | Excel | 3-Statement, Debt Schedule, DCF & Returns Analysis
The institutional-grade LBO model private equity professionals actually use. Built by a Senior Financial Analyst, this Excel template gives you a fully integrated, deal-ready leveraged buyout model — the kind investment banks and PE firms pay analysts six figures to build from scratch. Whether you're evaluating a search fund acquisition, underwriting a sponsor deal, or preparing for a PE interview, this model gives you the rigorous analytical foundation you need. --- WHAT'S INCLUDED: 9 TABS --- Full 3-Statement Financial Model — Integrated P&L, Balance Sheet, and Cash Flow, all linked and self-balancing. Adjust one Assumptions tab and every statement updates automatically. LBO Analysis — Sources & Uses table, dual-tranche debt schedule (Term Loan B + Senior Subordinated Notes), mandatory amortization, 5-year hold period. IRR and MoM multiples calculate automatically. Debt Schedule — Separate TLB and Senior Sub schedules with configurable interest rates and amortization. Total interest expense flows directly into P&L and Balance Sheet. DCF Valuation — Unlevered FCF model with WACC build-up (Rf, ERP, Beta, cost of debt), PV of terminal value via exit multiple method, EV to equity bridge. Mid-year discounting included. Sensitivity Tables — Two-variable sensitivity tables for LBO returns (IRR x Exit Multiple) and DCF EV (WACC x Exit Multiple) — the exact output format used in IC memos. Clean Assumptions Architecture — All inputs in one tab. Color-coded: blue (inputs), black (formulas), green (cross-sheet links). --- DEFAULT ASSUMPTIONS --- LTM EBITDA: $5mm | Entry Multiple: 8.0x | Entry EV: $40mmCapital Structure: 40% TLB (7% / 5% amort) + 20% Senior Sub (10% / bullet)5-Year Hold | 9.0x Exit MultipleOutput: ~36% IRR / 4.7x MoM at default inputsDCF: ~7.5% WACC | ~$91mm Enterprise Value All assumptions are fully customizable. --- FILE DETAILS --- Format: Microsoft Excel (.xlsx)Compatible with Excel 2016+ (Windows recommended) and Excel for Mac9 tabs, 591 formulas, fully unlockedInstant download after purchaseBuyer FAQQ: What Excel version do I need?A: Excel 2016 or later on Windows is recommended. Excel for Mac works. Google Sheets is not recommended for this model.Q: Can I customize it for my specific deal?A: Yes — everything is unlocked. Update the Assumptions tab and the entire model recalculates.Q: Is this appropriate for PE interview prep?A: Yes. The architecture (3-statement integration, debt schedule, IRR/MoM, DCF with WACC build-up) matches exactly what's tested in on-cycle and off-cycle PE interview processes.
Get it → furnish7.gumroad.com