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.
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.