Mini LBO Underwrite
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) –…
We need to build a simplified year-by-year table FY2026-FY2030. First, compute initial purchase price: EBITDA FY2025 = $120m. Purchase price = 12.0x EBITDA = 12 * 120 = $1,440m (enterprise value). Transaction fees = 2.0% of EV = 0.02 * 1440 = $28.8m, paid at close from equity. Total leverage at close = 5.5x EBITDA.Read the full answer
Simplified Year-by-Year Cash Flow Table (FY2026–FY2030) Year Revenue EBITDA Cash Interest (Term + Mezz) Cash Taxes Capex ΔNWC FCF After Required Payments Term Loan Balance Mezz Balance 2026 $972.0M $136.1M $64.8M $17.8M $29.2M $0.4M $19.1M $456.1M $183.6M 2027 $1,040.0M $156.0M $63.1M $23.2M $31.2M $0.3M $33.4M $417.9M…Read the full answer