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
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