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
Answer 3 questions and Léa tailors the prompt to your situation.
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
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.