100 Best Gemini Financial Ratio Analysis Prompts for Accountants

Direct Answer

The best Gemini prompts for financial ratio analysis for accountants are designed to produce precise, audit-ready insights from ratio data, with clear outputs and actionable recommendations. Use them to diagnose liquidity, profitability, leverage, and efficiency, then translate results into practical steps. Note that interpretation should consider data quality and context.

Introduction

This page is a practical Gemini prompt library for financial ratio analysis tailored to accountants. It provides 100 ready-to-use prompts that cover liquidity, profitability, leverage, and efficiency metrics with context-rich instructions.

The prompts are crafted to be copyable and immediately usable without inventing missing context, and they support CFO-level decision making as well as day-to-day financial analysis.

How to Use These Gemini Prompts

• Replace placeholders with your actual data and dates where shown.
• Add constraints or formats to match your reporting standards, such as two-page summaries or dashboard-ready outputs.
• Request outputs in structured formats like bullet lists, tables, or charts described in text so you can reproduce visuals.
• Verify outputs by cross-checking calculated ratios with source data and by validating assumptions used in scenario analyses.
• If needed, request the outputs to be generated in a specific tone suitable for executives or technical stakeholders.
• Iterate prompts by refining data inputs and constraints based on prior outputs.

100 Best Gemini Financial Ratio Analysis Prompts for Accountants

1. Liquidity ratio assessment: Role: You are a financial analyst consultant. Task: Evaluate liquidity for a company using current ratio and quick ratio. Context: Provided are the company’s balance sheet data for the last fiscal year and the most recent quarter. Output format: present findings in a concise report with computed ratios, trend analysis, and risk flags. Constraints: avoid over-interpretation, cite data sources, keep to two pages.
2. Profitability trend analysis: Role: Senior accountant. Task: Analyze profitability ratios over five years and identify drivers of change. Context: Use gross margin, operating margin, and net margin with year-by-year values. Output: bullet list of drivers, graphical notes, and a short executive summary. Constraints: include at least one recommendation.
3. Debt service coverage review: Role: Financial analyst. Task: Compute debt service coverage ratio and assess ability to meet debt obligations. Context: Use annual cash flow and debt service obligations from the latest annual report. Output: a dashboard-ready summary with ratio, sensitivity to interest rate changes, and a risk rating. Constraints: present results in clear numeric and qualitative terms.
4. Efficiency ratios snapshot: Role: Controller. Task: Generate a snapshot of efficiency ratios (资产周转, turnover ratios) for inventory and receivables. Context: Quarterly data across the last four quarters. Output: table with ratio values, interpretation notes, and recommended operational actions. Constraints: translate any non-English terms where relevant.
5. Leverage vs. profitability: Role: Finance analyst. Task: Compare leverage ratios with profitability margins to detect over-leverage risks. Context: Use debt-to-equity, interest coverage, and return on equity for the last three years. Output: comparative chart description and a concise risk assessment. Constraints: avoid speculative claims.
6. Cash flow quality check: Role: External auditor. Task: Assess cash flow quality using cash flow ratio and cash conversion cycle. Context: Provided cash flow statement and balance sheet data for the most recent year. Output: findings with anomalies and suggestions for improvement. Constraints: keep explanations practical for non-technical stakeholders.
7. Industry benchmark analysis: Role: Equity researcher. Task: Benchmark key ratios against industry peers. Context: Use observable publicly reported ratios for a peer set. Output: ranked list with gaps, possible reasons, and strategic implications. Constraints: ensure fair comparator selection.
8. Quick ratio drilldown: Role: Financial analyst. Task: Drill into the quick ratio with components and noncash items. Context: Balance sheet data, including inventory and current liabilities. Output: breakdown of numerator and denominator and a mitigation plan for any liquidity gaps. Constraints: present in two-page limit.
9. ROE decomposition: Role: Accountant. Task: Decompose return on equity into profitability, asset turnover, and leverage effects. Context: Use five-year data, including common-size statements. Output: ROE drivers with narrative and chart-ready figures. Constraints: avoid jargon.
10. Interest coverage sensitivity: Role: Credit analyst. Task: Calculate interest coverage and test sensitivity to rising interest rates. Context: EBIT and interest expense for the latest year. Output: scenario analysis with action items for management. Constraints: show at least three scenarios.
11. Receivables aging analysis: Role: Credit manager. Task: Analyze accounts receivable aging to assess collection risk. Context: Aging schedule and bad debt reserve. Output: recommended credit policy adjustments and forecast impact. Constraints: include at least two actionable steps.
12. Inventory turnover depth: Role: Operations analyst. Task: Analyze inventory turnover and days of inventory on hand. Context: Inventory and cost of goods sold over the last twelve months. Output: insights on stock efficiency and actions to optimize. Constraints: compare to prior year.
13. Gross margin compression: Role: Financial planner. Task: Identify drivers of gross margin compression. Context: Product mix and input costs across two periods. Output: root-cause analysis and mitigation plan. Constraints: quantify impact where possible.
14. Profitability by channel: Role: FP&A analyst. Task: Break down margins by distribution channel. Context: Revenue and cost data by channel for the latest year. Output: channel profitability map and recommendations. Constraints: include top and bottom performers.
15. Liquidity risk matrix: Role: Treasury analyst. Task: Create a liquidity risk matrix using multiple ratios. Context: Short-term and long-term liquidity indicators. Output: matrix with risk levels and recommended actions. Constraints: present in plain language.
16. Capital structure review: Role: Finance manager. Task: Review capital structure and cost of capital. Context: Weighted average cost of capital and component costs. Output: recommendations for optimal mix with a one-page summary. Constraints: justify changes with data.
17. Seasonality impact test: Role: Financial analyst. Task: Test how seasonality affects key ratios. Context: Quarterly data over two years. Output: seasonal adjustment plan and revised targets. Constraints: specify method used.
18. Receivable collection plan: Role: Credit risk analyst. Task: Propose a receivables collection plan to improve days sales outstanding. Context: Aging analysis and credit terms. Output: step-by-step plan with KPI targets. Constraints: include risk controls.
19. Supplier payment impact: Role: FP&A specialist. Task: Assess how supplier payment terms affect liquidity ratios. Context: Terms, payables, and cash flow data. Output: recommendations to optimize working capital. Constraints: quantify impact.
20. CFO-ready executive brief: Role: Senior financial analyst. Task: Produce a CFO-ready brief summarizing key ratio insights. Context: All relevant ratios and trends for the last year. Output: concise executive memo with charts and recommendations. Constraints: avoid technical jargon.
21. DuPont analysis: Role: Financial analyst. Task: Conduct DuPont decomposition for ROE. Context: Last five years of income statement and balance sheet data. Output: factor-by-factor explanation and improvement plan. Constraints: keep to two pages.
22. Cash burn rate alert: Role: Startup accountant. Task: Calculate cash burn rate and runway. Context: Monthly cash flow data for the past six months. Output: alert levels with recommended fundraising or expense cuts. Constraints: include confidence intervals.
23. Working capital cycle: Role: Treasury officer. Task: Map the working capital cycle and identify bottlenecks. Context: Accounts payable, receivable, and inventory data. Output: cycle diagram description and optimization steps. Constraints: ensure feasibility.
24. Acid-test vs. current: Role: Financial analyst. Task: Compare current and acid-test ratios, explain differences. Context: Balance sheet components and recent changes. Output: interpretation notes and recommended actions. Constraints: provide numeric examples.
25. Debt maturity analysis: Role: Credit manager. Task: Analyze debt maturity profile and refinance risks. Context: Maturity schedule and cash flow projections. Output: risk assessment and refinancing plan. Constraints: consider interest rate scenarios.
26. Net profit margin drivers: Role: FP&A analyst. Task: Identify drivers of net profit margin changes. Context: Income statement data over multiple periods. Output: driver analysis with actionable steps. Constraints: quantify effect where possible.
27. Liquidity stress test: Role: Risk analyst. Task: Run liquidity stress tests under adverse scenarios. Context: Cash reserves, inflows, and outflows. Output: stress-test results with recommended buffers. Constraints: document assumptions.
28. Benchmark gap analysis: Role: Financial analyst. Task: Identify gaps between company ratios and best-in-class peers. Context: Public data for peers. Output: gap report with remediation actions. Constraints: ensure fair peer selection.
29. Debt-to-assets check: Role: Financial modeler. Task: Calculate debt-to-assets and assess leverage adequacy. Context: Balance sheet data and asset values. Output: adequacy assessment with suggestions. Constraints: include ratio trend.
30. Interest coverage drill: Role: Credit analyst. Task: Delve into interest coverage with multiple scenarios. Context: EBIT, interest expense, and debt levels. Output: sensitivity table and recommended covenants. Constraints: present in two-page format.
31. Inventory aging check: Role: Controller. Task: Analyze inventory aging and obsolescence risk. Context: Inventory aging report and COGS. Output: risk flags and stock management plan. Constraints: action-oriented.
32. Receivable risk scoring: Role: Credit risk analyst. Task: Score accounts receivable by risk level. Context: Customer data and historical payment behavior. Output: risk scores and collection strategy. Constraints: link scores to actions.
33. Cost of capital vs returns: Role: FP&A manager. Task: Compare projects’ returns to cost of capital. Context: Projected cash flows and WACC. Output: decision guidance with ROI thresholds. Constraints: include break-even analysis.
34. ROA trend check: Role: Financial analyst. Task: Track return on assets across divisions. Context: Asset base and earnings by division. Output: division-level ROA trend and recommendations. Constraints: normalize for one-off items.
35. Cash conversion cycle: Role: Treasury analyst. Task: Compute cash conversion cycle and optimize timings. Context: Receivables, payables, and inventory data. Output: actionable plan with KPI targets. Constraints: keep calculations transparent.
36. Capex vs depreciation: Role: Finance planner. Task: Assess alignment of capex with depreciation. Context: Capital budget and depreciation schedules. Output: alignment report with recommendations. Constraints: quantify impact on cash flow.
37. Working capital forecast: Role: FP&A analyst. Task: Build a rolling working capital forecast. Context: Historical trends and upcoming plans. Output: forecast with triggers for action. Constraints: incorporate seasonality.
38. Shareholder value metrics: Role: Equity analyst. Task: Map ratios to shareholder value creation. Context: ROE, ROIC, and earnings growth. Output: value creation narrative and charts. Constraints: link to strategic objectives.
39. Credit quality assessment: Role: Credit analyst. Task: Assess overall credit quality from ratio signals. Context: Coverage, leverage, and liquidity metrics. Output: risk rating and mitigation steps. Constraints: avoid overclaiming certainty.
40. Cash flow consistency: Role: FP&A analyst. Task: Test cash flow consistency vs earnings. Context: Cash flow from operations and net income. Output: consistency score and explanation. Constraints: provide corrective actions.
41. Cost leverage analysis: Role: Cost accountant. Task: Analyze fixed vs variable cost leverage on margins. Context: Cost structure data and activity levels. Output: leverage map and margin impact. Constraints: quantify breakeven changes.
42. Product line profitability: Role: FP&A manager. Task: Assess profitability by product line. Context: Revenue, costs, and margins across lines. Output: profitability heatmap and actions. Constraints: consider allocation methods.
43. Receivable aging forecast: Role: Credit manager. Task: Forecast aging trends for the next quarter. Context: Current aging data and sales forecast. Output: risk alerts and collection plan. Constraints: limit assumptions.
44. Liquidity heatmap: Role: Treasury analyst. Task: Create a liquidity heatmap by month. Context: Cash, revolver availability, and upcoming obligations. Output: heatmap description and funding plan. Constraints: include level of certainty.
45. Break-even ratio: Role: FP&A analyst. Task: Compute break-even point for key products. Context: Fixed costs, variable costs, and unit economics. Output: break-even chart description and actions. Constraints: use conservative estimates.
46. P&L sensitivity matrix: Role: Financial modeller. Task: Build a P&L sensitivity matrix for revenue and cost drivers. Context: Historical data and forecast assumptions. Output: scenario table with impact on margins. Constraints: document assumptions.
47. Dividend capacity check: Role: Corporate finance analyst. Task: Determine dividend capacity from ratios. Context: Retained earnings and cash flow. Output: payment capacity and risk notes. Constraints: highlight constraints.
48. Capital expenditure prioritization: Role: FP&A lead. Task: Prioritize capex projects by financial impact. Context: Projected cash flows and hurdle rates. Output: ranked project list with rationale. Constraints: include risk assessment.
49. Working capital ratio map: Role: Financial analyst. Task: Create a map of working capital ratios by entity. Context: Group-level data and sub-entity data. Output: map with insights and actions. Constraints: ensure data parity.
50. Covenant compliance review: Role: Compliance officer. Task: Review financial ratios against debt covenants. Context: Covenant terms and latest financials. Output: compliance status and remediation steps. Constraints: present clearly.
51. Scenario planning pack: Role: Strategy analyst. Task: Build scenario packs based on ratio shifts. Context: Macro assumptions and internal metrics. Output: scenario narratives and decision triggers. Constraints: keep to executive level.
52. Forecast vs actual delta: Role: FP&A analyst. Task: Analyze forecast deviations in ratios. Context: Forecast vs actual for the last four quarters. Output: variance explanations and corrective actions. Constraints: provide quantified impact.
53. Receivable aging policy: Role: Credit risk manager. Task: Propose aging policy changes to reduce risk. Context: Current aging policy and outcomes. Output: policy draft with thresholds and controls. Constraints: align with regulatory expectations.
54. Inventory write-down risk: Role: Controller. Task: Identify write-down risk in inventory. Context: Aging, turnover, and obsolescence indicators. Output: risk flags and remediation plan. Constraints: quantify potential impact.
55. Credit mix optimization: Role: Credit manager. Task: Optimize customer credit mix for risk-adjusted returns. Context: Customer segments and payment history. Output: recommended credit policies and expected impact. Constraints: include risk controls.
56. Liquidity ratio dashboard: Role: Treasurer. Task: Build a dashboard for liquidity ratios. Context: Current ratio, quick ratio, cash ratio across periods. Output: dashboard narrative and action plan. Constraints: visuals described in text.
57. Cash flow by segment: Role: FP&A analyst. Task: Break down cash flow by business segment. Context: Segment-level cash flow data. Output: segment insights and recommendations. Constraints: ensure comparability.
58. EBIT margin comparison: Role: Financial analyst. Task: Compare EBIT margins across divisions. Context: Income statements and cost allocations. Output: matrix with drivers and actions. Constraints: normalize for one-offs.
59. Credit risk heatmap: Role: Credit risk analyst. Task: Create a credit risk heatmap from ratios. Context: Coverage, leverage, liquidity data. Output: heatmap with risk color and notes. Constraints: concise.
60. Net working capital goal: Role: FP&A planner. Task: Set net working capital targets aligned with strategy. Context: Current assets and liabilities. Output: targets and action steps. Constraints: include milestones.
61. ROIC drivers map: Role: Investment analyst. Task: Map drivers of return on invested capital. Context: Earnings, asset use, and capital mix. Output: actionable map and recommendations. Constraints: link to strategy.
62. Inventory turnover forecast: Role: Operations finance. Task: Forecast inventory turnover for next year. Context: Historical turnover and supplier terms. Output: forecast with planning notes. Constraints: scenario planning.
63. Receivable collection metrics: Role: Credit manager. Task: Define metrics to monitor collections. Context: DSO, aging buckets, and disputes. Output: KPI definitions and target levels. Constraints: align with policy.
64. Working capital stress: Role: Risk manager. Task: Assess working capital under stress scenarios. Context: Economic downturn inputs. Output: stress results and buffers. Constraints: document assumptions.
65. CFO KPI package: Role: Finance lead. Task: Assemble CFO-facing KPIs for ratios. Context: Most relevant ratios and trends. Output: one-page KPI sheet with narrative. Constraints: avoid jargon.
66. Tax-adjusted margins: Role: Tax specialist. Task: Adjust margins for tax effects. Context: Tax rates and reliefs. Output: tax-adjusted margin analysis with notes. Constraints: show calculation steps.
67. Sales mix sensitivity: Role: FP&A analyst. Task: Assess how sales mix shifts affect ratios. Context: Product-level revenue and costs. Output: sensitivity results and actions. Constraints: include break-even implications.
68. Cash liquidity forecast: Role: Treasury analyst. Task: Predict cash liquidity for next quarter. Context: Cash balances and forecasted receipts. Output: liquidity forecast with risk flags. Constraints: specify confidence level.
69. Receivables turnover study: Role: Credit risk officer. Task: Study receivables turnover trends. Context: Billing terms and payment behavior. Output: turnover trend with actions. Constraints: keep simple.
70. Asset utilization review: Role: Asset manager. Task: Review asset utilization ratios by asset class. Context: Asset base and revenue. Output: utilization map and recommendations. Constraints: entity-level granularity.
71. Debt maturity stress: Role: Debt analyst. Task: Stress-test debt maturities under rate hikes. Context: Maturity schedule and cash flow. Output: risk notes and refinancing plan. Constraints: provide data-driven rationale.
72. Dividend sustainability check: Role: Financial planner. Task: Assess dividend sustainability against ratios. Context: Cash flow and reserves. Output: sustainability score and actions. Constraints: conservative assumptions.
73. Transfer pricing impact: Role: FP&A analyst. Task: Evaluate how transfer pricing affects margin ratios. Context: intra-group pricing and costs. Output: impact analysis and recommendations. Constraints: include compliance notes.
74. Vendor finance impact: Role: Finance analyst. Task: Analyze impact of vendor financing on ratios. Context: Financing terms and payables. Output: impact report and risk controls. Constraints: quantify effect.
75. Working capital by region: Role: Global finance manager. Task: Compare working capital ratios by region. Context: Regional sub-entities data. Output: regional insight map and actions. Constraints: ensure data normalization.
76. Liquidity covenant review: Role: Compliance analyst. Task: Review covenants for liquidity triggers. Context: Debt terms and latest financials. Output: covenant status and remediation plan. Constraints: clarity essential.
77. Pricing impact analysis: Role: FP&A analyst. Task: Estimate how pricing changes affect margins. Context: Price elasticity and cost structure. Output: margin scenarios and recommendations. Constraints: avoid overclaiming elasticity.
78. Cost control plan: Role: Controller. Task: Propose cost-cutting actions without harming operations. Context: Expense data and productivity metrics. Output: prioritized cost-control actions. Constraints: quantify savings.
79. Cash burn comparison: Role: Startup accountant. Task: Compare cash burn versus runway against peers. Context: Public peer data and internal burn. Output: comparison and strategy notes. Constraints: avoid sensitive data.
80. Capital efficiency score: Role: Investment analyst. Task: Create a capital efficiency scorecard. Context: Returns on capital, asset turns, and investment costs. Output: score explanations and actions. Constraints: use transparent methodology.
81. Receivable risk flags: Role: Credit risk manager. Task: Flag high-risk receivables with justification. Context: Customer data and history. Output: risk flags and collection plan. Constraints: escalate where needed.
82. Margin leakage audit: Role: Internal auditor. Task: Audit for margin leakage across products. Context: Cost and price data by product. Output: leakage findings and controls. Constraints: practical remediation.
83. Asset impairment check: Role: Controller. Task: Screen for asset impairment indicators. Context: Asset values and market indicators. Output: impairment flags and accounting impact. Constraints: thresholds defined.
84. CFO narrative brief: Role: Finance leader. Task: Write a concise CFO narrative on ratios. Context: Yearly performance and strategic priorities. Output: one-page brief with evidence. Constraints: avoid fluff.
85. Operating leverage drill: Role: Financial engineer. Task: Drill operating leverage effects on margins. Context: Revenue and fixed costs. Output: leverage analysis and actions. Constraints: use precise figures.
86. Cash forecasting method: Role: Treasurer. Task: Describe a robust cash forecasting method. Context: Input data sources and cadence. Output: method steps and validation checks. Constraints: include example.
87. Tax-rate sensitivity: Role: Tax manager. Task: Model earnings sensitivity to tax-rate changes. Context: Tax laws and effective rates. Output: sensitivity results and planning tips. Constraints: conservative assumptions.
88. Liquidity reserves plan: Role: Treasury head. Task: Design liquidity reserves plan. Context: Reserve levels, liquidity needs, and credit lines. Output: reserve policy and trigger points. Constraints: plain-language rationale.
89. Cash flow cycle map: Role: Financial analyst. Task: Map the cash flow cycle visually described in text. Context: Inflows, outflows, and timing. Output: cycle map narrative and actions. Constraints: keep alignment with data.
90. Profit by segment analysis: Role: FP&A analyst. Task: Analyze profit contribution by segment. Context: Revenue, costs, and allocations. Output: segment profit map and recommendations. Constraints: allocation method stated.
91. Ratio governance framework: Role: Finance governance lead. Task: Propose a governance framework for ratio reporting. Context: Stakeholders and cadence. Output: framework document with controls. Constraints: actionable.
92. One-page financials: Role: Investor relations. Task: Compile a one-page financials summary with ratios. Context: Key metrics and narrative. Output: concise, investor-friendly sheet. Constraints: avoid excessive detail.
93. Benchmark client metrics: Role: Consulting finance. Task: Compare client metrics to industry standards. Context: Sector-specific ratios. Output: insights and recommended actions. Constraints: cite sources.
94. Ratio-driven pricing: Role: Pricing analyst. Task: Use ratios to inform pricing strategy. Context: Margins, elasticity, and competitive data. Output: pricing recommendations with impact estimates. Constraints: track risk.
95. Cash flow optimization: Role: FP&A manager. Task: Identify quick wins to optimize cash flow. Context: Accounts payable, receivable, and inventory. Output: prioritized actions with expected gains. Constraints: feasibility check.
96. Debt capacity roadmap: Role: Corporate finance lead. Task: Chart a debt capacity roadmap aligned with growth. Context: Revenue projections and covenants. Output: phased debt plan with milestones. Constraints: risk controls.
97. Receivable aging benchmarks: Role: Credit risk analyst. Task: Benchmark aging against peers. Context: Public data and internal data. Output: benchmarking table and actions. Constraints: ensure comparability.
98. Cost-to-serve analysis: Role: Operations finance. Task: Calculate cost-to-serve by product or customer. Context: Direct and indirect costs. Output: profitability by segment and actions. Constraints: provide granularity.
99. Margin restoration plan: Role: FP&A director. Task: Develop a plan to restore margins after compression. Context: Root causes and cost-reduction options. Output: step-by-step plan with milestones. Constraints: track progress.
100. Final executive digest: Role: CFO assistant. Task: Create a final digest summarizing all ratio insights for executives. Context: Entire ratio set and strategic implications. Output: one-page digest with charts and notes. Constraints: keep concise.

Best Practices

• Keep prompts data-driven by anchoring prompts to concrete data points.
• Reuse prompts with the same data set across meetings to maintain consistency.
• Include data source citations and disclaimers to avoid overclaiming certainty.
• Specify output formats clearly to speed up downstream reporting.
• Review prompts for compliance and privacy when handling sensitive client data.

Common Mistakes to Avoid

• Using vague prompts that omit data sources or required outputs.
• Neglecting to specify output formats, leading to inconsistent reports.
• Assuming readers understand abbreviations or industry terms without definitions.
• Overloading prompts with too many goals, reducing clarity.
• Not validating outputs against source data before action.

FAQ

What is the best way to start using Gemini prompts for ratio analysis?

Begin with a clear data set, specify the exact ratios to calculate, and choose a concise output format such as a brief executive memo or a dashboard-style description.

How should I tailor prompts for different industries?

Activate industry-specific data points and benchmark peers, and request explanations that reflect typical sector dynamics and risks.

Can these prompts handle multi-entity financials?

Yes. Use prompts that include entity-level data and a consolidation context, then ask for a consolidated view with entity-specific highlights.

What outputs should I expect from these prompts?

Structured outputs like ratio tables, trend notes, risk flags, and actionable recommendations suitable for management or auditors.

How can I ensure accuracy when using these prompts?

Cross-check calculated values with source data, validate assumptions in scenario prompts, and verify any projections with historical trends.

Are these prompts compliant with common reporting standards?

Prompts are designed to support standard reporting, but you should tailor it to your jurisdiction and regulatory requirements.