...
๐Ÿ“– Research Document ยท DCF Model v2.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 2.0ยทLast Updated: February 15, 2026ยท~7,500 Wordsยท12 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

๐Ÿ’ก 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:

๐Ÿ“Š 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:

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.

Size-Adjusted WACC Bounds

Raw CAPM estimates are clamped to prevent extreme discount rates that would render the model output meaningless:

Market Cap TierWACC FloorWACC CeilingLogic
Mega-cap (>$500B)6%10%Blue-chip, high-liquidity, well-diversified businesses with lower systemic risk
Large-cap ($50Bโ€“$500B)7%12%Established businesses; moderate beta; standard risk premium
All Others (<$50B)8%15%Higher risk premium for smaller, less diversified companies

Why Clamp WACC?

Raw beta-driven WACC can produce unreasonable extremes: a stock with a beta of 2.5 would generate a 17%+ WACC, making virtually any company appear worthless in a DCF. Conversely, a near-zero beta would produce a WACC of 4โ€“5%, inflating values beyond reason. The bounds ensure the discount rate stays within the range used by institutional practitioners.


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)
Where: g_terminal = 3% (fixed)

The 3% terminal growth rate reflects long-run nominal GDP growth (real GDP ~2% + inflation ~1%). This is standard institutional practice โ€” terminal growth should never exceed the long-run economic growth rate, otherwise the company would eventually become larger than the entire economy.

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.

Scenario Definitions

ScenarioGrowth RateDiscount RateInterpretation
BearBase Growth ร— 0.80WACC + 2.0%Conservative downside โ€” slower growth, higher risk premium. Reflects execution challenges, competitive pressure, or macro headwinds
BaseHistorical CAGR (capped)WACC (CAPM-derived)Most likely outcome โ€” assumes the company continues at its demonstrated historical trajectory, subject to size-adjusted caps
BullBase Growth ร— 1.20 (max 30%)WACC โˆ’ 1.5% (floor 6%)Optimistic upside โ€” accelerating growth, improving risk profile. Reflects successful product launches, market expansion, or operating leverage

Why These Specific Adjustments?

๐Ÿ“Š How to Use ScenariosThe bear case establishes a floor โ€” if the stock trades below the bear case intrinsic value, even pessimistic assumptions support a higher price. The bull case establishes a ceiling โ€” if the stock trades above the bull case, the market is pricing in growth above what history suggests is achievable. The base case provides the central estimate for comparison.

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

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.

11

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

๐Ÿ“Š 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.

12

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.

Planned Enhancements


Ready to explore intrinsic values?

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