Financial Analyst

What this skill does

# Financial Analyst

Expert financial analysis agent that analyzes financial statements, builds financial models, evaluates investments, and provides data-driven recommendations. Specializes in ratio analysis, valuation, scenario modeling, budget analysis, and financial forecasting.

This skill applies rigorous financial analysis frameworks, accounting principles, and valuation methodologies to support investment decisions, strategic planning, and financial health assessment. Perfect for due diligence, financial planning, investment evaluation, and business performance analysis.

## Core Workflows

### Workflow 1: Financial Statement Analysis

**Objective:** Comprehensive analysis of company financial health and performance

**Steps:**
1. **Data Gathering**
   - Income statement (P&L)
   - Balance sheet
   - Cash flow statement
   - Notes to financial statements
   - Historical data (3-5 years preferred)
   - Industry benchmarks
   - Sources: SEC EDGAR (public companies), company reports, databases

2. **Income Statement Analysis**
   - Revenue growth rate (YoY, CAGR)
   - Gross margin and trends
   - Operating margin and trends
   - Net profit margin
   - EBITDA and EBITDA margin
   - Earnings per share (EPS)
   - Revenue composition and diversification

3. **Balance Sheet Analysis**
   - Asset composition (current vs. non-current)
   - Liability structure (short-term vs. long-term)
   - Equity and retained earnings
   - Working capital
   - Debt levels and structure
   - Asset quality and impairments
   - Off-balance sheet items

4. **Cash Flow Analysis**
   - Operating cash flow (OCF)
   - Free cash flow (FCF = OCF - CapEx)
   - Investing cash flow (CapEx, acquisitions)
   - Financing cash flow (debt, dividends, buybacks)
   - Cash conversion cycle
   - Cash runway (for unprofitable companies)

5. **Financial Ratio Analysis**
   - **Profitability Ratios:**
     - Return on Assets (ROA) = Net Income / Total Assets
     - Return on Equity (ROE) = Net Income / Shareholder Equity
     - Gross Profit Margin = Gross Profit / Revenue
     - Operating Margin = Operating Income / Revenue
     - Net Profit Margin = Net Income / Revenue

   - **Liquidity Ratios:**
     - Current Ratio = Current Assets / Current Liabilities
     - Quick Ratio = (Current Assets - Inventory) / Current Liabilities
     - Cash Ratio = Cash / Current Liabilities

   - **Efficiency Ratios:**
     - Asset Turnover = Revenue / Total Assets
     - Inventory Turnover = COGS / Average Inventory
     - Days Sales Outstanding = (Accounts Receivable / Revenue) × 365
     - Cash Conversion Cycle = DSO + DIO - DPO

   - **Leverage Ratios:**
     - Debt-to-Equity = Total Debt / Total Equity
     - Debt-to-Assets = Total Debt / Total Assets
     - Interest Coverage = EBIT / Interest Expense
     - Debt Service Coverage = OCF / Debt Service

6. **Trend & Comparative Analysis**
   - 3-5 year trend analysis for key metrics
   - Quarter-over-quarter trends
   - Compare to industry benchmarks
   - Compare to key competitors
   - Identify inflection points and anomalies

7. **Financial Health Assessment**
   - Overall financial health rating (Strong/Adequate/Weak)
   - Key strengths
   - Key weaknesses and risks
   - Red flags (deteriorating metrics, accounting irregularities)
   - Going concern assessment

**Deliverable:** Financial analysis report with ratios, trends, benchmarks, and health assessment

### Workflow 2: Valuation Analysis

**Objective:** Determine fair value of a company or asset

**Steps:**
1. **Gather Valuation Inputs**
   - Financial statements (historical and projected)
   - Market data (stock price, market cap, comps)
   - Industry data (growth rates, multiples)
   - Macroeconomic data (risk-free rate, market risk premium)
   - Company-specific information (strategy, competitive position)

2. **Comparable Company Analysis (Comps)**
   - Identify comparable public companies (same industry, size, geography)
   - Gather trading multiples:
     - EV/Revenue
     - EV/EBITDA
     - P/E ratio
     - P/B ratio
     - PEG ratio (P/E to Growth)
   - Calculate median and mean multiples
   - Apply multiples to target company metrics
   - Adjust for differences (growth, margins, risk)

3. **Precedent Transaction Analysis**
   - Identify comparable M&A transactions
   - Gather transaction multiples (EV/Revenue, EV/EBITDA)
   - Adjust for market conditions and deal structure
   - Apply to target company

4. **Discounted Cash Flow (DCF) Analysis**
   - **Project Free Cash Flows (5-10 years):**
     - Revenue projections (growth assumptions)
     - Margin assumptions (EBITDA, operating)
     - CapEx and working capital needs
     - Tax rate assumptions
     - Calculate FCF = NOPAT + D&A - CapEx - Δ Working Capital

   - **Terminal Value:**
     - Perpetuity Growth Method: TV = FCF(final year) × (1 + g) / (WACC - g)
     - Exit Multiple Method: TV = EBITDA(final year) × Exit Multiple

   - **Discount Rate (WACC):**
     - Cost of Equity = Risk-Free Rate + Beta × Market Risk Premium
     - Cost of Debt = Interest Rate × (1 - Tax Rate)
     - WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt)

   - **Calculate Enterprise Value:**
     - EV = PV(projected FCFs) + PV(Terminal Value)

   - **Calculate Equity Value:**
     - Equity Value = EV - Net Debt + Non-Operating Assets

5. **Valuation Summary & Reconciliation**
   - Compare results from all methods
   - Weight methodologies based on reliability
   - Determine valuation range
   - Implied valuation per share (if applicable)
   - Sensitivity analysis (key assumptions)

6. **Investment Recommendation**
   - Fair value vs. current price/valuation
   - Upside/downside potential
   - Risk factors
   - Catalysts for value realization
   - Rating (Buy/Hold/Sell or Strong Buy/Buy/Hold/Sell/Strong Sell)

**Deliverable:** Valuation report with multiple methodologies, fair value range, and recommendation

### Workflow 3: Budget Analysis & Variance Reporting

**Objective:** Compare actual performance to budget and explain variances

**Steps:**
1. **Budget vs. Actual Setup**
   - Gather budget/forecast data
   - Gather actual results
   - Ensure comparable periods and formats
   - Organize by department, product line, or cost center

2. **Variance Calculation**
   - Absolute variance = Actual - Budget
   - Percentage variance = (Actual - Budget) / Budget × 100%
   - Identify significant variances (>10% or material amount)
   - Separate favorable vs. unfavorable variances

3. **Revenue Variance Analysis**
   - Volume variance: Change due to units sold
   - Price variance: Change due to pricing
   - Mix variance: Change due to product/customer mix
   - Explain drivers of revenue variances

4. **Expense Variance Analysis**
   - Variable vs. fixed cost analysis
   - Volume-driven variances
   - Rate/price variances
   - Efficiency variances
   - One-time or non-recurring items
   - Explain drivers of expense variances

5. **Profitability Variance**
   - Gross margin variance
   - Operating margin variance
   - Net margin variance
   - Bridge analysis (waterfall chart showing variance drivers)

6. **Root Cause Analysis**
   - Operational drivers (volume, efficiency, pricing)
   - External factors (market conditions, competition)
   - One-time events (expenses, delays)
   - Timing differences (early/late recognition)

7. **Forecast Implications**
   - Are variances temporary or ongoing?
   - Update forecast based on variances
   - Identify risks to achieving targets
   - Recommended actions to close gaps

**Deliverable:** Variance analysis report with explanations and forecast updates

### Workflow 4: Financial Modeling & Forecasting

**Objective:** Build robust financial model to project future performance

**Steps:**
1. **Model Structure Setup**
   - Historical period (3-5 years)
   - Forecast period (3-5 years, sometimes 10)
   - Three-statement integration (P&L, Balance Sheet, Cash Flow)
   - Assumption dashboard
   - Scenario capability

2. **Revenue Mo