Prompt Gemini 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 and structured data processing capabilities, becomes a valuable assistant for deciphering the information contained in a balance sheet. Whether you are a business leader assessing your company's financial health, an investor analyzing an opportunity, or an accounting student seeking to deepen your understanding, Gemini can turn columns of numbers into actionable insights. The AI excels particularly in 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.

The prompt

Gemini

Act as a senior financial analyst with 15 years of experience in auditing and analyzing financial balance sheets. I will provide you with the data from a financial balance sheet. Perform a complete 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. debt
- Evolution of working capital, working capital requirement, and net cash
Key Financial Ratios (calculate and interpret each):
- Liquidity ratios (current, quick, cash)
- Solvency ratios (financial autonomy, debt)
- Profitability ratios (ROE, ROA)
- Fixed asset coverage ratio
Points of Attention: Identify 3 to 5 warning signals or risk areas.
Strengths: Identify 3 to 5 financial strengths of the company.
Recommendations: Propose 3 to 5 concrete actions to improve the financial situation.

Present the ratios in a comparative table with industry norms where relevant. Use a professional yet 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 it works

This prompt is effective because it assigns a precise expert role to Gemini, which guides the quality and depth of the analysis. The structure in six numbered sections forces an exhaustive 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.

Expected result

You will obtain a complete and structured financial analysis report, including an overall diagnosis, calculated and interpreted ratio tables, and a list of strengths, risks, and actionable recommendations. The result will be comparable to a summary note produced by an audit firm, presented clearly and professionally, directly usable for decision-making or presentation to a management committee.

Variants by level

FAQ

In what format should I provide the balance sheet data to Gemini?

Gemini can process data in several formats. The most effective way is to copy and paste a structured table with items in rows and amounts in columns (year N and N-1 if available). You can also directly import a PDF file or an image of the balance sheet into Gemini, which will be able to extract the data thanks to its multimodal capabilities. For best results, ensure the data is legible and includes the names of accounting items, amounts in euros, and the relevant fiscal year.

Can Gemini compare my balance sheet with industry norms?

Yes, Gemini has knowledge of average ratios by industry sector and can contextualize your analysis. To get a relevant comparison, specify the company's industry sector, size (micro-enterprise, SME, mid-cap, large corporation), and country in your prompt. Gemini will rely on known sector benchmarks to assess whether your ratios are above or below norms. However, keep in mind that these norms are indicative and may vary by source.

Are the results of the financial analysis by Gemini reliable for making decisions?

Gemini provides a professional-quality analysis that serves as an excellent starting point, but it does not replace the expertise of a certified accountant or financial analyst. Ratio calculations are reliable if the provided data is accurate and complete. However, contextual interpretation (economic conditions, regulatory specifics, exceptional events) may require human judgment. Use Gemini's analysis as a decision-support and pre-diagnosis tool, then validate critical conclusions with a professional before making any major strategic decisions.

How to use this prompt

Copy the prompt with the button above.
Paste it into ChatGPT, Claude or your favorite AI assistant.
Replace the bracketed variables with your details, then refine the result.

About Prompt Guide

Prompt Guide is a free library of 4800+ ready-to-use prompts for ChatGPT, Claude and other AIs, with guides to learn prompting and tools to build and optimize your own prompts.

Prompt library Learn prompting Prompt builder Prompt optimizer

Already have a prompt?

Paste it into the Optimizer, AI improves it in 5 seconds: role, context, format. Free, no signup.

Open the Optimizer

More prompts to explore

Prompt Gemini to Draft Terms of Service

Drafting Terms of Service (ToS) is a legal necessity for any website, mobile app, or online service. These documents define the relationship between the provider and its users, establish rights and obligations, and protect the business in case of disputes. However, writing them is often seen as complex, costly, and time-consuming. Gemini, Google's AI model, offers a powerful solution to generate structured, comprehensive ToS tailored to your activity. With its ability to process detailed instructions and produce coherent legal content, Gemini lets you obtain a professional first draft of your ToS in minutes. Whether you're launching an e-commerce site, a SaaS platform, or a blog with a member area, a well-crafted prompt will guide Gemini to cover all essential clauses: purpose of service, intellectual property, data protection, limitation of liability, and termination terms. However, it remains essential to have the final document validated by a legal professional to ensure compliance with current laws.

Prompt Gemini to Write a Master's Thesis

Writing a master's thesis is one of the most demanding academic exercises: structuring complex thought, articulating a relevant problem statement, mobilizing reliable sources, and producing coherent argumentation over several dozen pages.

Prompt GitHub Copilot for Creating an Editorial Calendar

GitHub Copilot, the AI-powered coding assistant, proves to be an unexpected ally for content creators and marketing teams. Beyond code generation, Copilot excels at structuring complex data, making it a formidable tool for designing a comprehensive editorial calendar. By leveraging its intelligent completion and structure generation capabilities, you can produce in minutes a publication plan organized by themes, distribution channels, and key dates. Whether you manage a corporate blog, a multi-platform social media strategy, or a weekly newsletter, a well-crafted prompt transforms Copilot into a true editorial planner. The major advantage lies in its ability to generate exploitable data structures — JSON, CSV, Markdown tables — directly integrable into your project management tools. This guide offers an optimized prompt and its variants to create an editorial calendar tailored to your needs, whether it's a simple monthly schedule or a quarterly multi-channel content strategy with performance indicators.

Prompt GitHub Copilot for Creating Images

GitHub Copilot, developed by GitHub in partnership with OpenAI, is primarily known as a coding assistant, but its capabilities now extend to image generation thanks to the integration of multimodal models like GPT-4o. Directly from your IDE or the Copilot Chat interface, you can describe an image in natural language and get an AI-generated visual. This feature is particularly useful for developers who want to quickly create interface mockups, icons, illustrations for their documentation, or visual assets without leaving their work environment. By mastering the right prompting techniques, you can obtain precise images that are consistent with your project and ready to be integrated. This guide offers an optimized prompt as well as several variants adapted to your level, to fully exploit GitHub Copilot's image generation potential and accelerate your daily creative workflow.

Prompt GitHub Copilot for Data Analysis

GitHub Copilot, the AI assistant developed by GitHub and OpenAI, is not limited to code generation. It is a powerful tool for analyzing data directly in your development environment.

Prompt GitHub Copilot for HR Data Analysis

HR data analysis has become a strategic lever for companies looking to optimize human capital management. GitHub Copilot, integrated