Dividend discount model calculator
What a stock is worth today from the dividends it is expected to pay.
For mature companies with steady dividend growth.
Fills in example figures; check the current dividend.
Intrinsic value per share
$52.50
Price close to this value- Margin of safety
- 4.8%
- Next year's dividend
- $2.63
- Implied yield
- 5.0%
- Value of high-growth dividends
- -
- Value of later dividends
- -
Value at other rates
| Return / growth |
|---|
The marked cell is closest to the rates you entered.
How the dividend discount model works
The dividend discount model values a stock as the present value of its future dividends. The Gordon Growth version assumes the dividend grows at one rate forever, which reduces the sum to one line.
Value = D0 x (1 + g) / (r - g)
An example
A $2.50 dividend growing 5% a year pays $2.63 next year ($2.625). With a 10% required return: $2.625 / (0.10 - 0.05) = $52.50 a share. At a $50 price, the margin of safety is 4.8%.
Questions
What is a good required rate of return for DDM?
Most investors use 8% to 12%. Common starting points are the stock market's long-run return of about 10%, the CAPM formula (risk-free rate + beta x market risk premium) or your own target. It must be higher than the growth rate.
How do you estimate the dividend growth rate?
Use the dividend's CAGR over the past 5 to 10 years, the sustainable growth rate (return on equity x share of earnings retained) or analyst estimates. A long-run rate above the economy's growth rarely holds, so many investors stay below about 5%.
What are the limits of the dividend discount model?
It only values stocks that pay dividends, it ignores buybacks, and small changes in r or g move the result a lot. It suits mature companies with steady dividends best.
What is the difference between DDM and DCF?
DDM discounts the dividends paid to shareholders. DCF discounts the company's free cash flow, so it also works for companies that pay no dividend.
Can DDM value a stock that pays no dividend?
No, there are no dividends to discount. Use a discounted cash flow model or earnings-based valuation instead.
What is margin of safety?
The gap between intrinsic value and market price, as a share of intrinsic value: (Value - Price) / Value. A positive figure means the price is below the value the model gives.
What is the two-stage dividend discount model?
It gives a company a period of high dividend growth, then a lower growth rate forever. The value is the present value of the high-growth dividends plus the present value of a Gordon Growth value at the end of that period.
How do I calculate DDM in Excel?
With the current dividend in A1, growth in B1 and required return in C1: =A1*(1+B1)/(C1-B1). The return must be higher than the growth rate.
Related tools
For education only, not financial advice. Results depend on the numbers you enter.