Mini LBO Underwrite
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) –…
Simplified Year-by-Year Cash Flow Table (FY2026–FY2030) Year Revenue EBITDA Cash Interest (Term + Mezz) Cash Taxes Capex ΔNWC FCF After Required Payments Term Loan Balance Mezz Balance 2026 $972.0M $136.1M $64.8M $17.8M $29.2M $0.4M $19.1M $456.1M $183.6M 2027 $1,040.0M $156.0M $63.1M $23.2M $31.2M $0.3M $33.4M $417.9M…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