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: Multi-Stage

. 5 min read

The Dividend Discount Model (DDM) estimates the value of a company's stock price based on the theory that its worth is equal to the sum of the present value all of its future dividend payments to shareholders. There are two variations of the DDM on finbox.com, Stable Growth and Multi-Period. This guide covers the key steps and assumptions used in the Multi-Stage variation, also knowns as Multi-Period DDM.

The Multi-Stage model assumes the subject company will experience differing growth phases. This provides greater control over the near-term dividends which are the most valuable. After the discrete projection period of five years, we can use the standard Gordon Growth Formula to estimate Terminal Value. The methodology behind the DDM can be summarized with the following two formulas:

Source: AccountingExplained

As equations above suggests, we'll need estimates for `Growth Period Dividends`, present value of stable growth dividends or `Terminal Dividend`, `Cost of Equity`, and `growth rate`.

Here is an outline of the process:

• Step 1: Forecast Net Income
• Step 2: Forecast Adjusted Dividends
• Step 3: Estimate a Perpetuity Growth Rate
• Step 4: Calculate Fair Value

I've created an Illustrative DDM: Multi-Stage model for MasterCard that you can use to follow along:

Illustrative DDM: Multi-Stage Model

##### Step 1: Forecast Net Income

All Finbox's models are powered by the latest analyst forecasts so you don't have to forecast net income alone:

##### Step 2: Forecast Adjusted Dividends

We can use the `Net Income` forecast to serve as the basis for the `dividend` forecast. In my forecast, I assumed a steady increase in payout ratio. Management is highly incentivized to manage earnings and deliver steady quarterly growth in revenue, earnings, and dividends so it is unlikely they will be as aggresive. Much has been studied and written on this topic. Steadily increasing the `payout ratio` assumption however allows me to capture value that would otherwise build up as cash on the balance sheet. In practice, this excess retained cash is usually paid out to shareholders as special dividends or to make up for cash shortfalls for dividends during economic downturns.

Here's my final `Adjusted Dividends` forecast:

##### Step 3: 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.
``````

MasterCard's historical and projected compound annual growth rates (CAGRs) are great data points for guiding selection of a perpetuity growth rate.

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 MasterCard's strong future outlook, we have a `Perpetuity Growth Rate` that ranges between 4.25% and 4.8%, with a mid-point of 4.5%.

##### Step 4: Calculate Fair Value

The last assumption we need to calculate a `Fair Value` is `Cost of Equity`. finbox.com has a Cost of Capital that's great for estimating `Cost of Equity`.

Time to put it all together! First order of business is discounting the individually forecasted dividends back to present value. finbox.com's models do the heavily lifting of calculating the `Discount Factors` using the mid-year convention. You can follow the methodology used to estimate present value by reviewing the a) `Discounting Periods`, b) `Discounting Factors` c) `PV of Discrete Dividends` sections in the model.

Using these `Discount Factors` the model arrives at an estimate for the present value of the forecasted dividends of \$31.78 to \$32.66 billion.

Next we need to estimate the value after the forecast period or `Terminal Value`. As discussed earlier, this model uses the `Gordon Growth` formula to estimate `Terminal Value` in the future and then uses the `Terminal Discount Factor` to determine it's value today.

Here is the calculation of `Present Value of Terminal Dividends`:

The model then adds the two present values to calculate MasterCard's `Total Equity Value`. You can compare `Total Equity Value` to MasterCard's `Market Cap.`. To get to a per share `Fair Value` that we can compare to the current stock price, the model divides `Total Equity Value` by the `current shares outstanding`.

The assumptions I used in my model calculated yield a `Fair Value per Share` for MasterCard of \$255.60, 23% below it's current stock price of \$332.82. This isn't surprising since Dividend Discount Models are known to provide conservative estimates of `Fair Value`. Nevertheless, I prefer to invest in stocks that offer at least a 15% discount price estimates derived using DDMs. Luckily, finbox.com's Price Target and Alerts features are great for tracking keeping an eye out for pull-backs in stock price!

##### 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.

### Andy Pai

Founder @ finbox.io. We build tools that make life easier for investors. I started my career in investment banking. I live in Chicago. Reach out if I can be helpful!

Tags
Try The Tools Used By Smart Investors