Mistral Prompt for Analyzing a Financial Balance Sheet
Analyzing a financial balance sheet is a complex task requiring deep understanding of accounting entries, financial ratios, and the economic dynamics of a company. Mistral, a language model developed in France, stands out for its mastery of French and its ability to process technical documents with precision. By using a well-structured prompt, you can transform Mistral into a true financial analyst capable of dissecting a balance sheet, identifying the strengths and weaknesses of a financial structure, and formulating strategic recommendations. Whether you are a CFO, chartered accountant, auditor, or entrepreneur, AI allows you to save considerable time on data interpretation while obtaining a methodical and exhaustive analysis. This guide provides optimized prompts to fully leverage Mistral's capabilities for financial balance sheet analysis, from quick diagnostics to in-depth multi-year audits.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a senior financial analyst with 15 years of experience in audit and advisory. Analyze the following balance sheet in a structured and in-depth manner.
[PASTE_BALANCE_SHEET_DATA_HERE]
Produce a complete analysis following this structure:
-
Executive Summary: Summarize the company's overall financial health in 5 lines.
-
Balance Sheet Structure Analysis:
- Breakdown of fixed assets vs. current assets
- Equity structure and debt levels
- Composition of debts (short-term vs. long-term)
-
Key Financial Ratios: Calculate and interpret:
- Current ratio and quick ratio
- Gearing ratio
- Solvency ratio
- Net Working Capital (NWC)
- Working Capital Requirement (WCR)
- Net Cash
-
Red Flags: Identify major financial risks and unusual line items.
-
Recommendations: Propose 3 to 5 concrete actions to improve the financial situation.
Use tables to present the ratios. Systematically indicate whether each indicator is favorable, neutral, or unfavorable relative to industry standards.
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
This prompt works by assigning a precise expert role that steers Mistral toward a professional analytical register, coupled with a five-section structure that forces a comprehensive analysis with no omissions. The explicit request for calculating standardized ratios (NWC, WCR, gearing) and qualifying them as favorable/unfavorable eliminates vague answers and ensures an output that is directly actionable for decision-making.
Use Cases
Variants
Expected Output
You will receive a structured financial analysis report including an executive summary, a detailed breakdown of the balance sheet structure, a table of calculated and interpreted financial ratios, along with a list of red flags and actionable recommendations. The format is directly usable for an executive committee or an internal audit report.
Frequently Asked Questions
Can Mistral analyze a balance sheet as well as a chartered accountant?
Mistral can produce a structured analysis and correctly calculate key financial ratios from the data you provide. However, it does not replace a chartered accountant for complex restatements, verifying compliance with accounting standards (PCG, IFRS), or judgments requiring in-depth knowledge of the sector context. Use it as a decision-support tool to speed up your analysis and structure your thinking, then validate critical conclusions with a professional.
How should I provide balance sheet data to Mistral for the best possible analysis?
For optimal results, structure your data by clearly separating assets (fixed assets, inventories, receivables, cash) and liabilities (equity, provisions, financial debt, trade payables). Include gross amounts, depreciation, and net amounts. If possible, provide data for 2 to 3 fiscal years to allow dynamic analysis. You can copy-paste a table from Excel or present the data line by line. The more detailed and well-organized the data, the more accurate and relevant the analysis will be.
Why choose Mistral over another AI model for financial analysis in French?
Mistral offers several advantages for financial analysis in French: it was developed by a French company and has an excellent command of French accounting terminology (PCG, WCR, NWC, CF). Its recent models like Mistral Large rival the best international models in terms of analytical reasoning. Additionally, Mistral offers hosting options in Europe, which can be a decisive factor for the confidentiality of sensitive financial data, particularly in the context of GDPR and sector-specific regulations.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
Be the first to comment on this prompt.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Audit Preparation Checklist
Helping clients prepare for audits
DALL-E Prompt for Analyzing an Annual Report
Analyzing an annual report is a strategic exercise that requires synthesizing dozens of pages of financial, operational, and forward-looking data. DALL-E, OpenAI's image generation tool, offers a unique visual approach to transforming this dense information into impactful graphic representations. Instead of sifting through tables of numbers, you can create infographics, conceptual diagrams, and metaphorical visualizations that make key trends immediately understandable. This method is particularly useful for executive committee presentations, investor summaries, or internal communications. By crafting precise prompts describing the desired data and visual style, you obtain professional visuals that capture attention and facilitate decision-making. Whether you want to illustrate revenue growth, map the geographical distribution of activities, or represent the evolution of ESG indicators, DALL-E turns your data into compelling images. Here are the optimized prompts to get the most out of this tool in the context of annual report analysis.
Profitability Analysis by Segment
Segment profitability analysis for management decisions
Detect and Prevent Account Takeover
Design a multi-layered account takeover detection and prevention framework to protect your customers.