Mini LBO Underwrite
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) –…
Let's proceed step by step. All calculations are built from the data provided above. Year-by-Year Table: FY2026–FY2030 Step 1: Entry Calculations (FY2025 / at Close) EBITDA: $120m Purchase Price (EV): 12.0 × $120m = $1,440m Transaction Fees: 2.0% × $1,440m = $28.8m Total Uses: $1,440m + $28.8m = $1,468.8m Debt at…Read the full answer
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