๐Ÿ“– Research Document ยท DCF Model v3.0

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.

Model Version 3.0ยทLast Updated: April 21, 2026ยท~11,000 Wordsยท15 Sections
1

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.
๐Ÿ’ก Why Not Just Use Multiples?Multiples (P/E, EV/EBITDA) tell you what the market is paying relative to peers โ€” they are a consensus thermometer. DCF tells you what the business is worth based on its own cash flow trajectory. Both are valuable, and our platform provides both: DCF for absolute valuation, Relative Valuation for peer-based anchoring. The best analysis uses both lenses.

2

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:

GateThresholdRationale
Market Capitalizationโ‰ฅ $1 BillionExcludes micro-caps, shell companies, and penny stocks where financial data is unreliable or illiquid
Annual Revenueโ‰ฅ $1 BillionEnsures 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 ExclusionNOT Energy, Basic MaterialsCyclical sectors are valued on mid-cycle earnings and EV/EBITDA bands, not DCF (see Section 10)
Industry ExclusionNOT Marine ShippingHighly cyclical sub-industry with volatile charter rates
Free Cash FlowFCF > 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
๐Ÿ“Š How Should Cyclicals Be Valued?For Energy, Basic Materials, and Marine Shipping โ€” the correct approaches are EV/EBITDA bands (using mid-cycle earnings), replacement cost analysis, and commodity cycle positioning. Our Relative Valuation model handles these using peer-based multiples, which are less sensitive to cyclical distortion.

Coverage Statistics

As of February 2026, the eligibility gates produce the following coverage:

TOTAL UNIVERSE
~5,800
US-listed equities in the database
DCF ELIGIBLE
~727
Pass all eligibility gates and receive bear/base/bull valuations
EXCLUDED
~5,073
Cyclicals, small-caps, negative FCF, low-margin โ€” shown as N/A with alternative valuation guidance

3

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 TypeCash Flow MetricRationale
Industrial / Technology / HealthcareFree Cash Flow (FCF)Standard FCF = Operating Cash Flow โˆ’ Capital Expenditures. The purest measure of distributable cash for non-financial companies
Banks & InsuranceNet IncomeFCF is not meaningful for financial institutions โ€” capital is their raw material, not an expense. Net income better captures earnings power
REITsFunds 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
UtilitiesFree 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:

CriterionThresholdWhat 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 TypeNOT bank/insurance/REIT/utilityFinancial-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:

Normalized FCF = Revenue (TTM) ร— 8% Target Margin

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.

โš ๏ธ Normalization TransparencyWhen FCF normalization is applied, the dashboard clearly flags this with a "Normalized FCF" indicator. Users can see both the actual FCF margin and the 8% normalized figure. This ensures the valuation reflects long-term earnings power while maintaining full transparency about the adjustment.

4

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 TierMaximum Growth RateRationale
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
Growth Rate = min(max(best_of(rev_CAGR, eps_CAGR, fcf_CAGR), 0.08), size_cap)
Where: size_cap โˆˆ {12%, 15%, 20%} based on market cap tier
๐Ÿ’ก Why an 8% Floor?An 8% minimum growth rate prevents the model from producing collapsed valuations for mature, stable businesses that have temporarily flat growth (e.g., a consumer staples company in a normalization year). The floor reflects the long-run nominal GDP growth rate plus inflation โ€” a reasonable baseline for any business that has passed all eligibility gates.

5

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:

WACC = Risk-Free Rate + ฮฒ ร— Equity Risk Premium
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:

ฮฒ_adjusted = (2/3) ร— ฮฒ_raw + (1/3) ร— 1.0

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 CapSize Premium AddedExample 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:

TierWACC FloorWACC CeilingRationale
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.
REIT7.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 Defensive7.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).


6

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:

PV of Explicit Period = ฮฃ (FCF ร— (1 + g)โฟ / (1 + WACC)โฟ) for n = 1 to 5

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 Value = FCFโ‚… ร— (1 + g_terminal) / (WACC โˆ’ g_terminal)

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 / SizeTerminal Growth BaseRationale
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.
REIT2.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โ€“$500B2.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 <$50B2.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:

PV of Terminal = Terminal Value / (1 + WACC)โต

Enterprise Value โ†’ Equity Value โ†’ Intrinsic Value

The final intrinsic value per share follows the standard corporate finance waterfall:

Enterprise Value = PV of Explicit Period + PV of Terminal Value
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.


7

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.

ParameterBear ShiftBase (no shift)Bull Shift
Revenue growth rateโˆ’2.0 ppHistorical CAGR (size-capped)+1.5 pp
Operating / FCF marginโˆ’2.0 ppTTM margin+1.5 pp
CapEx ratio (% revenue)+0.4 ppHistorical averageโˆ’0.3 pp
NWC ratio (% revenue)+0.4 ppHistorical averageโˆ’0.2 pp
Discount rate (WACC)+1.5 ppCAPM-derived (clamped)โˆ’1.0 pp
Terminal growth rateโˆ’0.5 ppSize / 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.

๐Ÿ“Š How to Use ScenariosThe bear case is a stress-test floor โ€” if the stock trades below the bear case intrinsic value, even pessimistic FCF assumptions support a higher price. The bull case is a maximum achievable ceiling under favorable conditions. The base case is the central estimate. Stocks that clear the bear case by a wide margin and sit near or below the base case are typically the highest-conviction setups in the eligible universe.

8

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

BoundConstraintPurpose
IV / Price Ratio0.1ร— to 10ร—Intrinsic value must be between 10% and 1,000% of current price โ€” anything outside is speculation, not valuation
Bull IV / PriceMax 15ร—Even the most optimistic scenario should not exceed 15ร— current price
Bear IVMust be > 0A negative bear case indicates the model's assumptions are incompatible with the company's capital structure
Upside PercentageCapped 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:

UNDERVALUED
>15% upside
Base case intrinsic value exceeds current price by more than 15%. The 15% threshold provides a margin of safety buffer.
FAIRLY VALUED
ยฑ15%
Price is within 15% of base case intrinsic value in either direction. The market is pricing in assumptions broadly consistent with the DCF.
OVERVALUED
>15% downside
Current price exceeds base case intrinsic value by more than 15%. The market may be pricing in growth rates or margin expansion beyond historical precedent.

9

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 TypeCash Flow MetricGrowth MetricOperating Margin Gate
Industrial / TechnologyFree Cash FlowFCF growth (5Y โ†’ 3Y โ†’ 1Y cascade)Required: >8%
BanksNet IncomeNet Income growth (5Y โ†’ 3Y)Exempted
InsuranceNet IncomeNet Income growth (5Y โ†’ 3Y)Exempted
REITsFFO (fallback: Net Income)FFO growth โ†’ Net Income growthExempted
UtilitiesFree Cash FlowFCF growth (5Y โ†’ 3Y โ†’ 1Y cascade)Required: >8%
๐Ÿ’ก Why Different Cash Flow Metrics?For a bank, capital deployed is a raw material โ€” it generates Net Interest Income. Measuring"Free Cash Flow" for a bank is like measuring "Free Flour" for a bakery: technically possible but misses the point. Net Income is the appropriate bottom-line for financial institutions. For REITs, depreciation of real property is a non-cash charge that understates true recurring income โ€” FFO (Funds From Operations) adds it back for a more accurate picture.

10

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:

CriterionThresholdPurpose
IndustrySoftware โ€” Application or Software โ€” InfrastructureThese 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 pointsThe 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:

Owner Earnings = EBIT ร— (1 โˆ’ tax rate) + D&A โˆ’ CapEx โˆ’ ฮ”NWC

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.

๐Ÿ’ก Why Not Just Use EBITDA?EBITDA adds back depreciation without subtracting CapEx. For capital-light pure-software companies this approximation is acceptable โ€” but for cloud-infrastructure companies with significant server depreciation (DDOG, ZS, SNOW all operate their own infrastructure), EBITDA overstates distributable cash by ignoring the real capex cycle. The owner earnings formula charges actual CapEx, not just the depreciation on prior CapEx. Capital-intensive periods are penalized correctly.

11

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:

CriterionThresholdPurpose
SectorTechnology or Communication ServicesTargets platform, software, and internet businesses. Excludes industrials, healthcare, financials, and consumer sectors where moat durability is harder to establish.
Market Capโ‰ฅ $200 BillionOnly 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

ParameterStandard ModelPlatform QualityEffect
Cost of equityCAPM outputCAPM โˆ’ 0.75%โˆ’75bp applied to the equity component before debt blending in WACC. Reflects the demonstrated market-implied equity cost for these names.
WACC floor8.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:

ScenarioWithout Platform QualityWith Platform QualityChange
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.


12

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:

AxisShifts AppliedExample (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.


13

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.

โš ๏ธ Model HumilityNo quantitative model captures the full complexity of a business or the markets it operates in. This DCF model is one analytical tool among many โ€” it should be used alongside relative valuation, qualitative analysis, and independent judgment, not as a standalone investment decision framework.

14

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 CategorySourceCoverage
Financial StatementsSEC EDGAR (XBRL filings), standardized and normalized across reporting formats10+ years of annual data, 5+ years of quarterly data
Market DataPublicly available exchange feeds via institutional-grade data providersDaily OHLCV, market capitalization, shares outstanding
BetaComputed from historical price returns against the S&P 500 benchmarkTrailing period, updated with each price refresh
Company ClassificationProprietary L1โ€“L4 industry taxonomy built from SIC/NAICS codes and SEC filings5,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.
๐Ÿ“Š Data Pipeline IntegrityAll financial data undergoes automated normalization to handle differences in reporting standards, fiscal year-end dates, currency denominations, and XBRL taxonomy variations. The pipeline processes 5,800+ companies with consistent methodology, ensuring cross-company comparability.

15

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.

VersionDateChanges
v1.0Dec 2025Initial DCF model. Standard two-stage DCF with Gordon Growth terminal value. Fixed WACC estimation. No reinvestor detection. Basic eligibility gates (market cap, revenue).
v2.0Feb 2026Reinvestor-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.0Apr 20265ร—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 lastUpdated field 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.

Ready to explore intrinsic values?

View DCF fair value estimates for any eligible US-listed equity.