100 Best ChatGPT Financial Ratio Analysis Prompts for Accountants

Direct Answer

The best ChatGPT prompts for financial ratio analysis for accountants are a curated, precise set of prompts designed to yield actionable ratio insights, provide clear explanations, and support decision making across liquidity, profitability, efficiency, solvency, and capital structure analyses.

Introduction

This page is a practical prompt library offering 100 ready-to-use ChatGPT prompts focused on financial ratio analysis for accountants. Each prompt is crafted to be copyable, specific, and immediately usable with placeholders for your data.

Whether you are a CPA, auditor, controller, or FP&A professional, these prompts help you quickly generate ratio calculations, interpret results, and create client-ready reports without reinventing context.

How to Use These ChatGPT Prompts

• Replace placeholders like [currentAssets], [currentLiabilities], and [industry] with your actual data before running the prompt.
• Add constraints such as target ratio thresholds, time frames, or benchmark values to keep outputs focused.
• Request outputs in formats like bullet lists, tables, or short narratives to suit your reporting needs.
• Ask for multiple scenario variations to see how ratios shift under different assumptions.
• Verify outputs by cross-checking with your own calculations or source documents.

100 Best ChatGPT Financial Ratio Analysis Prompts for Accountants

1. Liquidity quick check: You are a financial analyst. Task: assess liquidity using current ratio and quick ratio with placeholder data [currentAssets], [currentLiabilities], [inventory]. Context: company X in [industry]. Output format: bulleted results with interpretation and a one sentence remediation plan. Constraints: include thresholds: current ratio above 1.5, quick ratio above 1.0.
2. Working capital trend: You are a CPA. Task: compare three consecutive quarters of working capital using [currentAssets], [currentLiabilities], and [cashEquivalents]. Context: small business in [region]. Output format: table with quarter, working capital, and trend arrow. Constraints: highlight half-year spikes and explain drivers.
3. Gross margin analysis: You are an FP&A analyst. Task: break down gross margin into price, cost of goods sold, and volume effects for [productLine] using data [revenue], [COGS], [unitsSold]. Context: product line pivot in [year]. Output format: bullet list of drivers with quantified impact in percentage.
4. Net margin drivers: You are a management consultant. Task: identify top five drivers of net profit margin for [company] with placeholders [netIncome], [revenue], [operatingExpenses], [taxRate]. Context: year-to-date period. Output format: ranked list with brief explanation and recommended actions.
5. Return on assets breakdown: You are an equity analyst. Task: decompose ROA into operating ROA and non operating elements for [company]. Context: asset-heavy industry. Output format: two sections showing numerator and denominator details, with calculations in parentheses.
6. ROE sensitivity: You are a financial modeler. Task: model ROE changes with variations in net income [NI], equity [Equity], and preferred dividends [PDiv]. Context: hypothetical scenarios A, B, C. Output format: scenario table with ROE impact in percentage points.
7. Debt ratio check: You are a credit analyst. Task: compute debt-to-equity and debt-to-assets for [totalDebt], [shareholderEquity], [totalAssets]. Context: balance sheet snapshot. Output format: concise paragraph plus a ratio chart-ready list.
8. Interest coverage insight: You are a treasury analyst. Task: assess times interest earned using [operatingIncome], [interestExpense]. Context: company under refinancing. Output format: summary with risk flags and suggested debt capacity.
9. Current liquidity forecast: You are a financial planner. Task: forecast current ratio for next four quarters using [plausibleReceivables], [inventories], [payables], [cash]. Context: seasonal business. Output format: quarterly forecast with confidence bands and key drivers.
10. Inventory turnover check: You are an inventory analyst. Task: compute inventory turnover ratio using [COGS], [averageInventory]. Context: retail business. Output format: ratio, days in inventory, and recommended stocking actions.
11. Receivables days analysis: You are a collections specialist. Task: calculate days sales outstanding using [averageAccountsReceivable], [creditSales]. Context: customer concentration risk. Output format: single page summary with aging notes and collection plan.
12. Payables period review: You are a cash flow advisor. Task: determine average payables period using [costOfGoodsSold], [averageAccountsPayable]. Context: supplier negotiation scenario. Output format: bullet list of negotiation levers and expected cash impact.
13. Asset turnover focus: You are a performance analyst. Task: compute asset turnover and comment on efficiency using [netSales], [averageTotalAssets]. Context: capital-intensive industry. Output format: two-column comparison with benchmarks.
14. Cash conversion: You are a treasury analyst. Task: compute cash conversion cycle using [DIO], [DSO], [DPO]. Context: identify bottlenecks. Output format: compact scorecard with recommended fixes.
15. EBITDA margin view: You are a financial analyst. Task: calculate EBITDA margin from [EBITDA], [revenue]. Context: growth plan. Output format: one-page memo with margin trend and risks.
16. Operating margin drill: You are a corporate finance expert. Task: decompose operating margin into cost structure components using [OPERatingIncome], [Revenue], [COGS], [SGA]. Context: cost reduction program. Output format: structured list with impact percentages.
17. Asset mix effect: You are an finance strategist. Task: analyze how asset mix affects ROA using [totalAssets], [netIncome], [assetCategories]. Context: restructuring plan. Output format: narrative plus numbers.
18. Leverage and liquidity: You are a risk analyst. Task: assess liquidity risk under leverage scenarios using [debt], [cash], [equity]. Context: stress test. Output format: risk flags with recommended hedges.
19. PPE efficiency: You are an FP&A professional. Task: measure fixed asset efficiency using [netPPESalvage], [depreciation], [totalPPE]. Context: capex review. Output format: ratio with interpretation and action list.
20. Interest burden: You are a financial advisor. Task: quantify interest burden as interest expense to earnings before interest and taxes using [interestExpense], [EBIT]. Context: refinancing discussion. Output format: concise table and bullet notes.
21. Liquidity by segment: You are a segment analyst. Task: compute liquidity ratios by business segment using [segmentAssets], [segmentLiabilities], [segmentReceivables]. Context: diversified company. Output format: segment table with insights.
22. Profit per product: You are a productController. Task: calculate gross profit and net profit per product using [product], [revenue], [COGS], [operatingCosts]. Context: portfolio review. Output format: per-product brief with improvement options.
23. Seasonal margin swing: You are an FP&A analyst. Task: compare seasonal margins using [Q1], [Q2], [Q3], [Q4] data for [productLine]. Context: seasonality impact. Output format: chart-ready bullets.
24. Credit risk ratio: You are a credit risk specialist. Task: compute credit risk score from liquidity and leverage ratios using [currentRatio], [debtToEquity], [DSO]. Context: client onboarding. Output format: risk rating with justification.
25. Break-even ratio: You are a business analyst. Task: determine break-even ratio using [fixedCosts], [variableCostPerUnit], [sellingPricePerUnit]. Context: pricing decision. Output format: few-line summary with margin safety.
26. Industry benchmark gaps: You are a benchmarking specialist. Task: compare key ratios to industry benchmarks using [industry], [ratios]. Context: due diligence. Output format: gap analysis and prioritized actions.
27. Cross-period consistency: You are a financial auditor. Task: assess consistency of ratios across four periods using [period1], [period2], [period3], [period4]. Context: audit trail. Output format: checklist with red flags.
28. Tax-adjusted margins: You are a tax analyst. Task: calculate after-tax margin using [EBT], [taxRate], [revenue]. Context: tax planning. Output format: concise calculation and planning notes.
29. Capital productivity: You are a corporate strategist. Task: assess capital productivity via ratio of revenue to net fixed assets using [revenue], [netFixedAssets]. Context: capex review. Output format: quick verdict and action items.
30. Liquidity stress test: You are a risk manager. Task: perform a liquidity stress test under sudden cash drain using [cash], [receivables], [payables]. Context: scenario planning. Output format: scenario results and mitigation steps.
31. Payback period check: You are a project analyst. Task: compute simple payback period from [initialInvestment], [annualCashInflow]. Context: project evaluation. Output format: one-page summary with risk notes.
32. Cash flow quality: You are a financial controller. Task: assess cash flow quality using [operatingCashFlow], [netIncome], [nonCashItems]. Context: earnings quality review. Output format: bullet points with signals.
33. Debt maturity profile: You are a treasury planner. Task: map debt maturities and repayment schedule using [debtMaturities], [cashReserves]. Context: liquidity planning. Output format: timeline chart-ready summary.
34. EBITDA vs cash: You are a cash flow analyst. Task: reconcile EBITDA to operating cash flow using [EBITDA], [operatingCashFlow], [nonCashItems]. Context: financial health check. Output format: short reconciliation and notes.
35. Receivable mix effect: You are a credit analyst. Task: analyze how customer mix affects DSO using [customerSegments], [DSO] data. Context: concentration risk. Output format: narrative with segment-specific actions.
36. Supplier terms impact: You are a procurement analyst. Task: model impact of extending payables terms on liquidity using [currentPayables], [averageMilk], [paymentTerms]. Context: supplier negotiation. Output format: bullet list with cash impact.
37. Gross margin by channel: You are a channel analyst. Task: compute gross margin by channel using [channel], [revenueChannel], [COGSChannel]. Context: multi-channel strategy. Output format: table and key takeaways.
38. ROIC check: You are a corporate finance specialist. Task: calculate return on invested capital using [NOPAT], [investedCapital]. Context: capital allocation. Output format: compact memo with recommendations.
39. CFO KPI pack: You are a finance executive. Task: assemble a KPI pack for liquidity, profitability, efficiency using placeholders [KPI1] to [KPI6]. Context: board briefing. Output format: bullet list with targets.
40. Liquidity by region: You are a regional analyst. Task: calculate liquidity ratios by region using [regionAssets], [regionLiabilities], [regionReceivables]. Context: multinational. Output format: region-by-region bullets.
41. Capex efficiency: You are a capital budgeting analyst. Task: evaluate capex efficiency with [capitalExpenditure], [incrementalRevenue], [incrementalEBITDA]. Context: project portfolio. Output format: ROI-like summary.
42. Inventory aging: You are an operations analyst. Task: classify inventory aging and suggest write-down risk using [inventoryAge], [inventoryValue]. Context: stock health. Output format: bullets with aging bands.
43. Liquidity heat map: You are a risk analyst. Task: generate a liquidity heat map from ratios [currentRatio], [quickRatio], [cashRatio]. Context: risk dashboard. Output format: 2x2 grid description.
44. PBT to cash: You are a treasury professional. Task: convert pretax income to cash flow using [PBT], [tax], [nonCash]. Context: cash forecasting. Output format: short equation and interpretation.
45. Operating leverage: You are an economic analyst. Task: assess operating leverage using [contributionMargin], [salesVolume]. Context: pricing strategy. Output format: bulleted impact assessment.
46. Financial ratio map: You are a prompt engineer. Task: create a ratio map linking each core ratio to actions using placeholders [ratio], [action]. Context: training. Output format: organized bullet map.
47. Profitability by product: You are a product controller. Task: calculate profitability per product using [price], [cost], [volume], [overhead]. Context: product review. Output format: table with suggested optimization.
48. Liquidity vs profitability: You are a strategic analyst. Task: balance liquidity and profitability trade-offs for [company]. Context: strategic plan. Output format: scenario-based bullets.
49. Working capital sprint: You are an operations manager. Task: outline a 30-day working capital improvement plan using placeholders [receivables], [payables], [inventory], [cash]. Context: turnaround. Output format: week-by-week actions.
50. CFO narrative: You are a corporate storyteller. Task: craft a CFO-style narrative explaining key ratios and business health using [ratio1], [ratio2], [ratio3]. Context: investor outreach. Output format: short executive summary.
51. Debt maturity drill: You are a debt planner. Task: simulate maturity ladder consequences for [debtSeries], [interestRates], [cashBuffer]. Context: refinancing decision. Output format: risk flags and recommended actions.
52. Liquidity by product: You are a product analyst. Task: break down liquidity metrics by product line using [productLine], [currentAssets], [currentLiabilities]. Context: portfolio risk. Output format: concise per-line summary.
53. Tax shield impact: You are a tax consultant. Task: quantify tax shield effect on profitability using [interestExpense], [taxRate], [EBT]. Context: financing choice. Output format: short calculation and implications.
54. Budget vs actuals: You are a financial controller. Task: compare budgeted vs actual ratios using [budget], [actual]. Context: monthly close. Output format: variance report with suggestions.
55. Scenario planning pack: You are a scenario planner. Task: build three ratio-based scenarios for demand, price, and costs using placeholders [demand], [price], [cost]. Context: strategic planning. Output format: matrix with outcomes.
56. Client-ready ratios: You are a client eng storyteller. Task: generate client-facing ratio summaries for [clientName], using [ratios]. Context: advisory meeting. Output format: executive-friendly bullets.
57. Industry variance notes: You are an industry analyst. Task: annotate ratio differences across industries using [industryA], [industryB], [ratios]. Context: due diligence. Output format: quick notes.
58. Cost center profitability: You are a cost accountant. Task: compute profitability by cost center using [revenue], [costCenterCost], [allocations]. Context: cost control. Output format: per-center brief with optimization ideas.
59. Cash burn rate: You are a startup financial modeler. Task: calculate monthly cash burn rate from [cash], [monthlyNetOutflows]. Context: runway analysis. Output format: two-sentence dashboard note.
60. Remedial actions list: You are a financial advisor. Task: propose top five actions to improve liquidity metrics for [company], with rationale using [currentRatio], [DSO], [DPO]. Context: turnaround plan. Output format: numbered actions.
61. Capital structure review: You are a finance consultant. Task: evaluate optimal debt-equity mix for [company] using [debt], [equity], [costOfDebt], [costOfEquity]. Context: capital optimization. Output format: recommendation memo.
62. Competitive ratio map: You are a market analyst. Task: compare key ratios to competitors using [companyRatios], [peerRatios]. Context: competitive benchmarking. Output format: side-by-side table.
63. Liquidity dashboard: You are a finance dashboard engineer. Task: produce a liquidity dashboard spec using [metrics], [dataSources]. Context: reporting. Output format: list of charts and data fields.
64. Profitability heat map: You are a data analyst. Task: create a profitability heat map by product and region using [profit], [revenue], [cost]. Context: portfolio analysis. Output format: heat map description.
65. Cost of capital check: You are a finance officer. Task: compute WACC using [costOfDebt], [costOfEquity], [taxRate], [debtMarketValue], [equityMarketValue]. Context: investment appraisal. Output format: concise calculation and verdict.
66. Receivable risk score: You are a risk analyst. Task: score receivable risk from aging, concentration, and bad debt using [DSO], [customerConcentration], [historicalDefaultRate]. Context: credit approval. Output format: risk rating with mitigations.
67. Inventory profitability: You are an operations financial analyst. Task: measure gross margin per inventory category using [category], [revenue], [COGS], [inventories]. Context: SKU rationalization. Output format: per-category verdicts.
68. Cash conversion cues: You are a treasury analyst. Task: identify cues that predict cash conversion cycle improvements using [DSO], [DIO], [DPO], [cash]. Context: optimization. Output format: bullet cues and plan.
69. Liquidity risk flags: You are a risk manager. Task: generate a risk flags list for liquidity using [currentRatio], [quickRatio], [cashPosition]. Context: risk review. Output format: flags with severity.
70. Segment profitability: You are a financial analyst. Task: calculate segment EBITDA and margin using [segment], [revenue], [segmentCosts]. Context: performance review. Output format: table and recommendations.
71. Debt service coverage: You are a credit analyst. Task: compute DSCR using [EBITDA], [debtService]. Context: loan covenant monitoring. Output format: summary with covenant health.
72. Capital allocation map: You are a capital allocator. Task: map potential investments to ROI and payback using placeholders [investment], [ROI], [payback]. Context: portfolio optimization. Output format: prioritized list.
73. Liquidity by department: You are an organizational finance lead. Task: break down liquidity by department using [deptAssets], [deptLiabilities]. Context: internal reporting. Output format: department summary bullets.
74. Cost structure scan: You are a cost analyst. Task: scan fixed vs variable costs using [fixedCosts], [variableCosts], [revenue]. Context: efficiency drive. Output format: breakdown and action items.
75. Projection sanity check: You are a forecasting specialist. Task: sanity-check four-quarter projections against ratios using [projections], [ratios]. Context: forecast validation. Output format: checklist with fixes.
76. Profit leakage hunt: You are a controller. Task: locate sources of profit leakage across processes using [revenueLeak], [costLeak]. Context: optimization. Output format: bullet list with fixes.
77. Tax efficiency prompt: You are a tax advisor. Task: simulate tax-efficiency improvements affecting margins using [taxRate], [loans], [deductions]. Context: planning. Output format: short plan with numbers.
78. Scenario volatility: You are a risk strategist. Task: model ratio sensitivity to price and volume changes using [price], [volume], [cost]. Context: volatility scenario. Output format: table of outcomes.
79. Audit-ready ratios: You are an auditor. Task: prepare ratios with source data references for audit trail using [dataSources]. Context: year-end close. Output format: audit-friendly summary.
80. Margin impact template: You are a finance tutor. Task: create a template to estimate how changes in inputs affect margins using [inputVariations], [currentMargins]. Context: training. Output format: fill-in guide.
81. Receivables aging notes: You are a collections manager. Task: annotate aging buckets with actions using [agingBuckets], [customerNotes]. Context: collections plan. Output format: bullets with owners.
82. Payables optimization: You are a procurement advisor. Task: propose optimization steps to extend payables while maintaining supplier relations using [terms], [supplierPerformance]. Context: cash management. Output format: prioritized actions.
83. Leverage ladder view: You are a financial planner. Task: present a leverage ladder with stress scenarios for [debtLevels], [interestRates]. Context: financing strategy. Output format: ladder diagram description.
84. Capital efficiency score: You are a metrics specialist. Task: build a capital efficiency score using [ROI], [ROIC], [assetTurnover]. Context: quarterly review. Output format: scorecard with trends.
85. Margin recovery plan: You are a turnaround consultant. Task: draft a margin recovery plan for [productLine] with actions on pricing and cost using [marginCurrent], [targetMargin]. Context: optimization project. Output format: stepwise plan.
86. Debt covenant check: You are a compliance analyst. Task: review debt covenants vs current ratios using [covenants], [ratios]. Context: loan compliance. Output format: risk notes and reminders.
87. Cash reserve strategy: You are a treasury officer. Task: set targets for cash reserves using [requiredReserves], [stability], [cashFlows]. Context: risk management. Output format: policy brief.
88. Revenue mix effects: You are a market analyst. Task: analyze how revenue mix shifts affect gross margin using [revenueMix], [margins]. Context: growth strategy. Output format: narrative with numbers.
89. Inventory policy prompt: You are an operations manager. Task: propose inventory policy changes to improve turnover using [policyOptions], [currentTurnover]. Context: process improvement. Output format: recommended options.
90. Cost control prompt: You are a cost optimization consultant. Task: identify actionable cost cuts in [department], [spend], [savings]. Context: quarterly plan. Output format: list with impact and risk.
91. Efficiency benchmark: You are a performance analyst. Task: benchmark efficiency metrics against a peer group using [ourMetrics], [peerMetrics]. Context: competitive comparison. Output format: table with gaps.
92. Break-even scenario: You are a market planner. Task: analyze break-even under different demand levels using [demandLow], [demandMid], [demandHigh]. Context: pricing strategy. Output format: summary bullets.
93. P&L ratio check: You are a financial auditor. Task: verify P&L ratios for accuracy using [P&LRatios], [sourceDocs]. Context: audit trail. Output format: checklist-style notes.
94. Supplier risk prompts: You are a supply chain analyst. Task: assess supplier risk with liquidity and concentration using [supplierData], [creditLimit]. Context: risk mitigation. Output format: bullet risks and mitigations.
95. Forecast alignment: You are a planning lead. Task: ensure forecasted ratios align with strategic goals using [forecastRatios], [targets]. Context: annual planning. Output format: alignment notes.
96. Client ratio briefing: You are a client advisor. Task: prepare a concise ratio briefing for a client using [clientName], [keyRatios], [interpretation]. Context: advisory session. Output format: brief slides-free notes.
97. Liquidity by currency: You are a treasury analyst. Task: compute liquidity metrics by currency using [currency], [cash], [liabilities]. Context: multinational. Output format: currency-specific bullets.
98. Cost center ROI: You are a cost controller. Task: evaluate ROI by cost center using [revenue], [cost], [allocations], [ROI]. Context: performance review. Output format: per-center report.
99. Capital stress test: You are a risk manager. Task: run a capital stress test affecting ratios using [shocks], [capital]. Context: resilience planning. Output format: results with action plan.
100. CFO-ready dashboard prompts: You are a dashboard specialist. Task: generate prompts for a CFO-ready liquidity and profitability dashboard using [metrics], [dataSources]. Context: executive reporting. Output format: prompt list for automation.

Best Practices

• Use precise data ranges and clearly define the period you are analyzing to improve accuracy.
• Reuse prompts across other clients or periods by preserving a consistent set of placeholders and constraints.
• Combine ratio prompts with a short interpretation section to translate numbers into actionable insights.
• Keep outputs auditable by asking for source data references and a brief justification for any conclusions.
• Test prompts with edge cases to ensure safety and reliability in unusual scenarios.

Common Mistakes to Avoid

• Using vague prompts without data placeholders or time frames, which yields generic results.
• Forgetting to specify output format, causing inconsistent or hard-to-parse results.
• Overloading prompts with too many variables, reducing clarity of conclusions.
• Ignoring data quality issues or missing data in the input.
• Assuming benchmarks without providing benchmark data or context.

FAQ

What makes a good financial ratio prompt for accountants?

A good prompt is specific, data-driven, includes placeholders, defines the period, and requests a clear, actionable output.

How do I customize prompts for different clients?

Replace placeholders with client-specific data and adjust constraints, benchmarks, and channels for client reporting.

Can prompts generate client-ready reports?

Yes, prompts can produce concise summaries, tables, and action lists suitable for client presentations.

What outputs should I expect from these prompts?

Expect structured outputs such as ratio calculations, interpretations, benchmarks, and recommended actions.

How do I ensure accuracy and auditability?

Include source data references, specify data sources, and request step-by-step calculations or checks.

Are these prompts suitable for real-time dashboards?

They can feed structured data into dashboards, but ensure data pipelines are reliable and timely.