company-valuation

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

Company type	DCF	Relative	SOTP	Fallback
Mature cash-flow (CPG, telecom, utilities)	✅ primary	✅	❌	—
High-growth SaaS / software	✅ with care	✅ primary	❌	Use EV/Revenue + Rule of 40
Multi-segment conglomerate	✅	✅	✅ primary	See references/sotp.md
Banks / insurance	❌	✅ (P/B, P/TBV)	❌	DDM or excess return; note in output
Pre-revenue	❌	EV/Revenue only	❌	Flag low confidence
REITs	❌	✅ (P/FFO, P/AFFO)	❌	NAV-based
Cyclicals (energy, semis, industrials)	✅ on mid-cycle	✅	sometimes	Normalize through-cycle

Defaults table

Settle every parameter before pulling data — these defaults apply unless the user overrides them.