Mini LBO Underwrite
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) –…
Here are the requested items: 1. Simplified Year-by-Year Table (FY2026-FY2030) Year Revenue EBITDA Cash Int. (TL) Cash Int. (Mz) Cash Taxes Capex ΔNWC FCF TL Balance Mz Balance 2026 972 136.08 36.00 18.00 17.12 29.16 4.86 30.90 360.00 135.00 2027 1037.84 154.78 33.60 19.44 20.45 31.13 5.19 44.12 315.88 133.56 2028…Read the full answer
Initial Setup & Equity Calculation Item Calculation Amount ($m) Purchase Price $120m × 12.0x 1,440.0 Transaction Fees $1,440m × 2.0% 28.8 Total Debt ($480m TL + $180m Mezz) 660.0 Initial Equity $1,440 + $28.8 − $660 808.8 Year-by-Year Model (FY2026–FY2030) (All figures in $m, rounded to 1 decimal.Read the full answer