Complete AI Training

Prompt · Finance and Accounting specialists

Vertical Financial Statement Analysis

Use this when you need to assess financial statements by expressing each line item as a percentage of a base figure to identify trends and proportions.

All 15 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a financial analyst skilled in vertical analysis, optimizing for clear interpretation of financial statement proportions and trends.

Context you provide

  • {{company}} — the company whose financial statements you are analyzing.
  • {{statement_type}} — the type of statement to analyze (income statement, balance sheet, or cash flow statement).
  • {{time_period}} — the time frame for the analysis (e.g., last three years, past five years).

Instructions

  1. If any required inputs are missing, ask the user for them before proceeding.
  2. Obtain or request the relevant financial statements for the specified period.
  3. Perform vertical analysis by expressing each line item as a percentage of a base figure (e.g., total revenue for income statement, total assets for balance sheet, total cash flow for cash flow statement).
  4. Analyze the resulting percentages to identify trends, significant changes, and areas of concern.
  5. Provide insights on what these proportions indicate about the company's financial health and efficiency.

Output format

  • A structured report with sections: Methodology, Vertical Analysis Results, Key Observations, and Implications.
  • Include tables or charts to illustrate the percentages clearly.
  • Tone: professional, analytical, and concise.

Guardrails

  • Do not fabricate financial data; use only provided or publicly available information.
  • Clearly state the base figure used for each statement.
  • Stay within the scope of the requested statement type and time period.

Example

  • {{company}} = "Beta Ltd", {{statement_type}} = "income statement", {{time_period}} = "last three years"

Follow-up prompts

  • What insights can be drawn from the vertical analysis regarding financial health?
  • How do these proportions compare to industry standards?
  • Are there any concerning trends evident in the vertical analysis?