company-valuation

Featured

Estimate the intrinsic value of a public company using DCF, relative (peer multiple) and sum-of-parts (SOTP) methods, then triangulate to an implied share price with upside/downside versus the current market price. Use this skill whenever the user asks: "what is AAPL worth", "valuation of NVDA", "fair value of TSLA", "intrinsic value", "DCF for MSFT", "build a DCF", "discounted cash flow", "WACC", "terminal value", "implied share price", "upside to fair value", "is X overvalued/undervalued", "relative valuation", "peer comparison valuation", "EV/EBITDA target", "SOTP", "sum of the parts", "how much is [company] worth", "price target from fundamentals", "value this company", or any ticker in the context of computing intrinsic or relative valuation. Default to running ALL three methods (DCF + relative + SOTP-if-applicable) and presenting a blended implied price with a sensitivity table. Do not answer valuation questions from memory — always run the workflow.

AI & Automation 3,309 stars 377 forks Updated 2 weeks ago MIT

Install

View on GitHub

Quality Score: 88/100

Stars 20%
100
Recency 20%
90
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
80
License 10%
100
Description 5%
100

Skill Content

# Company Valuation Triangulates intrinsic value via three methods, then blends them to an implied share price: 1. **DCF** — 5-year FCFF projection, discount at WACC, terminal value. 2. **Relative** — apply peer median P/E, EV/Revenue, EV/EBITDA. 3. **SOTP** — when 2+ distinct reporting segments exist, value each at pure-play peer multiples. Always present a WACC × terminal-growth sensitivity table and Bull/Base/Bear scenarios. **Disclaimer**: Research/educational output. Not financial advice. --- ## Step 1: Detection Flow Detect data source and runtime deps. The skill supports 2 method paths — pick the richest one available. **Environment status:** ``` !`python3 -c "exec('try:\n import yfinance, numpy, pandas\n print(\'YFIN_OK\')\nexcept Exception:\n print(\'YFIN_MISSING\')')"` ``` ``` !`python3 -c "exec('try:\n import yfinance as yf\n t=yf.Ticker(\'^TNX\')\n p=t.fast_info.last_price\n print(f\'RF_10Y={p/100:.4f}\')\nexcept Exception:\n print(\'RF_FETCH_FAIL\')')"` ``` **Decision tree:** | Condition | Method path | |---|---| | `YFIN_OK` | **Path A** (primary): yfinance for financials + peer multiples | | `YFIN_MISSING` | **Path B**: pip-install yfinance, then Path A. `python3 -m pip install -q yfinance numpy pandas` | | `RF_FETCH_FAIL` | Use default `rf = 0.045` and note stale risk-free rate in output | If `RF_10Y=` printed, use that value as `rf` in Step 4d instead of the hardcoded 4.5%. --- ## Step 2: Choose Methods & Set Defaults ### Method applicability ...

Details

Author
himself65
Repository
himself65/finance-skills
Created
6 months ago
Last Updated
2 weeks ago
Language
JavaScript
License
MIT

Similar Skills

Semantically similar based on skill content — not just same category