Gemini Prompt to Analyze a Financial Balance Sheet
Analyzing a financial balance sheet is a complex exercise that requires a deep understanding of accounting items, financial ratios, and the economic dynamics of a company. Gemini, with its advanced reasoning capabilities and structured data processing, becomes a valuable assistant for deciphering the information contained in a balance sheet. Whether you are a manager looking to assess your company's financial health, an investor analyzing an opportunity, or an accounting student seeking to deepen your understanding, Gemini can transform columns of numbers into actionable insights. The AI particularly excels at identifying trends, automatically calculating key ratios, and putting data into perspective relative to industry standards. By formulating a precise and structured prompt, you will obtain a rigorous analysis covering solvency, liquidity, profitability, and capital structure, all in seconds.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Act as a senior financial analyst with 15 years of experience in auditing and balance sheet analysis. I will provide you with the data from a financial balance sheet. Perform a comprehensive and structured analysis following this plan:
-
Overview: Summarize the overall financial situation of the company in 3-4 sentences.
-
Balance Sheet Structure Analysis:
- Breakdown of fixed assets vs. current assets
- Structure of equity vs. liabilities
- Changes in working capital, working capital requirements, and net cash
-
Key Financial Ratios (calculate and interpret each):
- Liquidity ratios (current, quick, cash)
- Solvency ratios (financial autonomy, debt ratio)
- Profitability ratios (ROE, ROA)
- Fixed asset coverage ratio
-
Points of Concern: Identify 3-5 warning signals or risk areas.
-
Strengths: Identify 3-5 financial strengths of the company.
-
Recommendations: Propose 3-5 concrete actions to improve the financial situation.
Present the ratios in a comparative table with industry standards where relevant. Use a professional but accessible tone. Here are 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 a precise expert role to Gemini, which guides the quality and depth of the analysis. The six-section numbered structure forces a comprehensive and organized response, covering all critical aspects of a balance sheet analysis. The explicit request for ratio calculation with interpretation and industry comparison fully leverages Gemini's quantitative reasoning capabilities.
Use Cases
Variants
Expected Output
You will receive a complete and structured financial analysis report, including an overall diagnosis, tables of calculated and interpreted ratios, as well as a list of strengths, risks, and actionable recommendations. The result will be comparable to an audit firm's summary note, presented clearly and professionally, directly usable for decision-making or presentation to a management committee.
Frequently Asked Questions
What format should I use to provide balance sheet data to Gemini?
Gemini can process data in several formats. The most efficient method is to copy-paste a structured table with line items in rows and amounts in columns (current year and previous year, if available). You can also directly import a PDF file or an image of the balance sheet into Gemini, which will extract the data using its multimodal capabilities. For best results, ensure the data is legible and includes the account line item labels, amounts in euros, and the relevant fiscal year.
Can Gemini compare my balance sheet against industry benchmarks?
Yes, Gemini has knowledge of average industry ratios and can contextualize your analysis. To get a relevant comparison, specify the company's industry sector, its size (micro-business, SME, mid-market, large corporation), and its country in your prompt. Gemini will leverage known industry benchmarks to assess whether your ratios are above or below norms. However, keep in mind that these norms are indicative and may vary depending on the source.
Are the financial analysis results from Gemini reliable enough for making decisions?
Gemini provides professional-quality analysis that serves as an excellent starting point, but it does not replace the expertise of a certified accountant or financial analyst. The ratio calculations are reliable if the data provided is accurate and complete. On the other hand, contextual interpretation (economic climate, regulatory specifics, exceptional events) may require a human touch. Use Gemini's analysis as a decision-support and pre-diagnosis tool, then validate critical conclusions with a professional before making any major strategic decision.
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 affiner les normes sectorielles, précisez le secteur d'activité dans les données (ex : "secteur : distribution") et fournissez idéalement deux exercices consécutifs. Gemini pourra ainsi calculer les tendances et ajuster les benchmarks, rendant l’analyse bien plus pertinente.
📬 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.