Back to Details

financial-analyst

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Financial Analyst Skill

财务分析师Skill

Overview

概述

Production-ready financial analysis toolkit providing ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction. Designed for financial analysts with 3-6 years experience performing financial modeling, forecasting & budgeting, management reporting, business performance analysis, and investment analysis.
一款可投入生产的财务分析工具包，提供比率分析、DCF估值、预算差异分析及滚动预测构建功能。专为拥有3-6年财务建模、预测与预算编制、管理报告、业务绩效分析及投资分析经验的财务分析师设计。

5-Phase Workflow

五阶段工作流程

Phase 1: Scoping

阶段1：范围界定

  • 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

阶段2：数据分析与建模

  • Collect and validate financial data (income statement, balance sheet, cash flow)
  • Calculate financial ratios across 5 categories (profitability, liquidity, leverage, efficiency, valuation)
  • Build DCF models with WACC and terminal value calculations
  • Construct budget variance analyses with favorable/unfavorable classification
  • Develop driver-based forecasts with scenario modeling
  • 收集并验证财务数据（利润表、资产负债表、现金流量表）
  • 计算五大类财务比率（盈利能力、流动性、杠杆率、运营效率、估值）
  • 构建包含WACC及终值计算的DCF模型
  • 构建带有有利/不利分类的预算差异分析
  • 开发基于驱动因素的预测模型及场景建模

Phase 3: Insight Generation

阶段3：洞察生成

  • 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

阶段4：报告输出

  • 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
  • 生成包含关键发现的执行摘要
  • 按部门及类别生成详细差异报告
  • 交付带有敏感性表格的DCF估值报告
  • 呈现带有趋势分析的滚动预测

Phase 5: Follow-up

阶段5：后续跟进

  • 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
  • 跟踪预测准确性（目标：收入误差±5%，费用误差±3%）
  • 监控报告交付及时性（目标：100%按时交付）
  • 在实际数据可用时更新模型
  • 根据差异分析优化假设

Tools

工具

1. Ratio Calculator (
scripts/ratio_calculator.py
)

1. 比率计算器（
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
bash
python scripts/ratio_calculator.py sample_financial_data.json
python scripts/ratio_calculator.py sample_financial_data.json --format json
python scripts/ratio_calculator.py sample_financial_data.json --category profitability
根据财务报表数据计算并解读财务比率。
比率类别：
  • 盈利能力： ROE、ROA、毛利率、营业利润率、净利润率
  • 流动性： 流动比率、速动比率、现金比率
  • 杠杆率： 债务权益比、利息保障倍数、DSCR
  • 运营效率： 资产周转率、存货周转率、应收账款周转率、DSO
  • 估值： P/E、P/B、P/S、EV/EBITDA、PEG比率
bash
python scripts/ratio_calculator.py sample_financial_data.json
python scripts/ratio_calculator.py sample_financial_data.json --format json
python scripts/ratio_calculator.py sample_financial_data.json --category profitability

2. DCF Valuation (
scripts/dcf_valuation.py
)

2. DCF估值工具（
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)
bash
python scripts/dcf_valuation.py valuation_data.json
python scripts/dcf_valuation.py valuation_data.json --format json
python scripts/dcf_valuation.py valuation_data.json --projection-years 7
带有敏感性分析的折现现金流（DCF）企业及股权估值工具。
功能：
  • 通过CAPM计算WACC
  • 收入与自由现金流预测（默认5年）
  • 通过永续增长法及退出乘数法计算终值
  • 推导企业价值与股权价值
  • 双向敏感性分析（折现率vs增长率）
bash
python scripts/dcf_valuation.py valuation_data.json
python scripts/dcf_valuation.py valuation_data.json --format json
python scripts/dcf_valuation.py valuation_data.json --projection-years 7

3. Budget Variance Analyzer (
scripts/budget_variance_analyzer.py
)

3. 预算差异分析器（
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
bash
python scripts/budget_variance_analyzer.py budget_data.json
python scripts/budget_variance_analyzer.py budget_data.json --format json
python scripts/budget_variance_analyzer.py budget_data.json --threshold-pct 5 --threshold-amt 25000
分析实际值vs预算值vs上年业绩，并支持重大性过滤。
功能：
  • 计算金额与百分比差异
  • 重大性阈值过滤（默认：10%或5万美元）
  • 根据收入/费用逻辑进行有利/不利分类
  • 按部门及类别细分
  • 生成执行摘要
bash
python scripts/budget_variance_analyzer.py budget_data.json
python scripts/budget_variance_analyzer.py budget_data.json --format json
python scripts/budget_variance_analyzer.py budget_data.json --threshold-pct 5 --threshold-amt 25000

4. Forecast Builder (
scripts/forecast_builder.py
)

4. 预测构建器（
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)
bash
python scripts/forecast_builder.py forecast_data.json
python scripts/forecast_builder.py forecast_data.json --format json
python scripts/forecast_builder.py forecast_data.json --scenarios base,bull,bear
基于驱动因素的收入预测工具，带有滚动现金流预测及场景建模功能。
功能：
  • 基于驱动因素的收入预测模型
  • 13周滚动现金流预测
  • 场景建模（基准/乐观/悲观场景）
  • 使用标准库中的简单线性回归进行趋势分析
bash
python scripts/forecast_builder.py forecast_data.json
python scripts/forecast_builder.py forecast_data.json --format json
python scripts/forecast_builder.py forecast_data.json --scenarios base,bull,bear

Knowledge Bases

知识库

ReferencePurpose
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/financial-ratios-guide.md
比率公式、解读、行业基准
references/valuation-methodology.md
DCF方法论、WACC、终值、可比公司分析
references/forecasting-best-practices.md
基于驱动因素的预测、滚动预测、准确性

Templates

模板

TemplatePurpose
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
模板用途
assets/variance_report_template.md
预算差异报告模板
assets/dcf_analysis_template.md
DCF估值分析模板
assets/forecast_report_template.md
收入预测报告模板

Industry Adaptations

行业适配

SaaS

SaaS

  • Key metrics: MRR, ARR, CAC, LTV, Churn Rate, Net Revenue Retention
  • Revenue recognition: subscription-based, deferred revenue tracking
  • Unit economics: CAC payback period, LTV/CAC ratio
  • Cohort analysis for retention and expansion revenue
  • 关键指标：MRR、ARR、CAC、LTV、客户流失率、净收入留存率
  • 收入确认：基于订阅、递延收入跟踪
  • 单位经济效益：CAC回收期、LTV/CAC比率
  • 用于留存及扩展收入的群组分析

Retail

零售

  • Key metrics: Same-store sales, Revenue per square foot, Inventory turnover
  • Seasonal adjustment factors in forecasting
  • Gross margin analysis by product category
  • Working capital cycle optimization
  • 关键指标：同店销售额、每平方英尺收入、存货周转率
  • 预测中的季节性调整因素
  • 按产品类别分析毛利率
  • 营运资金周期优化

Manufacturing

制造业

  • Key metrics: Gross margin by product line, Capacity utilization, COGS breakdown
  • Bill of materials cost analysis
  • Absorption vs variable costing impact
  • Capital expenditure planning and ROI
  • 关键指标：按产品线划分的毛利率、产能利用率、COGS细分
  • 物料清单成本分析
  • 吸收成本法vs变动成本法的影响
  • 资本支出规划与ROI

Financial Services

金融服务

  • Key metrics: Net Interest Margin, Efficiency Ratio, ROA, Tier 1 Capital
  • Regulatory capital requirements
  • Credit loss provisioning and reserves
  • Fee income analysis and diversification
  • 关键指标：净息差、效率比率、ROA、一级资本充足率
  • 监管资本要求
  • 信贷损失拨备与准备金
  • 手续费收入分析与多元化

Healthcare

医疗保健

  • Key metrics: Revenue per patient, Payer mix, Days in A/R, Operating margin
  • Reimbursement rate analysis by payer
  • Case mix index impact on revenue
  • Compliance cost allocation
  • 关键指标：每位患者收入、付款人结构、应收账款周转天数、营业利润率
  • 按付款人划分的报销率分析
  • 病例组合指数对收入的影响
  • 合规成本分配

Key Metrics & Targets

关键指标与目标

MetricTarget
Forecast accuracy (revenue)+/-5%
Forecast accuracy (expenses)+/-3%
Report delivery100% on time
Model documentationComplete for all assumptions
Variance explanation100% of material variances
指标目标
预测准确性（收入）±5%
预测准确性（费用）±3%
报告交付100%按时
模型文档所有假设均有完整文档
差异解释100%重大差异均有解释

Input Data Format

输入数据格式

All scripts accept JSON input files. See 
assets/sample_financial_data.json
for the complete input schema covering all four tools.
所有脚本均接受JSON输入文件。完整输入架构请参考
assets/sample_financial_data.json
，适用于所有四款工具。

Dependencies

依赖项

None - All scripts use Python standard library only (
math
, 
statistics
, 
json
, 
argparse
, 
datetime
). No numpy, pandas, or scipy required.
无 - 所有脚本仅使用Python标准库（
math
、
statistics
、
json
、
argparse
、
datetime
）。无需numpy、pandas或scipy。