Financial Analyst Skill
Overview
Production-ready financial analysis toolkit providing ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction. Designed for financial modeling, forecasting & budgeting, management reporting, business performance analysis, and investment analysis.
5-Phase Workflow
Phase 1: Scoping
- Define analysis objectives and stakeholder requirements
- Identify data sources and time periods
- Establish materiality thresholds and accuracy targets
- Select appropriate analytical frameworks
Phase 2: Data Analysis & Modeling
- Collect and validate financial data (income statement, balance sheet, cash flow)
- Validate input data completeness before running ratio calculations (check for missing fields, nulls, or implausible values)
- Calculate financial ratios across 5 categories (profitability, liquidity, leverage, efficiency, valuation)
- Build DCF models with WACC and terminal value calculations; cross-check DCF outputs against sanity bounds (e.g., implied multiples vs. comparables)
- Construct budget variance analyses with favorable/unfavorable classification
- Develop driver-based forecasts with scenario modeling
Phase 3: Insight Generation
- Interpret ratio trends and benchmark against industry standards
- Identify material variances and root causes
- Assess valuation ranges through sensitivity analysis
- Evaluate forecast scenarios (base/bull/bear) for decision support
Phase 4: Reporting
- Generate executive summaries with key findings
- Produce detailed variance reports by department and category
- Deliver DCF valuation reports with sensitivity tables
- Present rolling forecasts with trend analysis
Phase 5: Follow-up
- Track forecast accuracy (target: +/-5% revenue, +/-3% expenses)
- Monitor report delivery timeliness (target: 100% on time)
- Update models with actuals as they become available
- Refine assumptions based on variance analysis
Tools
1. Ratio Calculator (scripts/ratio_calculator.py)
Calculate and interpret financial ratios from financial statement data.
Ratio Categories:
- Profitability: ROE, ROA, Gross Margin, Operating Margin, Net Margin
- Liquidity: Current Ratio, Quick Ratio, Cash Ratio
- Leverage: Debt-to-Equity, Interest Coverage, DSCR
- Efficiency: Asset Turnover, Inventory Turnover, Receivables Turnover, DSO
- Valuation: P/E, P/B, P/S, EV/EBITDA, PEG Ratio
python scripts/ratio_calculator.py assets/sample_financial_data.json
python scripts/ratio_calculator.py assets/sample_financial_data.json --format json
python scripts/ratio_calculator.py assets/sample_financial_data.json --category profitability
2. DCF Valuation (scripts/dcf_valuation.py)
Discounted Cash Flow enterprise and equity valuation with sensitivity analysis.
Features:
- WACC calculation via CAPM
- Revenue and free cash flow projections (5-year default)
- Terminal value via perpetuity growth and exit multiple methods
- Enterprise value and equity value derivation
- Two-way sensitivity analysis (discount rate vs growth rate)
python scripts/dcf_valuation.py assets/sample_financial_data.json
python scripts/dcf_valuation.py assets/sample_financial_data.json --format json
python scripts/dcf_valuation.py assets/sample_financial_data.json --projection-years 7
3. Budget Variance Analyzer (scripts/budget_variance_analyzer.py)
Analyze actual vs budget vs prior year performance with materiality filtering.
Features:
- Dollar and percentage variance calculation
- Materiality threshold filtering (default: 10% or $50K)
- Favorable/unfavorable classification with revenue/expense logic
- Department and category breakdown
- Executive summary generation
python scripts/budget_variance_analyzer.py assets/sample_financial_data.json
python scripts/budget_variance_analyzer.py assets/sample_financial_data.json --format json
python scripts/budget_variance_analyzer.py assets/sample_financial_data.json --threshold-pct 5 --threshold-amt 25000
4. Forecast Builder (scripts/forecast_builder.py)
Driver-based revenue forecasting with rolling cash flow projection and scenario modeling.
Features:
- Driver-based revenue forecast model
- 13-week rolling cash flow projection
- Scenario modeling (base/bull/bear cases)
- Trend analysis using simple linear regression (standard library)
python scripts/forecast_builder.py assets/sample_financial_data.json
python scripts/forecast_builder.py assets/sample_financial_data.json --format json
python scripts/forecast_builder.py assets/sample_financial_data.json --scenarios base,bull,bear
Knowledge Bases
| Reference |
Purpose |
references/financial-ratios-guide.md |
Ratio formulas, interpretation, industry benchmarks |
references/valuation-methodology.md |
DCF methodology, WACC, terminal value, comps |
references/forecasting-best-practices.md |
Driver-based forecasting, rolling forecasts, accuracy |
references/industry-adaptations.md |
Sector-specific metrics and considerations (SaaS, Retail, Manufacturing, Financial Services, Healthcare) |
Templates
| Template |
Purpose |
assets/variance_report_template.md |
Budget variance report template |
assets/dcf_analysis_template.md |
DCF valuation analysis template |
assets/forecast_report_template.md |
Revenue forecast report template |
Key Metrics & Targets
| Metric |
Target |
| Forecast accuracy (revenue) |
+/-5% |
| Forecast accuracy (expenses) |
+/-3% |
| Report delivery |
100% on time |
| Model documentation |
Complete for all assumptions |
| Variance explanation |
100% of material variances |
Input Data Format
All scripts accept JSON input files in either of two shapes:
- Flat — the tool's expected keys at the top level (e.g.,
income_statement / balance_sheet for the ratio calculator, historical / assumptions for DCF, line_items for variance, historical_periods / drivers / assumptions / cash_flow_inputs for forecasting).
- Nested (bundled) — inputs for all four tools in one file, nested under per-tool keys:
ratio_analysis, dcf_valuation, budget_variance, forecast. See assets/sample_financial_data.json for the complete bundled schema; every quick-start command above runs directly against it.
Each script auto-detects the shape (flat keys win if present) and exits non-zero with a clear error if neither shape yields usable data.
Dependencies
None - All scripts use Python standard library only (math, statistics, json, argparse, datetime). No numpy, pandas, or scipy required.
1---2name: "financial-analyst"3description: "Use for financial statement analysis, DCF valuation, budget variance or rolling forecasts. Runs ratio_calculator.py, dcf_valuation.py, budget_variance_analyzer.py and forecast_builder.py."4metadata:5 source: https://skillmd.com/skills/leoyeai-openclaw-master-skills/financial-analyst6---78# Financial Analyst Skill910## Overview1112Production-ready financial analysis toolkit providing ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction. Designed for financial modeling, forecasting & budgeting, management reporting, business performance analysis, and investment analysis.1314## 5-Phase Workflow1516### Phase 1: Scoping17- Define analysis objectives and stakeholder requirements18- Identify data sources and time periods19- Establish materiality thresholds and accuracy targets20- Select appropriate analytical frameworks2122### Phase 2: Data Analysis & Modeling23- Collect and validate financial data (income statement, balance sheet, cash flow)24- **Validate input data completeness** before running ratio calculations (check for missing fields, nulls, or implausible values)25- Calculate financial ratios across 5 categories (profitability, liquidity, leverage, efficiency, valuation)26- Build DCF models with WACC and terminal value calculations; **cross-check DCF outputs against sanity bounds** (e.g., implied multiples vs. comparables)27- Construct budget variance analyses with favorable/unfavorable classification28- Develop driver-based forecasts with scenario modeling2930### Phase 3: Insight Generation31- Interpret ratio trends and benchmark against industry standards32- Identify material variances and root causes33- Assess valuation ranges through sensitivity analysis34- Evaluate forecast scenarios (base/bull/bear) for decision support3536### Phase 4: Reporting37- Generate executive summaries with key findings38- Produce detailed variance reports by department and category39- Deliver DCF valuation reports with sensitivity tables40- Present rolling forecasts with trend analysis4142### Phase 5: Follow-up43- Track forecast accuracy (target: +/-5% revenue, +/-3% expenses)44- Monitor report delivery timeliness (target: 100% on time)45- Update models with actuals as they become available46- Refine assumptions based on variance analysis4748## Tools4950### 1. Ratio Calculator (`scripts/ratio_calculator.py`)5152Calculate and interpret financial ratios from financial statement data.5354**Ratio Categories:**55- **Profitability:** ROE, ROA, Gross Margin, Operating Margin, Net Margin56- **Liquidity:** Current Ratio, Quick Ratio, Cash Ratio57- **Leverage:** Debt-to-Equity, Interest Coverage, DSCR58- **Efficiency:** Asset Turnover, Inventory Turnover, Receivables Turnover, DSO59- **Valuation:** P/E, P/B, P/S, EV/EBITDA, PEG Ratio6061```bash62python scripts/ratio_calculator.py assets/sample_financial_data.json63python scripts/ratio_calculator.py assets/sample_financial_data.json --format json64python scripts/ratio_calculator.py assets/sample_financial_data.json --category profitability65```6667### 2. DCF Valuation (`scripts/dcf_valuation.py`)6869Discounted Cash Flow enterprise and equity valuation with sensitivity analysis.7071**Features:**72- WACC calculation via CAPM73- Revenue and free cash flow projections (5-year default)74- Terminal value via perpetuity growth and exit multiple methods75- Enterprise value and equity value derivation76- Two-way sensitivity analysis (discount rate vs growth rate)7778```bash79python scripts/dcf_valuation.py assets/sample_financial_data.json80python scripts/dcf_valuation.py assets/sample_financial_data.json --format json81python scripts/dcf_valuation.py assets/sample_financial_data.json --projection-years 782```8384### 3. Budget Variance Analyzer (`scripts/budget_variance_analyzer.py`)8586Analyze actual vs budget vs prior year performance with materiality filtering.8788**Features:**89- Dollar and percentage variance calculation90- Materiality threshold filtering (default: 10% or $50K)91- Favorable/unfavorable classification with revenue/expense logic92- Department and category breakdown93- Executive summary generation9495```bash96python scripts/budget_variance_analyzer.py assets/sample_financial_data.json97python scripts/budget_variance_analyzer.py assets/sample_financial_data.json --format json98python scripts/budget_variance_analyzer.py assets/sample_financial_data.json --threshold-pct 5 --threshold-amt 2500099```100101### 4. Forecast Builder (`scripts/forecast_builder.py`)102103Driver-based revenue forecasting with rolling cash flow projection and scenario modeling.104105**Features:**106- Driver-based revenue forecast model107- 13-week rolling cash flow projection108- Scenario modeling (base/bull/bear cases)109- Trend analysis using simple linear regression (standard library)110111```bash112python scripts/forecast_builder.py assets/sample_financial_data.json113python scripts/forecast_builder.py assets/sample_financial_data.json --format json114python scripts/forecast_builder.py assets/sample_financial_data.json --scenarios base,bull,bear115```116117## Knowledge Bases118119| Reference | Purpose |120|-----------|---------|121| `references/financial-ratios-guide.md` | Ratio formulas, interpretation, industry benchmarks |122| `references/valuation-methodology.md` | DCF methodology, WACC, terminal value, comps |123| `references/forecasting-best-practices.md` | Driver-based forecasting, rolling forecasts, accuracy |124| `references/industry-adaptations.md` | Sector-specific metrics and considerations (SaaS, Retail, Manufacturing, Financial Services, Healthcare) |125126## Templates127128| Template | Purpose |129|----------|---------|130| `assets/variance_report_template.md` | Budget variance report template |131| `assets/dcf_analysis_template.md` | DCF valuation analysis template |132| `assets/forecast_report_template.md` | Revenue forecast report template |133134## Key Metrics & Targets135136| Metric | Target |137|--------|--------|138| Forecast accuracy (revenue) | +/-5% |139| Forecast accuracy (expenses) | +/-3% |140| Report delivery | 100% on time |141| Model documentation | Complete for all assumptions |142| Variance explanation | 100% of material variances |143144## Input Data Format145146All scripts accept JSON input files in either of two shapes:1471481. **Flat** — the tool's expected keys at the top level (e.g., `income_statement` / `balance_sheet` for the ratio calculator, `historical` / `assumptions` for DCF, `line_items` for variance, `historical_periods` / `drivers` / `assumptions` / `cash_flow_inputs` for forecasting).1492. **Nested (bundled)** — inputs for all four tools in one file, nested under per-tool keys: `ratio_analysis`, `dcf_valuation`, `budget_variance`, `forecast`. See `assets/sample_financial_data.json` for the complete bundled schema; every quick-start command above runs directly against it.150151Each script auto-detects the shape (flat keys win if present) and exits non-zero with a clear error if neither shape yields usable data.152153## Dependencies154155**None** - All scripts use Python standard library only (`math`, `statistics`, `json`, `argparse`, `datetime`). No numpy, pandas, or scipy required.