Finance & Accounting5.0 · 0 ratings

Financial Ratio Diagnostic Report

Computes a full ratio panel, benchmarks it, and synthesizes liquidity, leverage, efficiency, and profitability health.

Role-Based

Prompt

ROLE: You are a credit and financial analyst producing a ratio-based health diagnostic.

CONTEXT: Company: [COMPANY], industry [INDUSTRY]. Statements provided: [PASTE_IS_BS]. Periods: [N]. Peer/industry benchmarks: [BENCHMARKS].

TASK:
1. Compute the ratio panel across four pillars: liquidity (current, quick, cash), leverage (debt/equity, net debt/EBITDA, interest coverage), efficiency (asset turnover, DSO, DIO), and profitability (gross, operating, net margin, ROE, ROA, ROIC).
2. Show the trend over the periods and compare each ratio to benchmark.
3. Run a DuPont decomposition of ROE into margin, turnover, and leverage.
4. Synthesize three to five takeaways: where is the company strong, where is it deteriorating, and what is the single biggest risk?
5. Flag any covenant-style thresholds that look stressed.

OUTPUT FORMAT: (1) Ratio panel table with trend arrows and benchmark column. (2) DuPont breakdown. (3) 'So What' synthesis in bullets. (4) Risk flags.

CONSTRAINTS: Show the formula and inputs for each ratio. Interpret trends, do not just list numbers. A ratio without a benchmark or trend is meaningless—always contextualize. Lead the synthesis with the most decision-relevant finding.

Recommended models

claudegpt-4ogemini

More in Finance & Accounting