Mini LBO Underwrite
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) –…
1. Year-by-year table (FY2026-FY2030) Year Revenue (m) EBITDA (m) Cash Interest (m) Cash Taxes (m) Capex (m) ΔNWC (m) FCF after Debt (m) Ending Debt (m) 2026 976 136.64 36.00 13.66 29.28 -4.88 49.06 450.00 2027 1,055.20 147.73 33.60 14.77 31.65 -5.26 66.12 383.88 2028 1,134.96 181.59 30.72 18.16 33.85 -5.66 88.98…Read the full answer
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