跳到正文
cccskills
免费在 GitHub 公开

Financial Modeling

Execute a single deterministic Python script to compute WACC, DCF assumptions, projected free cash flows, enterprise value, and intrinsic value per share. Updates the metadata markdown.

中文简介正在准备中。当前显示原文说明。

实测评分 未实测

查看安装方法

包含的文件(4)

  • SKILL.md2.5 KB
  • examples/FISV_example.md6.0 KB
  • examples/PYPL_example.md1.5 KB
  • scripts/calculate.py17.3 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Financial Modeling (Phase 6)

All modeling logic is consolidated into a single script that executes the complete sequence: WACC → Assumptions → DCF → Intrinsic Value.

  1. Execute the script: python skills/financial_modeling/scripts/calculate.py {TICKER} {TICKER_metadata_path}
  2. Verify it threw no errors.

What the Script Does

StepActionDetails
1Fetch Market DataCalls tools/market_data.py profile {TICKER} for share price, beta, market cap
2Read Historical DataParses Financial History table from metadata for L4Q averages
3Read Qualitative DataParses Economic Moat, Margin Outlook, Growth Outlook from metadata
4Calculate WACCCAPM with Blume-adjusted beta, capital structure weights
5Generate AssumptionsThree-stage DCF assumptions blending historical trends + qualitative outlook
6Run DCF Projections10-year projections with interpolated growth/margin, terminal value via Gordon Growth
7Compute Intrinsic ValueEquity bridge: EV + Cash - Debt → Per Share
7bFX & ADR ConversionIf reporting currency != USD, convert IVPS to USD. Apply ADR ratio to share count if applicable
8Update MetadataReplaces WACC, Assumptions, DCF Model, and Intrinsic Value sections in markdown

Prerequisites

  • output_data/TICKER/TICKER_metadata.md must exist with Financial History and Qualitative Assessment sections
  • Internet access required for Yahoo Finance market data lookup
  • Python 3.10+ with yfinance installed

Key Parameters

ParameterSourceDefault
Risk-Free RateHardcoded (TODO: fetch 10Y Treasury)4.20%
Equity Risk PremiumHardcoded5.00%
Terminal GrowthMoat rating: Wide=4%, Narrow=3%, None=2.5%3.00%
MCTDerived from IC, default if negative IC100.0x
Tax Rate (statutory)Hardcoded for WACC25%
Tax Rate (NOPAT)L4Q average adjusted tax rateVaries
WACC BoundsFloor 6%, Cap 15%—
FX Ratemarket_data.py if Currency != USD1.0
ADR RatioParsed from metadata header1.0

Changelog

  • 2026-05-06: Fixed crash when Yahoo Finance returns null for beta. Added explicit checks for share_price, market_cap, and shares_outstanding.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Classify financial PDFs by extracting company identity, document type, and date metadata. Validates ticker via Yahoo Finance with multi-step fallback. Uses a Python orchestration script for validation, file modification, and writing markdown.

中文简介正在准备中。当前显示原文说明。

Ruinius/financial-analyst-skills52026年6月9日 更新

Execute a single deterministic Python script to harmonize units, create/update metadata, move files to output_data/, and clean up input_data/.

中文简介正在准备中。当前显示原文说明。

Ruinius/financial-analyst-skills52026年6月9日 更新

Execute a single deterministic Python script to compute all derived financial metrics (EBITA, Invested Capital, Tax Rates, Summary Table) from extracted financial data.

中文简介正在准备中。当前显示原文说明。

Ruinius/financial-analyst-skills52026年6月9日 更新

Extract balance sheet, income statement, shares outstanding, organic growth, and GAAP reconciliation data from financial PDFs. Standardize via Tiger-Transformer and append structured output to the document markdown.

中文简介正在准备中。当前显示原文说明。

Ruinius/financial-analyst-skills52026年6月9日 更新

Extracts the WACC, assumptions, and DCF projections from the markdown metadata file and converts them into a clean, structured JSON file for the frontend interactive viewer.

中文简介正在准备中。当前显示原文说明。

Ruinius/financial-analyst-skills52026年6月9日 更新

Assess a company's economic moat, EBITA margin trajectory, and organic growth trajectory from analyst reports, earnings transcripts, or long-form articles. Produces structured qualitative outlook that feeds into the Financial Modeling skill's assumption generation.

中文简介正在准备中。当前显示原文说明。

Ruinius/financial-analyst-skills52026年6月9日 更新

查看 Ruinius 的全部技能

报告此技能的问题