DCF Intrinsic Value Model
Methodology & Framework
A comprehensive, institutional-grade documentation of the Discounted Cash Flow engine that computes intrinsic fair value for 700+ eligible US equities. This document covers every computational step โ from eligibility screening and cash flow selection to terminal value estimation, scenario analysis, and output validation.
Philosophy & Design Principles
The DCF Intrinsic Value Model is built on a foundational belief: fair value is the present value of all future free cash flows a business will generate for its shareholders. This is the most theoretically grounded approach to equity valuation, rooted in decades of academic finance and practiced by institutional investors worldwide.
However, DCF is only as good as its inputs. Small changes in growth or discount rate assumptions can swing output by 50% or more. Our model addresses this through conservative guardrails, scenario analysis, and radical transparency โ every assumption is visible, adjustable, and documented.
Core Design Principles
- DCF is for structural cash generators: The model is deliberately restricted to companies with demonstrated, recurring free cash flow. Cyclical, pre-revenue, and speculative businesses are excluded โ not because they lack value, but because DCF provides false precision for them.
- Exclusion is a feature, not a bug: Showing "N/A" for companies where DCF is inappropriate is intellectually honest. Alternative valuation lenses (relative multiples, EV/EBITDA bands) are provided for excluded stocks.
- Honest framing over false confidence: The model avoids language like "conservative estimate" or "market is wrong." Instead, outputs are presented as "DCF at X% growth suggests Y" โ letting users draw their own conclusions.
- Sanity bounds prevent mathematical nonsense: Uncapped DCF models routinely produce "9,000% upside" for a stock trading at $50. Hard caps on growth, upside, and IV/Price ratios keep outputs actionable.
- Reinvestor awareness: High-growth companies that reinvest heavily (suppressing current FCF) receive normalized cash flow treatment to reflect long-term earnings power.
Eligibility Gates
Not every stock belongs in a DCF model. The eligibility framework ensures that only companies with the financial characteristics suited to discounted cash flow analysis receive a valuation. Every gate exists for a specific mathematical or financial reason.
Required Criteria
A stock must pass all of the following gates to receive a DCF valuation:
| Gate | Threshold | Rationale |
|---|---|---|
| Market Capitalization | โฅ $1 Billion | Excludes micro-caps, shell companies, and penny stocks where financial data is unreliable or illiquid |
| Annual Revenue | โฅ $1 Billion | Ensures a real operating business with sufficient scale for meaningful cash flow projection |
| Operating Margin | > 8% | Confirms the business has an economic moat โ commodity-like margins produce unreliable DCF outputs. Financial-sector companies (banks, insurance, REITs) are exempted from this gate as their margin structures differ fundamentally |
| Sector Exclusion | NOT Energy, Basic Materials | Cyclical sectors are valued on mid-cycle earnings and EV/EBITDA bands, not DCF (see Section 10) |
| Industry Exclusion | NOT Marine Shipping | Highly cyclical sub-industry with volatile charter rates |
| Free Cash Flow | FCF > 0 (or reinvestor) | DCF requires positive cash generation โ reinvestor detection handles suppressed FCF cases (see Section 3) |
Why Exclude Cyclicals?
DCF assumes stable, predictable cash flows that grow at a modelable rate. Cyclical businesses fundamentally violate this assumption:
- Margins mean-revert to long-term averages โ current high margins are peak-cycle, not sustainable
- Terminal value calculations become unreliable when base-year FCF is at a cyclical peak
- Minor assumption changes swing intrinsic value by 5โ10ร because the starting cash flow is unstable
- Commodity price dependency makes forward cash flow fundamentally unpredictable via extrapolation
Coverage Statistics
As of February 2026, the eligibility gates produce the following coverage:
Cash Flow Selection & Reinvestor Detection
The starting cash flow figure is the most critical input to any DCF model. It must accurately represent the company's sustainable cash generation capability โ not a cyclically inflated or temporarily suppressed number.
Company-Type-Specific Cash Flow
Different business models generate cash through fundamentally different mechanisms. The model selects the most appropriate cash flow metric for each company type:
| Company Type | Cash Flow Metric | Rationale |
|---|---|---|
| Industrial / Technology / Healthcare | Free Cash Flow (FCF) | Standard FCF = Operating Cash Flow โ Capital Expenditures. The purest measure of distributable cash for non-financial companies |
| Banks & Insurance | Net Income | FCF is not meaningful for financial institutions โ capital is their raw material, not an expense. Net income better captures earnings power |
| REITs | Funds From Operations (FFO) | FFO adjusts net income for depreciation of real estate assets (non-cash charge), providing a truer picture of recurring cash flow. Falls back to net income if FFO is unavailable |
| Utilities | Free Cash Flow (FCF) | Regulated utilities have relatively predictable capex, making FCF appropriate |
The Reinvestor Problem
Some of the world's most valuable companies โ Amazon, Nvidia, Meta โ reinvest so heavily that their reported FCF dramatically understates long-term earnings power. Using actual FCF for these companies produces absurdly low intrinsic values, which would be misleading.
Reinvestor Detection Criteria
A company is flagged as a "reinvestor" when all of the following are true:
| Criterion | Threshold | What It Detects |
|---|---|---|
| Revenue Growth (5Y CAGR) | > 15% | Company is in a high-growth phase where reinvestment is expected |
| FCF Margin (TTM) | < 5% | Current free cash flow is suppressed relative to revenue |
| Gross Margin (TTM) | > 30% | Strong underlying economic engine exists โ low FCF is a choice, not a structural limitation |
| Company Type | NOT bank/insurance/REIT/utility | Financial-sector companies have different cash flow dynamics and should not use normalization |
Normalized FCF Formula
When a company is flagged as a reinvestor, the model substitutes actual FCF with a normalized figure:
The 8% target margin represents a reasonable long-term FCF margin for mature technology and consumer companies. This normalization is only applied when the normalized figure exceeds actual FCF โ the model never artificially deflates cash flow.
Growth Rate Methodology
The growth rate determines how fast projected cash flows increase over the 5-year explicit forecast period. Getting this right โ or at least keeping it reasonable โ is essential for meaningful output.
Multi-Metric Growth Selection
Rather than relying on a single growth metric, the model evaluates multiple growth dimensions and selects the highest, subject to caps. This "best of" approach captures the strongest signal of the company's expansion trajectory:
- Revenue Growth: 5-year CAGR โ 3-year CAGR โ TTM (cascade from longest available)
- EPS Growth: 5-year CAGR โ 3-year CAGR โ TTM
- Cash Flow Growth: FCF growth for industrials, Net Income growth for banks/insurance, FFO growth for REITs
- Floor: Minimum 8% growth rate applied universally โ prevents value collapse for stable but slow-growing businesses
Size-Adjusted Growth Caps
Uncapped growth rates are the primary source of absurd DCF outputs. A $2 trillion company growing at 30% would double the size of most national economies within a decade. The model applies hard growth caps based on company size:
| Market Cap Tier | Maximum Growth Rate | Rationale |
|---|---|---|
| Mega-cap (>$500B) | 12% | Law of large numbers โ base effect makes high growth rates mathematically improbable at this scale |
| Large-cap ($100Bโ$500B) | 15% | Scaling constraints begin to bind; competitive markets limit sustainable above-average growth |
| All Others (<$100B) | 20% | Hard cap prevents terminal value explosion while allowing for legitimate high-growth phases |
Where: size_cap โ {12%, 15%, 20%} based on market cap tier
Discount Rate (WACC) Estimation
The Weighted Average Cost of Capital (WACC) determines the rate at which future cash flows are discounted to present value. A higher WACC reflects greater risk and produces lower intrinsic values.
CAPM-Based Estimation
WACC is derived from the Capital Asset Pricing Model (CAPM) with size-specific adjustments:
Where: Risk-Free Rate โ 4.5% (10-Year Treasury yield), ERP โ 4.5โ5.5% (size-dependent)
Beta (ฮฒ) is sourced from publicly available market data and measures the stock's sensitivity to broad market movements. A beta of 1.0 means the stock moves in line with the market; above 1.0 implies higher volatility.
Step 1 โ Blume Beta Mean-Reversion Adjustment
Raw beta estimates from price regression are noisy and systematically biased away from 1.0 due to measurement error. Before plugging beta into CAPM, the model applies the Blume (1971) mean-reversion adjustment โ the same formula used by Bloomberg, Damodaran, and FactSet:
In practice this matters most for outlier stocks: a high-beta stock at ฮฒ=2.0 becomes ฮฒ=1.67 after adjustment โ 33bp lower WACC than raw CAPM would produce. A defensive stock at ฮฒ=0.50 becomes ฮฒ=0.67 โ preventing unrealistically low discount rates for utilities and consumer staples. At ฮฒ=1.0 (market), there is no change.
Raw beta is clamped before Blume to reject data-corrupt outliers: Technology companies are capped at ฮฒ=1.75 (betas above this almost always reflect short-term price dislocations, not structural risk); all other sectors are capped at ฮฒ=2.25. Blume is then applied to the clamped value.
Step 2 โ Size Premium
Smaller companies carry a higher equity risk premium due to liquidity constraints, less institutional coverage, and weaker access to capital markets. The model adds a size premium on top of CAPM:
| Market Cap | Size Premium Added | Example Companies |
|---|---|---|
| โฅ $100B (mega/large) | 0% | AAPL, MSFT, JNJ, PG โ institutional coverage, deep liquidity, investment-grade capital access |
| $10B โ $100B | +0.75% | EW, CGNX, POST, SNA โ still well-covered but meaningfully smaller risk profile |
| < $10B (small/mid) | +1.50% | NWLI, SWX, ACLS โ thinner float, less analyst coverage, higher refinancing risk |
Step 3 โ WACC Clamp by Company Quality Tier
After CAPM + Blume + size premium, the resulting discount rate is clamped based on company type and a quality tier check. This prevents data-quality extremes (a biotech with one year of price history and raw ฮฒ=2.8 getting a 19% WACC) while keeping rates in the range institutional analysts actually use. The tiers are calibrated to observed implied discount rates for each category, not just theoretically derived values:
| Tier | WACC Floor | WACC Ceiling | Rationale |
|---|---|---|---|
| Utility (rate-regulated) | 6.5% | 11% | Explicit ROE approval from regulators, predictable rate base growth, bond-like cash flows. Natural market-implied WACC clusters 6.5โ8.5% for investment-grade utilities. |
| REIT | 7.5% | 13% | Equity-only CAPM for REITs (no debt blending). Real-asset backing and mandatory dividend payouts reduce distress risk relative to pure equity. |
| Consumer Defensive | 7.5% | 14% | KO, PEP, PG, WMT, COST exhibit pricing power, inelastic demand, and recession-resistant volumes. Their CAPM rates cluster near 7% โ an 8.5% floor would systematically suppress DCF values below any major analyst model. |
| Platform Quality (see ยง11) | 7.5% | 14% | AAPL, MSFT, GOOGL, META, NFLX. Damodaran (2026) implied ERP analysis shows these trade at 6.5โ7.5% implied discount rates โ demonstrably below the 8.5% standard floor. See Section 11 for full criteria. |
| General (all others) | 8.5% | 16% | Industrials, healthcare, consumer discretionary, most tech/communications. Low reported beta in these sectors frequently reflects measurement noise (short price history, thin float) rather than genuine low business risk. |
Complete Walkthrough โ Apple (AAPL, April 2026)
Walking each step for a real company shows how the components combine:
- Risk-free rate: 4.5% (10Y Treasury yield)
- Beta (raw): 1.20 โ clamped at 1.75 Tech ceiling (no change) โ Blume: (2/3 ร 1.20) + (1/3 ร 1.0) = 1.133
- Equity risk premium: 5.0% (standard for $100B+ liquid companies)
- Size premium: 0% (market cap โซ $100B)
- Raw cost of equity: 4.5% + (1.133 ร 5.0%) = 10.17%
- Platform Quality adjustment: โ0.75% (qualifies: Tech sector, ~$3T MCap, ~27% FCF margin โ see ยง11)
- Adjusted cost of equity: 9.42%
- After debt blending: WACC โ 8.3% (minimal net debt, near-equity structure)
- Clamp check (Platform Quality tier, 7.5โ14%): 8.3% is within range โ no adjustment
Without the Platform Quality adjustment, AAPL's WACC would be 9.2% โ above the 8.5% floor but close enough that the entire difference flows through to intrinsic value. The 90bp gap produces a ~$36 difference in the base case per-share value (~$152 vs ~$188).
DCF Calculation Engine
The core engine uses a two-stage DCF model: a 5-year explicit forecast period followed by a terminal value that captures all cash flows beyond year 5 in perpetuity.
Stage 1: Explicit Forecast Period (Years 1โ5)
Free cash flow is projected forward for 5 years using the selected growth rate, then each year's projected FCF is discounted back to present value:
Where g is the capped growth rate from Section 4 and WACC is the discount rate from Section 5. Each year's cash flow grows at the same rate โ the model does not apply growth fade during the explicit period (this is handled by the growth caps which already reflect sustainable rates).
Stage 2: Terminal Value (Gordon Growth Model)
Beyond year 5, the model assumes the company grows in perpetuity at a fixed terminal growth rate. This is computed using the Gordon Growth Model:
Terminal growth is not a single fixed number. It varies by company size and type, reflecting the economic reality that a $10B mid-cap has more structural room to outgrow GDP than a $2 trillion company that is already larger than most national economies:
| Company Type / Size | Terminal Growth Base | Rationale |
|---|---|---|
| Utility (rate-regulated) | 2.0% | Customer base and rate base expansion are constrained by geography and regulatory approval. Growth at roughly CPI is the sustainable ceiling for a regulated monopoly. |
| REIT | 2.25% | Long-run NOI growth tracks inflation + population density trends. Physical real estate supply limits volume growth; pricing power provides the remainder. |
| Mega-cap >$500B (non-Platform Quality) | 2.25% | Law of large numbers โ compounding 0.5% above US nominal GDP in perpetuity at $500B+ scale is already an aggressive long-run claim. Anything above 2.5% implies eventually dominating the global economy. |
| Mega-cap >$500B (Platform Quality โ see ยง11) | 2.75% | AAPL, MSFT, GOOGL have high-growth platform/services revenue streams that sustain above-GDP compound rates even as legacy hardware or core search matures. Apple Services grew ~13% YoY in FY2025 while hardware was flat; the blended terminal trajectory is materially above 2.25%. |
| Large-cap $50Bโ$500B | 2.5% | Established businesses with demonstrated scale but still operationally nimble enough to sustain modest above-GDP growth through pricing, geographic expansion, or adjacent market penetration. |
| Small / mid-cap <$50B | 2.75% | Mid-sized businesses at scale inflection points have more accessible white-space. The slightly higher base reflects realistic organic reinvestment returns, not an optimism bias. |
Sector-level fine-tuning is applied on top of these base rates โ Consumer Defensive industries receive a small downward adjustment (their volumes are inelastic, not growth-oriented); high-growth tech-adjacent verticals receive a small upward push. The final terminal growth rate is clamped hard at 1.5%โ3.5%, so no company can be modeled growing faster than the long-run ceiling for US nominal GDP in perpetuity.
The terminal value is then discounted back to present value:
Enterprise Value โ Equity Value โ Intrinsic Value
The final intrinsic value per share follows the standard corporate finance waterfall:
Equity Value = max(Enterprise Value โ Net Debt, 0)
Intrinsic Value Per Share = Equity Value / Shares Outstanding
Net debt is defined as total debt minus cash and cash equivalents. For companies with net cash positions (cash exceeds debt), net debt is negative, which increases equity value above enterprise value. Share counts are sourced from the most recent publicly filed quarterly report.
Scenario Analysis: Bear / Base / Bull
Point estimates create false precision. A single intrinsic value number implies a level of certainty that does not exist in financial modeling. To address this, the model produces three scenarios that bracket the most likely range of outcomes.
Scenarios are built by applying absolute percentage-point shifts to the base case inputs โ not percentage-of-base haircuts. This matters because a 20% haircut on a 5% growth rate is only 1pp, whereas a 20% haircut on a 15% growth rate is 3pp. Absolute shifts ensure the spread between bear and bull is driven by the magnitude of uncertainty, not by the starting level of the base case.
| Parameter | Bear Shift | Base (no shift) | Bull Shift |
|---|---|---|---|
| Revenue growth rate | โ2.0 pp | Historical CAGR (size-capped) | +1.5 pp |
| Operating / FCF margin | โ2.0 pp | TTM margin | +1.5 pp |
| CapEx ratio (% revenue) | +0.4 pp | Historical average | โ0.3 pp |
| NWC ratio (% revenue) | +0.4 pp | Historical average | โ0.2 pp |
| Discount rate (WACC) | +1.5 pp | CAPM-derived (clamped) | โ1.0 pp |
| Terminal growth rate | โ0.5 pp | Size / type-based | +0.3 pp |
Why Asymmetric Shifts?
Bear shifts are intentionally larger than bull shifts. This reflects how downside risk actually materializes in practice:
- Bear WACC +1.5pp vs Bull โ1.0pp: Risk deterioration (credit stress, rising rates, execution failure) tends to be sudden and non-linear. Damodaran's implied ERP data shows equity risk premiums spike 200โ400bp during market crises while compression rarely exceeds 100โ150bp during recoveries.
- Bear margin โ2pp vs Bull +1.5pp: Margin compression happens fast โ cost inflation, competitive undercutting, and pricing power erosion are the most common FCF failure modes for high-margin businesses. Margin expansion is slower and requires demonstrated operating leverage, not just optimism.
- Terminal shift cap +0.3pp: Terminal growth of 3%+ already stretches credibility for most businesses. Allowing a large bull shift on terminal growth would make the model mechanically sensitive to a perpetuity assumption rather than to actual near-term cash flow โ the opposite of what investors should be weighing.
Concrete Example โ Microsoft (MSFT, Base WACC 8.0%)
With base growth of 12% (mega-cap cap applied) and base margin at TTM levels:
- Bear: 10% growth, 9.5% WACC, margin โ2pp โ per-share value ~$285
- Base: 12% growth, 8.0% WACC, base margin โ per-share value ~$380
- Bull: 13.5% growth, 7.0% WACC, margin +1.5pp โ per-share value ~$510
The $285โ$510 range is wide enough to acknowledge genuine uncertainty but narrow enough to be actionable. A model that shows a $50โ$5,000 range for a stock trading at $400 is not providing analysis โ it is providing noise.
Sanity Bounds & Output Validation
Even with growth caps and WACC bounds, certain edge-case combinations can produce mathematically correct but financially meaningless outputs. The model applies a final layer of sanity checks before publishing any intrinsic value.
Output Bounds
| Bound | Constraint | Purpose |
|---|---|---|
| IV / Price Ratio | 0.1ร to 10ร | Intrinsic value must be between 10% and 1,000% of current price โ anything outside is speculation, not valuation |
| Bull IV / Price | Max 15ร | Even the most optimistic scenario should not exceed 15ร current price |
| Bear IV | Must be > 0 | A negative bear case indicates the model's assumptions are incompatible with the company's capital structure |
| Upside Percentage | Capped at ยฑ300% | Displayed upside/downside is clamped to ยฑ300% to prevent misleading extreme figures |
Valuation Status Classification
Based on the relationship between base case intrinsic value and market price:
Company Type Handling
Different business models require different valuation inputs. A bank's "free cash flow" is fundamentally different from a technology company's. The model adapts its inputs based on the company's classification:
| Company Type | Cash Flow Metric | Growth Metric | Operating Margin Gate |
|---|---|---|---|
| Industrial / Technology | Free Cash Flow | FCF growth (5Y โ 3Y โ 1Y cascade) | Required: >8% |
| Banks | Net Income | Net Income growth (5Y โ 3Y) | Exempted |
| Insurance | Net Income | Net Income growth (5Y โ 3Y) | Exempted |
| REITs | FFO (fallback: Net Income) | FFO growth โ Net Income growth | Exempted |
| Utilities | Free Cash Flow | FCF growth (5Y โ 3Y โ 1Y cascade) | Required: >8% |
Owner Earnings Model (SBC-Heavy Software)
For SaaS and software infrastructure companies, a standard FCFF model systematically overstates intrinsic value. The root cause is stock-based compensation (SBC) โ a real economic cost to shareholders that GAAP accounting allows companies to add back into operating cash flow, creating a large structural gap between reported FCF and true distributable earnings.
The SBC Gap Problem in Detail
Consider ServiceNow (NOW) in FY2025: operating margin was roughly 14%, but reported FCF margin was ~28% โ a 14 percentage-point gap driven almost entirely by ~$1.5B of SBC being added back in the cash flow statement. If a DCF model uses the 28% FCF margin as its base, it implicitly treats SBC as free โ as if the company is generating 28 cents of distributable cash per dollar of revenue. In reality, those shares are diluting existing shareholders every year. The true owner earning power is closer to the 14% operating margin, not the 28% FCF margin.
Datadog (DDOG), Zscaler (ZS), and Snowflake (SNOW) exhibit the same pattern: FCF margins of 20โ30% sitting 15โ20pp above GAAP operating margins. Using raw FCF for these companies would produce intrinsic values 40โ80% higher than the economically correct number.
Routing Criteria
A company is routed to the Owner Earnings model when all of the following are observed in its trailing-twelve-month financials:
| Criterion | Threshold | Purpose |
|---|---|---|
| Industry | Software โ Application or Software โ Infrastructure | These are the industries with structural SBC dynamics. Other industries with occasional SBC (biotech, consumer tech) are not automatically routed. |
| FCF margin โ Operating margin gap | > 15 percentage points | The gap is detected dynamically from actual TTM data, not assumed from the industry label. A software company that has matured past the high-SBC phase and now shows aligned FCF and operating margins continues to receive standard FCFF treatment. |
Owner Earnings Calculation
Rather than using either FCF or net income, the model uses operating income (EBIT) as the economic base โ which already deducts SBC as a compensation expense โ then applies the standard DCF adjustments:
This is identical to FCFF except that EBIT (post-SBC) replaces NOPAT derived from reported cash flows. The effect is to charge SBC as a real cost rather than adding it back. D&A is added back because it is a non-cash charge that does not reduce the company's economic earning power; CapEx and working capital changes are deducted because they represent real capital consumption.
Platform Quality Adjustment
Standard CAPM systematically overstates the cost of equity for a narrow category of exceptional businesses: durable-moat, platform-scale companies where near-zero bankruptcy risk, deep ecosystem lock-in, and highly predictable recurring cash flows make the beta-implied risk premium economically inaccurate.
The Problem With Beta for Mega-Cap Platforms
AAPL, MSFT, and GOOGL each have a reported beta close to 1.0 โ implying they are "average risk". But this conflates price correlation with the index with fundamental business risk. These stocks move with the market not because their businesses are risky, but because they arethe market โ they constitute 15โ25% of the S&P 500 by weight. Their actual business risk (probability of cash flow impairment, margin collapse, or default) is orders of magnitude lower than a typical beta-1.0 industrial company.
Damodaran's (2026) implied equity risk premium analysis shows AAPL and MSFT trade at implied discount rates of 6.5โ7.5% โ well below the 8.5% floor the CAPM model would assign without adjustment. The market, in aggregate, has been pricing these companies as if their WACC is 7โ8%, not 8.5โ10%. A model that ignores this produces bull cases below the current market price โ which is methodologically incoherent.
Qualifying Criteria
Platform quality adjustment is applied when all three conditions are met simultaneously:
| Criterion | Threshold | Purpose |
|---|---|---|
| Sector | Technology or Communication Services | Targets platform, software, and internet businesses. Excludes industrials, healthcare, financials, and consumer sectors where moat durability is harder to establish. |
| Market Cap | โฅ $200 Billion | Only mega-cap platforms with demonstrated, multi-decade market dominance qualify. Prevents the adjustment applying to high-growth mid-caps with volatile FCF and unproven moats. |
| FCF Margin (TTM) | โฅ 18% | Durable cash generation is the economic justification for the quality premium. Businesses printing 18%+ FCF margins have demonstrated pricing power and capital efficiency that go beyond what beta captures. This threshold excludes capital-intensive tech (data centers, telecom), hardware commodity plays, and cyclical semiconductors. |
Qualifying Companies (April 2026)
The three-way criteria identify approximately 10 companies across the active DCF universe: Apple (AAPL), Microsoft (MSFT), Alphabet (GOOGL), Meta Platforms (META), Netflix (NFLX), Cisco (CSCO), and a small number of other large-cap platform businesses. Notably excluded:
- NVDA / AMD / AVGO (Semiconductors): Already excluded from DCF entirely by the cyclical industry gate โ chip-cycle margins are not suitable for terminal value extrapolation. No overlap with PQ adjustment.
- AMZN (Consumer Cyclical / Specialty Retail): AWS's platform value is missed because Amazon is classified at the parent company level, not broken out. This is a known limitation documented in Section 13.
- TSLA (Consumer Cyclical): FCF margin below 18% threshold and classified outside Technology sector. Not eligible.
Three Changes Applied to Qualifying Companies
| Parameter | Standard Model | Platform Quality | Effect |
|---|---|---|---|
| Cost of equity | CAPM output | CAPM โ 0.75% | โ75bp applied to the equity component before debt blending in WACC. Reflects the demonstrated market-implied equity cost for these names. |
| WACC floor | 8.5% | 7.5% | Allows the computed WACC to reach the 7โ8% range where these companies actually trade on an implied basis. The 8.5% floor was calibrated for general industrials and would systematically floor platform valuations above fair levels. |
| Terminal growth (mega-cap >$500B) | 2.25% | 2.75% | +0.5pp reflects the Services/platform revenue streams that sustain above-GDP growth even as legacy segments mature. Apple Services (12โ14% YoY), Google Cloud (28% YoY), Azure (30%+ YoY) provide durable compound drivers that a commodity-industrial would not have. |
Before & After โ Apple (AAPL, April 2026)
With AAPL trading at approximately $195 at the time of calibration:
| Scenario | Without Platform Quality | With Platform Quality | Change |
|---|---|---|---|
| Bear | ~$130 | ~$162 | +$32 (+25%) |
| Base | ~$152 | ~$188 | +$36 (+24%) |
| Bull | ~$217 | ~$288 | +$71 (+33%) |
Before the adjustment, the bull case was $217 โ below the current market price of ~$195. That result is methodologically incoherent: if even the optimistic scenario sits below market price, it means the market is pricing in assumptions more aggressive than the model's bull case, which would imply the stock is universally overvalued under any reasonable WACC assumption. That conclusion conflicts with how the world's most sophisticated institutional buyers โ who collectively own trillions of dollars of AAPL โ are actually pricing the asset. The platform quality adjustment corrects the source: the discount rate assumptions, not the growth assumptions, were too conservative for this tier of business.
Sensitivity Matrix (5ร5 Grid)
The three-scenario analysis (bear/base/bull) provides a useful range but obscures the continuous relationship between assumptions and value. The sensitivity matrix makes the model's behavior fully transparent: it shows intrinsic value across a full grid of WACC and terminal growth combinations, so users can immediately see which assumption drives value the most and whether the investment thesis holds under stress.
Grid Construction
The matrix is a 5ร5 grid โ 5 discount rate scenarios ร 5 terminal growth scenarios โ centered on the base case. Shifts are applied symmetrically:
| Axis | Shifts Applied | Example (AAPL base WACC = 8.3%, base TG = 2.75%) |
|---|---|---|
| Discount rate (rows, 5 levels) | โ2%, โ1%, 0%, +1%, +2% | 6.3% / 7.3% / 8.3% / 9.3% / 10.3% |
| Terminal growth (columns, 5 levels) | โ1.0%, โ0.5%, 0%, +0.5%, +1.0% | 1.75% / 2.25% / 2.75% / 3.25% / 3.75% |
Each of the 25 cells contains a full intrinsic value recalculation using that specific WACC and terminal growth combination, with base-case revenue growth and margin projections held constant. This isolates the discount rate / terminal growth interaction โ the two parameters that drive the largest share of valuation spread in practice, and the two where honest uncertainty is highest.
How to Read the Matrix
Every cell is colour-coded relative to the current market price:
- Green (Upside): DCF value exceeds market price by more than 5% โ this combination of WACC and terminal growth supports the investment case
- Blue (Fair): DCF value is within ยฑ5% of market price โ fairly valued under this assumption combination
- Red (Premium): Market price exceeds DCF value by more than 5% โ the market is pricing in assumptions more optimistic than this cell
The center cell (0% shift on both axes) always equals the base case intrinsic value. Reading across a row reveals terminal growth sensitivity at a fixed WACC. Reading down a column reveals WACC sensitivity at a fixed terminal growth. Reading the diagonal from top-right to bottom-left (highest terminal growth + lowest WACC to lowest terminal growth + highest WACC) captures the full valuation range โ from most optimistic to most pessimistic.
A thesis is robust when most of the upper half of the grid (lower WACC scenarios) is green โ meaning the stock is cheap even at average cost-of-capital assumptions. A thesis is fragile when only the most optimistic corner (top-right: minimum WACC, maximum terminal growth) produces an upside case โ meaning investors need everything to go right simultaneously on both discount rate and terminal value for the investment to work.
Technical Implementation
The matrix is computed in the Python DCF engine and stored as a JSONB blob in the dcf_snapshots.sensitivity_json table column. The frontend reads grid dimensions (rowCount and colCount) directly from the data array lengths โ there is no hardcoded grid size in the frontend. The center-cell index is computed as Math.floor(rowCount / 2), ensuring the base case always stays centred regardless of future grid dimension changes. Upgrading from 5ร5 to 7ร7 requires only a backend change to the shift arrays; the UI adapts automatically.
Known Limitations & Exclusions
Intellectual honesty demands acknowledging where the model falls short. These limitations are structural โ they arise from the inherent nature of DCF modeling, not from implementation gaps.
1. Cyclical Businesses
Energy, basic materials, and marine shipping companies are excluded because DCF assumes stable, projectable cash flows. Cyclical businesses should be valued on mid-cycle earnings using EV/EBITDA bands and commodity cycle analysis. Our Relative Valuation model provides peer-based multiples for these sectors.
2. Narrative-Driven Stocks
Companies like Tesla, where valuation is heavily driven by narrative and future optionality (autonomous driving, energy, robotics), produce unreliable DCF outputs because minor assumption changes swing value by 5โ10ร. Showing "N/A" is the correct behavior โ it signals that DCF is not the right tool, not that the stock has no value.
3. Pre-Revenue and Early-Stage Companies
Companies with less than $1 billion in revenue are excluded. These businesses are typically valued using revenue multiples, TAM analysis, or venture-style frameworks that are outside the scope of a DCF model.
4. M&A-Driven Transformations
The model extrapolates from historical financial data and cannot predict the cash flow impact of a major acquisition or divestiture. Post-M&A financials will flow through the model on the next update cycle, but there may be a lag of 1โ2 quarters before the full impact is captured.
5. Macro Regime Shifts
The model does not directly incorporate macroeconomic variables (interest rates, GDP growth, inflation). A sharp rise in rates would increase WACC for all companies, but the model relies on the risk-free rate embedded in the CAPM formula rather than forward rate expectations. The scenario analysis partially hedges this limitation.
6. Currency Effects
For ADRs and companies reporting in non-USD currencies, financial figures are converted to USD using current exchange rates. This introduces currency risk that the model does not explicitly price โ a weakening foreign currency could reduce USD-denominated fair value independent of business fundamentals.
Data Sources & Refresh Cadence
The integrity of any quantitative model depends on the quality and timeliness of its inputs. All data used in the DCF model is derived from publicly available sources and regulatory filings.
Data Sources
| Data Category | Source | Coverage |
|---|---|---|
| Financial Statements | SEC EDGAR (XBRL filings), standardized and normalized across reporting formats | 10+ years of annual data, 5+ years of quarterly data |
| Market Data | Publicly available exchange feeds via institutional-grade data providers | Daily OHLCV, market capitalization, shares outstanding |
| Beta | Computed from historical price returns against the S&P 500 benchmark | Trailing period, updated with each price refresh |
| Company Classification | Proprietary L1โL4 industry taxonomy built from SIC/NAICS codes and SEC filings | 5,800+ US-listed equities |
Refresh Cadence
- Daily: Market prices, shares outstanding, and net debt are updated after market close. Intrinsic values are recomputed daily for the full eligible universe (~80 seconds runtime).
- Quarterly: Financial statement data is updated as SEC filings (10-Q, 10-K) become available โ typically within 2โ4 weeks of the reporting date.
- Continuous: The front-end caches intrinsic values for 4 hours (ISR) to balance data freshness with infrastructure efficiency.
Model Versioning & Updates
The DCF model is versioned and updated on a defined cadence. Each version increment documents what changed and why, ensuring full audit trail transparency.
| Version | Date | Changes |
|---|---|---|
| v1.0 | Dec 2025 | Initial DCF model. Standard two-stage DCF with Gordon Growth terminal value. Fixed WACC estimation. No reinvestor detection. Basic eligibility gates (market cap, revenue). |
| v2.0 | Feb 2026 | Reinvestor-aware FCF normalization (Revenue ร 8%). Size-adjusted growth caps (12%/15%/20%). Size-adjusted WACC bounds. Company-type-specific cash flow selection (FCF, Net Income, FFO). Bear/Base/Bull scenario analysis. Sanity bounds on IV/Price ratios. Cyclical sector exclusions. ADR currency conversion. |
| v3.0 | Apr 2026 | 5ร5 sensitivity matrix (expanded from 3ร3; frontend auto-sizes from data arrays โ no UI code change needed). Owner Earnings routing for SBC-heavy software (Software โ Application, Software โ Infrastructure) when FCF-to-operating-margin gap exceeds 15pp โ corrects systematic overvaluation of NOW, WDAY, DDOG, ZS, SNOW. Platform Quality Adjustment for durable-moat mega-cap platforms (Technology/CommSvcs, โฅ$200B MCap, โฅ18% FCF margin): โ75bp to cost of equity, WACC floor 8.5% โ 7.5%, mega-cap terminal growth 2.25% โ 2.75%. Calibrated against Damodaran (2026) implied ERP analysis showing AAPL/MSFT/GOOGL trade at 6.5โ7.5% implied discount rates. Blume beta adjustment (2/3 ร ฮฒ_raw + 1/3 ร 1.0) documented and confirmed live. Variable terminal growth by company size and quality (2.0%โ2.75% base, 1.5%โ3.5% hard clamp). Absolute pp scenario shifts replacing previous percentage-of-base haircuts for cleaner spread behaviour across growth regimes. |
Planned Enhancements
- v3.1 (Planned): Amazon (AMZN) model-family override โ current classification as Consumer Cyclical / Specialty Retail causes the FCFF model to miss AWS cloud value entirely. A segment-weighted approach (cloud DCF + retail EV/EBITDA) would produce materially better results.
- v3.2 (Planned): Stale-cache detection for share counts โ the current sanity check compares float-shares against income-statement shares from the same cached file. If both are stale and consistently stale (pre-split), the ratio โ 1.0 and the check passes silently. A freshness check against the FMP
lastUpdatedfield would catch these cases before they enter the DCF pipeline. - v4.0 (Research): Specialized bank and insurance models โ Excess Return Model for banks (using ROAE vs cost of equity spread), NAV-based approach for REITs to complement the current FFO proxy. Multi-stage DCF with explicit growth fade (high โ stable โ terminal) for companies in strategic transition.
๐ Important Legal Disclaimer
This methodology document and all associated model outputs, intrinsic value estimates, scenario analyses, and valuation classifications 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, publicly available regulatory filings, and standardized financial data. These outputs are inherently uncertain, may contain errors, and are subject to change without notice.
Intrinsic value estimates are not price targets. They represent the mathematical output of a DCF model under specific assumptions. Actual market prices reflect factors beyond any DCF โ including sentiment, liquidity, macro conditions, and information asymmetry. The model may produce values that differ significantly from market prices; this does not mean the market is "wrong."
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 SEC EDGAR (XBRL), publicly available exchange feeds, and standardized financial databases ยท 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 explore intrinsic values?
View DCF fair value estimates for any eligible US-listed equity.