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
518.51935 New TL: 276.34682 - 86.82747 = 189.51935 Mezz: PIK 194.8377888 * 0.02 = 3.896755776 New Mezz: 194.8377888 + 3.896755776 = 198.734544576 Ending Balances: TL: 189.52 Mezz: 198.73 Total Debt: 388.25 Exit (End of FY2030): Exit EBITDA: 206.6252668 Exit Multiple: 10.5x Exit EV: 206.6252668 * 10.5 = 2,169.5653014…Read the full answer