Finance AI Skill

Financial Statement Analysis

Perform comprehensive analysis of financial statements including horizontal/vertical analysis, ratio analysis, cash flow quality assessment, and trend evaluation. Use when analyzing a company's financial health, evaluating investment opportunities, conducting credit analysis, benchmarking performance, preparing investment committee materials, or assessing financial trends. Triggers on phrases like "financial statement analysis", "ratio analysis", "horizontal analysis", "vertical analysis", "trend analysis", "financial health", "credit analysis", "common-size statements", "DuPont analysis", "financial ratio benchmarking".

Financial Statement Analysis

Systematically analyze financial statements to assess a company's profitability, liquidity, solvency, efficiency, and overall financial health.

Workflow

Analysis Framework

Gather financial data:

Income statement (3-5 years annual + most recent quarter)
Balance sheet (comparative periods)
Cash flow statement (indirect method preferred)
Footnotes and supplementary disclosures
Industry benchmarks and peer company data
Management discussion and analysis (MD&A)

Vertical Analysis (Common-Size Statements):

   COMMON-SIZE INCOME STATEMENT (% of Revenue)
   ════════════════════════════════════════
                            FY21    FY22    FY23    FY24    Trend
   Revenue                 100.0%  100.0%  100.0%  100.0%  —
   COGS                     42.1%   40.5%   39.2%   38.0%  ↑ (improving)
   Gross Profit             57.9%   59.5%   60.8%   62.0%  ↑
   
   Operating Expenses:
     R&D                    12.0%   12.5%   13.0%   13.5%  ↑ (investment)
     Sales & Marketing      22.0%   21.0%   20.5%   19.8%  ↑ (efficiency)
     G&A                    10.5%   10.0%   9.5%    9.0%   ↑
   
   Operating Income         13.4%   16.0%   17.8%   19.7%  ↑
   Interest Expense          2.1%    2.0%    1.8%    1.5%  ↑
   Pretax Income            11.3%   14.0%   16.0%   18.2%  ↑
   Tax (21%)                2.4%    2.9%    3.4%    3.8%  ↑
   Net Income               8.9%   11.1%   12.6%   14.4%  ↑
   
   INSIGHT: Gross margin improved 400bps over 3 years — indicates
   pricing power or cost structure improvement. Operating leverage
   evident as OpEx declining as % of revenue while revenue grows.

Horizontal Analysis (Year-over-Year Growth):

   HORIZONTAL ANALYSIS (YoY $ and %)
   ════════════════════════════════════════
                            FY22    YoY      FY23    YoY      FY24    YoY
   Revenue              $120.0M  +20.0%   $145.0M  +20.8%   $175.0M  +20.7%
   Gross Profit          $79.2M  +21.8%   $96.7M   +22.1%  $108.5M  +12.2%
   Operating Income      $19.2M  +35.0%   $25.8M   +34.4%   $34.5M   +33.7%
   Net Income            $13.3M  +37.0%   $18.3M   +37.6%   $25.2M   +37.7%
   Total Assets          $200.0M  +18.2%  $235.0M   +17.5%  $270.0M   +14.9%
   Total Debt             $45.0M  +12.5%   $48.0M    +6.7%   $50.0M    +4.2%
   FCF                   $15.0M  +50.0%   $22.5M   +50.0%   $30.0M   +33.3%
   
   INSIGHT: Revenue growing at stable ~20% CAGR. Net income growing
   faster than revenue (operating leverage). Debt growing much slower
   than revenue (improving balance sheet). FCF growing robustly.

Ratio Analysis

Liquidity Ratios:

   LIQUIDITY ASSESSMENT
   ════════════════════════════════════════
   
   Current Ratio = Current Assets / Current Liabilities
     FY24: $120M / $80M = 1.50x
     Benchmark: 1.2-2.0x (healthy)
     Assessment: ✓ Adequate short-term liquidity
   
   Quick Ratio = (Current Assets - Inventory) / Current Liabilities
     FY24: ($120M - $30M) / $80M = 1.13x
     Benchmark: >1.0x
     Assessment: ✓ Strong (not dependent on inventory liquidation)
   
   Cash Ratio = Cash & Equivalents / Current Liabilities
     FY24: $35M / $80M = 0.44x
     Benchmark: >0.2x
     Assessment: ✓ Comfortable cash cushion
   
   Operating Cash Flow Ratio = OCF / Current Liabilities
     FY24: $45M / $80M = 0.56x
     Benchmark: >0.3x
     Assessment: ✓ Strong operating cash generation relative to obligations

Profitability Ratios:

   PROFITABILITY ASSESSMENT
   ════════════════════════════════════════
   
   Gross Margin = Gross Profit / Revenue
     FY24: 62.0% (improved from 57.9% in FY21)
     Industry avg: 55-60%
     Assessment: ✓ Above industry average; improving trend
   
   Operating Margin = Operating Income / Revenue
     FY24: 19.7% (improved from 13.4% in FY21)
     Industry avg: 12-18%
     Assessment: ✓ Excellent; significant operating leverage
   
   Net Profit Margin = Net Income / Revenue
     FY24: 14.4% (improved from 8.9% in FY21)
     Industry avg: 8-12%
     Assessment: ✓ Well above peers
   
   Return on Assets (ROA) = Net Income / Average Total Assets
     FY24: $25.2M / $252.5M = 10.0%
     Benchmark: >5%
     Assessment: ✓ Efficient asset utilization
   
   Return on Equity (ROE) = Net Income / Average Shareholders' Equity
     FY24: $25.2M / $180M = 14.0%
     Benchmark: >12%
     Assessment: ✓ Strong return to shareholders
   
   Return on Invested Capital (ROIC) = NOPAT / (Debt + Equity)
     FY24: $32.0M / $230M = 13.9%
     WACC: 9.5%
     Assessment: ✓ ROIC > WACC; creating economic value

Leverage/Solvency Ratios:

   LEVERAGE ASSESSMENT
   ════════════════════════════════════════
   
   Debt-to-Equity = Total Debt / Shareholders' Equity
     FY24: $50M / $180M = 0.28x
     Benchmark: <1.0x for healthy companies
     Assessment: ✓ Very conservative leverage
   
   Debt-to-EBITDA = Total Debt / EBITDA
     FY24: $50M / $42M = 1.19x
     Benchmark: <3.0x (investment grade); <4.5x acceptable
     Assessment: ✓ Very low leverage
   
   Interest Coverage = EBIT / Interest Expense
     FY24: $36M / $2.5M = 14.4x
     Benchmark: >3.0x; >5.0x comfortable
     Assessment: ✓ Exceptional coverage; minimal refinancing risk
   
   Debt Service Coverage = (EBITDA - CapEx) / (Interest + Principal)
     FY24: ($42M - $10M) / ($2.5M + $5M) = 4.27x
     Assessment: ✓ Strong ability to service debt

Efficiency/Activity Ratios:

   EFFICIENCY ASSESSMENT
   ════════════════════════════════════════
   
   Days Sales Outstanding (DSO) = AR / (Revenue/365)
     FY24: $45M / ($175M/365) = 93 days
     FY23: 95 days | FY22: 98 days
     Assessment: ✓ Improving collections (93 → 95 → 98 days)
   
   Days Inventory Outstanding (DIO) = Inventory / (COGS/365)
     FY24: $30M / ($67M/365) = 163 days
     FY23: 168 days | FY22: 175 days
     Assessment: ✓ Improving inventory management
   
   Days Payable Outstanding (DPO) = AP / (COGS/365)
     FY24: $40M / ($67M/365) = 218 days
     FY23: 210 days | FY22: 205 days
     Assessment: ⚠ Increasing DPO; monitor vendor relationship impact
   
   Cash Conversion Cycle = DSO + DIO - DPO
     FY24: 93 + 163 - 218 = 38 days
     FY23: 95 + 168 - 210 = 53 days
     Assessment: ✓ Improving CCC (faster cash conversion)
   
   Asset Turnover = Revenue / Average Total Assets
     FY24: $175M / $252.5M = 0.69x
     Assessment: → Moderate; typical for capital-light business
   
   Fixed Asset Turnover = Revenue / Average Fixed Assets
     FY24: $175M / $65M = 2.69x
     Assessment: ✓ Good utilization of fixed assets

DuPont Analysis

Decompose ROE using DuPont framework:

   DUPONT ANALYSIS — 5-Factor
   ════════════════════════════════════════
   
   ROE = Net Profit Margin × Asset Turnover × Financial Leverage × Tax Burden × Interest Burden
   
   FY24 Components:
     Net Profit Margin:         14.4%    (FY21: 8.9%)
     × Asset Turnover:           0.69    (FY21: 0.60)
     × Tax Burden (Net/Pre-tax): 0.79    (FY21: 0.79)
     × Interest Burden (Pre-tax/EBIT): 1.07  (FY21: 1.19)
     × Equity Multiplier (Assets/Equity): 1.50  (FY21: 1.67)
   
   ROE = 14.4% × 0.69 × 0.79 × 1.07 × 1.50 = 14.0%
   
   DRIVERS OF ROE IMPROVEMENT:
     → Primary driver: Net profit margin expansion (8.9% → 14.4%)
     → Secondary: Asset turnover improvement (0.60 → 0.69)
     → Offset: Lower financial leverage (multiplier 1.67 → 1.50)
   
   CONCLUSION: ROE improvement driven by operational excellence
   (margin + efficiency), not by taking on more debt. Quality growth.

Cash Flow Quality Assessment

Evaluate quality of earnings through cash flows:

   CASH FLOW QUALITY CHECK
   ════════════════════════════════════════
   
   Accruals Ratio = (Net Income - Operating CF) / Average Total Assets
     FY24: ($25.2M - $38.0M) / $252.5M = -5.1%
     Assessment: ✓ NEGATIVE = cash flows exceed earnings
     → High quality earnings; company generating more cash than reported
   
   Free Cash Flow Yield = FCF / Enterprise Value
     FY24: $30M / $350M = 8.6%
     Assessment: ✓ Attractive yield (vs treasury rate ~4%)
   
   FCF Conversion = Free Cash Flow / Net Income
     FY24: $30M / $25.2M = 119%
     Assessment: ✓ Excellent cash conversion (>100% = cash exceeds income)
   
   Capex as % of Depreciation
     FY24: $10M / $8M = 125%
     Assessment: ✓ Maintaining/replacing assets (maintenance + growth capex)
   
   Cash Flow from Operations / Total Revenue
     FY24: $38M / $175M = 21.7%
     Assessment: ✓ Strong operational cash generation
   
   🚩 RED FLAG CHECK:
     □ Net income positive but OCF negative? NO ✓
     □ Growing receivables faster than revenue? NO ✓
     □ Increasing inventory without revenue growth? NO ✓
     □ Unusual increase in accrued expenses? NO ✓
     □ Large one-time items boosting earnings? NO ✓
   
   OVERALL: High-quality earnings supported by strong cash generation

Peer Benchmarking

Compare against industry peers:

    PEER COMPARISON SUMMARY
    ════════════════════════════════════════
    
    Metric            | Company | Peer 1 | Peer 2 | Peer 3 | Industry Avg
    ──────────────────┼─────────┼────────┼────────┼────────┼─────────────
    Revenue Growth    |  20.7%  | 15.2%  | 18.5%  | 12.0%  |   15.2%
    Gross Margin      |  62.0%  | 58.0%  | 60.5%  | 55.0%  |   57.8%
    Operating Margin  |  19.7%  | 15.5%  | 17.0%  | 12.0%  |   14.8%
    Net Margin        |  14.4%  | 10.2%  | 11.5%  | 8.0%   |    9.9%
    ROE               |  14.0%  | 12.5%  | 13.0%  | 9.5%   |   11.7%
    ROIC              |  13.9%  | 11.0%  | 12.5%  | 8.0%   |   10.5%
    Debt/EBITDA       |   1.19x | 2.50x  | 2.80x  | 1.50x  |    2.27x
    DSO               |   93d   | 85d    | 100d   | 90d    |    92d
    FCF Margin        |  17.1%  | 12.0%  | 14.5%  | 10.0%  |   12.2%
    
    Assessment: Company outperforms peers on virtually all profitability
    metrics. Leverage is significantly lower than peers. FCF margin is
    top quartile. This is a high-quality business.

Edge Cases

Companies with negative earnings: Focus on cash burn, runway, path to profitability; use alternative metrics (user growth, GMV, unit economics)
Highly cyclical companies: Normalize for cycle; analyze through multiple cycles; stress-test at trough conditions
Financial institutions: Use different ratio set (tier 1 capital ratio, NIM, NCO ratio, LCR); regulatory metrics take precedence
Real estate companies: Use FFO/AFFO instead of net income; analyze NOI, cap rates, occupancy
Startups with no revenue: Analyze burn rate, runway, unit economics, CAC/LTV; traditional ratios not applicable
Companies with related-party transactions: Strip out non-arm's-length items; assess standalone economics

Integration Points

Financial databases: Bloomberg, Capital IQ, FactSet (peer data, ratios)
Accounting systems: ERP exports (GL trial balance)
Analytics tools: Excel (primary analysis), Tableau/Power BI (visualization)
Industry reports: IBISWorld, Gartner, Forrester (benchmarking data)
SEC filings: EDGAR (10-K, 10-Q for public companies)

Output

Analysis Summary Report

FINANCIAL STATEMENT ANALYSIS SUMMARY
═══════════════════════════════════════

Company: [Name] | Period: FY2020-FY2024 | Date: [Current]

OVERALL ASSESSMENT: [STRONG / MODERATE / CONCERNING]

Key Strengths:
  1. Revenue growth 20%+ CAGR, above peer average
  2. Expanding margins across all levels (gross, operating, net)
  3. Strong cash conversion (FCF > Net Income)
  4. Minimal leverage (D/E 0.28x, well below peers)
  5. Improving efficiency (DSO, CCC trending down)

Areas of Attention:
  1. DPO trending up — monitor vendor impact
  2. Asset turnover moderate — ensure capex efficiency
  3. Customer concentration [if applicable]

Rating: [Investment Grade / Speculative / Distressed]
Recommendation: [BUY / HOLD / SELL / APPROVE CREDIT / PROCEED]

Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.