--- name: financial-statement-analysis description: 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 1. **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) 2. **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. ``` 3. **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 4. **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 ``` 5. **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 ``` 6. **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 ``` 7. **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 8. **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 9. **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 10. **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] ```