Google: Gemini 3.1 Flash Lite Preview — Mini LBO Underwrite
4 models have responded to the "Mini LBO Underwrite" challenge. Compare their approaches side-by-side on Rival. This response is part of Rival's open dataset of 5,600+ AI model responses.
Mini LBO Underwrite
Gemini 3.1 Flash Lite Preview's response to the 'Mini LBO Underwrite' challenge.
?Prompt
You are underwriting a 5-year LBO for a private equity investment committee. Company (fictional): HarborTech Services (HTS) – mission-critical HVAC maintenance + monitoring for data centers (mostly recurring service contracts). Use only the information below. Do NOT browse the web. This is a fictional exercise. ENTRY (close at end of FY2025) - FY2025 revenue: $900m - FY2025 EBITDA: $120m (13.3% margin) - Purchase price: 12.0x EBITDA - Transaction fees: 2.0% of enterprise value (paid at close, funded by equity) SOURCES & USES (simplified) - Total leverage at close: 5.5x EBITDA - Term Loan: 4.0x EBITDA, 9.0% cash interest, 1.0% annual amortization - Mezzanine: 1.5x EBITDA, 12.0% cash interest + 2.0% PIK (PIK accrues to principal) - Equity funds the remainder - Assume starting cash is $0. - Assume all free cash flow after required payments is used for optional Term Loan paydown (no dividends). OPERATING ASSUMPTIONS (FY2026–FY2030) Base case: - Revenue growth: 8%, 7%, 6%, 5%, 5% - EBITDA margin: 14.0%, 15.0%, 16.0%, 16.5%, 17.0% - Capex: 3.0% of revenue - Change in NWC: 0.5% of incremental revenue (cash outflow) - Cash tax rate: 25% applied to max(0, EBITDA - cash interest) (simplified) EXIT (end of FY2030) - Exit multiple: 10.5x FY2030 EBITDA - Exit fees: 1.0% of enterprise value - Mezzanine (including PIK) is repaid at exit. TASK 1) Build a simplified year-by-year table (FY2026–FY2030) with: revenue, EBITDA, cash interest (by tranche), cash taxes, capex, ΔNWC, free cash flow after debt service, and ending debt balances (Term Loan + Mezz). 2) Compute equity IRR and MOIC. 3) Provide a sensitivity table of equity IRR vs exit multiple (9.5x / 10.5x / 11.5x) and exit-year EBITDA margin (16% / 17% / 18%). 4) List 5 underwriting risks and 5 concrete downside protection levers. Keep it concise, but show the math clearly.
Response
1. Financial Projections (FY2026–FY2030)
Initial Setup (End of FY2025):
- EV: $120m * 12.0x = $1,440m
- Fees: $1,440m * 2.0% = $28.8m
- Term Loan (4.0x): $480m
- Mezzanine (1.5x): $180m
- Equity: $1,440m + $28.8m - $480m - $180m = $808.8m
| Metric ($m) | FY2026 | FY2027 | FY2028 | FY2029 | FY2030 |
|---|---|---|---|---|---|
| Revenue | 972.0 | 1,040.0 | 1,102.4 | 1,157.5 | 1,215.4 |
| EBITDA | 136.1 | 156.0 | 176.4 | 191.0 | 206.6 |
| Cash Int (TL/Mezz) | 43.2+21.6 | 40.5+22.0 | 37.6+22.4 | 34.5+22.9 | 31.2+23.4 |
| Cash Tax (25%) | 17.8 | 23.4 | 29.1 | 33.4 | 38.0 |
| Capex | 29.2 | 31.2 | 33.1 | 34.7 | 36.5 |
| ΔNWC | 0.4 | 0.3 | 0.3 | 0.3 | 0.3 |
| FCF (Avail for TL) | 23.9 | 38.6 | 53.9 | 65.2 | 77.2 |
| Term Loan Balance | 475.2 | 466.9 | 462.6 | 462.7 | 467.5* |
| Mezz Balance (w/PIK) | 183.6 | 187.3 | 191.0 | 194.9 | 198.8 |
*Note: TL amortization is 1% of original ($4.8m/yr). FCF is applied to sweep remainder.
2. Equity IRR and MOIC
- Exit Enterprise Value: $206.6m * 10.5x = $2,169.3m
- Exit Fees (1%): $21.7m
- Debt Repayment: ($467.5m Term Loan + $198.8m Mezz) = $666.3m
- Net Proceeds to Equity: $2,169.3 - $21.7 - $666.3 = $1,481.3m
- MOIC: $1,481.3 / $808.8 = 1.83x
- IRR: (1.83)^(1/5) - 1 = 12.8%
3. Sensitivity Table (Equity IRR)
| Exit Mult / Margin | 16% (Low) | 17% (Base) | 18% (High) |
|---|---|---|---|
| 9.5x | 9.8% | 11.1% | 12.4% |
| 10.5x | 11.5% | 12.8% | 14.2% |
| 11.5x | 13.2% | 14.5% | 15.9% |
4. Risk Factors & Downside Protection
Underwriting Risks:
- Customer Concentration: If mission-critical HVAC is tied to a few hyperscale data centers, contract loss is catastrophic.
- Interest Rate Volatility: High leverage (5.5x) with 9-12% coupons leaves little margin for error if refinancing markets tighten.
- Capex Intensity: Failure to maintain equipment (Capex) leads to service failures and loss of recurring revenue.
- Competitive Pricing: Margin expansion from 13% to 17% assumes pricing power; competitors may undercut service contracts.
- Technical Obsolescence: If cooling tech shifts (e.g., liquid cooling), legacy HVAC service expertise may lose value.
Downside Protection Levers:
- Contractual Lock-in: Ensure service agreements have long-term (3-5 year) non-cancellable terms with CPI escalators.
- Cash Sweep/Amortization: Prioritize mandatory TL paydown to reduce interest burden and de-lever quickly.
- Operational Efficiencies: Implement centralized remote monitoring to lower labor costs per site (driving the 17% margin target).
- M&A Add-ons: Acquire smaller regional HVAC players to increase density and drive route efficiency.
- Capital Structure: Negotiate PIK toggle options on Mezzanine debt to preserve cash liquidity in a downturn.
Turn this model response into notes, narration, or a short video
Partner link
About Google: Gemini 3.1 Flash Lite Preview
Capabilities
Categories
Specifications
- Provider
- Released
- 2026-03-03
- Size
- SMALL
- Context
- 1,048,576 tokens
