Leveraged Buyout Debt Capacity Evaluation

Role: Private Equity Principal and Senior Debt Capital Markets Modeler.

Context

• Target acquisition company: {{target_fintech_company}}
• Topline scale and recurring cash flow base: {{current_arr_or_revenue}}
• Gross margin profile and operating efficiency: {{gross_margin_percentage}}
• Assumed acquisition valuation: {{entry_ebitda_multiple}}
• Fund target return threshold: {{sponsor_target_irr}}
• Capital structure parameters: {{proposed_leverage_levers}}

Task

Author an LBO debt capacity and valuation feasibility report that details capital structure optimization, models debt paydown schedules across senior and subordinated tranches, and evaluates fund returns against hurdle rates.

Method

1. Deconstruct {{current_arr_or_revenue}} and {{gross_margin_percentage}} to determine steady-state unlevered free cash flow.
2. Calibrate total enterprise value using the {{entry_ebitda_multiple}} and quantify total sources and uses.
3. Segment debt tranches according to the parameters in {{proposed_leverage_levers}}.
4. Project a 5-year debt amortization profile and interest burden across changing rate assumptions.
5. Calculate cumulative deleveraging capacity and cash flow sweep efficacy over the holding period.
6. Evaluate equity exit valuations at multiple expansion/contraction cases to derive IRR against {{sponsor_target_irr}}.
7. Identify covenant tripwires and recommend capital structure adjustments to optimize the debt-to-equity ratio.

Constraints

• MUST evaluate returns at both flat exit multiples and a 1.5x multiple contraction case.
• MUST NOT exceed leverage boundaries unsupported by steady-state cash conversion.
• Include exact Debt/EBITDA and Interest Coverage multiples for all projected years.
• Limit the returns sensitivity matrix to three defined exit year horizons (Years 3, 5, and 7).

Output format

1. Transaction Overview & Sources/Uses Table (Structured summary)
2. Debt Sizing & Tranche Structure Analysis (350 words maximum)
3. 5-Year Deleveraging & Cash Flow Coverage Projections (Tabular layout with notes)
4. Returns Sensitivity Matrix & IRR Assessment (Cross-tabulating exit multiple vs. holding period)
5. Structuring Recommendation & Deal Redlines (Actionable summary)

Self-review

• Confirm that total sources equal total uses in the transaction structuring section.
• Check that the modeled IRR realistically reflects the entry multiple {{entry_ebitda_multiple}} and target {{sponsor_target_irr}}.
• Validate that cash sweep mechanisms adhere strictly to the terms outlined in {{proposed_leverage_levers}}.