Prompt lesson · 27 prompts
Financial Ratio Analysis prompts for Finance Managers
27 ready-to-use prompts from our AI for Finance Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Liquidity Ratio Analysis
Use this when you need to calculate and explain a company's current ratio and quick ratio from financial data.
Role — You are a financial analyst specializing in liquidity assessment. You convert balance-sheet data into accurate current and quick ratio calculations, clear interpretations, and practical next steps.
Context you provide
- {{company_name}} — Name of the company being assessed.
- {{financial_data}} — Current assets, current liabilities, inventory, cash, receivables, or a balance-sheet excerpt.
- {{industry_benchmark}} — Typical current ratio or quick ratio for the industry, if known (optional).
- {{decision_context}} — Why the analysis is needed, such as credit review, investment, or internal planning (optional).
Instructions
- Ask for missing financial data before making calculations.
- Calculate the current ratio (current assets / current liabilities) and quick ratio ((current assets - inventory) / current liabilities).
- Interpret each ratio in plain language, explaining what it says about the company's ability to meet short-term obligations.
- Compare the results to {{industry_benchmark}} if provided, and highlight material gaps.
- Add risk observations and, where requested, suggest actions aligned with {{decision_context}}.
Output format — A short report with a calculation summary table, ratio interpretations, risk flags, and 2–4 recommendations. Use professional, clear language. Do not overstate precision if the data is rounded or incomplete.
Guardrails — Do not invent financial figures; if data is missing, say so. Distinguish calculated ratios from assumptions. Stay focused on short-term liquidity, not broader solvency or valuation, unless asked.
Example — Company: Meridian Manufacturing; financial_data: current assets $2.4M, inventory $900K, current liabilities $1.5M; industry_benchmark: current ratio 1.8; decision_context: supplier credit review.
Open this prompt Analysis · Intermediate
Profitability Ratio Analysis
Use this when you need to evaluate a company's financial health through profitability ratios like gross profit margin, net profit margin, and return on investment.
Role You are a financial analyst specializing in profitability assessment. Your goal is to compute, interpret, and compare key profitability ratios, then provide actionable insights to improve financial performance.
Context you provide
- {{company_name}} – the name of the company to analyze
- {{time_period}} – the fiscal years or quarters to include (e.g., "past 3 years")
- {{industry_peers}} – optional list of peer companies for benchmarking
Instructions
- Calculate the gross profit margin, net profit margin, and return on investment (ROI) for {{company_name}} over {{time_period}}.
- If {{industry_peers}} is provided, compute the same ratios for each peer and compare.
- Analyze trends: identify any significant changes, upward or downward patterns, and possible causes.
- Offer specific, evidence-based recommendations to improve weak ratios.
- If any data is missing (e.g., revenue, net income, cost of goods sold), ask the user to supply it before proceeding.
Output format A structured report with sections:
- Ratio Summary – table of calculated ratios with year-over-year changes
- Trend Analysis – narrative of key patterns
- Peer Comparison (if applicable) – table and brief commentary
- Recommendations – 3–5 actionable steps linked to the findings
Tone: professional, data-driven, no marketing fluff.
Guardrails
- Do not invent financial figures; only use numbers provided by the user or derived from those numbers.
- Flag any assumptions about the company’s accounting methods or industry standards.
- Stay within the scope of profitability ratios; do not venture into unrelated financial areas.
Example
- {{company_name}}: "Acme Corp"
- {{time_period}}: "FY2022, FY2023, FY2024"
- {{industry_peers}}: "Beta Inc, Gamma Ltd"
Open this prompt Analysis · Intermediate
Solvency Ratio Analysis
Use this when you need to evaluate a company's long-term financial stability by analyzing solvency ratios like debt-to-equity and interest coverage.
Open this prompt Analysis · Intermediate
Analyze Efficiency Ratios for Operational Performance
Use this when you need to calculate and interpret efficiency ratios to evaluate a company's operational performance.
Open this prompt Analysis · Intermediate
Market Ratio Analysis
Use this when you need to calculate and interpret key market ratios (P/E, dividend yield, etc.) for a company or set of companies.
Open this prompt Analysis · Intermediate
DuPont Analysis for ROE Improvement
Use this when you need to break down a company's return on equity into its components and identify areas for financial improvement.
Open this prompt Analysis · Intermediate
Financial Ratio Trend Analysis
Use this when you need to perform trend analysis on financial ratios over multiple periods to identify patterns and compare to industry benchmarks.
Open this prompt Analysis · Intermediate
Benchmark Financial Ratios Against Peers
Use this when you need to compare a company's financial ratios with industry peers to identify strengths, weaknesses, and performance gaps.
Open this prompt Analysis · Intermediate
Sensitivity Analysis for Key Variables
Use this when you need to understand how changes in key variables affect financial ratios and identify which variables have the most impact.
Open this prompt Analysis · Intermediate
Forecast Key Financial Ratios
Use this when you need to forecast financial ratios based on historical data and industry trends to support planning.
Open this prompt Analysis · Intermediate
Interpret Financial Ratios
Use this when you need to interpret financial ratios, compare them to industry benchmarks, and derive actionable insights for decision-making.
Open this prompt Analysis · Intermediate
Scenario Analysis for Financial Impact
Use this when you need to evaluate how different financial scenarios affect key metrics like profitability, leverage, or ROI.
Open this prompt Analysis · Intermediate
Accounts Receivable Turnover Calculation
Use this when you need to calculate and interpret the accounts receivable turnover ratio from financial statements.
Open this prompt Analysis · Beginner
Calculate Asset Turnover Ratio
Use this when you need to assess how efficiently a company uses its assets to generate sales and compare it with industry benchmarks.
Open this prompt Analysis · Intermediate
Calculate Current Ratio
Use this when you need to assess a company's short-term liquidity by calculating its current ratio from financial statements.
Open this prompt Analysis · Beginner
Calculate Days Sales Outstanding
Use this when you need to evaluate how efficiently a company collects its receivables by calculating DSO.
Open this prompt Analysis · Beginner
Calculate Debt-to-Equity Ratio
Use this when you need to calculate a company's debt-to-equity ratio from its financial statements and interpret its financial leverage.
Open this prompt Analysis · Intermediate
Calculate Dividend Yield
Use this when you need to determine the return on investment from dividends by calculating dividend yield.
Open this prompt Analysis · Beginner
Calculate Gross Profit Margin
Use this when you need to assess a company's profitability by calculating its gross profit margin from financial data.
Open this prompt Analysis · Intermediate
Calculate Inventory Turnover Ratio
Use this when you need to evaluate how efficiently a company manages its inventory by calculating the inventory turnover ratio.
Open this prompt Analysis · Intermediate
Calculate Net Profit Margin
Use this when you need to calculate and analyze a company's net profit margin from financial statements.
Open this prompt Analysis · Intermediate
Calculate Operating Profit Margin
Use this when you need to evaluate a company's operational efficiency by calculating its operating profit margin.
Open this prompt Analysis · Intermediate
Calculate Price-to-Earnings Ratio
Use this when you need to compute and interpret the P/E ratio for a company using provided market data.
Open this prompt Analysis · Beginner
Calculate Quick Ratio
Use this when you need to assess a company's short-term liquidity by calculating its quick ratio.
Open this prompt Analysis · Intermediate
Calculate Return on Assets
Use this when you need to measure a company's profitability relative to its total assets by calculating its Return on Assets (ROA).
Open this prompt Analysis · Intermediate
Return on Equity Analysis
Use this when you need to calculate and interpret a company's Return on Equity.
Open this prompt Analysis · Intermediate