Dividend Discount Model Calculation Explained

Boosted by a new confidence, the market has hit new record highs lately. Value investors must be grinning at the moment as it was already difficult to find undervalued companies at the moment, a new boost in the stock market is nothing to help. Assessing the right value of a company is quite a challenge by itself, it’s even harder when you have several years of bullish markets to improve any metrics you look at. This is why I decided to revisit the methodology used in my dividend discount model calculations.

The basics of the dividend discount model

The idea behind the dividend discount model (DDM) is fairly simple; this model considers any company as a money making machine (e.g. dividend paying). The purpose of the calculations is to give a value of all future dividend payments that will be made by this company in the future.

This assumes the company will pay & increase dividends forever. This assumption is very important as you have to keep in mind that a very limited number of companies have been successfully increasing their dividend payment for 25 consecutive years. Those companies are called “dividend aristocrats”. There are 50 of them. A more elite group of companies exists where we consider only companies showing 50 consecutive years with a dividend increase. This small group of 18 companies are called the “dividend kings”. You can then imagine how you must remain cautious when you use a dividend growth rate as only 50 companies out of the S&P 500 had successfully increased their payouts long enough to be considered “an eternity of dividend payments”.

The tool I use to run my calculations is called the Dividend Toolkit. The toolkit comes with a 200 page book explaining how to find and assess strong dividend growth payers. This also comes with an excel spreadsheet doing all the hard work for you in order for you to avoid any miscalculation. The spreadsheet allows you to simply key-in the important numbers and it will run the dividend discount model for you without further error. There are two different dividend discount model spreadsheets. My favorite one is the double stage DDM. In this article, I will walk you through step-by-step in order to have the most precise valuation possible. There are four components in this spreadsheet:

Recent Annual Dividend Payment

Expected Dividend Growth Rate Years 1-10

Expected Terminal Dividend Growth Rate

Discount Rate

They are displayed as follows:

DDM explained 1

For the purpose of this example, we will take McCormick (MKC) figures as at July 2016. The idea is not to make MKC stock analysis but rather to take real numbers to show you how they work out in the dividend discount model. As the recent annual dividend payment is quite easy to find. MKC recently increased its payout to $0.43/share quarterly. We already have our first data to enter in the matrix:

DDM explained 2

Now, let’s focus on the dividend growth rate…

Dividend Growth Rate Years 1-10

The first dividend growth rate to enter in the DDM is your assumption of what is going to happen over the next 10 years. This number can be more optimistic as it will only affect a period of time for the calculation. Plus, it has a better chance to reflect the near future of a company. There are many ways you can determine this number. You can use the past 10 years dividend growth history, the past 5 years, 3 years or the most recent year. You can also use other metrics to enhance your analysis.

For example, MKC past 5 years dividend growth rate is at 9%. However, their most recent dividend increase was only of 7.5%. At the same time, the 5 years revenue growth was 5.18% and the 5 year EPS growth was 2.02%. Both recent revenue and EPS growth shows a 9% annual increase is unsustainable. Management seems to go towards the same assumptions as they raised their dividend by 7.5% in 2016. However, I can presume a sustainable dividend increase by looking at the payout (48.91%) and the cash payout (44.39%) ratios. Finally, MKC is spending 50% of its cash flow on business growth (introduction of new products, acquisitions and marketing). This means to me that MKC focuses on generating more revenues and eventually more cash flow for its shareholders. For this reason, I’ve selected a 7.50% dividend growth rate for the upcoming 10 years.

Here’s our second data to enter in our spreadsheet:

DDM explained 3

The terminal dividend growth rate is a little bit tricky though…

Terminal Dividend Growth Rate

The terminal rate is the one to be used “forever”. Already, the word “forever” is big enough, we now have to quantify it. A mistake in your assumption at this stage will render your calculations bogus. In this situation, it is important to give more thought about the company business model, its past history of dividend payments along with what is coming in the future. In other words, you can’t determine a stock valuation without doing its detailed analysis first. In order to save you some time, I’ve already done the McCormick stock analysis on Seeking Alpha. In the light of my analysis, I’ve determined that a 7% dividend growth rate was possible. I always tend to diminish the terminal dividend growth rate vs its first 10 years in order to be more conservative. Here’s what we have so far in our spreadsheet:

DDM explained 4

We are almost done (already!?!) before we get our valuation! All we need now is a discount rate.

Discount Rate

The discount rate reflects the risk vs return you expect from your investment. For example, if we had done the same analysis with treasury bills, the discount rate will have to be very small as it is a “risk free” return. When it comes down to investing in stocks, I use 4 differents discount rate.

9%: for companies with strong economic moat and stellar dividend growth history

10%: for companies with an economic advantage and a strong dividend growth history

11%: for companies showing additional risks (a weakness in their business model)

12%: for long shots

I don’t bother going too high or too low with the choice of my discount rate as it would not serve me well in the valuation process. For MKC, I will use a 9% discount rate based on the fact that MKC is a leader in its market, protects its model by investing massively in marketing and R&D and shows an impressive dividend payment record. In other words, this company shows less risks than Chevron (CVX) for example. We have then completed our spreadsheet:

DDM explained 5

Now… let’s see how much MKC worth if it was purely a dividend paying machine. But first, we must introduce one last concept. The margin of safety.

The Margin of Safety

As you probably realized by now, making these assumptions puts you right between science and magic when it comes down to determining the future of a company. As a small difference in your calculation would lead to completely different valuation, it is important to have a margin of safety. This margin is the room for error in your calculations. The Dividend Toolkit will not only give you the intrinsic value of the company you analyze based on your numbers, but it will also calculate various scenarios where the margin of safety goes from a 20% discount to a 20% premium. Here’s a complete example to show you how it works.

15 Possible Values with the Dividend Discount Model

We are now at the final stage of our calculations. Once you finish your input, you automatically see the result on the right side of the spreadsheet:

DDM explained 6

As you can see, the intrinsic value of MKC is $96.06. However, the Dividend Toolkit Spreadsheet also gives you the value if you had chose an 8% or a 10% discount rate. You also have various scenarios for its margin of safety. For example, if the stock would trade at $75 this morning and you have an intrinsic value of $96, you have a 20% discount value or 20% margin of safety. This means that you can buy the stock at $75 and even if you are wrong in your calculations, you still have 20% on the stock price as a margin of error. On the other hand, if the stock currently trades at $115, you know you are already paying an important premium. In other words, you have no room for error at this point.

As you can see, assigning a dollar value to a company is not that easy. You can get the Dividend Toolkit to help you in your investing process. Using this tool will enhance your investment process and give you a better indication as to when to buy the companies on your watch list and when to wait for a market correction.

Cummins

Summary

It’s key advantage is CMI’s expertise in the design of lower emission generating engines.
CMI is working with its clients to meet new regulation requirements from the Environmental Protection Agency.
CMI’s ability to protect its know-how in designing more eco-friendly engines will open doors to markets such as India and China.

DSR Quick Stats

Sector: industrials
5 Year Revenue Growth: 7.64%
5 Year EPS Growth: 18.13%
5 Year Dividend Growth: 32.03%
Current Dividend Yield: 3.43%

What Makes Cummins (CMI) a Good Business?

Cummins Inc., a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service diesel and natural gas engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems.

The company is divided into 4 business segments:
CMI business segmentsSource: author’s table, data from Cummins financial reports

Cummins’ business model is closely related to the transportation, mining and infrastructure industries as 42% of its sales come from its engine division. The demand for heavy-duty and medium-duty trucks/bus engines are the two biggest sectors of this division with $631M in sales (-17%) and $549M (-10%) respectively during their latest quarter.

The company has a long time expertise in building efficient engines with low emissions. As environmental regulations increase each year, we can see a strong economic moat for Cummings.

Ratios

Price to Earnings: 15.06
Price to Free Cash Flow: 14.09
Price to Book: 2.2798
Return on Equity: 17.71%

Revenue

CMI revenueRevenue Graph from Ycharts

The demand for engines in North America and Brazil has been lower than in previous years and this is mainly why Cummins shows a decrease in its revenue in 2016. Management expects revenue to drop by 5 to 9% yoy for 2016.

How CMI fares vs My 7 Principles of Investing

We all have our methods for analyzing a company. Over the years of trading, I’ve been through several stock research methodologies from various sources. This is how I came up with my 7 investing principles of dividend investing. Let’s take a closer look at them.
CMISource: Ycharts

Principle #1: High Dividend Yield Doesn’t Equal High Returns

My first investment principle goes against many income seeking investors’ rule: I try to avoid most companies with a dividend yield over 5%. Very few investments like this will be made in my case (you can read my case against high dividend yield here). The reason is simple; when a company pays a high dividend, it’s because the market thinks it’s a risky investment… or that the company has nothing else but a constant cash flow to offer its investors. However, high yield hardly come with dividend growth and this is what I am seeking most.
CMI div paid yieldSource: data from Ycharts.

As you can see, CMI dividend yield has been low historically. Besides the 2008 crisis, the company used to pay a yield between 1% and 2% for most of the decade. The stock yield has recently increased due to a very steep dividend growth increase rate and a recent drop in the stock price.

Most industrials have the bad habit of following cyclical trends. The good news is when you didn’t buy it yet, it opens great opportunities for new investors. Entering a position in CMI at 3.43% dividend yield seems like a good deal so far.
CMI meets my 1st investing principle.

Principle#2: Focus on Dividend Growth

My second investing principle relates to dividend growth as being the most important metric of all. It proves management’s trust in the company’s future and is also a good sign of a sound business model. Over time, a dividend payment cannot be increased if the company is unable to increase its earnings. Steady earnings can’t be derived from anything else but increasing revenue. Who doesn’t want to own a company that shows rising revenues and earnings?

CMI has been more than generous with its shareholders over the past 5 years. In fact, the company shows a dividend growth rate of 32.03% CAGR. It has successfully increased its dividend for the past 6 years in a row after taking a small pause of 1 year in 2009 following the latest recession. With their recent strong dividend increase, management has made a solid statement that dividend growth was a priority for them too. CMI meets my 2nd investing principle.

Principle #3: Find Sustainable Dividend Growth Stocks

Past dividend growth history is always interesting and tells you a lot about what happened with a company.As investors, we are more concerned about the future than the past. this is why it is important to find companies that will be able to sustain their dividend growth.
CMI payout ratioSource: data from Ycharts.

While the company has been increasing their dividend aggressively over the past 5 years, you can see that this wasn’t an operation to simply look good. Management was able to maintain both the payout ratio and cash payout ratio under 50% until recently. It would be unrealistic to expect a double digit dividend growth rate forever. The company has simply positioned itself in the dividend basket to attract more investors. Further on, we can expect a slower but solid dividend growth rate. CMI meets my 3rd investing principle.

Principle #4: The Business Model Ensure Future Growth

Cummins sells consumable products with a strong brand name. The best part is that there is an important evolution in most of its products. The company is the largest manufacturer of natural gas and hybrid bus engines in the USA. As environmental regulations move forward, we will see an increase in the demand for such products. Being a leader in a changing industry is a very good thing only if you can put the money in R&D to make sure you follow the trend.

What Cummins does with its cash?
The company increased its operating cash flow from $173M to $263M for their first quarter of the year. This improvement was due to lower working capital required. As previously mentioned, management has been quite generous with its shareholders and a good part of CMI cash flow went into dividend payments.

Besides paying back its shareholders, CMI has also used a lot of money to improve its products and remain the leader in low emission engines. This is how they will remain on the top of their game and gain additional market share in the future.
CMI has a strong business model and meets my 4th investment principle.

Principle #5: Buy When You Have Money in Hand – At The Right Valuation

I think the perfect time to buy stocks is when you have money. Sleeping money is always a bad investment. However, it doesn’t mean that you should buy everything you see because you have some savings aside. There is some evaluation work to be done. In order to achieve this task, I will start by looking at how the stock market valued the stock over the past 10 years by looking at its PE ratio:
CMI PE ratioSource: data from Ycharts.

As is the case with most industrials, CMI is demonstrates a cyclical PE ratio depending on which environment it evolves. The company recently saw its PE going up as earnings dropped faster than its price due to slower demand. Nonetheless, I don’t think that such a strong company is overvalued at a 15 PE ratio.

I’ve also used the dividend discount model to give a more precise value to CMI with a dividend growth investor perspective. As I’ve mentioned before, I don’t expect CMI to keep up its double digit dividend growth policy. This is why I’ve used an 8% growth rate for the first 10 years and dropped it to 6% for the years after. Since the company is evolving in a cyclical industry and is dependent on other cyclical industries such as mining, I’m using a 10% discount rate.

Input Descriptions for 15-Cell Matrix INPUTS
Enter Recent Annual Dividend Payment: $3.92
Enter Expected Dividend Growth Rate Years 1-10: 8.00%
Enter Expected Terminal Dividend Growth Rate: 6.00%
Enter Discount Rate: 10.00%

Here’s what the calculation give me:

CMI intrinsic value

Source: Dividend Monk Toolkit Excel Calculation Spreadsheet

As the stock is currently trading around $113, we have a small discount as its intrinsic value should be more around $121. Considering both analysis, CMI meets my 5th investing principle.

Principle #6: The Rationale Used to Buy is Also Used to Sell

I’ve found that one of the biggest investor struggles is to know when to buy and sell his holdings. I use a very simple, but very effective rule to overcome my emotions when it is the time to pull the trigger. My investment decisions are motivated by the fact that the company confirms or not my investment thesis. Once the reasons (my investment thesis) why I purchase shares of a company are no longer valid, I sell and never look back.

Investment thesis
An investment in CMI is based on its ability to protect its know-how in designing more eco-friendly engines. New markets are slowly but surely opening to Cummins due to this specific expertise. Europe in the upcoming years and later China & India will also improve their environmental rules with regards to emissions. They will then open the doors to companies such as Cummins to benefit from their expertise. CMI has already created partnerships with important clients such as TATA in India.

It is very difficult for its competitors to catch up on 10 years of massive R&D investments to develop such technology. This is how Cummins should keep its competitive advantage for a while. An investment in CMI right now, is also an investment in a lowered valued stock paying a healthy dividend around 3.50%.

Risks
Nothing is perfect for Cummins and it will face additional competition in the future. One of its largest clients, Paccar started to sell its own engine in North America. This has obviously slowed down CMI’s growth potential in the US while also hurting its margins.

The company also might have to make partnerships with Chinese companies to conquer this market. While this is very positive for the future growth of the company, CMI might also put at risk its best asset: intellectual property. They will have to remain very cautious about their offshore partnerships.

Overall, there is more goods than bad and CMI meets my 6th investing principle.

Principle #7: Think Core, Think Growth

My investing strategy is divided into two segments: the core portfolio built with strong & stable stocks meeting all our requirements. The second part is called the “dividend growth stock addition” where I may ignore one of the metrics mentioned in principles #1 to #5 for a greater upside potential (e.g. riskier pick as well).

Having both segments helps me to categorize my investments into a “conservative” or “core” section or into a “growth” section. I then know exactly what to expect from it; a steady dividend payment or higher fluctuations with a greater growth potential.

Cummins is clearly a good holding for a core portfolio. They will continue to pay a steady and increasing dividend but the stock growth is limited. While I would not buy CMI as my first stock for a portfolio, Cummins offer a great addition for a stable conservative portfolio. CMI is a core holding.

Final Thoughts on CMI– Buy, Hold or Sell?

Considering the very few opportunities in the current market, I think CMI could be a good addition for any dividend growth investors. Don’t expect to see the stock skyrocket in the upcoming year, but you can rest assured to receive an increasing dividend payment. I’m not overly confident in the company’s growth perspective, but I would gladly give them a moderate buy rating. What do you think?

Disclaimer: I do not hold CMI in my DividendStocksRock portfolios.

Disclaimer: The opinions and the strategies of the author are not intended to ever be a recommendation to buy or sell a security. The strategy the author uses has worked for him and it is for you to decide if it could benefit your financial future. Please remember to do your own research and know your risk tolerance.

Seaspan Corporation – High Yield, Tough Earnings Growth

 

Summary:

Seaspan is the world’s largest major shipping line company with alternatives to vessel ownership.

Investors benefit from a generous 8%-9% yield, why would you ignore it?

The company’s fleet is increasing in size leading to higher revenues, but earnings are not following.

Regardless a nice business model, the company will have to bring more cash flow to the table to become interesting.

DSR Quick Stats

Sector: Industrial

5 Year Revenue Growth: 15.00%

5 Year EPS Growth: -0.68%

5 Year Dividend Growth: 26.71%

Current Dividend Yield: 8.94%

What Makes Seaspan (SSW) a Good Business?

Seaspan provides many of the world’s major shipping lines with alternatives to vessel ownership by offering long-term leases on large, modern container ships combined with industry leading ship management services.

The company owns over 100 ships with over 3,000 employees working. The company has successfully signed several long term contracts with major clients the size of Costco (COST) for example. Their role is to become the solution for transportation for many retail clients selling merchandising across the world.

Ratios

Price to Earnings: 12.74
Price to Free Cash Flow: N/A
Price to Book: 1.972
Return on Equity: 10.50%

Revenue

ssw1

Revenue Graph from Ycharts

Seaspan revenues keep increasing year after year which is a good thing. Their fleet is expanding at the same rate (more on this later). So far, I like what I’m seeing.

How SSW fares vs My 7 Principles of Investing

We all have our methods for analyzing a company. Over the years of trading, I’ve been through several stock research methodologies from various sources. This is how I came up with my 7 investing principles of dividend investing. Let’s take a closer look at them.

ssw2

Source: Ycharts

Principle #1: High Dividend Yield Doesn’t Equal High Returns

My first investment principle goes against many income seeking investors’ rule: I try to avoid most companies with a dividend yield over 5%. Very few investments like this will be made in my case (you can read my case against high dividend yield here). The reason is simple; when a company pays a high dividend, it’s because the market thinks it’s a risky investment… or that the company has nothing else but a constant cash flow to offer its investors. However, high yield hardly come with dividend growth and this is what I am seeking most.

ssw3

Source: data from Ycharts.

The company’s yield seem attractive to many investors, but you have to dig deeper to see what is happening behind it. As you can see, the company ran into some serious difficulties back in 2009 and cut their dividend significantly. Since then, investors have yet to receive a paycheck as big as it was prior to the dividend cut. This is the first warning signal right there. SSW doesn’t meet my 1st investing principle.

Principle#2: Focus on Dividend Growth

My second investing principle relates to dividend growth as being the most important metric of all. It proves management’s trust in the company’s future and is also a good sign of a sound business model. Over time, a dividend payment cannot be increased if the company is unable to increase its earnings. Steady earnings can’t be derived from anything else but increasing revenue. Who doesn’t want to own a company that shows rising revenues and earnings?

ssw4

Source: Ycharts

I have mixed feelings when I look at this graph. If I had only considered the past 6 years of dividend history, I would been thrilled to continue my analysis. Since 2010, the dividend is increasing like clockwork each year. However, it is after a huge dividend cut in 2009. SSW fails to meet my 2nd investing principle.

Principle #3: Find Sustainable Dividend Growth Stocks

Past dividend growth history is always interesting and tells you a lot about what happened with a company.  As investors, we are more concerned about the future than the past. this is why it is important to find companies that will be able to sustain their dividend growth.

ssw5

Source: data from Ycharts.

We are already at 2 strikes and are just starting to look into the company’s fundamentals. The payout ratio is set to the maximum and the company is still bleeding cash at the moment with a negative cash flow. I hope you start to understand why the company is paying such a high dividend yield by now. SSW doesn’t meet my 3rd investing principle.

Principle #4: The Business Model Ensure Future Growth

This is where is starts to get interesting. While the first principles are not met, there is still something interesting with this company. The thing is that maritime transportation is not going to slowdown in the future. Plus, the company shows the largest fleet of private vessels.

Seaspan’s business model is interesting as it is fueled by long term contracts with solid clients. This should translate in a strong cash flow generation in the future.

What Seaspan does with its cash?

ssw6

Source: SSW FACT sheet

So here’s the problem with SSW; the company is growing its fleet significantly, but it’s requiring lots of money. I’m not too worried at the moment because Seaspan’s fleet utilization rate is over 97%. In other words; the company is doing well to grab market share by increasing its fleet. Now is the time to generate higher margins to show more profits. Seaspan has a good business model and meet my 4th investing principle.

Principle #5: Buy When You Have Money in Hand – At The Right Valuation

I think the perfect time to buy stocks is when you have money. Sleeping money is always a bad investment. However, it doesn’t mean that you should buy everything you see because you have some savings aside. There is evaluation work to be done. In order to achieve this task, I will start by looking at how the stock market valued the stock over the past 10 years by looking at its PE ratio:

ssw7

Source: data from Ycharts.

This is one of the hardest PE ratio trends to analyze that I’ve seen in recent years. The company goes from extremes and often doesn’t generate a profit to even show a valid PE ratio. Right now, the PE ratio seems interesting for an entry point.

By using the dividend discount model, we will see if the dividend payment is worth what you pay for. Since payout ratios are very high, I’ve used a small 3% dividend growth rate and an 11% discount rate:

 

Input Descriptions for 15-Cell Matrix INPUTS
Enter Recent Annual Dividend Payment: $1.52
Enter Expected Dividend Growth Rate Years 1-10: 3.00%
Enter Expected Terminal Dividend Growth Rate: 3.00%
Enter Discount Rate: 11.00%

 

 

 

Calculated Intrinsic Value OUTPUT 15-Cell Matrix
  Discount Rate (Horizontal)
Margin of Safety 10.00% 11.00% 12.00%
20% Premium $26.84 $23.48 $20.87
10% Premium $24.60 $21.53 $19.14
Intrinsic Value $22.37 $19.57 $17.40
10% Discount $20.13 $17.61 $15.66
20% Discount $17.89 $15.66 $13.92

 

Source: Dividend Monk Toolkit Excel Calculation Spreadsheet

Considering the DDM, the stocks seems quite undervalued. I guess this is linked with its risk level. SSW meets my 5th principle.

Principle #6: The Rationale Used to Buy is Also Used to Sell

I’ve found that one of the biggest investor struggles is to know when to buy and sell his holdings. I use a very simple, but very effective rule to overcome my emotions when it is the time to pull the trigger. My investment decisions are motivated by the fact that the company confirms or not my investment thesis. Once the reasons (my investment thesis) why I purchase shares of a company  are not valid anymore, I sell and never look back.

Investment thesis

An investment in SSW is an investment in future profitable growth. The company has successfully grown its business and their revenues. It is now time to generate stronger margins to make sure the company can continue to pay its generous dividend.

I like their business model around long term contracts with important clients. As they are growing their fleet, it makes it difficult for their clients to switch and use another vessel provider. SSW is able to answer important workload needs and can support a growing global economy.

Risks

Speaking of growing global economy, this is probably one of the biggest risks SSW could face. It sells well when you show that your fleet is growing faster than the grass in your background, but it’s another story if the economy stalls and your fleet stays at port. Without making bad jokes, this could sink the company.

Therefore, I would remain cautious about this company and the investment thesis is not strong enough to support a strong buy.

Principle #7: Think Core, Think Growth

My investing strategy is divided into two segments: the core portfolio built with strong & stable stocks meeting all our requirements. The second part is called the “dividend growth stock addition” where I may ignore one of the metrics mentioned in principles #1 to #5 for a greater upside potential (e.g. riskier pick as well).

Having both segments helps me to categorize my investments into a “conservative” or “core” section or into a “growth” section. I then know exactly what to expect from it; a steady dividend payment or higher fluctuations with a greater growth potential.

In the light of my analysis, SSW would fit in a conservative portfolio as long as the other holdings show very strong fundamentals. This is the kind of company that can do well and pay a high yield if it is blended into a solid asset allocation portfolio. A big position in this company and you would be at risk.

Final Thoughts on SSW – Buy, Hold or Sell?

Overall, I think SSW can be attractive for income seeking investors. It is a good example of a company that looks attractive at first sight (interesting business model, steady revenues, high dividend yield), but is the kind of company that implies a certain amount of risk too. I think there are other very interesting companies with less risk you could pursue.

Disclaimer: I hold SSW in my DividendStocksRock portfolios.

Disclaimer: The opinions and the strategies of the author are not intended to ever be a recommendation to buy or sell a security. The strategy the author uses has worked for him and it is for you to decide if it could benefit your financial future. Please remember to do your own research and know your risk tolerance.