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
Tags
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.
Replace these placeholders in the prompt with your own values.
| Placeholder | Description | Example |
|---|---|---|
| [COMPANY_NAME] | Company name. | Carnival Corporation |
| [TICKER] | Stock ticker symbol. | CCL |
| [N_YEARS] | Years of historical leverage ratios to trend (recommend 3-5). | 5 |
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.
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.