Mini LBO Underwrite
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) –…
Financial Projections (FY2026–FY2030) Initial Setup (End of FY2025): EV: $120m * 12.0x = $1,440m Fees: $1,440m * 2.0% = $28.8m Term Loan (4.0x): $480m Mezzanine (1.5x): $180m Equity: $1,440m + $28.8m - $480m - $180m = $808.8m Metric ($m) FY2026 FY2027 FY2028 FY2029 FY2030 Revenue 972.0 1,040.0 1,102.4 1,157.5 1,215.4…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