本文へ移動
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(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

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.

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

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 のスキルをすべて見る

このスキルの問題を報告する