← 返回 Skills 市场
alirezarezvani

financial-analyst

作者 Alireza Rezvani · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
368
总下载
0
收藏
3
当前安装
2
版本数
在 OpenClaw 中安装
/install cs-financial-analyst
功能描述
Performs financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making. Use when analyzi...
使用说明 (SKILL.md)

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

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

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

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

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. See assets/sample_financial_data.json for the complete input schema covering all four tools.

Dependencies

None - All scripts use Python standard library only (math, statistics, json, argparse, datetime). No numpy, pandas, or scipy required.

安全使用建议
This package appears consistent with its stated purpose, but the Python scripts (scripts/*.py) were not included in the provided contents for review — that is the main unknown. Before running this skill on sensitive or production financial data, review the Python sources for these risks: any outbound network calls (requests, urllib, sockets, http clients), arbitrary subprocess execution (subprocess, os.system, eval/exec), file reads outside the working/input files, credential harvesting (os.environ access and transmission), and obfuscated or minified code (base64, exec of decoded strings). If you can't inspect the code, run it in an isolated sandbox/container with no network access and test with synthetic or redacted data. Consider static checks (grep for 'requests', 'socket', 'subprocess', 'eval', 'exec', 'open' with absolute paths) and a quick dynamic monitor (network traffic, file writes) when first executing.
功能分析
Type: OpenClaw Skill Name: cs-financial-analyst Version: 1.0.0 The 'cs-financial-analyst' skill bundle is a legitimate financial analysis toolkit providing tools for DCF valuation, ratio analysis, and budgeting. All Python scripts (e.g., scripts/dcf_valuation.py, scripts/forecast_builder.py) strictly use the Python standard library, contain no network or unauthorized file system access, and lack any form of code obfuscation or malicious logic. The SKILL.md instructions and associated markdown templates are well-structured and focused entirely on the stated financial analysis workflow without any evidence of prompt injection or malicious directives.
能力评估
Purpose & Capability
Name, description, SKILL.md, templates, reference docs, and the four analysis scripts (ratio, DCF, variance, forecast) are coherent and proportional to a financial-analysis skill — nothing in the manifest asks for unrelated credentials, binaries, or system paths.
Instruction Scope
SKILL.md limits runtime actions to running local Python scripts against user-provided JSON files and generating reports/templates. It does instruct validating input data and cross-checking outputs (appropriate). It does not mention contacting external endpoints, but the provided SKILL.md and assets do not include the actual Python source content for inspection, so we cannot verify whether the scripts themselves perform network I/O, write outside expected locations, or read unrelated system files.
Install Mechanism
No install specification — instruction-only skill that relies on local Python. This is low-risk in terms of installation because nothing is downloaded or written during install.
Credentials
No required environment variables, no primary credential, and no config paths are declared. That is appropriate for a local financial-analysis tool that operates on files supplied by the user.
Persistence & Privilege
Skill is not always-enabled and uses normal model invocation. It does not request persistent platform privileges in the registry metadata.
如何使用
  1. 确保已安装 OpenClaw(本地或 Docker 部署)
  2. 在对话框中输入安装命令:/install cs-financial-analyst
  3. 安装完成后,直接呼叫该 Skill 的名称或使用 /cs-financial-analyst 触发
  4. 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
Initial publish (prefixed slug)
v2.1.2
- Enhanced clarity in skill description and detailed the specific analytical areas (ratio analysis, DCF valuation, budget variance, rolling forecast). - Provided a structured 5-phase financial analysis workflow, including scoping, modeling, insight generation, reporting, and follow-up. - Documented available scripts and usage examples for each analysis category with input and output options. - Listed reference guides and report templates for consistent analysis and reporting. - Outlined key metrics and targets for accuracy and timeliness. - Made clear that all scripts run with standard Python libraries (no external dependencies).
元数据
Slug cs-financial-analyst
版本 1.0.0
许可证 MIT-0
累计安装 3
当前安装数 3
历史版本数 2
常见问题

financial-analyst 是什么?

Performs financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making. Use when analyzi... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 368 次。

如何安装 financial-analyst?

在 OpenClaw 或 Claude Code 对话框中运行命令「/install cs-financial-analyst」即可一键安装,无需额外配置。

financial-analyst 是免费的吗?

是的,financial-analyst 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。

financial-analyst 支持哪些平台?

financial-analyst 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。

谁开发了 financial-analyst?

由 Alireza Rezvani(@alirezarezvani)开发并维护,当前版本 v1.0.0。

💬 留言讨论