Dividend Discount Model Calculator
Calculate intrinsic stock value using the Gordon Growth Model
Select a dividend aristocrat to auto-fill current dividend and historical growth rate.
Sensitivity Analysis
See how intrinsic value changes with different growth rates and required returns.
Valuation Matrix
| r \ g | 3% | 4% | 5% | 6% | 7% |
|---|
Your current inputs are highlighted. Green = undervalued, red = overvalued vs current price.
Want to calculate dividend income instead?
Use our Dividend Calculator for income projections, DRIP growth, and portfolio analysis.
What is the Dividend Discount Model?
The Dividend Discount Model (DDM) is a fundamental stock valuation method that calculates a stock's intrinsic value based on the present value of all expected future dividend payments. The underlying principle is that a stock is worth the sum of all future cash flows (dividends) it will generate, discounted back to today's value.
The most widely used version is the Gordon Growth Model (also called the constant-growth DDM), developed by economist Myron Gordon. It assumes dividends will grow at a constant rate forever, simplifying the calculation to a single formula.
DDM works best for mature, stable companies with predictable dividend policies—like dividend aristocrats (JNJ, KO, PG) that have increased dividends for 25+ consecutive years. It's less suitable for growth stocks that don't pay dividends or companies with erratic dividend histories.
DDM Formulas
Gordon Growth Model (Constant Growth)
- P₀ = Intrinsic value (fair price today)
- D₀ = Current annual dividend
- D₁ = Next year's expected dividend
- r = Required rate of return (discount rate)
- g = Dividend growth rate (must be < r)
Zero-Growth Model (Perpetuity)
For preferred stocks or companies with constant dividends. Simply divides the annual dividend by the required return.
Two-Stage DDM
For companies transitioning from high growth to stable growth. Sums the present value of high-growth dividends plus the terminal value.
Excel Formulas for DDM
| Model | Excel Formula |
|---|---|
| Gordon Growth | =A1*(1+B1)/(C1-B1)A1=Dividend, B1=Growth, C1=Required Return |
| Zero Growth | =A1/B1A1=Dividend, B1=Required Return |
| Margin of Safety | =(A1-B1)/A1A1=Intrinsic Value, B1=Current Price |
| Two-Stage (Terminal Value) | =A1*(1+B1)/(C1-B1)A1=Final high-growth dividend, B1=Terminal growth, C1=Required return |
When to Use the Dividend Discount Model
DDM Works Best For
- Dividend aristocrats (25+ years of increases)
- Mature, stable blue-chip companies
- Utilities and consumer staples
- REITs (required to pay 90% of income)
- Companies with predictable cash flows
- Preferred stocks (fixed dividends)
DDM Not Suitable For
- Non-dividend paying stocks (AMZN, TSLA)
- High-growth companies reinvesting profits
- Companies with erratic dividend history
- Cyclical industries (volatile earnings)
- Companies likely to cut dividends
- Early-stage or turnaround situations
Frequently Asked Questions
=A1*(1+B1)/(C1-B1) where A1=dividend, B1=growth rate (as decimal), C1=required return (as decimal). For two-stage DDM, use NPV(rate, dividends) + terminal_value/(1+rate)^n. Always ensure r > g to avoid division errors. Use IF(C1>B1, formula, "Error") for validation.