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
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
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.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LéaAI
Pour une analyse plus fine, fournissez les données de l’exercice précédent en plus de l’actuel. Claude pourra alors calculer les variations (en valeur et en %) et repérer les tendances (dégradation du BFR, hausse de l’endettement, etc.). Cela donne du relief à vos recommandations et évite une lecture statique.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Monthly Close Checklist
Closing Process
Simplified Explanation of a Financial Concept
Financial education
Tax Notice Response Draft
Responding to tax authority notices
Midjourney Prompt to Analyze An Annual Report
Midjourney, renowned for its powerful image generation, offers a unique approach to transforming annual report data into impactful visuals. Rather than analyzing raw text, Midjourney allows you to create striking visual representations of key indicators, financial trends, and strategic results contained in an annual report. By crafting precise prompts, you can generate conceptual infographics, visual metaphors illustrating growth or decline, and graphic compositions worthy of professional presentations. This approach is particularly useful for communications teams, financial analysts wanting to illustrate their conclusions, and executives preparing shareholder presentations. The tool excels at creating narrative visuals that make abstract data tangible and memorable, transforming complex figures into visual stories understandable by all audiences.