joellewis/finance_skills

equities

Analyze equity securities, factor models, and equity portfolio construction.

Zobacz źródło
Oryginalny dokument Skill

Treść z repozytorium z zachowaniem nagłówków, przykładów, kodu, tabel, linków i obrazów.

Equities

This skill is a decision procedure: which valuation metric to use for which company, which index methodology fits which mandate, and the order of operations for analyzing a stock. It assumes the user can look up definitions; the value here is choosing the right tool.

Core Concepts

Choosing the Valuation Metric

Match the metric to the sector and capital structure — using the wrong one is the most common equity-analysis error.

SituationUseAvoidWhy
Financials (banks, insurers)P/B, P/TBV, ROE vs P/BEV/EBITDADebt is raw material, not financing — EV and EBITDA are meaningless; book value is marked closer to fair value
Capital-intensive (industrials, telecom, energy)EV/EBITDA, EV/EBITP/E aloneNeutralizes depreciation policy and leverage differences across peers
Mature dividend payers (utilities, staples)Dividend yield + payout sustainability, P/EPEGGrowth is low and stable; income and coverage matter most
High-growth, low/no earningsEV/Sales, PEG (if earnings exist), unit economicsP/E, P/BEarnings are depressed by reinvestment; book value is mostly intangibles
Cyclicals (autos, semis, materials)Mid-cycle or normalized P/E, P/B at troughSpot P/EP/E is lowest at the cycle peak and highest at the trough — spot P/E inverts the buy/sell signal
Negative earnings, positive cash flowEV/EBITDA, P/FCFP/E, earnings yieldRatio is undefined or misleading with negative denominator
REITs and listed real estateP/FFO, P/AFFO, NAVP/EGAAP depreciation distorts earnings for property — handled in detail by the real-assets skill
Cross-border / different leverageEV-based multiplesEquity multiplesEnterprise value normalizes for capital structure

Cross-checks that apply everywhere:

  • Use forward (next-12-month) estimates for the numerator decision when the business is changing; trailing figures when estimate quality is poor.
  • Compare against the company's own history and a true peer set, not the whole market.
  • Translate any multiple into its implied assumptions (growth, margin, required return) before declaring cheap/expensive — a low multiple usually encodes a real problem.

Choosing the Index Methodology

MandateMethodologyTrade-off to flag
Cheap, tax-efficient market exposureCap-weighted (S&P 500, total market)Momentum-chasing by construction; concentration in mega-caps — a single sector can exceed 30%
Reduce concentration / small-cap tiltEqual-weightedHigher turnover and rebalancing cost; structural size and contrarian tilt
Break the price-weight linkFundamental-weighted (revenue, earnings, book)Effectively a value tilt with extra steps; compare cost vs an explicit value fund
Explicit factor exposureFactor/style index (value, momentum, quality, low vol)Verify the factor definition and rebalance rules; factor timing rarely works
AvoidPrice-weighted (DJIA-style)Weight proportional to share price is economically arbitrary — legacy only

Selection rules: default to cap-weighted for core beta; add equal- or fundamental-weighted only when the user explicitly wants the embedded tilt and accepts the turnover; treat any "smart beta" product as a factor portfolio and evaluate its factor loadings, not its marketing name.

Security Analysis Sequence

  1. Classify the business — sector (GICS or equivalent), cyclical vs defensive, capital intensity, leverage. This determines the valuation toolkit (table above).
  2. Quality screen — revenue trend, margin trend, ROIC vs cost of capital, balance-sheet risk (net debt/EBITDA, interest coverage), share count trajectory (dilution vs buybacks).
  3. Earnings basis — pick trailing vs forward EPS, check for one-offs, use diluted share count. For cyclicals, normalize to mid-cycle.
  4. Value with the matched metric — primary multiple from the table, one cross-check multiple, and where dividends are central a dividend-based check (Gordon growth: P = D1 / (r - g), valid only when g < r).
  5. Factor and style context — regress (or eyeball) exposures to market beta, size, value, momentum, quality. Distinguish stock-specific thesis from a factor bet you could buy more cheaply via an index.
  6. Portfolio fit — marginal effect on sector concentration and factor tilts; total return (price + dividends) is the comparison basis, never price return alone.

Key Formulas

FormulaExpressionUse Case
EV/EBITDA(Market Cap + Debt - Cash) / EBITDACapital-structure-neutral valuation
Earnings YieldEPS / PriceCompare equity vs bond yields
PEG(P/E) / Earnings Growth Rate (in %)Growth-adjusted valuation
Gordon GrowthP = D1 / (r - g)Dividend-based intrinsic value
CAPME(R) = Rf + beta × (E(Rm) - R_f)Required return input for valuation
Total ReturnPrice Return + Dividend ReturnPerformance comparison basis

Worked Examples

Metric Selection and Valuation

Given: An industrial company with market cap $500M, total debt $100M, cash $50M, EBITDA $75M, EPS $7.50, price $150. Decide and calculate:

  1. Capital-intensive industrial → primary metric is EV/EBITDA (table above), with P/E as cross-check.
  2. EV = $500M + $100M - $50M = $550M. EV/EBITDA = $550M / $75M = 7.33x.
  3. Cross-check: P/E = $150 / $7.50 = 20.0x; earnings yield = 7.50 / 150 = 5.0%.
  4. Interpretation: 7.33x EV/EBITDA is modest for an industrial if margins are stable — compare against the peer set and the company's own 5-10 year range. The 20x P/E looks richer than the EV multiple because the company carries little net debt; the EV multiple is the better cross-peer comparison.

Common Pitfalls

  • Applying EV/EBITDA to banks or P/E to REITs — metric/sector mismatch is the dominant error this skill exists to prevent
  • Buying cyclicals on low trailing P/E at the cycle peak (the "value trap" inversion)
  • Treating a fundamental-weighted or smart-beta index as alpha rather than a packaged factor tilt
  • Confusing price return with total return — dividends compound to a large share of long-run equity returns
  • Survivorship bias in backtested factor or screen results

Cross-References

  • historical-risk (wealth-management plugin): volatility and drawdown measurement for equity return series
  • statistics-fundamentals (core plugin): beta estimation via CAPM regression
  • performance-metrics (wealth-management plugin): Sharpe ratio and related risk-adjusted return measures
  • fund-vehicles (wealth-management plugin): equity fund selection (ETFs, mutual funds, SMAs)
  • currencies-and-fx (wealth-management plugin): international equity currency effects
  • asset-allocation (wealth-management plugin): equity allocation within multi-asset portfolios
  • real-assets (wealth-management plugin): REIT valuation (P/FFO, NAV) is owned by that skill
  • qualitative-valuation (wealth-management plugin) and quantitative-valuation (wealth-management plugin): deeper single-company valuation workflows
  • financial-statements (wealth-management plugin): EBITDA, free cash flow, ROIC, and margin analysis underpinning fundamental stock selection
  • equity-compensation (wealth-management plugin): employer stock acquired through RSUs, options, and ESPPs carries equity risk plus tax and insider-trading constraints
  • factor-investing (wealth-management plugin): the factor-loading evaluation of smart-beta and style products prescribed above lives in that skill

Running the Script

bash
uv run scripts/equities.py            # run the demo (uses PEP 723 inline deps)
uv run scripts/equities.py --verify   # check demo outputs against the worked example (exit 1 on mismatch)
python3 scripts/equities.py            # alternative (requires: pip install numpy)

The demo prints valuation metrics (including the worked example's EV/EBITDA and earnings yield), a factor regression on synthetic data, and sector concentration analysis. Run --help for a list of the classes and functions. For programmatic use, import the module rather than running it — the demo only executes under python equities.py.

z tego samego repozytorium

Więcej Skills

Wszystkie Skills
joellewis
Społeczność

investment-policy

Construct comprehensive Investment Policy Statements governing return objectives, risk tolerance, and portfolio constraints. Use when the user asks about building an IPS, setting return objectives, assessing risk tolerance, defining investment constraints, or establishing rebalancing and benchmark policies. Also trigger when users mention 'investment plan', 'policy portfolio', 'risk capacity vs willingness', 'spending rate for an endowment', 'foundation payout', 'manager selection criteria', or ask how to document their investment strategy.

instalacje
1
GitHub Stars
184
Aktualizacja
18 lip
joellewis
Społeczność

account-maintenance

Process account maintenance requests across the account lifecycle. Use when changing a client address or contact info with identity verification, updating beneficiary designations after marriage, divorce, birth, or death, re-registering or re-titling an account to a trust or new entity, selecting tax lot methods or fixing cost basis records, applying legal or compliance holds or Reg T freezes, setting up systematic withdrawals or standing instructions, processing a death notification and estate account setup, handling a QDRO, power of attorney, or guardianship, closing accounts and managing escheatment, or designing data quality review programs.

instalacje
1
GitHub Stars
179
Aktualizacja
18 lip
joellewis
Społeczność

account-transfers

Process and manage account transfers between and within financial institutions. Use when handling full or partial ACAT transfers between broker-dealers, troubleshooting ACAT rejection codes or FINRA Rule 11870 timelines, setting up non-ACAT transfers (Fund/SERV, DTC free delivery, physical certificates), processing internal journal entries, handling retirement rollovers or Roth conversions with proper tax reporting, transferring cost basis under IRC Section 6045A, moving decedent assets to beneficiaries with date-of-death step-up, or reconciling residual credits and fractional shares after transfer completion.

instalacje
1
GitHub Stars
179
Aktualizacja
18 lip
joellewis
Społeczność

bet-sizing

Determine how much capital to allocate to individual positions within a portfolio. Use when the user asks about position sizing, the Kelly criterion, fractional Kelly, risk budgeting, or conviction weighting. Also trigger when users mention 'how much to put in one stock', 'maximum position size', 'how concentrated should my portfolio be', 'number of holdings', 'VaR budget per position', 'how big a bet', or ask about scaling position sizes with volatility.

instalacje
1
GitHub Stars
179
Aktualizacja
18 lip