You've successfully subscribed to The Finbox Blog
Great! Next, complete checkout for full access to The Finbox Blog
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.
How To Build A Dividend Discount Model: Stable Growth

How To Build A Dividend Discount Model: Stable Growth

. 4 min read

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:

DDM Formula

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.

Sources / Further Reading: