Disclaimer: This platform provides informational and educational summaries of publicly available data only. It is not investment advice, financial advice, or a recommendation or solicitation regarding any security. Users make independent decisions; past performance does not guarantee future results. Read full disclaimer · Terms of Service · Privacy Policy

Back to all prompts

Analyze Debt Maturity & Balance Sheet Risk: AI Prompt for Claude & ChatGPT

Copy this Claude prompt to analyze debt maturity and balance-sheet risk for stock research. Works with Claude, ChatGPT, Gemini, and Grok.

This credit prompt for stock analysis maps maturity walls, leverage, coverage, and refinancing risk. Paste debt footnotes into Claude, ChatGPT, Gemini, or Grok and recompute coverage from the statements.

Recommended tools

ChatGPTClaudeGeminiGrok

Tags

Financial StatementsIntermediate

The Analyze Debt Maturity & Balance Sheet Risk prompt (Claude, ChatGPT, Gemini, Grok)

Select a watchlist or portfolio ticker to pre-fill placeholders, or copy and replace manually.

You are a senior credit analyst with expertise in corporate debt and balance sheet risk assessment. Perform a comprehensive debt and balance sheet analysis for [COMPANY_NAME] (ticker: [TICKER]).

## Context
Analyze the company's debt structure, maturity profile, and ability to service and refinance obligations using data from the most recent 10-K and 10-Q filings. This is a research exercise; do not provide investment recommendations or suggest buying/selling bonds or equity.

## Required Analysis

### Part 1 - Debt Structure Summary
Create a comprehensive table of all outstanding debt:
| Instrument | Principal ($M) | Coupon/Rate | Fixed/Floating | Maturity Date | Callable? | Covenants |

Include: term loans, revolving credit facilities, senior notes, convertible notes, capital leases, and any off-balance-sheet obligations.

### Part 2 - Maturity Wall Analysis
Build a year-by-year maturity schedule:
| Year | Amount Maturing ($M) | % of Total Debt | Cumulative % |

Identify:
- The "maturity wall" (year with highest concentration of maturities)
- Whether the company can cover near-term maturities from cash + FCF alone (no refinancing needed)
- The weighted-average maturity of the debt stack

### Part 3 - Leverage & Coverage Ratios
Calculate and trend over the past [N_YEARS] years:
| Year | Net Debt/EBITDA | Gross Debt/EBITDA | Interest Coverage (EBIT/Interest) | FCF/Total Debt | Debt/Equity |

Compare each ratio to:
- The company's own credit facility covenants (if disclosed)
- Sector median and investment-grade thresholds
- Rating agency guidelines for the current credit rating

### Part 4 - Refinancing Risk Assessment
Evaluate:
- Current credit spread environment vs. the company's existing coupon rates (will refinancing be more or less expensive?)
- Any change-of-control or cross-default provisions that create hidden risk
- The company's access to capital markets (investment-grade vs. high-yield issuer)
- Variable-rate debt exposure: if rates rise [X] bps, what is the annual incremental interest expense?

### Part 5 - Liquidity Runway
Calculate:
- Available liquidity = Cash + undrawn revolver capacity - near-term maturities
- Months of operating expenses covered by current liquidity
- "Stress scenario" liquidity: if EBITDA declines 30%, can the company still service debt and avoid covenant breach?

### Part 6 - Balance Sheet Risk Scorecard
Rate each (1-5 scale, 5 = strongest) with one-line justification:
- Maturity profile (well-laddered vs. concentrated)
- Interest coverage adequacy
- Fixed vs. floating mix (insulated from rate changes)
- Covenant headroom
- Liquidity cushion
- Overall credit quality trajectory (improving / stable / deteriorating)

### Part 7 - Follow-Up Research Questions
List 3-5 specific questions to investigate (e.g. "If the 2027 notes cannot be refinanced below [X]%, what is the FCF impact?").

### Part 8 - Visual Verification & Chart Follow-Up
- Identify 2-3 visual inflection points that require multi-year chart inspection (e.g. net debt trajectory over 10 years, interest coverage buffer cycles, and operating cash flow vs debt obligations).
- Provide the direct Chartloom visual research link for the user to inspect these 10-year interactive charts: https://www.chartloom.com/c/ticker/[TICKER]

## Output Format
Tables, headers, bullets. Neutral, credit-research language. Do not suggest whether to buy or sell equity or debt securities.

**Variables:** If any [BRACKETED] placeholders above are not set, ask the user for each missing value before proceeding.

Variables

Replace these placeholders in the prompt with your own values.

PlaceholderDescriptionExample
[COMPANY_NAME]Company name.Carnival Corporation
[TICKER]Stock ticker symbol.CCL
[N_YEARS]Years of historical leverage ratios to trend (recommend 3-5).5

How to use this prompt

Replace all bracketed variables. For significantly better output, paste the debt footnotes from the 10-K (usually "Long-Term Debt" or "Debt and Credit Facilities" notes) alongside the prompt. The AI can then build the maturity table from actual filing data rather than estimates.

Tips

  • The maturity wall is the most important output - companies with heavy maturities in a single year face concentrated refinancing risk.
  • Always check whether Net Debt/EBITDA is trending up or down - the direction matters more than the absolute level.
  • Variable-rate exposure is especially important in rising-rate environments. Even 200bps of rate increases can meaningfully compress FCF for highly levered companies.
  • Cross-reference the AI output with the company's actual credit rating and recent rating agency commentary.
  • Companies that generate strong FCF can "self-fund" maturities without accessing capital markets - this is the strongest balance sheet posture.

When to use this prompt

Screening out companies with concentrated maturity walls or covenant-breach risk

Assessing whether a beaten-down stock faces actual solvency risk or just sentiment

Evaluating interest rate sensitivity for companies with floating-rate debt

Building the balance sheet section of a full fundamental research report

Updated 2026-06-09

These prompts are research tools, not financial advice. Outputs should be independently verified. They are not a recommendation to buy, sell, or hold any security. See our disclaimer for more information.