biz-financial-ratios

Financial Ratio Analysis

Overview

Financial ratio analysis transforms raw financial statements into comparable metrics across five categories. Ratios are meaningful only in context — compare against industry benchmarks, historical trends, and peer companies.

When to Use

Trigger conditions:

• User has financial statements and needs to assess company health
• User comparing financial performance across companies
• User performing due diligence or credit analysis
• User asks "is this company financially healthy?" or "analyze these numbers"

When NOT to use:

• For valuation → use DCF or comparables
• For ROE deep-dive → use DuPont Analysis
• For strategic assessment → use SWOT

Framework

IRON LAW: Ratios Without Context Are Meaningless

A current ratio of 1.5 means nothing alone. Is 1.5 good? Compare to:
1. Industry average (retail ~1.2, manufacturing ~1.8)
2. Company's own trend (was it 2.0 last year? → declining liquidity)
3. Peers (competitor has 2.5? → relatively weak)

NEVER report a ratio without at least one comparison point.

IRON LAW: All Five Categories, Every Time

Analyzing only profitability misses a leveraged company about to default.
Analyzing only liquidity misses a profitable company's growth potential.
Cover all five categories for a complete picture.

The Five Categories

1. Profitability — Is the company making money?

2. Liquidity — Can it pay short-term obligations?

3. Leverage — How much debt is used?

⚠️ "Debt" definition: This skill (and the bundled script) defines "Debt" in the leverage ratios as Total Liabilities — not "long-term debt only" or "interest-bearing debt only". Both alternative definitions exist in textbooks and produce materially different ratios. If you need a different definition, document the choice explicitly and compute it manually; do not silently substitute.

4. Efficiency — How well are assets used?

5. Valuation — Is the stock fairly priced?

Analysis Process

1. Calculate all relevant ratios from financial statements
2. Compare against industry benchmarks and 3-year trend
3. Identify red flags (declining trends, outliers vs peers)
4. Synthesize a financial health verdict across all five categories
5. Recommend actions based on weak areas

Output Format

⚠️ Decimal vs percent: The bundled script returns all profitability ratios (gross_margin, operating_margin, net_margin, roa, roe) as decimals — 0.35 means 35%, NOT 35.0. Liquidity and leverage ratios are already unitless multiples (e.g. current_ratio: 2.125). Render percentages only in the human-facing markdown report, never in JSON outputs.

# Financial Ratio Analysis: {Company}

## Summary Dashboard
| Category | Status | Key Metric |
|----------|--------|-----------|
| Profitability | 🟢/🟡/🔴 | {headline ratio} |
| Liquidity | 🟢/🟡/🔴 | {headline ratio} |
| Leverage | 🟢/🟡/🔴 | {headline ratio} |
| Efficiency | 🟢/🟡/🔴 | {headline ratio} |
| Valuation | 🟢/🟡/🔴 | {headline ratio} |

## Detailed Ratios
{Tables per category with ratio, value, industry avg, trend}

## Red Flags
- {specific concern with data}

## Overall Assessment
{Synthesized financial health verdict}

Examples

Correct Application

Scenario: Ratio analysis for a Taiwanese electronics manufacturer

Synthesis: Profitability weakening + inventory building up + leverage rising = potential working capital crisis ahead ✓

Incorrect Application

• Reported "Gross Margin 18%" as standalone fact → No comparison. Is 18% good or bad? Violates Iron Law: ratios without context.
• Only analyzed profitability ratios, missed D/E of 4.5x → Company appeared healthy by margins but was dangerously overleveraged. Violates Iron Law: all five categories.

Gotchas

• Industry matters enormously: A 5% net margin is terrible for software (expect 20-30%) but excellent for grocery retail (expect 2-3%). Always benchmark within industry.
• One-time items: Restructuring charges, asset sales, or legal settlements distort ratios for that period. Use adjusted figures or note the distortion.
• Seasonal businesses: Ratios at different quarter-ends tell different stories. Use trailing 12-month or compare same quarter YoY.
• Off-balance-sheet items: Operating leases (pre-IFRS 16), special purpose vehicles, and contingent liabilities may not appear in standard ratios. Check footnotes.
• Growth companies look "unhealthy": High-growth companies often have low profitability, high leverage, and negative cash flow by design. Context matters.

Scripts

Run python scripts/financial_ratios.py --verify to execute built-in sanity tests.

References

• For industry-specific benchmark ranges, see references/industry-benchmarks.md
• For DuPont deep-dive on ROE, see the biz-dupont skill