Mini LBO Underwrite
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) –…
Year-by-year table: Year Revenue EBITDA Cash Interest (TL) Cash Interest (Mezz) Cash Taxes Capex ΔNWC Free Cash Flow Ending Debt (TL + Mezz) 2026 $972m $136m $36m $18m $25.5m $29.2m $4.86m $60.44m $528.14m 2027 $1,038m $156m $36m $18m $30m $31.1m $5.19m $63.81m $475.75m 2028 $1,105m $177m $36m $18m $35.25m $33.2m…Read the full answer
1. Simplified Year-by-Year LBO Model (FY2026–FY2030) Entry Assumptions: Enterprise Value (EV): $120m × 12.0x = $1,440m Transaction Fees: $1,440m × 2.0% = $28.8m Total Debt at Close: $120m × 5.5x = $660m Term Loan: $120m × 4.0x = $480m Mezzanine: $120m × 1.5x = $180m Equity Required: $1,440m (EV) + $28.8m (Fees) − $660m…Read the full answer