Dividend Discount Model Sheet
The dividend discount model (DDM) values a stock based on the present value of all future dividends. It's particularly useful for mature, dividend-paying companies like utilities, real estate investment trusts (REITs), and dividend aristocrats. While the DCF model assumes reinvested cash flows, the DDM explicitly models the cash returned to shareholders through dividends. For income-focused investors, the DDM directly values what you own—the stream of dividend cash. This article builds a complete DDM template, covering multi-stage growth models, dividend sustainability analysis, and dividend yield comparison to valuations.
Quick definition: The dividend discount model values a stock as the present value of all future dividend payments, discounted at the cost of equity, using the formula: V = D1 / (Re − g) for the simple perpetuity, or multi-stage models that distinguish between high-growth and stable periods.
Key takeaways
- Gordon growth model (stable growth DDM) is simple and useful for mature companies with stable dividend growth: V = D1 / (Re − g)
- Two-stage DDM models a high-growth dividend period (e.g., 10 years) followed by stable perpetual growth, more realistic for most dividend payers
- Dividend sustainability requires free cash flow analysis; unsustainable dividends signal value traps and downside risk
- Payout ratio progression shows whether management is increasing, cutting, or maintaining dividends as earnings grow
- Dividend growth history reveals management's long-term capital allocation priorities; aristocrats with 25+ years of increases are higher quality
- Yield comparison between current market yield and justified yield (from DDM) identifies overvalued or undervalued income stocks
Building the Gordon growth model
The simplest DDM is the Gordon growth model, ideal for stable, mature companies:
Intrinsic Value = D1 / (Re − g)
Where:
D1 = Next dividend (current dividend × (1 + growth rate))
Re = Cost of equity
g = Perpetual growth rate (typically = long-term GDP growth, 2–3%)
Setup:
DIVIDEND ASSUMPTIONS
Current Annual Dividend (D0): $2.00 per share
Assumed Growth Rate (g): 3.0% (perpetual)
Next Year Dividend (D1): $2.06 (= $2.00 × 1.03)
DISCOUNT RATE (COST OF EQUITY)
Risk-Free Rate: 3.0% (10-year Treasury)
Equity Risk Premium: 5.5%
Beta: 0.9 (lower beta for utilities)
Cost of Equity (Re): 3.0% + 0.9 × 5.5% = 7.95%
VALUATION
Intrinsic Value = $2.06 / (0.0795 − 0.03)
= $2.06 / 0.0495
= $41.62 per share
The formula is sensitive to both the numerator (dividend growth) and denominator (cost of equity minus growth). A 1% change in either drastically shifts intrinsic value:
- If growth increases from 3% to 4%: V = $2.06 / (0.0795 − 0.04) = $58.86 (+41%)
- If cost of equity increases from 7.95% to 8.95%: V = $2.06 / (0.0895 − 0.03) = $36.51 (−12%)
This sensitivity is why the Gordon model is best used for companies with truly stable, predictable dividends. For companies with volatile or changing dividend policies, a multi-stage model is more appropriate.
Multi-stage dividend discount model
Most dividend payers don't grow at a constant rate forever. A two-stage model captures a higher-growth period followed by stable perpetual growth:
Two-Stage DDM
Period 1 (Years 1–10): Higher dividend growth (e.g., 5–8%)
Period 2 (Year 11+): Stable perpetual growth (e.g., 2–3%)
Value = PV(Dividends Years 1–10) + PV(Terminal Value at Year 10)
Build the model:
Year 0 Year 1 Year 2 Year 3 ... Year 10
Dividend ($) $2.00 $2.10 $2.21 $2.32 ... $3.26
Dividend Growth % 5.0% 5.0% 5.0% ... 5.0%
Cost of Equity: 7.95%
Present Value Factors:
Year 1: 1 / 1.0795^1 = 0.9263
Year 2: 1 / 1.0795^2 = 0.8581
...
Year 10: 1 / 1.0795^10 = 0.4719
PV of Dividends:
Year 1: $2.10 × 0.9263 = $1.945
Year 2: $2.21 × 0.8581 = $1.897
...
Year 10: $3.26 × 0.4719 = $1.538
Sum of PV(Dividends Years 1–10) = $19.84
Terminal Value at Year 10:
Year 11 Dividend = $3.26 × 1.03 = $3.358 (stable growth 3%)
Terminal Value (Gordon model) = $3.358 / (0.0795 − 0.03) = $74.40
PV of Terminal Value = $74.40 × 0.4719 = $35.09
Intrinsic Value = $19.84 + $35.09 = $54.93 per share
This structure is more realistic: dividends grow faster than GDP for 10 years as the company reinvests, then stabilize at GDP-like rates thereafter. It accommodates companies increasing their dividend payout as they mature and need less reinvestment.
Dividend sustainability analysis
A critical question: Can the company afford its dividend? A high-yield stock might be a value trap if the dividend is unsustainable. Analyze dividend sustainability through free cash flow coverage:
DIVIDEND SUSTAINABILITY ANALYSIS
Year 0 Year 1 Year 2 Forecast
(Actual)
Free Cash Flow ($M) $150 $165 $180 $200
Dividends Paid ($M) $80 $84 $88 $92
Payout Ratio 53% 51% 49% 46%
Coverage Ratio 1.88x 1.96x 2.05x 2.17x
Sustainability Assessment:
Payout ratio <60%: GREEN (sustainable)
FCF Coverage >1.5x: GREEN (dividends covered)
Trend: IMPROVING (payout declining, FCF growing)
Healthy dividend characteristics:
- Payout ratio <60% (leaves room for growth, reduces risk of cuts)
- FCF coverage >1.5x (FCF covers dividend 1.5x or more)
- Declining or stable payout ratio as company matures
- Multi-year dividend growth history without cuts
Risky dividend characteristics:
- Payout ratio >70% (leaves little room; vulnerable to earnings shocks)
- FCF coverage <1.2x (dividend barely covered; no margin of safety)
- Rising payout ratio (company maximizing payout at expense of safety)
- Recent dividend cuts or freezes (could signal deterioration)
Dividend cut risk example:
Company: Legacy Utility
Current Dividend: $2.00 per share
Payout Ratio: 85%
FCF Coverage: 1.05x
Earnings Growth: -2% per year
Recent History: Dividend frozen for 3 years
Red Flags:
- Earnings declining, but payout ratio static (coverage eroding)
- Payout ratio near maximum (85%)
- FCF barely covers dividend
- No history of growth; stagnant
Risk Assessment: HIGH DIVIDEND CUT RISK
Expected Dividend (5 years): $1.60–$1.80 (down 10–20%)
Implied 5-year TSR: -8% to -5% (negative return)
Dividend growth progression and payout ratio
Model how dividends will progress as the company matures:
DIVIDEND GROWTH ROADMAP
Hist. Year 1 Year 2 Year 3 Year 4 Year 5
DPS ($) $1.90 $2.00 $2.10 $2.20 $2.30 $2.40
Dividend Growth % 5.3% 5.0% 5.0% 4.8% 4.5% 4.3%
EPS ($) $3.20 $3.60 $4.08 $4.60 $5.13 $5.70
Payout Ratio 59.4% 55.6% 51.5% 47.8% 44.8% 42.1%
ROE 10.0% 10.5% 11.0% 11.3% 11.5% 11.6%
Interpretation:
- EPS grows 5% annually (sustainable growth from ROE × payout ratio)
- Dividend grows 5% initially, moderating to 3–4% as payout ratio declines
- Payout ratio falls from 59% to 42%, showing dividend safety improves
- By Year 5, company retains 58% of earnings for growth; mature and balanced
A healthy dividend payer increases payouts annually while the payout ratio gradually declines (or stays stable). This shows growing profitability supporting higher absolute dividends while maintaining safety.
Three-stage DDM for transition from growth to maturity
For companies in transition (e.g., a REIT that recently went public, or a pharma company transitioning from growth to stable cash flow), use a three-stage model:
Stage 1 (Years 1–5): High dividend growth (8–10%)
Stage 2 (Years 6–10): Moderate dividend growth (5–6%)
Stage 3 (Year 11+): Stable perpetual growth (2–3%)
Example: Dividend aristocrat transitioning to maturity
Stage 1 (Years 1–5): 8% dividend growth
Year 1: $2.50 → Year 5: $3.67
Stage 2 (Years 6–10): 5% dividend growth
Year 6: $3.85 → Year 10: $4.91
Stage 3 (Year 11+): 3% perpetual growth
Year 11: $5.06 → Perpetuity at 3%
PV Stage 1 (8% growth): $9.50
PV Stage 2 (5% growth): $11.20
PV Stage 3 (terminal): $45.30
Total Intrinsic Value: $66.00 per share
This model reflects realistic expectations: rapid dividend growth while the company retains earnings, then moderation as the company reaches maturity.
Real-world example: Utility stock valuation
Value a regional utility company:
Company Profile:
- Current dividend: $3.00 per share
- Dividend history: 5% annual increases for 10 years
- Payout ratio: 65% of earnings
- Regulatory environment: Stable, allowed ROE 9.0%
- Industry growth: 2–3% (inflation + customer growth)
DDM Assumptions:
Stage 1 (Years 1–5): Dividend growth 4.5%
Management committed to 4.5% annual increases
Payout ratio stable at 65%, earnings growing 6–7%
Stage 2 (Years 6–10): Dividend growth 3.5%
Maturation phase; payout ratio declining to 60%
Earnings growth moderating to 3–4%
Stage 3 (Year 11+): Dividend growth 2.5%
Terminal growth aligns with inflation + utility volumes
Payout ratio stable at 60%
Cost of Equity: 3.0% (risk-free) + 0.8 (beta) × 5.5% (equity risk premium) = 7.4%
Model Build:
Stage 1 Dividends (4.5% growth):
Year 1: $3.00 × 1.045 = $3.14 → PV = $2.92
Year 2: $3.14 × 1.045 = $3.28 → PV = $2.83
Year 3: $3.28 × 1.045 = $3.43 → PV = $2.76
Year 4: $3.43 × 1.045 = $3.58 → PV = $2.68
Year 5: $3.58 × 1.045 = $3.74 → PV = $2.62
Sum PV Stage 1: $13.81
Stage 2 Dividends (3.5% growth):
Year 6: $3.74 × 1.035 = $3.87 → PV = $2.50
...
Year 10: $4.49 → PV = $2.33
Sum PV Stage 2: $11.94
Terminal Value (2.5% perpetuity growth):
Year 11 Dividend: $4.49 × 1.025 = $4.60
Terminal Value = $4.60 / (0.074 − 0.025) = $93.88
PV Terminal = $93.88 / (1.074)^10 = $45.67
Total Intrinsic Value = $13.81 + $11.94 + $45.67 = $71.42 per share
Valuation Comparison:
Current Stock Price: $65.00
Intrinsic Value (DDM): $71.42
Upside: 9.9%
Current Dividend Yield: 4.6% ($3.00 ÷ $65)
Justified Yield (at fair value): 4.2% ($3.00 ÷ $71.42)
Investment Decision:
- Stock is undervalued by ~10%
- Yield is attractive at 4.6%, supported by stable growth and 65% payout ratio
- Dividend sustainability is strong (65% payout, growing earnings)
- Risk: Regulatory changes, rising cost of equity (rates rise → lower valuations)
Comparing DDM valuation to current market yield
Market yield can signal whether a stock is over- or undervalued:
Relationship between Yield and DDM Valuation
Fair Value Yield (from DDM): 4.2%
Current Market Yield: 4.6%
If Current Yield > Fair Yield:
Stock is UNDERVALUED (trading cheaper than intrinsic value)
Example: $71.42 fair value, $65 market price
Explanation: Market is pricing in higher risk or slower growth
If Current Yield < Fair Yield:
Stock is OVERVALUED (trading more expensive than intrinsic value)
Example: $60 market price (4.2 ÷ 0.07 ≈ $60 implied), yielding 5.0%
Explanation: Market is pricing in lower risk or faster growth
A sudden spike in a dividend stock's yield (e.g., from 3% to 5%) without dividend cut signals market repricing to lower valuation. Could indicate:
- Negative news (dividend cut expected), or
- Rising cost of equity due to broader market repricing
Common mistakes
Mistake 1: Using Gordon model for non-stable companies Applying V = D1 / (Re − g) to a company still in high-growth phase (30% dividend growth) is inappropriate. If growth rate is high or volatile, use multi-stage DDM instead.
Mistake 2: Overlooking dividend sustainability A 6% yield looks attractive until the company cuts the dividend 20%. Always validate that FCF covers the dividend with adequate margin (>1.5x). A 70%+ payout ratio is a warning sign.
Mistake 3: Using wrong cost of equity If you overestimate the cost of equity (e.g., using 10% instead of 8%), intrinsic value is depressed. Reconcile your cost of equity with peers and market risk premia.
Mistake 4: Assuming dividends grow forever at historical rates A company that grew dividends 8% for 10 years won't do so forever. Eventually, growth moderates to GDP growth. Use multi-stage models to reflect this transition.
Mistake 5: Forgetting that dividends are not the only return DDM values dividends, but share price appreciation also contributes to total return. DDM implicitly assumes shares neither appreciate nor depreciate in real terms at perpetuity (price grows with dividends). If you expect price appreciation beyond dividend growth, that's upside to the DDM estimate.
FAQ
Q: Should I include special dividends in the DDM? A: No. Special dividends are one-time, non-recurring. Base your model on regular, recurring dividends. If special dividends are frequent (e.g., quarterly REITs distributing 100%+ of earnings), model the full distribution as the dividend.
Q: What if a company doesn't pay dividends yet? A: If it's a growth company reinvesting all cash, use DCF or relative valuation instead. DDM requires a current dividend payment. Alternatively, project when the company will pay dividends (mature phase), then use a DDM starting from that year.
Q: How sensitive is DDM to cost of equity? A: Extremely sensitive. A 1% change in cost of equity can swing intrinsic value by 20–30%. This is why accurate CAPM or cost-of-equity calculation is critical for DDM valuations.
Q: Should I model dividend growth equal to earnings growth? A: Often, yes, if the payout ratio is stable. Dividend growth = Earnings growth × (1 − payout ratio / 1 − payout ratio in prior year), simplified to earnings growth if payout ratio is constant. But if payout ratio is changing, model dividends separately from earnings.
Q: What's a reasonable perpetual growth rate for the terminal stage? A: 2–3% for most companies (aligns with long-term GDP growth). Utilities might use 2–2.5%. Dividend aristocrats with strong track records might justify 3%. Rarely exceed 3%; perpetual growth >>GDP is unrealistic.
Q: Can I use DDM for a REIT? A: Yes, REITs are ideal for DDM (they distribute most earnings as dividends). Model FFO (funds from operations) growth rather than earnings growth, but the DDM structure is the same.
Related concepts
- Total return = Dividend yield + Price appreciation. DDM captures the dividend yield component; price appreciation depends on multiple expansion/contraction.
- Payout ratio analysis reveals whether dividends are sustainable. Compare to FCF, not just earnings, for accuracy.
- Dividend growth rate (DGR) is the key input to DDM. Historical DGR informs forward projections, but don't extrapolate indefinitely.
- Cost of equity (CAPM) is the discount rate in DDM. Accurate estimation is critical; small errors have large valuation impacts.
- Dividend aristocrats with 25+ years of consecutive increases have demonstrated sustainability; consider using slightly higher growth assumptions.
- Relative valuation for dividend stocks (P/E, dividend yield relative to peers) provides a secondary validation check on DDM.
Summary
The dividend discount model values dividend-paying stocks based on the present value of future dividend payments. Use the simple Gordon model for stable, mature companies, but multi-stage models (two or three stages) are more realistic for companies transitioning from growth to maturity. Always validate dividend sustainability through free cash flow coverage and payout ratio analysis. Model dividend growth rates that reflect realistic transitions from high growth to perpetual stable growth. Compare DDM intrinsic value to current market yield to identify over- or undervaluation. DDM works best for utilities, REITs, and dividend aristocrats with predictable cash flows.