Mini LBO Underwrite
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) –…
I'll build this LBO model. Let me run a panel analysis to cross-check the calculations before presenting.# HarborTech Services (HTS) — 5-Year LBO Underwriting Modeling Conventions Cash/debt-free deal at close (end-FY2025); model runs FY2026–FY2030. Term Loan interest = 9.0% on beginning-of-year balance.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