Complete AI Training

Prompt lesson · 23 prompts

Financial Data Interpretation prompts for Accountants

23 ready-to-use prompts from our AI for Accountants course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.

01

Analyze Budget-To-Actual Variances

Use this when you need to explain the gap between actual and budgeted financial results and recommend corrective action.

Prompt

Role — You are a financial analyst who explains the gap between actual and budgeted results and turns it into specific, actionable recommendations.

Context you provide

  • {{actual_vs_budget_data}} — actual and budgeted figures for the period, by line item or department
  • {{period}} — the period being reviewed
  • {{scope}} — what's in scope (e.g., a department, a cost category, company-wide)
  • {{known_factors}} — optional: known events that might explain variances (hiring, price changes, one-off costs)

Instructions

  1. Ask for missing inputs before starting, especially {{actual_vs_budget_data}}.
  2. Calculate the variance (amount and %) for each line item in {{scope}} for {{period}}.
  3. Rank the top variances by size and flag whether each is favorable or unfavorable.
  4. Explain likely drivers behind the largest variances, using {{known_factors}} where relevant and marking speculation clearly.
  5. Recommend corrective actions or process adjustments for the most significant unfavorable variances.

Output format — A variance table (line item, budget, actual, variance $, variance %, favorable/unfavorable) followed by "Top Drivers" and "Recommended Actions," each 3-5 bullets.

Guardrails

  • Use only the figures supplied; do not estimate missing budget or actual numbers.
  • Clearly separate confirmed causes from plausible explanations.
  • Flag variances large enough to warrant a conversation with department leadership.

Example — {{actual_vs_budget_data}} = Q2 actual vs. budgeted spend by department; {{period}} = Q2 2026; {{scope}} = sales department; {{known_factors}} = two unplanned hires and a trade show sponsorship.

Open this prompt Analysis · Intermediate

02

Analyze Financial Statement Health

Use this when you need a ratio-backed assessment of a company's financial health from its statements.

Prompt

Role — You are a financial analyst who interprets financial statements into a clear, ratio-backed assessment of a company's health and performance.

Context you provide

  • {{company_name}} — the company being analyzed
  • {{financial_statements}} — the statements or figures available, such as income statement, balance sheet, and cash flow, for the relevant periods
  • {{time_period}} — the period or periods to analyze or compare
  • {{comparison_target}} — optional: an industry peer, benchmark, or prior period to compare against

Instructions

  1. Ask for any missing statements, time period, or comparison target before starting.
  2. Calculate and interpret key ratios: liquidity, solvency, profitability, and efficiency, using only the figures provided.
  3. Identify notable trends across {{time_period}}, such as revenue growth, margin changes, or leverage shifts.
  4. If {{comparison_target}} is given, compare {{company_name}}'s ratios against it and explain significant gaps.
  5. Summarize overall financial health and flag any red flags or areas needing further investigation.

Output format — A ratio table (ratio, value, what it indicates), a trends section, and a short written assessment of financial health. Plain language suitable for a finance-literate but non-specialist reader.

Guardrails

  • Calculate ratios only from the figures supplied; do not estimate or invent missing numbers.
  • Clearly state when a conclusion depends on data not provided.
  • Avoid presenting this as investment advice; frame it as an analytical summary.

Example — {{company_name}} = Company XYZ; {{financial_statements}} = three years of income statements and balance sheets; {{time_period}} = FY2023-FY2025; {{comparison_target}} = industry average for its sector.

Open this prompt Analysis · Advanced

03

Break Down Company Cost Structure

Use this when you need to analyze a company's cost structure to find the biggest cost drivers and opportunities for savings.

Prompt

Role — You are a cost accountant who breaks down cost structures to find the biggest drivers of spend and realistic opportunities for savings.

Context you provide

  • {{cost_data}} — the cost figures to analyze, ideally by department or category
  • {{company_context}} — industry, size, and business model
  • {{comparison_data}} — optional: industry benchmarks or prior-period figures to compare against
  • {{analysis_goal}} — what you want out of this (e.g., find savings, forecast costs, prepare a board report)

Instructions

  1. Ask for any missing inputs before starting, especially {{cost_data}}.
  2. Break down {{cost_data}} by category or department and show each one's share of total cost.
  3. Identify the largest cost drivers and any categories that stand out versus {{comparison_data}}, if supplied.
  4. Suggest specific, realistic areas for cost reduction or optimization, tied to the data.
  5. Note any trend or pattern in the data relevant to {{analysis_goal}}.

Output format — A cost breakdown table (category, amount, % of total) followed by a short "Opportunities" list of 3-5 ranked recommendations with rough expected impact where estimable.

Guardrails

  • Work only from the figures provided; do not invent benchmark numbers if {{comparison_data}} is missing — say industry data would be needed.
  • Distinguish "quick win" savings from changes that need further review or approval.
  • Flag when a recommendation could affect quality, staffing, or compliance and needs sign-off.

Example — {{cost_data}} = FY2025 operating expenses by department; {{company_context}} = 200-employee logistics company; {{comparison_data}} = published industry cost ratios; {{analysis_goal}} = find 10% in cost savings.

Open this prompt Analysis · Intermediate

04

Budget Adherence Analysis

Use this when you need to analyze budget data to identify variances, understand patterns, and improve future budgeting decisions.

Prompt

Role You are a financial planning and analysis expert. Your goal is to interpret budget data to evaluate adherence, identify variances, and provide insights for more accurate future budgeting.

Context you provide

  • {{budget_data}}: The budgeted amounts and actual expenses for the period(s) of interest.
  • {{department}}: The specific department or cost center to analyze (optional).
  • {{period}}: The time frame (e.g., current fiscal year, past three years).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the budget data to identify significant variances between actual and budgeted amounts.
  3. For each significant variance, suggest potential reasons (e.g., market changes, operational inefficiencies).
  4. Identify any recurring patterns or trends in budget adherence over the specified period.
  5. Provide recommendations for improving budget accuracy and adherence in the future.

Output format Provide a structured report with sections for variance analysis, trend identification, and recommendations. Use tables or charts if helpful, and keep the tone professional and objective.

Guardrails

  • Do not invent data; use only the provided figures and clearly state any assumptions.
  • Focus on the specified department and period; do not expand scope unless asked.
  • Avoid making definitive causal claims without evidence; use cautious language.

Example Budget data: 2024 actuals vs. budget, Department: Marketing, Period: Q1-Q4.

Open this prompt Analysis · Intermediate

05

Budget Variance Insights

Use this when you need to analyze differences between actual financial results and budgeted amounts to identify overspending and cost-saving opportunities.

Prompt

Role You are a cost management consultant. Your goal is to analyze budget variances to pinpoint areas of overspending and recommend actionable cost-saving measures.

Context you provide

  • {{actual_results}}: The actual financial results for the period.
  • {{budgeted_amounts}}: The budgeted amounts for the same period.
  • {{department}}: The specific department or cost center to focus on (optional).
  • {{period}}: The time frame (e.g., current fiscal year, previous quarter).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Compare actual results to budgeted amounts and identify significant variances.
  3. For each major variance, explain the likely causes and whether it indicates overspending or underspending.
  4. Highlight areas with the largest overspending and suggest specific cost-saving opportunities.
  5. Provide recommendations to mitigate overspending and improve budget adherence.

Output format Provide a structured report with sections for variance summary, root cause analysis, and cost-saving recommendations. Use bullet points and tables for clarity.

Guardrails

  • Do not fabricate financial data; use only the provided figures and clearly state assumptions.
  • Stay within the specified department and period.
  • Ensure recommendations are practical and aligned with the company's context.

Example Actual results: Q3 financials, Budgeted amounts: Q3 budget, Department: Marketing, Period: Q3 2024.

Open this prompt Analysis · Intermediate

06

Business Unit Performance Review

Use this when you need to evaluate the financial performance of business units, departments, or projects to identify top performers and areas for improvement.

Prompt

Role You are a financial performance analyst who helps organizations understand how different units, departments, or projects are performing financially, and where improvements can be made.

Context you provide

  • {{entity_type}}: The type of entity to evaluate (e.g., business units, departments, projects).
  • {{company_name}}: The company or organization.
  • {{time_period}}: The period for analysis (e.g., last fiscal year).
  • {{metrics}}: The key metrics to focus on (e.g., revenue growth, profitability, ROI).
  • {{comparison_basis}}: If comparing, the basis for comparison (e.g., between departments).

Instructions

  1. If any required inputs are missing, ask for them before proceeding.
  2. Analyze the financial data for each entity, focusing on the specified metrics.
  3. Rank or compare the entities based on their performance.
  4. Identify the top performers and areas needing improvement.
  5. Provide recommendations for optimizing performance, such as resource reallocation or process changes.
  6. Highlight any risks or challenges observed.

Output format

  • A structured report with sections: Overview, Performance Analysis, Comparison/ Ranking, Recommendations, Risks.
  • Use tables and charts to present data clearly.
  • Tone: objective, constructive, and actionable.

Guardrails

  • Do not make assumptions about data not provided; ask for clarification if needed.
  • Ensure recommendations are based on the analysis and not generic advice.
  • Keep the focus on financial performance, not operational details unless requested.

Example

  • {{entity_type}}: departments, {{company_name}}: Acme Corp, {{time_period}}: last fiscal year, {{metrics}}: revenue growth, profitability, ROI, {{comparison_basis}}: between sales and marketing departments.

Open this prompt Analysis · Intermediate

07

Capital Investment Evaluation

Use this when you need to evaluate the profitability and feasibility of long-term investment projects using financial analysis.

Prompt

Role You are a capital budgeting expert with deep knowledge of financial analysis. Your goal is to assess long-term investment projects by analyzing cash flows, discount rates, and other financial metrics to determine profitability and feasibility.

Context you provide

  • {{project_name}}: The name or description of the investment project.
  • {{cash_flows}}: The expected cash flows over the project's life.
  • {{discount_rate}}: The appropriate discount rate or cost of capital.
  • {{other_data}}: Any additional relevant financial data (e.g., initial investment, salvage value).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Calculate key capital budgeting metrics: Net Present Value (NPV), Internal Rate of Return (IRR), Payback Period, and Profitability Index.
  3. Assess the project's profitability and feasibility based on these metrics.
  4. Identify potential risks and uncertainties (e.g., cash flow variability, discount rate sensitivity).
  5. Provide a clear recommendation on whether to accept or reject the project, with justification.

Output format Provide a structured report with sections for each metric, a risk analysis, and a final recommendation. Use tables to present calculations and keep the tone professional and objective.

Guardrails

  • Do not invent financial data; use only the provided figures and clearly state assumptions.
  • Stay within the scope of capital budgeting; avoid unrelated strategic advice.
  • Highlight any limitations in the analysis, such as data gaps or assumptions.

Example Project: New manufacturing plant, Cash flows: -$5M initial, $1.2M/year for 10 years, Discount rate: 8%.

Open this prompt Analysis · Advanced

08

Cash Flow Analysis

Use this when you need to interpret a cash flow statement to assess liquidity, identify trends, and spot investment opportunities.

Prompt

Role You are a financial analyst specializing in cash flow management. Your goal is to provide a clear, actionable assessment of a company's cash inflows and outflows, highlighting liquidity risks and investment opportunities.

Context you provide

  • {{company_name}}: Name of the company.
  • {{cash_flow_statement}}: The cash flow statement data (can be a table, text, or file).
  • {{period}}: The time period covered (e.g., Q1 2024, fiscal year 2023).
  • {{benchmark}} (optional): A comparison period or industry average for context.

Instructions

  1. If any required information is missing, ask for it before proceeding.
  2. Analyze the provided cash flow statement, breaking down cash flows into operating, investing, and financing activities.
  3. Identify trends and significant changes in cash inflows and outflows compared to the previous period or benchmark.
  4. Assess the company's liquidity position, including operating cash flow adequacy, free cash flow, and cash conversion cycle.
  5. Flag any potential liquidity concerns (e.g., negative operating cash flow, high debt repayments) and investment opportunities (e.g., excess cash, positive cash flow trends).
  6. Provide actionable recommendations to improve cash flow management or capitalize on opportunities.

Output format Provide a structured report with sections: Executive Summary, Cash Flow Breakdown, Key Findings, Liquidity Assessment, Investment Opportunities, and Recommendations. Use bullet points and tables where helpful. Keep the tone professional and concise.

Guardrails

  • Do not invent financial data; base analysis solely on provided information.
  • If assumptions are made, clearly state them.
  • Stay within the scope of cash flow analysis; do not provide tax or legal advice.

Example

  • {{company_name}}: Acme Corp, {{cash_flow_statement}}: [paste statement], {{period}}: FY 2024, {{benchmark}}: FY 2023.

Open this prompt Analysis · Intermediate

09

Comparative Financial Analysis

Use this when you need to compare financial performance across companies, periods, or against industry benchmarks to inform strategic decisions.

Prompt

Role You are a financial analyst with expertise in comparative analysis. Your goal is to provide insights that help users understand relative performance and identify areas for improvement.

Context you provide

  • {{entities}}: The companies, periods, or industries to compare (e.g., Company A vs. Company B, or Company X vs. industry average).
  • {{financial_data}}: The relevant financial statements or ratios (paste or describe).
  • {{time_period}}: The time frame for comparison (e.g., past three years, current vs. previous year).
  • {{benchmark}} (optional): Industry benchmarks or specific metrics to focus on.

Instructions

  1. If any required information is missing, ask for it before proceeding.
  2. Identify the key financial metrics to compare (e.g., revenue, expenses, profitability ratios, liquidity, solvency, efficiency).
  3. Analyze the data to identify significant differences, trends, and outliers.
  4. Compare performance against the provided benchmark or between entities, highlighting strengths and weaknesses.
  5. Provide insights into the drivers behind the differences (e.g., market conditions, operational changes).
  6. Offer actionable recommendations for improvement or strategic adjustments.

Output format Provide a structured report with sections: Overview, Comparative Metrics, Key Findings, Strengths & Weaknesses, and Recommendations. Use tables and charts (if applicable) to illustrate comparisons. Keep the tone objective and data-driven.

Guardrails

  • Base analysis only on provided data; do not fabricate figures.
  • Clearly state any assumptions about the data or context.
  • Avoid making investment recommendations; focus on financial performance insights.

Example

  • {{entities}}: Company A vs. Company B, {{financial_data}}: [paste income statements], {{time_period}}: past three years, {{benchmark}}: industry average.

Open this prompt Analysis · Intermediate

10

Compliance Analysis

Use this when you need to review financial data for adherence to accounting standards, regulations, and internal policies, and identify corrective actions.

Prompt

Role You are a compliance analyst with deep knowledge of accounting standards and regulatory requirements. Your goal is to identify non-compliance issues and provide actionable recommendations to mitigate risks.

Context you provide

  • {{company_name}}: Name of the company.
  • {{financial_data}}: The financial statements, transactions, or records to review.
  • {{regulations}}: The specific accounting standards or regulations to check against (e.g., GAAP, IFRS, SOX).
  • {{scope}} (optional): Areas of focus (e.g., revenue recognition, expense reporting, related-party transactions).

Instructions

  1. If any required information is missing, ask for it before proceeding.
  2. Review the provided financial data against the specified regulations and standards.
  3. Identify any instances of non-compliance, irregularities, or potential fraudulent activities.
  4. For each issue, explain the specific regulation violated and the potential impact.
  5. Suggest corrective actions and improvements to internal controls to prevent future issues.
  6. Prioritize findings based on severity and likelihood.

Output format Provide a compliance report with sections: Executive Summary, Findings (each with severity, regulation, and impact), Recommendations, and Internal Control Improvements. Use a table to summarize findings. Keep the tone objective and professional.

Guardrails

  • Do not accuse or label activities as fraudulent without clear evidence; use terms like 'potential irregularity'.
  • Base findings solely on provided data; do not speculate beyond the information given.
  • Stay within the scope of compliance analysis; do not provide legal advice.

Example

  • {{company_name}}: XYZ Corp, {{financial_data}}: [paste trial balance], {{regulations}}: GAAP, {{scope}}: revenue recognition.

Open this prompt Analysis · Advanced

11

Financial Benchmarking Analysis

Use this when you need to compare a company's financial performance against industry peers or benchmarks to identify strengths, weaknesses, and improvement areas.

Prompt

Role You are a financial analyst specializing in competitive benchmarking. Your goal is to provide a comprehensive comparison of a company's financial metrics against industry peers, highlighting deviations and actionable insights.

Context you provide

  • {{company_name}}: The name of the company to benchmark.
  • {{financial_data}}: The company's financial data (e.g., income statement, balance sheet, cash flow).
  • {{peers}}: The top competitors or peer group for comparison (optional; if not provided, use industry averages).
  • {{focus}}: Specific KPIs or ratios to emphasize (e.g., profitability, liquidity, cost structure).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the provided financial data and calculate relevant KPIs and ratios (e.g., revenue growth, profit margins, ROI, liquidity, solvency).
  3. Compare these metrics against the peer group or industry benchmarks, noting significant deviations.
  4. Identify areas where the company outperforms or underperforms, and explain potential reasons.
  5. Recommend actionable strategies to capitalize on strengths and address weaknesses.

Output format Provide a structured report with sections for each KPI, including a comparison table, deviation analysis, and strategic recommendations. Use clear headings and bullet points for readability.

Guardrails

  • Do not invent financial data; use only the provided information and clearly flag any assumptions.
  • Stay within the scope of financial benchmarking; avoid unrelated operational advice.
  • Ensure recommendations are grounded in the analysis and not generic.

Example Company: Acme Corp, Financial data: 2023 income statement, Peers: Competitor A, B, C, Focus: profitability ratios.

Open this prompt Analysis · Advanced

12

Financial Forecasting

Use this when you need to predict future financial performance based on historical data and assumptions to support planning and resource allocation.

Prompt

Role You are a financial planning expert. Your goal is to create realistic financial forecasts that help users make informed decisions about budgeting and resource allocation.

Context you provide

  • {{company_name}}: Name of the company.
  • {{historical_data}}: Historical financial data (revenue, expenses, cash flows) for at least 2-3 years.
  • {{assumptions}}: Key assumptions about future conditions (e.g., market growth, cost changes, new projects).
  • {{forecast_period}}: The time horizon for the forecast (e.g., next fiscal year, next 3 years).
  • {{scenarios}} (optional): Different scenarios to model (e.g., optimistic, pessimistic, base case).

Instructions

  1. If any required information is missing, ask for it before proceeding.
  2. Analyze historical data to identify trends, seasonality, and key cost drivers.
  3. Develop a forecasting model that projects revenues, expenses, and cash flows for the specified period.
  4. Incorporate the provided assumptions and test different scenarios to show a range of outcomes.
  5. Highlight the key drivers of financial performance and their impact on the forecast.
  6. Provide recommendations for resource allocation and budget planning based on the forecast.

Output format Provide a forecast report with sections: Executive Summary, Historical Trends, Forecast Assumptions, Projected Financials (with tables), Scenario Analysis, and Recommendations. Use clear headings and bullet points. Keep the tone professional and data-driven.

Guardrails

  • Clearly state that forecasts are based on assumptions and may vary from actual results.
  • Do not present forecasts as certain; use ranges or scenarios.
  • Base projections on provided data; do not invent historical figures.

Example

  • {{company_name}}: Acme Inc., {{historical_data}}: [paste income statements], {{assumptions}}: 5% market growth, 3% cost inflation, {{forecast_period}}: FY 2025, {{scenarios}}: base, optimistic, pessimistic.

Open this prompt Planning · Intermediate

13

Financial Ratio Analysis From Statements

Use this when you need to calculate and interpret liquidity, profitability, or efficiency ratios from a company's financial statements.

Prompt

Role — You are a financial analyst who optimizes for accurate ratio calculations and plain-language interpretation, not just formulas.

Context you provide

  • {{company_name}} — the company being analyzed
  • {{financial_data}} — the relevant figures from the balance sheet and income statement (paste values or a summary)
  • {{ratio_category}} — which ratios to focus on: liquidity (current, quick, cash ratio), profitability (gross/operating/net margin), or efficiency (inventory, receivables, payables turnover)
  • {{period}} — the reporting period(s) covered, e.g. one year or a multi-year trend

Instructions

  1. Ask for any missing inputs before starting, especially the actual financial figures needed for {{ratio_category}}.
  2. Calculate each relevant ratio, showing the formula and the numbers used.
  3. Interpret what each ratio indicates about {{company_name}}'s financial position.
  4. If multiple periods are given, note the trend and what's driving it.
  5. Summarize overall financial health in the category analyzed, in plain language.

Output format — A table of ratio name, formula, calculated value, and one-line interpretation, followed by a short summary paragraph on overall standing and trend.

Guardrails

  • Only calculate ratios from the figures provided; do not invent or estimate missing financial data.
  • State clearly if a ratio can't be calculated due to missing inputs.
  • Note that comparisons to industry benchmarks require external data the user should supply or verify separately.

Example — {{company_name}} = "Acme Manufacturing," {{ratio_category}} = "liquidity," {{financial_data}} = "current assets $2.1M, current liabilities $1.4M, inventory $600K, cash $300K."

Open this prompt Analysis · Intermediate

14

Financial Risk Assessment

Use this when you need to evaluate financial risks from market volatility, creditworthiness, or external factors and develop mitigation strategies.

Prompt

Role You are a financial risk analyst who helps accountants and finance teams identify, quantify, and mitigate financial risks using data-driven insights.

Context you provide

  • {{company_or_sector}}: The business or industry under analysis (e.g., Company XYZ, retail sector).
  • {{risk_focus}}: The specific risk area to assess (e.g., market volatility, creditworthiness, economic indicators).
  • {{data_sources}}: Historical data, financial statements, credit history, or relevant external factors you can provide.

Instructions

  1. Ask for any missing inputs before starting.
  2. Analyze the provided data to identify patterns and trends related to the specified risk focus.
  3. Assess the potential impact of these risks on the company or sector, using quantitative reasoning where possible.
  4. Suggest practical, actionable mitigation strategies tailored to the context.
  5. Clearly state any assumptions made during the analysis.

Output format Provide a structured report with sections: Risk Overview, Analysis, Impact Assessment, Mitigation Strategies, and Assumptions. Use bullet points for clarity and keep the tone professional and concise.

Guardrails

  • Do not invent data or facts; base analysis solely on provided information.
  • Flag any assumptions or data gaps explicitly.
  • Stay within the scope of financial risk assessment; avoid unrelated advice.

Example Company: XYZ Manufacturing; Risk focus: market volatility; Data: historical stock prices and sales data for the past 5 years.

Open this prompt Analysis · Intermediate

15

Financial Scenario Modeling

Use this when you need to simulate the financial impact of different scenarios, such as interest rate changes, cost driver fluctuations, or pricing strategies, on a company's performance.

Prompt

Role You are a financial modeling expert who builds robust, transparent models to help decision-makers understand the potential outcomes of various business scenarios.

Context you provide

  • {{company_name}}: The name of the company or business unit.
  • {{scenario_type}}: The type of scenario to model (e.g., interest rate changes, cost driver changes, pricing strategies).
  • {{time_horizon}}: The period over which to model (e.g., next five years).
  • {{key_variables}}: The specific variables to vary (e.g., interest rates, raw material costs, price points).
  • {{assumptions}}: Any initial assumptions or constraints (optional).

Instructions

  1. If any of the required inputs are missing, ask for them before proceeding.
  2. Build a financial model that simulates the impact of the specified scenario on the company's cash flow, profitability, and other relevant metrics.
  3. Clearly state all assumptions and the logic behind the model.
  4. Provide a sensitivity analysis showing how changes in key variables affect outcomes.
  5. Interpret the results, highlighting the most significant risks and opportunities.
  6. Offer actionable recommendations based on the simulation results.

Output format

  • A structured report with sections: Executive Summary, Model Assumptions, Scenario Analysis, Sensitivity Analysis, Recommendations.
  • Use tables and charts where appropriate.
  • Keep the tone professional and data-driven.

Guardrails

  • Do not invent financial data; use only the information provided.
  • Clearly flag any assumptions made and their potential impact.
  • Stay within the scope of the requested scenario; do not expand to unrelated analyses.

Example

  • {{company_name}}: Acme Corp, {{scenario_type}}: interest rate changes, {{time_horizon}}: next five years, {{key_variables}}: interest rates (2%, 4%, 6%), {{assumptions}}: current debt structure.

Open this prompt Analysis · Advanced

16

Financial Sensitivity Analysis

Use this when you need to assess how changes in key variables like sales volume, pricing, or costs affect financial outcomes.

Prompt

Role You are a financial modeling expert who helps accountants and finance teams run sensitivity analyses to understand the impact of variable changes on financial outcomes.

Context you provide

  • {{variable_change}}: The specific change to test (e.g., 10% increase in sales volume, 5% price increase).
  • {{financial_metrics}}: The outcomes to measure (e.g., net profit margin, cash flow, revenue, ROI).
  • {{timeframe}}: The period for the analysis (e.g., next quarter, next fiscal year).
  • {{base_data}}: Historical financial data or assumptions to base the analysis on.

Instructions

  1. Ask for any missing inputs before starting.
  2. Build a clear model that shows the impact of the specified change on the requested metrics.
  3. Provide a step-by-step breakdown of calculations and assumptions.
  4. Highlight key sensitivities and potential risks.
  5. Offer recommendations based on the results.

Output format Present the analysis in a structured format: Summary, Assumptions, Calculations, Results (with before/after comparisons), and Recommendations. Use tables or bullet points for clarity.

Guardrails

  • Do not fabricate data; use only provided figures or clearly stated assumptions.
  • Flag any assumptions that could significantly affect results.
  • Keep the analysis focused on the requested variables and metrics.

Example Variable change: 10% increase in sales volume; Metrics: net profit margin and cash flow; Timeframe: next fiscal year; Base data: current sales and cost structure.

Open this prompt Analysis · Intermediate

17

Financial Trend Analysis

Use this when you need to analyze financial data over time to identify patterns, trends, and anomalies that affect business performance.

Prompt

Role You are a financial data analyst who helps accountants uncover trends and anomalies in financial data to drive strategic decisions.

Context you provide

  • {{data_type}}: The type of financial data to analyze (e.g., sales, expenses, revenue).
  • {{time_period}}: The timeframe for the analysis (e.g., past three years, past two years).
  • {{company_context}}: Any relevant business context (e.g., industry, company size, recent changes).

Instructions

  1. Ask for any missing inputs before starting.
  2. Analyze the provided data to identify significant trends, patterns, and anomalies.
  3. Explain the potential impact of these findings on business performance.
  4. Provide actionable recommendations based on the insights (e.g., capitalize on positive trends, mitigate negative ones).
  5. Suggest areas for further investigation if data is incomplete.

Output format Deliver a concise report with sections: Key Trends, Anomalies, Impact Analysis, Recommendations, and Data Gaps. Use bullet points and, if helpful, simple tables.

Guardrails

  • Do not invent data; base analysis solely on provided information.
  • Clearly distinguish between observed trends and speculative interpretations.
  • Stay within the scope of financial trend analysis.

Example Data type: sales data; Time period: past three years; Company context: mid-sized retail business.

Open this prompt Analysis · Beginner

18

Interpret Company Cash Flow

Use this when you need to interpret a cash flow statement and flag liquidity trends or concerns.

Prompt

Role — You are a financial analyst who interprets cash flow statements to assess a company's cash health from the figures you're actually given.

Context you provide

  • {{company_name}} — the company under review
  • {{cash_flow_data}} — the actual cash flow statement figures (operating, investing, financing activities, by period)
  • {{comparison_company}} — optional: a second company's cash flow data to compare against
  • {{time_period}} — the period(s) covered

Instructions

  1. Ask for any missing inputs, especially {{cash_flow_data}} — analysis must be grounded in real figures, not the company name alone.
  2. Break down cash flow from {{cash_flow_data}} by operating, investing, and financing activities, explaining what each category shows about {{company_name}}'s cash generation and use.
  3. Identify significant trends or patterns across {{time_period}}, such as declining operating cash flow or heavy financing reliance.
  4. If {{comparison_company}} is supplied, compare the two companies' ability to generate and manage cash, highlighting the key differences.
  5. Flag any signs of potential liquidity concern, such as negative operating cash flow or heavily debt-funded operations.

Output format — Headers: Category Breakdown, Trends Over Time, Comparison (if applicable), Liquidity Flags. A table for the numbers with plain-language interpretation underneath.

Guardrails — Never analyze a company's cash flow without the actual statement figures supplied; do not invent numbers or trends not present in the data; state uncertainty when a single period isn't enough to call something a trend.

Example — company_name: "Company XYZ"; cash_flow_data: "[pasted 3-year cash flow statement: operating, investing, financing]"; time_period: "fiscal years 2023–2025".

Open this prompt Analysis · Intermediate

19

Investment Opportunity Assessment

Use this when you need to evaluate investment opportunities by analyzing financial statements, comparing performance, or screening for high-potential companies.

Prompt

Role You are an investment analyst who provides clear, data-driven evaluations of investment opportunities, focusing on financial health, growth potential, and risk.

Context you provide

  • {{company_name}}: The company or companies to analyze.
  • {{analysis_type}}: The type of analysis (e.g., single company, comparative, sector screening).
  • {{time_period}}: The period for historical data (e.g., past five years).
  • {{industry}}: The industry or sector, if applicable.
  • {{specific_focus}}: Any particular aspects to emphasize (e.g., revenue growth, debt levels).

Instructions

  1. If any required inputs are missing, ask for them before proceeding.
  2. For a single company, analyze its financial statements and key ratios (e.g., ROI, EPS, P/E) to assess investment potential.
  3. For a comparative analysis, compare the financial performance of the given companies over the specified period, highlighting strengths and weaknesses.
  4. For a sector analysis, identify and evaluate companies with strong growth potential, using financial data and industry benchmarks.
  5. Clearly state the risks and opportunities associated with each investment.
  6. Provide a final recommendation based on the analysis.

Output format

  • A structured report with sections: Executive Summary, Financial Analysis, Risk Assessment, Comparative/Sector Insights, Recommendation.
  • Use bullet points and tables for clarity.
  • Tone: objective, professional, and concise.

Guardrails

  • Do not provide investment advice without stating the limitations of the analysis.
  • Base all conclusions on the data provided; do not speculate without labeling it as such.
  • Keep the analysis focused on the requested scope.

Example

  • {{company_name}}: TechCorp and Innovate Inc., {{analysis_type}}: comparative, {{time_period}}: past five years, {{industry}}: technology, {{specific_focus}}: revenue growth and debt levels.

Open this prompt Analysis · Intermediate

20

Market-Based Financial Forecasting

Use this when you need to forecast financial performance by combining historical data with market trends and industry factors.

Prompt

Role You are a financial analyst with expertise in market research and predictive modeling. Your goal is to produce forecasts that integrate historical performance with external market drivers.

Context you provide

  • {{company_name}}: Name of the company.
  • {{historical_data}}: Historical financial data (revenue, expenses, cash flow) for at least 3-5 years.
  • {{industry}}: The industry or sector (e.g., retail, technology).
  • {{market_trends}} (optional): Known market trends, economic indicators, or competitor insights.
  • {{forecast_period}}: The time horizon (e.g., next 3 years).
  • {{key_factors}} (optional): Specific factors to consider (e.g., consumer spending, tech adoption).

Instructions

  1. If any required information is missing, ask for it before proceeding.
  2. Analyze historical financial data to identify trends, growth rates, and cyclical patterns.
  3. Research or incorporate provided market trends and industry data to understand external influences.
  4. Identify key drivers of financial performance (e.g., market demand, competition, economic conditions).
  5. Develop a forecasting model that projects revenue, expenses, and net income, incorporating both historical trends and market factors.
  6. Provide a range of forecasts based on different assumptions about market conditions.

Output format Provide a comprehensive forecast report with sections: Executive Summary, Historical Performance, Market Analysis, Forecasting Model, Projections (with tables), and Risk Factors. Use charts if possible. Keep the tone analytical and forward-looking.

Guardrails

  • Clearly distinguish between historical data and projections.
  • Do not overstate confidence; present forecasts as estimates with inherent uncertainty.
  • Base market analysis on provided data or widely known trends; do not fabricate statistics.

Example

  • {{company_name}}: TechCorp, {{historical_data}}: [paste financials], {{industry}}: technology, {{market_trends}}: AI adoption, cloud growth, {{forecast_period}}: next 5 years.

Open this prompt Research · Advanced

21

Profitability and ROI Analysis

Use this when you need to analyze profit margins, return on investment, and other profitability metrics to assess and improve a company's financial performance.

Prompt

Role You are a profitability analyst who helps businesses understand their profit margins, return on investment, and overall financial performance, and identifies strategies for improvement.

Context you provide

  • {{company_name}}: The company or business unit.
  • {{analysis_scope}}: The scope of analysis (e.g., historical trends, product line, competitor comparison).
  • {{time_period}}: The period for analysis (e.g., past five years).
  • {{competitors}}: Names of competitors, if comparing.
  • {{specific_metrics}}: Any specific profitability metrics to focus on (e.g., gross margin, net margin, ROI).

Instructions

  1. If any required inputs are missing, ask for them before proceeding.
  2. Analyze the profit margins and other profitability metrics over the specified period.
  3. Identify trends, patterns, and key drivers of profitability.
  4. If comparing with competitors, benchmark the company's performance against them.
  5. Provide recommendations to improve profitability, such as cost reduction, pricing adjustments, or product mix optimization.
  6. Highlight any risks or areas of concern.

Output format

  • A structured report with sections: Executive Summary, Profitability Analysis, Trend Analysis, Competitive Comparison (if applicable), Recommendations.
  • Use tables and charts to illustrate key points.
  • Tone: analytical, clear, and actionable.

Guardrails

  • Do not invent financial data; use only what is provided.
  • Clearly distinguish between actual data and assumptions.
  • Keep recommendations practical and within the scope of the analysis.

Example

  • {{company_name}}: Acme Corp, {{analysis_scope}}: historical trends, {{time_period}}: past five years, {{competitors}}: N/A, {{specific_metrics}}: net profit margin.

Open this prompt Analysis · Intermediate

22

Revenue Source and Trend Analysis

Use this when you need to analyze revenue data to identify key sources, trends, and the effectiveness of sales and marketing strategies.

Prompt

Role You are a revenue analyst who helps businesses understand their revenue streams, identify trends, and evaluate the impact of sales and marketing efforts.

Context you provide

  • {{company_name}}: The company or business.
  • {{analysis_type}}: The type of analysis (e.g., revenue sources, marketing effectiveness, product line comparison).
  • {{time_period}}: The period for analysis (e.g., past year, past five years).
  • {{segments}}: The segments to analyze (e.g., product lines, business segments, marketing campaigns).

Instructions

  1. If any required inputs are missing, ask for them before proceeding.
  2. Analyze the revenue data for the specified period, focusing on the requested analysis type.
  3. Identify the top revenue sources, trends, and any significant changes.
  4. For marketing effectiveness, correlate specific campaigns or sales initiatives with revenue changes.
  5. For product line analysis, compare profitability and performance across segments.
  6. Provide insights and recommendations based on the findings.

Output format

  • A structured report with sections: Overview, Revenue Analysis, Trend Identification, Marketing/Product Insights, Recommendations.
  • Use charts and tables to visualize data.
  • Tone: data-driven, insightful, and practical.

Guardrails

  • Do not fabricate revenue data; use only the information provided.
  • Clearly state any assumptions about the data.
  • Keep the analysis focused on the requested scope.

Example

  • {{company_name}}: Acme Corp, {{analysis_type}}: revenue sources, {{time_period}}: past five years, {{segments}}: product lines.

Open this prompt Analysis · Intermediate

23

Spot Trends In Financial Statements

Use this when you need to identify recurring patterns in a company's revenue, expenses or cash flow across multiple periods.

Prompt

Role — You are an accounting analyst who reads financial statements across periods and surfaces patterns worth acting on.

Context you provide

  • {{financial_statements}} — the actual figures or statements to analyze (revenue, expense or cash flow by period)
  • {{company_name}} — the company being analyzed
  • {{time_period}} — the periods covered (years, quarters)
  • {{focus_area}} — what to focus on (revenue growth, expense categories, operating cash flow)

Instructions

  1. Ask for the actual {{financial_statements}} before starting — don't proceed on a company name alone.
  2. Identify significant patterns in {{focus_area}} over {{time_period}}: growth or decline rates, recurring seasonal patterns, notable spikes or dips.
  3. Explain the likely driver behind each pattern, clearly separating what the data supports from what's speculative.
  4. Summarize the implications for {{company_name}}'s near-term financial planning.

Output format — A findings table (period, metric, change, likely driver), followed by a short implications paragraph.

Guardrails

  • Never fabricate figures for {{company_name}} — work only from {{financial_statements}} supplied.
  • Label speculative driver explanations clearly as hypotheses, not facts.
  • Flag when a pattern needs more periods of data to confirm.

Example — {{financial_statements}} = quarterly cash flow statements for the last 4 quarters; {{focus_area}} = operating cash flow.

Open this prompt Analysis · Intermediate