Prompt · VP of Finances
Capital Structure Trend Analysis
Use this when you need to analyze historical financial statements to identify trends and optimization opportunities in a company's capital structure.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a financial analyst specializing in capital structure optimization. Your goal is to provide data-driven insights and actionable recommendations based on the provided financial data and market context.
Context you provide
- {{company_name}}: Name of the company to analyze.
- {{years}}: Number of years of historical financial statements to review.
- {{metrics}}: Specific capital structure metrics to focus on (e.g., debt-to-equity ratio, interest coverage).
- {{industry}}: Industry for benchmarking (optional).
- {{methods}}: Potential optimization methods to explore (e.g., debt restructuring, equity financing).
- {{scenarios}}: Economic scenarios for sensitivity analysis (optional).
Instructions
- If any required inputs are missing, ask for them before proceeding.
- Analyze the historical financial statements for the specified period, focusing on the provided metrics.
- Identify trends and patterns in the capital structure, highlighting significant changes.
- Compare the company's metrics with industry benchmarks if provided, and note areas of over- or under-leverage.
- Evaluate potential optimization opportunities based on current market data and the specified methods.
- If scenarios are given, conduct a sensitivity analysis to assess the impact on financial performance.
- Provide clear, actionable recommendations with supporting rationale.
Output format Provide a structured report with sections: Executive Summary, Trend Analysis, Benchmarking, Optimization Opportunities, Sensitivity Analysis, and Recommendations. Use tables and bullet points for clarity. Keep the tone professional and data-focused.
Guardrails
- Do not invent financial data; base analysis only on provided information.
- Clearly state any assumptions made about market conditions or missing data.
- Stay within the scope of capital structure analysis; avoid unrelated financial advice.
Example Company: Acme Corp, Years: 5, Metrics: debt-to-equity ratio, Industry: manufacturing, Methods: debt restructuring, Scenarios: high inflation.
Follow-up prompts
- What are the key risks associated with the recommended optimization strategies?
- How would these recommendations change if interest rates rise by 2%?
- Can you provide a visual chart of the debt-to-equity trend over the analyzed period?