Private Equity LBO Debt Capacity and Returns Sensitivity Evaluation

Role: Principal Private Equity Modeling Specialist with deep expertise in buyout financial engineering and capital structure optimization.

Context

• Target Sector: {{target_company_industry}}
• Baseline Financials: {{target_run_rate_ebitda}}
• Financing Proposal: {{proposed_leverage_multiples}}
• Investment Horizon: {{exit_horizon_years}}
• Return Hurdle: {{sponsor_target_irr}}
• Capital Expenditure & Working Capital: {{capex_working_capital_needs}}

Task

Develop a comprehensive Leveraged Buyout (LBO) Debt Capacity and Returns Sensitivity Report for a target in {{target_company_industry}}, evaluating debt service viability, exit returns against {{sponsor_target_irr}}, and downside risk boundaries.

Method

1. Establish the baseline sources and uses table utilizing {{proposed_leverage_multiples}} and transaction fees.
2. Construct a multi-year cash flow waterfall incorporating {{capex_working_capital_needs}} and tax-shielded interest expenses.
3. Calculate annual unlevered and levered free cash flow available for debt service (CFADS).
4. Model mandatory amortization versus optional sweep mechanics across senior and subordinated debt tranches.
5. Run exit valuation scenarios at {{exit_horizon_years}} across varying EBITDA exit multiples.
6. Generate sensitivity tables mapping Sponsor IRR and MoIC (Multiple on Invested Capital) against exit multiples and revenue growth.
7. Identify covenant breach thresholds and compute maximum supportable leverage under conservative downside cases.

Constraints

• MUST express all final investment returns in both Gross IRR (%) and Gross MoIC (x).
• MUST NOT exceed leverage parameters that cause debt service coverage to fall below 1.25x in any projected year.
• Base working capital drag strictly on the metrics defined in {{capex_working_capital_needs}}.
• Maintain standard institutional modeling conventions (e.g., mid-year convention where applicable, strict seniority debt repayment).

Output format

Structure the report with the following defined sections:

• Transaction Overview & Sources/Uses Summary
• Debt Sizing, Amortization & Tranche Breakdown
• Free Cash Flow Waterfall & Deleveraging Schedule
• Returns Matrix: Sensitivity of IRR and MoIC to Exit Multiple and Growth Rates
• Key Downside Risks, Covenant Headroom & Structuring Recommendations

Self-review

• Ensure the baseline equity contribution correctly balances total sources and uses based on {{proposed_leverage_multiples}}.
• Verify that the target return comparisons match or exceed {{sponsor_target_irr}} under base case assumptions.
• Check that the cash sweep logic correctly accounts for debt service priority order.