Skip to content
cccskills
FreePublished on 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.

The English summary is being prepared. Showing the original description.

Run score Not tested

See how to install

Files included (4)

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

SKILL.md (original)

Review the instructions the agent will receive before you install.

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.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

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.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

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

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

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

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

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.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

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.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

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.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

See all skills by Ruinius

Report a problem with this skill