The Dividend Discount Model (DDM) is a simple and conservative method of determining the fair value of a stock. Dividend discount models estimate the value of a company's stock price by calculating the sum of the present value of future dividend payments. There are two variations of the DDM on finbox.io, Stable Growth and Multi-Stage. This guide covers the key steps and assumptions used in the Stable Growth variation, also known as a Single Period DDM.
A Stable Growth DDM estimates an adjusted dividend and applies the Gordon Growth Formula to estimate the value of a stock.
Here is the formula of DDM:

Source: Investopedia Definition
As equation above suggests, we'll need estimates for Dividend Per Share
, Cost of Equity
, and growth rate
to apply the formula. Here is an outline of the process we'll use select our assumptions and build a DDM:
- Step 1: Estimate Excess Retained and Adjusted Dividend
- Step 2: Estimate a Perpetuity Growth Rate
- Step 3: Calculate Fair Value
I've created an Illustrative Dividend Discount Model for JNJ that you can use to follow along with this guide:
Illustrative DDM: Stable Growth
Step 1: Estimate Excess Retained and Adjusted Dividend
Management is highly incentivized to manage earnings and grow revenue, earnings and dividends at stead intervals each quarter. Much has been studied and written on this topic.
Since the Dividend Discount Model assumes all available earnings are paid out as dividends, we can get a better estimate of fair value by adding a portion of net income that management could have paid out to the Current Dividend
. This is easier than projecting when the excess cash that gets built on the balance sheet will be returned to shareholders. In practice, the excess retained cash is usually paid out to shareholders in the form of special dividends or used to make up for cash shortfalls for dividends during economic downturns. You can choose to skip this adjustment, but beware that you'll likely end up with an estimate well below market value for most companies. Here is the general process of estimating Excess Retained
:

In the Illustrative Johnson & Johnson model, we can see that the company earned $14.714 billion in Net Income over the last twelve months, paid out $10.323 billion in cash dividends
, and "retained" $4.391 billion. This implies a retention ratio of 29.8%.
In a stable growth scenario, it would be fair to assume the company would only need to retain between 7.5% to 20% of Net Income
. This amounts to the Excess Cash Retained per Share
of $0.55 - $1.25 show above.
If we add this Excess Retained Cash
to the annualized Current Dividend
of $3.92 we can arrive at our estimate of Adjusted Dividend
$4.47 - $5.17, with a mid-point of $4.89 per share.

Step 2: Estimate a Perpetuity Growth Rate
Next, we need to estimate a Perpetuity Growth Rate
. Here is some sound guidance on selecting a perpetuity growth rate from Macabacus
The perpetuity growth rate is typically between the historical
inflation rate of 2-3% and the historical GDP growth rate of 4-5%.
If you assume a perpetuity growth rate in excess of 5%, you are
basically saying that you expect the company's growth to outpace the
economy's growth forever.

So how does Finbox estimate the perpetuity growth rate? After February 2020 update, all our financial models are powered by a sophisticated machine learning model that takes into account over 50 parameters as inputs to make default predictions for exit multiples used in DCF models as well as multiples used in comparable company analysis.
Given JNJ's strong future outlook, we have a Perpetuity Growth Rate
of 4% in my model with a range of +/-0.25%.

Step 3: Calculate Fair Value
The last assumption we need to calculate a Fair Value
is Cost of Equity
. finbox.io has a Cost of Capital model that you can use to estimate Cost of Equity
.
Using the Cost of Capital model, I've estimated the Cost of Equity
for JNJ to be in the range of 8% to 6%.
Now the fun part! We can take our estimates for Adjusted Dividend
, Perpetuity Growth Rate
and Cost of Equity
and input them in the Gordon Growth Formula discussed earlier calculated Fair Value
:

Based on my assumptions, Johnson and Johnson's Fair Value per Share
is somewhere between $109.49 to $310.31. Since the stock is currently trading at $160.03, the mid-point of my model suggests JNJ is currently undervalued by 6.4%.
Next Steps
Dividend discount models can be useful in quickly evaluating the impact of different assumptions about growth and future prospects. With a few assumptions, you can determine if a company justifies further research. As with all models on finbox.io we recommend using a combination of models to get a sense of the risks involved and triangulate a fair value.