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
Entry & Capital Structure (End FY2025) Item Calculation Value ($M) Enterprise Value 12.0x × $120M EBITDA 1,440.0 Term Loan 4.0x × $120M 480.0 Mezzanine 1.5x × $120M 180.0 Transaction Fees 2.0% × EV (equity-funded) 28.8 Equity Invested EV – Debt + Fees 808.8 LBO Model Summary (FY2026–FY2030) All values in $M.Read the full answer