
financial-analyst
Skill帮财务人员做报表比率分析、DCF 估值、预算差异分析和滚动预测,自带比率计算、估值和预算差异分析的 Python 脚本,数字可以复算。需本机装有 Python,并把财报数据整理成 JSON 输入;结果需专业人员复核。
name: "financial-analyst"
description: "Analyze financial statements, value a company with a DCF, explain budget variance, build rolling forecasts. Use whenever the user asks what a business is worth or why spend missed budget."
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_sheetfor the ratio calculator,historical/assumptionsfor DCF,line_itemsfor variance,historical_periods/drivers/assumptions/cash_flow_inputsfor forecasting). - Nested (bundled) — inputs for all four tools in one file, nested under per-tool keys:
ratio_analysis,dcf_valuation,budget_variance,forecast. Seeassets/sample_financial_data.jsonfor 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.
相關資源

dcf-model
Skill在 Excel 里搭建 DCF 现金流折现估值模型:从 SEC 文件与研报取数,预测自由现金流,计算 WACC 与终值并生成敏感性分析表;推导值一律写成公式,输入值附来源批注,每一步先与用户确认。属于 Anthropic 官方 financial-analysis 插件。
anthropics/financial-services41.4k
Equity Research Skill
Skill撰写个股深度研报和财报点评:九章覆盖业务、竞争、治理、盈利质量与估值,用脚本复算 DCF、EPV 等估值,关键数字注明来源,默认输出 PDF,支持美股、港股与 A 股。需 agent 能联网并能运行 Python(本机或 agent 自带环境);结果需专业人员复核。
rollingSirius/equity-research-skill478
Claude for Financial Services
SkillAnthropic 官方金融服务技能库,覆盖投行、股票研究、私募、基金行政与财富管理,包括可比公司分析、DCF、LBO、三表模型、CIM、财报点评、投委会备忘录与总账对账等。产出供专业人员复核,配套数据连接器可能需要订阅或 API Key。
anthropics/financial-services41.4k
financial-modeling
Skill根据两三年历史财报和增长率、毛利率等假设,搭建利润表、资产负债表、现金流量表三表联动的预测模型,含基准、乐观、悲观三种情景,适合做预算和融资测算。纯提示词技能,无需账号,默认输出 Markdown 表格;结果需财务人员复核。
claude-office-skills/skills581
Private Equity
PluginAnthropic 官方私募股权插件,覆盖项目寻源与 CRM 查重、创始人触达、CIM 快速筛选、尽调清单、IRR/MOIC 回报测算、投委会备忘录和投后组合监控。
anthropics/financial-services41.4k
Claude for Financial Services
PluginAnthropic 官方金融服务插件市场:打包估值建模(DCF、LBO、可比公司)、投行材料、卖方研究、私募与基金运营的技能、命令和代理,另带 FactSet、Morningstar 等数据连接器,连接器可能需要各厂商的订阅或 API Key。
anthropics/financial-services41.4k