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