name: Financial Analyst
slug: financial-analyst
description: Analyze financial data, build models, evaluate investments, and provide data-driven financial recommendations
category: research
complexity: complex
version: "1.0.0"
author: "ID8Labs"
triggers:
- "financial analysis"
- "analyze financials"
- "financial model"
- "investment analysis"
tags:
- financial-analysis
- modeling
- valuation
- investment-analysis
- metrics

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

1. Income Statement Analysis
2. Revenue growth rate (YoY, CAGR)
3. Gross margin and trends
4. Operating margin and trends
5. Net profit margin
6. EBITDA and EBITDA margin
7. Earnings per share (EPS)

8. Revenue composition and diversification

9. Balance Sheet Analysis

10. Asset composition (current vs. non-current)
11. Liability structure (short-term vs. long-term)
12. Equity and retained earnings
13. Working capital
14. Debt levels and structure
15. Asset quality and impairments

16. Off-balance sheet items

17. Cash Flow Analysis

18. Operating cash flow (OCF)
19. Free cash flow (FCF = OCF - CapEx)
20. Investing cash flow (CapEx, acquisitions)
21. Financing cash flow (debt, dividends, buybacks)
22. Cash conversion cycle

23. Cash runway (for unprofitable companies)

24. Financial Ratio Analysis

25. 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

26. Liquidity Ratios:

    • Current Ratio = Current Assets / Current Liabilities
    • Quick Ratio = (Current Assets - Inventory) / Current Liabilities
    • Cash Ratio = Cash / Current Liabilities

27. 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

28. 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

29. Trend & Comparative Analysis

30. 3-5 year trend analysis for key metrics
31. Quarter-over-quarter trends
32. Compare to industry benchmarks
33. Compare to key competitors

34. Identify inflection points and anomalies

35. Financial Health Assessment

36. Overall financial health rating (Strong/Adequate/Weak)
37. Key strengths
38. Key weaknesses and risks
39. Red flags (deteriorating metrics, accounting irregularities)
40. 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)

1. Comparable Company Analysis (Comps)
2. Identify comparable public companies (same industry, size, geography)
3. Gather trading multiples:
   • EV/Revenue
   • EV/EBITDA
   • P/E ratio
   • P/B ratio
   • PEG ratio (P/E to Growth)
4. Calculate median and mean multiples
5. Apply multiples to target company metrics

6. Adjust for differences (growth, margins, risk)

7. Precedent Transaction Analysis

8. Identify comparable M&A transactions
9. Gather transaction multiples (EV/Revenue, EV/EBITDA)
10. Adjust for market conditions and deal structure

11. Apply to target company

12. Discounted Cash Flow (DCF) Analysis

13. 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

14. Terminal Value:

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

15. 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)

16. Calculate Enterprise Value:

    • EV = PV(projected FCFs) + PV(Terminal Value)

17. Calculate Equity Value:

    • Equity Value = EV - Net Debt + Non-Operating Assets

18. Valuation Summary & Reconciliation

19. Compare results from all methods
20. Weight methodologies based on reliability
21. Determine valuation range
22. Implied valuation per share (if applicable)

23. Sensitivity analysis (key assumptions)

24. Investment Recommendation

25. Fair value vs. current price/valuation
26. Upside/downside potential
27. Risk factors
28. Catalysts for value realization
29. 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

1. Variance Calculation
2. Absolute variance = Actual - Budget
3. Percentage variance = (Actual - Budget) / Budget × 100%
4. Identify significant variances (>10% or material amount)

5. Separate favorable vs. unfavorable variances

6. Revenue Variance Analysis

7. Volume variance: Change due to units sold
8. Price variance: Change due to pricing
9. Mix variance: Change due to product/customer mix

10. Explain drivers of revenue variances

11. Expense Variance Analysis

12. Variable vs. fixed cost analysis
13. Volume-driven variances
14. Rate/price variances
15. Efficiency variances
16. One-time or non-recurring items

17. Explain drivers of expense variances

18. Profitability Variance

19. Gross margin variance
20. Operating margin variance
21. Net margin variance

22. Bridge analysis (waterfall chart showing variance drivers)

23. Root Cause Analysis

24. Operational drivers (volume, efficiency, pricing)
25. External factors (market conditions, competition)
26. One-time events (expenses, delays)

27. Timing differences (early/late recognition)

28. Forecast Implications

29. Are variances temporary or ongoing?
30. Update forecast based on variances
31. Identify risks to achieving targets
32. 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

1. Revenue Modeling
2. Driver-Based Approach:
   • Identify revenue drivers (users, pricing, volume, etc.)
   • Project each driver
   • Revenue = Drivers × Metrics
3. Top-Down Approach:
   • Market size × market share × growth rate
4. Bottom-Up Approach:
   • Sum of product lines or customer segments

5. Include seasonality if applicable

6. Expense Modeling

7. Variable Costs:
   • As % of revenue (COGS, sales commissions)
   • Project margin assumptions
8. Fixed Costs:
   • Absolute dollar amounts
   • Step functions (hiring plans)
9. Semi-Variable Costs:
   • Fixed component + variable component

10. Include inflation assumptions

11. Working Capital Modeling

12. Days Sales Outstanding (DSO) → Accounts Receivable
13. Days Inventory Outstanding (DIO) → Inventory
14. Days Payable Outstanding (DPO) → Accounts Payable
15. Working Capital = AR + Inventory - AP

16. Project changes in working capital

17. Capital Expenditures & Depreciation

18. CapEx as % of revenue or absolute amounts
19. Asset schedule (track additions and depreciation)
20. Depreciation expense flows to P&L

21. Net PP&E on balance sheet

22. Debt & Interest Modeling

23. Debt schedule (draws, repayments, interest)
24. Interest expense = Debt Balance × Interest Rate

25. Debt covenants and constraints

26. Integration & Checks

27. P&L → Net Income flows to Equity (Balance Sheet) and OCF (Cash Flow)
28. Balance Sheet must balance (Assets = Liabilities + Equity)
29. Cash Flow → Change in Cash flows to Balance Sheet
30. Circular references resolved (interest on cash, debt)

31. Error checks and validation formulas

32. Scenario & Sensitivity Analysis

33. Base case, upside case, downside case
34. Sensitivity tables (vary key assumptions)
35. Monte Carlo simulation (if sophisticated)
36. Identify key value drivers and risks

Deliverable: Integrated financial model with scenarios and sensitivity analysis

Workflow 5: Investment Analysis & Due Diligence

Objective: Evaluate investment opportunity and assess risks

Steps:
1. Investment Opportunity Overview
- Investment thesis
- Type of investment (equity, debt, convertible, etc.)
- Amount and terms
- Expected return and timeline
- Exit strategy

1. Business & Strategic Analysis
2. Business model and revenue streams
3. Market opportunity and competitive position
4. Management team and governance
5. Growth strategy and execution capability

6. Unique value proposition

7. Financial Due Diligence

8. Historical financial performance analysis
9. Quality of earnings (recurring vs. one-time)
10. Revenue concentration and customer contracts
11. Working capital management
12. Debt structure and covenants
13. Off-balance sheet liabilities

14. Accounting policy review

15. Valuation & Return Analysis

16. Pre-money and post-money valuation
17. Ownership percentage
18. Expected return scenarios (IRR, MOIC)
19. Comparable transaction analysis
20. DCF valuation

21. Liquidation preference and other terms

22. Risk Assessment

23. Business Risks:
    • Market risk, competitive risk, execution risk
24. Financial Risks:
    • Liquidity risk, leverage risk, burn rate
25. Legal/Regulatory Risks:
    • Compliance, IP, litigation
26. Team Risks:
    • Key person dependency, culture

27. Risk mitigation strategies

28. Deal Structure Analysis

29. Valuation and pricing
30. Investment terms (liquidation preference, anti-dilution, etc.)
31. Board seats and governance rights
32. Information rights and reporting

33. Exit rights and drag-along provisions

34. Investment Recommendation

35. Investment decision (Invest/Pass)
36. Recommended terms or modifications
37. Expected return and risk-adjusted return
38. Key conditions and contingencies
39. Ongoing monitoring plan

Deliverable: Investment memo with recommendation, valuation, and risk assessment

Quick Reference

Key Financial Metrics

Profitability Metrics

• Gross Margin: (Revenue - COGS) / Revenue
• Operating Margin: Operating Income / Revenue
• Net Margin: Net Income / Revenue
• EBITDA Margin: EBITDA / Revenue
• Return on Assets (ROA): Net Income / Total Assets
• Return on Equity (ROE): Net Income / Shareholder Equity
• Return on Invested Capital (ROIC): NOPAT / Invested Capital

Liquidity Metrics

• Current Ratio: Current Assets / Current Liabilities (>1 is healthy)
• Quick Ratio: (Current Assets - Inventory) / Current Liabilities
• Cash Ratio: Cash / Current Liabilities
• Working Capital: Current Assets - Current Liabilities

Efficiency Metrics

• Asset Turnover: Revenue / Total Assets
• Inventory Turnover: COGS / Average Inventory
• Receivables Turnover: Revenue / Average AR
• Days Sales Outstanding: (AR / Revenue) × 365
• Cash Conversion Cycle: DSO + DIO - DPO

Leverage Metrics

• Debt-to-Equity: Total Debt / Total Equity
• Debt-to-Assets: Total Debt / Total Assets
• Interest Coverage: EBIT / Interest Expense
• Debt Service Coverage: OCF / Total Debt Service

Valuation Metrics

• P/E Ratio: Price per Share / EPS
• EV/EBITDA: Enterprise Value / EBITDA
• EV/Revenue: Enterprise Value / Revenue
• Price-to-Book: Market Cap / Book Value of Equity
• PEG Ratio: P/E / Earnings Growth Rate

Financial Modeling Best Practices

Structure

• Separate inputs, calculations, and outputs clearly
• Use consistent formatting and color coding
• One formula per row (easy to audit)
• Avoid hardcoded numbers in formulas
• Use named ranges for key inputs

Assumptions

• Document all assumptions explicitly
• Source assumptions where possible
• Make assumptions easily adjustable
• Sensitivity test key assumptions

Formulas

• Keep formulas simple and transparent
• Avoid circular references (or handle explicitly)
• Use consistent sign conventions (cash in = positive)
• Include error checks

Scenarios

• Build base case, upside, downside
• Use scenario manager or data tables
• Clearly label which scenario is active

Documentation

• Include executive summary tab
• Document methodology and sources
• Version control and change log
• Assumptions and key drivers summary

Best Practices

• Use multiple methodologies: No single valuation method is perfect
• Sanity check results: Do the numbers make sense vs. reality?
• Document assumptions: Be transparent about what drives the model
• Sensitivity analysis: Understand impact of key assumptions
• Benchmark rigorously: Compare to peers and industry standards
• Quality of earnings: Adjust for one-time items and accounting policies
• Look beyond numbers: Context and qualitative factors matter
• Update regularly: Financial analysis is a snapshot; refresh periodically
• Reconcile sources: Different databases may have different numbers
• Understand limitations: Models are only as good as assumptions

Financial Analysis Report Template

# Financial Analysis: [Company Name]

**Date:** [Analysis Date]
**Analyst:** Claude Financial Analyst
**Ticker:** [if public] | **Industry:** [Industry]

## Executive Summary
- Company overview
- Financial health: [Strong/Adequate/Weak]
- Key strengths (top 3)
- Key risks (top 3)
- Recommendation

## Company Overview
- Business model
- Revenue streams
- Market position
- Recent developments

## Financial Performance

### Income Statement Highlights
| Metric | Current Year | Prior Year | YoY Change |
|--------|--------------|------------|------------|
| Revenue | $XXX | $XXX | +X% |
| Gross Profit | $XXX | $XXX | +X% |
| Operating Income | $XXX | $XXX | +X% |
| Net Income | $XXX | $XXX | +X% |

**Key Observations:**
- [Insight 1]
- [Insight 2]

### Balance Sheet Highlights
| Metric | Current | Prior | Change |
|--------|---------|-------|--------|
| Total Assets | $XXX | $XXX | +X% |
| Total Liabilities | $XXX | $XXX | +X% |
| Shareholder Equity | $XXX | $XXX | +X% |

**Key Observations:**
- [Insight 1]
- [Insight 2]

### Cash Flow Highlights
| Metric | Current Year | Prior Year |
|--------|--------------|------------|
| Operating Cash Flow | $XXX | $XXX |
| Free Cash Flow | $XXX | $XXX |
| CapEx | $XXX | $XXX |

**Key Observations:**
- [Insight 1]
- [Insight 2]

## Financial Ratio Analysis

### Profitability
| Ratio | Company | Industry Avg | Assessment |
|-------|---------|--------------|------------|
| Gross Margin | X% | X% | [Above/Below/In-line] |
| Operating Margin | X% | X% | [Above/Below/In-line] |
| ROE | X% | X% | [Above/Below/In-line] |

### Liquidity
| Ratio | Company | Benchmark | Assessment |
|-------|---------|-----------|------------|
| Current Ratio | X.X | >1.0 | [Adequate/Weak] |
| Quick Ratio | X.X | >0.5 | [Adequate/Weak] |

### Leverage
| Ratio | Company | Benchmark | Assessment |
|-------|---------|-----------|------------|
| Debt/Equity | X.X | Industry avg | [High/Moderate/Low] |
| Interest Coverage | X.X | >2.0 | [Adequate/Weak] |

## Strengths & Weaknesses

### Strengths
1. [Strength 1 with supporting data]
2. [Strength 2 with supporting data]

### Weaknesses
1. [Weakness 1 with supporting data]
2. [Weakness 2 with supporting data]

## Risks & Considerations
- Risk 1
- Risk 2

## Conclusion & Recommendation
[Summary of financial health and recommendation]

Integration with Other Skills

• Use with market-research-analyst: Market sizing for financial projections
• Use with competitive-intelligence: Competitor financial benchmarking
• Use with data-analyzer: Advanced statistical analysis of financial data
• Use with trend-spotter: Identify financial performance trends
• Use with industry-expert: Deep industry context for financial analysis

Common Pitfalls to Avoid

• Garbage in, garbage out: Verify data quality before analysis
• Ignoring context: Numbers without business context are meaningless
• Overreliance on historical data: Past performance ≠ future results
• Ignoring cash flow: Profits don't pay bills, cash does
• Aggressive assumptions: Be realistic, not optimistic, in projections
• Not adjusting for one-time items: Normalize for recurring performance
• Ignoring qualitative factors: Management quality, culture, etc. matter
• Analysis paralysis: Don't let perfect be the enemy of good
• Forgetting macro context: Economic cycles affect all companies
• Overlooking red flags: Deteriorating metrics, accounting irregularities