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, conducti...

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]