Relative Valuation Model
Methodology & Framework
A comprehensive, institutional-grade documentation of the quantitative frameworks, data pipelines, and statistical methodologies that power the Relative Valuation Dashboard. This document is intended for sophisticated investors, analysts, and researchers who require full transparency into model mechanics.
Investment Philosophy & Approach
The Relative Valuation Model is built on a foundational premise: a company's intrinsic worth, while ultimately unknowable with precision, can be meaningfully approximated by studying how the market prices similar businesses. This is not a momentum overlay, a technical signal, or a sentiment gauge. It is a fundamental, bottom-up valuation framework that treats market multiples as the collective judgment of thousands of institutional investors, sell-side analysts, and market participants.
Why Relative Valuation?
Discounted cash flow (DCF) models are theoretically elegant but suffer from acute sensitivity to terminal growth rate and discount rate assumptions โ small changes in these inputs produce vastly different outputs. Relative valuation sidesteps this fragility by asking a different question: given how the market prices comparable businesses, what should this company trade at?
The model combines this relative approach with absolute quality metrics, historical context, and stochastic simulation to produce a blended fair value estimate that is more robust than any single methodology alone.
Core Principles
- Multi-method convergence. No single valuation multiple is authoritative. The model blends 4โ10 methodologies, weighted by data quality and relevance, to reduce single-method bias.
- Quality deserves a premium. A company with 48% ROIC should not trade at the same multiple as a 12% ROIC peer. The model applies a justified quality premium calibrated on historical back-tests.
- Margins revert. Peak earnings create valuation traps. The model detects above-trend margins and applies cyclicality haircuts to prevent overvaluation at cycle peaks.
- Confidence matters. A fair value estimate without a confidence score is a guess. Every output includes a 0โ100 confidence assessment based on data depth, peer fit, and model agreement.
- Transparency over opacity. Every weight, every adjustment, and every assumption is visible to the user. There are no black boxes.
Data Infrastructure & Pipeline
The model operates on a proprietary data pipeline that ingests, normalizes, and validates financial data from multiple institutional-grade sources. Data integrity is the foundation of every valuation output โ no model can compensate for contaminated inputs.
Primary Data Sources
Data Processing Pipeline
- Ingestion: Raw XBRL filings parsed within 24 hours of SEC publication. Market data ingested at end-of-day.
- Normalization: Financial line items mapped to a standardized 180+ metric schema. Handles US-GAAP presentation differences across filers (e.g., "Revenue" vs "Net Revenue" vs "Total Revenue").
- Validation: Automated cross-statement reconciliation (e.g., Net Income on IS = Net Income on CF). Anomaly detection flags outlier values >3ฯ from historical.
- Derived Metrics: 90+ computed ratios (ROIC, FCF yield, Piotroski F-Score, etc.) calculated from normalized fundamentals.
- Screening Engine: Pre-computed screening tables updated daily with current multiples, growth rates, and quality scores for the full US equity universe.
Peer Universe Construction
The quality of a relative valuation is entirely dependent on the quality of the peer comparison set. An inappropriate peer universe renders all subsequent analysis meaningless. The model uses a hierarchical, four-level industry classification system to construct the most relevant peer group for each company.
Four-Level Industry Taxonomy
| Level | Description | Example (Apple) | Typical Count |
|---|---|---|---|
| L1 โ Sector | Broadest classification | Technology | 800โ1,200 |
| L2 โ Industry | Primary peer group (used for multiples) | Technology Hardware | 40โ150 |
| L3 โ Sub-Industry | Refined peer group | Consumer Electronics | 15โ50 |
| L4 โ Peer Cluster | Closest comparables | Mega-Cap Tech (MSFT, GOOGL, META, AMZN) | 8โ20 |
Peer Selection Rules
- Minimum viable peer set: Require โฅ10 companies at L2 level for valid industry median. If fewer, fall back to broader classification.
- Market cap tiering: Mega-cap ($200B+), large-cap ($10Bโ$200B), mid-cap ($2Bโ$10B), small-cap ($300Mโ$2B), micro-cap (<$300M). Cross-tier comparisons apply haircuts.
- Business model filtering: Companies classified as banks, REITs, insurance, utilities, or biotech use specialized multiple sets (P/FFO for REITs, P/TBV for banks).
- Outlier exclusion: Peers with negative earnings or multiples >3ร the industry median are excluded from median calculations but retained for scatter visualization.
Scatter Plot Visualization
The peer comparison scatter plot maps each company's P/E ratio (y-axis) against 5-year EPS CAGR (x-axis). Bubble size represents market capitalization. A regression line (quality curve) shows the expected relationship between growth and valuation, with Rยฒ measuring goodness-of-fit. Companies below the quality curve are potentially undervalued relative to their growth profile.
Multiple Selection & Prioritization
Not all valuation multiples are created equal. A trailing P/E ratio is meaningless for a pre-revenue biotech, and EV/EBITDA is inappropriate for a bank. The model dynamically selects and prioritizes multiples based on the target company's business model, data availability, and sector relevance.
Available Multiples
| Multiple | Tier | Best For | Limitations |
|---|---|---|---|
| P/E Ratio | Primary | Profitable companies, earnings-driven sectors | Distorted by non-recurring items, capital structure |
| EV/EBITDA | Primary | Capital-intensive industries, M&A comps | Ignores capex requirements, working capital |
| P/FCF | Primary | Cash-generative businesses, mature companies | Volatile for high-growth / capex-heavy firms |
| EV/EBIT | Secondary | Operating earnings focus, cross-border comps | Affected by D&A policies |
| P/Sales | Secondary | Pre-profit companies, revenue-stage firms | Ignores profitability entirely |
| EV/Sales | Secondary | Capital structure-neutral revenue comps | Same as P/Sales |
| P/Book | Secondary | Asset-heavy, financial companies | Meaningless for asset-light businesses |
| P/FFO | Primary (REIT) | Real Estate Investment Trusts | N/A for non-REITs |
| P/AFFO | Primary (REIT) | Adjusted funds from operations | Varies by REIT definition |
| P/TBV | Primary (Bank) | Banks, financials | N/A for asset-light companies |
| Dividend Yield | Supplementary | Income-oriented investors, utilities | Misleading for non-dividend payers |
Dynamic Weight Assignment
Weights are assigned algorithmically based on three criteria:
- Tier classification โ Primary multiples receive 2โ4ร the weight of secondary multiples.
- Data availability โ Multiples with <10 peers contributing data receive reduced weight. Multiples with no historical data receive zero weight.
- Business model relevance โ Banks receive zero weight on EV/EBITDA; REITs receive maximum weight on P/FFO and P/AFFO; standard companies receive maximum weight on P/E and EV/EBITDA.
Weights are normalized to sum to 100%. The resulting blend is the raw fair value before quality and cyclicality adjustments.
Fair Value Blend Methodology
Each contributing multiple produces an implied fair value โ the price at which the target company would trade if it were valued at the industry median multiple. The blended fair value is the weighted average of all implied values.
Implied Value Calculation
Implied Price = Industry Median Multiple ร Company's Metric (EPS, FCF/share, etc.)
For enterprise-value multiples (EV/EBITDA, EV/EBIT, EV/Sales):
Implied EV = Industry Median Multiple ร Company's Metric
Implied Price = (Implied EV โ Net Debt + Cash) รท Shares Outstanding
Three-Source Fair Value
Each multiple can produce up to three implied values:
- Industry-implied: Using current industry median multiple.
- Historical-implied: Using the company's own 7-year average multiple.
- Forward-implied: Using consensus forward estimates and forward multiples (where available).
The model prioritizes industry-implied values (most weight) but incorporates historical and forward perspectives to reduce recency bias and consensus herding risk.
Weighted Blend Formula
Adjusted Fair Value = Raw Fair Value ร Quality Adjustment ร Cyclicality Adjustment
Where:
โ Quality Adjustment is a multiplier from the quality framework (Section 6)
โ Cyclicality Adjustment is a haircut from the cyclicality framework (Section 7)
Quality Adjustment Framework
The industry median multiple treats all companies as equal. But a company with vastly superior profitability, faster growth, and a fortress balance sheet deserves a premium. The Quality Adjustment Framework quantifies this justified premium (or discount) based on three fundamental pillars.
Three-Pillar Scoring
Composite Premium Calculation
Justified Premium = Quality Score ร Elasticity Coefficient
Elasticity Coefficient: calibrated at 0.20 for US large-cap (i.e., a perfect quality score of +1.0
justifies a 20% premium to industry median). Capped at ยฑ40% to prevent runaway extremes.
Cyclicality Detection & Adjustment
One of the most dangerous valuation traps is buying a cyclical company at peak earnings. The P/E looks cheap because earnings are temporarily inflated โ when margins normalize, both earnings and the multiple contract simultaneously (the "double whammy"). The model's cyclicality framework detects this risk.
Margin Z-Score
The primary detection mechanism is the Margin Z-Score โ a standardized measure of how far the current net margin deviates from its 7-year historical average.
Interpretation:
โ Z < +0.5ฯ: Normal (no adjustment)
โ Z = +0.5ฯ to +1.0ฯ: Elevated (5%โ10% haircut)
โ Z = +1.0ฯ to +2.0ฯ: High (10%โ15% haircut)
โ Z > +2.0ฯ: Extreme (15%โ20% haircut)
Cycle Position Labels
- Trough: Margins >1ฯ below average. Recovery potential. Multiple expansion likely.
- Expansion: Margins improving but below peak. Normal business conditions.
- Peak: Margins significantly above average. Mean-reversion risk is elevated.
- Contraction: Margins declining from peak. Multiple compression may follow.
Normalized Fair Value
When cyclicality is detected (Z-Score >+1.0ฯ), the model computes a normalized fair value โ what the company would be worth if margins reverted to their 7-year average. This is displayed as the "downside scenario" in the Peak Risk Analysis section.
Monte Carlo Simulation Engine
A single-point fair value estimate creates false precision. The Monte Carlo engine generates a probability distribution of fair values by running 10,000 simulations with randomized inputs, producing percentile-based confidence intervals that acknowledge the inherent uncertainty in valuation.
Simulation Parameters
| Parameter | Distribution | Source |
|---|---|---|
| Industry median multiple | Normal(ฮผ, ฯ) where ฯ = IQR/1.35 | Cross-sectional peer dispersion |
| Quality premium | Uniform(โ5%, +5%) around computed premium | Elasticity uncertainty |
| Margin variation | Normal(current, historical_std) | 7-year margin volatility |
| Growth rate variation | Triangular(bear, base, bull) | Analyst consensus range |
| Multiple weight noise | Dirichlet perturbation (ฮฑ=10) | Weight uncertainty |
Output Percentiles
Conviction Zone Mapping
The current stock price's position within the Monte Carlo distribution determines the conviction zone:
- Strong Buy: Price below P10 (deep value territory โ extremely rare)
- Buy: Price between P10 and P25
- Mild: Price between P25 and P50
- Neutral: Price between P50 and P75
- Sell: Price above P75
Confidence Scoring System
Every fair value estimate should be accompanied by a confidence score. A model that says "fair value is $200, confidence 92" communicates something fundamentally different from "fair value is $200, confidence 38." The confidence score (0โ100) measures the reliability of the model's inputs and internal consistency, not the probability that the stock will reach fair value.
Six-Component Breakdown
| Component | Weight | Measures | Score Range |
|---|---|---|---|
| Data Completeness | 25% | How many multiples have valid data (current + historical + peer) | 0โ100 |
| Peer Quality | 20% | Number of valid peers, dispersion of peer multiples, Rยฒ of regression | 0โ100 |
| Historical Depth | 15% | Years of fundamental data available (7 = max, <3 = penalty) | 0โ100 |
| Earnings Stability | 15% | Coefficient of variation of EPS over 5 years. Stable = high score. | 0โ100 |
| Model Agreement | 15% | Standard deviation of implied values across methodologies. Lower = higher confidence. | 0โ100 |
| Cyclicality Penalty | 10% | Margin Z-Score. Elevated margins reduce confidence. | 0 to โ30 |
Floored at 0, capped at 100.
Signal Strength Composite Score
The Signal Strength Score (0.00โ1.00) is the model's single most actionable output. It synthesizes valuation attractiveness, model reliability, risk factors, and Monte Carlo positioning into one number. This is not a buy/sell recommendation โ it is a quantitative assessment of the current setup's favorability.
Four-Component Weighted Formula
| Component | Weight | Raw Input | Normalization |
|---|---|---|---|
| Margin of Safety (MOS) | 40% | Upside % to fair value | Capped at 1.0 (at +30% upside). Linear below. Zero at 0% upside. |
| Model Confidence | 30% | Confidence score (0โ100) | Divided by 100. Score of 78 โ 0.78. |
| Margin Risk Penalty | 15% | Margin Z-Score | Negative contribution. Z of +1.8 โ โ0.18. Capped at โ0.30. |
| P50 Price Spread | 15% | MC P50 vs current price % | Positive if P50 > price. Capped at ยฑ0.15. |
Signal Labels
- STRONG SIGNAL (โฅ 0.75): Multiple indicators converge favorably. Historically associated with positive 90-day outcomes.
- WATCH (0.55โ0.74): Mixed signals. Some indicators favorable, others neutral or negative. Monitor for improvements.
- NEUTRAL (< 0.55): Insufficient evidence of favorable setup. Model does not identify attractive risk/reward.
Model Action Zones
The Action Zone framework translates the quantitative model output into concrete, price-level-based zones. These zones represent model-derived price thresholds where the risk/reward profile changes meaningfully โ they are not buy/sell targets.
Zone Construction
- Primary Zone: Price at or below which the model calculates โฅ15% margin of safety to blended fair value, AND the price remains above the P10 downside scenario. This is the zone where the model identifies the most favorable risk/reward.
- Cautious Zone: Price range where upside exists (+8% to +15%) but margin of safety is below institutional thresholds. Additional confirming factors (DCF agreement, improving margins) would strengthen the case.
- Current Price Zone: Displays live market price with its risk/reward assessment. If MOS <8%, the model considers the setup unfavorable at current levels.
Threshold Conditions
Beyond price levels, the model tracks four quantitative conditions that must all be satisfied for the model to register a "favorable" signal:
- Price โค Primary Zone: Market price at or below the model's primary threshold.
- Confidence โฅ 75: Sufficient data quality and model agreement.
- Margin Z-Score โค +1.0ฯ: Margins not dangerously elevated.
- P50 Fair Value > Price: Monte Carlo median confirms upside.
Regression-Based Fair Multiples
The industry median approach assumes all companies deserve the same multiple. The quality-adjusted approach applies a blanket premium. The regression approach takes this further: it builds a cross-sectional regression model that predicts a company's "expected" multiple based on its specific fundamental characteristics.
Regression Specification
Regression is run cross-sectionally across the L2 peer universe.
Rยฒ typically ranges from 0.45 to 0.85 depending on sector homogeneity.
If a company's actual multiple is significantly below its regression-predicted multiple, it may be undervalued relative to its fundamental characteristics. The regression provides signals like "Cheap" (trading below expected), "Fair" (near expected), or "Rich" (trading above expected).
Peak Earnings Risk Framework
The Peak Earnings Risk framework is the model's guard against the classic value trap: buying a stock that looks cheap on peak earnings, only to see both earnings and multiple contract. It answers the question: "What if current profitability is unsustainably high?"
Three Outputs
Sensitivity & Scenario Analysis
The sensitivity matrix explores how fair value changes across different combinations of two key drivers:EPS growth rate (rows) and P/E multiple (columns). This reveals the model's sensitivity to its most impactful assumptions.
Matrix Construction
- P/E scenarios: Typically 5 columns spanning from โ4ร to +4ร around the current trailing P/E.
- EPS growth scenarios: 4 rows: Bear Case (50% of base), Conservative (75% of base), Base Case (current consensus), and Bull Case (133% of base).
- Fair value at each cell: Computed as Forward EPS (adjusted for growth scenario) ร P/E scenario.
The center cell (base case growth ร current P/E) represents the status quo. Cells highlighted in green indicate fair values above current price (upside); red cells indicate fair values below current price (downside).
Portfolio Fit Analysis
A stock can be undervalued and still be a poor fit for a specific portfolio. The Portfolio Fit module analyzes how the stock would interact with common portfolio archetypes, providing hypothetical sizing and correlation context.
Outputs
- Suggested Role: Core Compounder, Growth Satellite, Deep Value Recovery, Income Anchor, or Speculative Position โ based on market cap tier, growth profile, dividend characteristics, and quality score.
- Correlation Analysis: 90-day rolling correlation to SPY and QQQ (or sector-specific ETFs). High correlation (0.80+) suggests limited diversification benefit.
- Hypothetical Position Size: Model-suggested allocation range based on market cap, conviction level, and portfolio archetype. Includes maximum allocation threshold.
- Entry Urgency: 1โ5 scale reflecting how time-sensitive the current setup is. Based on signal score trend, approaching catalysts, and proximity to support levels.
Signal History & Track Record
The Signal History table records every model signal generated for a given ticker, along with the subsequent forward returns. This creates an auditable track record that allows users to assess the model's historical accuracy for each specific stock.
What Gets Recorded
- Signal Date: Date the model produced the signal.
- Signal Label: STRONG SIGNAL, WATCH, or NEUTRAL.
- Signal Score: The composite score at the time of signal generation.
- Price at Signal: Stock price when the signal was generated.
- Forward Returns: Actual stock return at 30, 60, 90, 180, and 365 days after the signal.
- Outcome: Whether the signal was followed by a positive or negative return (evaluated at 90 days).
Track Record Metrics
- Win Rate (90d): Percentage of signals that produced positive 90-day forward returns.
- Average Return: Mean 90-day forward return across all signals.
- Total Signals: Number of signals generated for this ticker.
๐ Important Legal Disclaimer
This methodology document and all associated model outputs, fair value estimates, signal scores, action zones, and scenario analyses are provided strictly for educational and informational purposes only. Nothing in this document or on this platform constitutes investment advice, a recommendation, a solicitation, or an offer to buy, sell, or hold any security, financial product, or instrument.
The operator of this platform is not a registered investment advisor (RIA), broker-dealer, financial planner, or fiduciary, and does not provide personalized financial advice under any jurisdiction. All model outputs are the result of automated quantitative computations that rely on historical data, public filings, and third-party estimates. These outputs are inherently uncertain, may contain errors, and are subject to change without notice.
Forward-looking statements involve significant risk and uncertainty. Actual results may differ materially from model projections. Past performance of model signals, back-tests, or simulations is not indicative of future results.
You should consult with a qualified, licensed financial advisor who can assess your individual circumstances, risk tolerance, and financial objectives before making any investment decisions. By using this platform, you acknowledge that you are solely responsible for your own investment decisions and that the platform bears no liability for any financial losses incurred.
ยฉ 2026 VCP Scanner ยท All data sourced from public filings, third-party providers, and quantitative computations ยท Not affiliated with any broker, exchange, or financial institution ยท SEC / FINRA safe harbor: No material contained herein constitutes a recommendation under applicable securities law.
Ready to apply this framework?
Explore the relative valuation dashboard for any US-listed equity.