Prompt Claude to Analyze a Financial Balance Sheet
Analyzing a financial balance sheet is a complex exercise that requires in-depth understanding of accounting standards, financial ratios, and the overall health of a company. Claude excels at this task thanks to its ability to process structured data, identify trends, and produce nuanced analyses. Whether you are a CFO, analyst, accountant, or entrepreneur, using Claude to analyze a balance sheet saves you considerable time while obtaining a rigorous reading of a company's financial position. The AI can break down assets and liabilities, calculate key liquidity, solvency, and profitability ratios, and then formulate strategic recommendations. It also identifies warning signs that the human eye might miss in a dense document. By combining Claude's analytical power with your business expertise, you get a faster, more comprehensive, and better-structured financial analysis than traditional manual processing.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Act as a senior financial analyst specialized in balance sheet analysis. I will provide you with balance sheet data. Perform a comprehensive analysis following this structure:
- Executive Summary: summarize the financial situation in 3-4 key sentences.
- Asset Analysis: break down fixed assets and current assets, identify significant items and their trends.
- Liability Analysis: examine equity, long-term and short-term debt, evaluate the financing structure.
- Key Financial Ratios: calculate and interpret the following ratios:
- Current and quick liquidity ratios
- Debt ratio and financial autonomy ratio
- Net working capital (FRNG)
- Working capital requirement (BFR)
- Net cash
- Return on equity (ROE)
- Warning Signs: identify any imbalances, cash flow risks, or points of concern.
- Recommendations: propose 3-5 concrete actions to improve the financial situation.
Present each ratio with its formula, calculated value, and interpretation relative to industry norms. Use tables for numerical data.
Here is the balance sheet data:
[PASTE BALANCE SHEET DATA HERE]
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
This prompt is effective because it assigns Claude a precise expert role (senior financial analyst), which activates a specialized knowledge base. The numbered six-section structure forces a thorough and methodical analysis, avoiding superficial responses. The explicit request for formulas, calculated values, and industry interpretations ensures an actionable and verifiable result.
Use Cases
Variants
Expected Output
You will receive a structured financial analysis report including an executive summary, a detailed breakdown of assets and liabilities, a table of financial ratios with formulas and interpretations, as well as a list of warning signs and strategic recommendations. The document will be directly usable for a management committee presentation or audit report.
Frequently Asked Questions
What format should I use to provide balance sheet data to Claude?
Claude can process balance sheet data in several formats: plain text with tab-separated amounts, a table copied and pasted from Excel or Google Sheets, or even a textual description of the line items. For best results, structure your data with line item labels and their amounts in two columns (current year N and previous year N-1 if available). You can also attach a PDF or image of the balance sheet if you're using Claude with file-reading capabilities. Make sure to include the total assets and total liabilities to allow for coherence checking.
Can Claude compare balance sheets over multiple fiscal years?
Yes, Claude excels at multi-year comparative analysis. Provide data for two to five fiscal years and explicitly request a trend analysis. Claude will calculate absolute and relative changes for each line item, identify significant shifts, and produce descriptive trend charts. It can also compute compound annual growth rates (CAGR) and detect trend breaks that might signal a change in strategy or an emerging risk.
Are the financial ratio calculations performed by Claude reliable?
Claude performs arithmetic calculations with high accuracy when the data provided is correct and complete. However, it's advisable to verify critical results, especially for ratios involving adjustments or off-balance sheet items that Claude cannot infer. To maximize reliability, ask Claude to show the formulas used and the intermediate values for each calculation. This allows you to quickly spot any potential errors and validate the analysis's consistency before using it in a decision-making context.
Learn more
Check the full skill on Prompt Guide to master this technique from A to Z.
View on Prompt Guide📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Similar Prompts
Generate a Compelling Investment Pitch
Create a structured, compelling investment pitch adapted to your audience for effective fundraising.
Optimize Tax Structuring
Optimize your company tax structure with an analysis of reorganization options and quantified simulations.
Summarize Insurance Product Reviews
Analyze customer reviews on your insurance products to identify strengths, pain points and concrete improvement levers.
Generate Blog Content Ideas for Insurance
Generate a complete, SEO-optimized blog content plan for your insurance or financial services website.