Wednesday, October 23, 2024

Using Simple Mathematical Calculations to Value Coke vs. PepsiCo

 1. In my recently released book, The Hidden Power of Rising Dividends, I described my 40-year journey into finding methods of valuing stocks.

2. My journey of valuation discovery was always about finding methods that worked, not just focusing on dividend investing, although for many companies, dividends are the best indicator.

3. Over the next few months, I am going to do a series of valuation comparisons of great companies of our country and the world. These comparisons will describe the various methods I have found to be helpful. The first two are Coke and Pepsi.

4. Coke and Pepsi are powerful brands that have won over our taste buds, grocery shelves, and portfolios. Most people are in one camp or the other, but these two companies are very similar in many ways. My blindfolded taste test can't tell them apart.

5. Since they are so dominant and so similar in their products and marketing, I have found that most people assume they are almost always efficiently priced and valued at about the same level. In this first look at the tools I have learned to use, a surprise may be in store for you.







 In valuing Coke and Pepsi, I am using a multi-stage correlation model. This model computes a correlation score, called R2, for eight different fundamental indicators for each company, such as earnings, dividends, sales, profit margin, GDP, etc., compared to changes in the company's annual stock prices. With both companies, the correlation, R2, between their annual dividends and stock prices is above 90%, and overrides the need to include any of the other fundamentals. Very simply, this means that over the last 15 years, the annual changes in the dividends for each company were able to explain 90% of the annual changes in its price. 

Next, look at each chart and note that stock prices are on the vertical axis and dividends per share are on the horizontal axis. The red line is the actual annual price over the last 15 years and the green line is the predicted price using the correlation formula. Here is where the model begins to talk. While these two companies are very similar in what they do, they are not similar in prospective valuation. PepsiCo's chart shows its current selling price of over $175.00 is well under its predicted price of $190.44. Coke's story is just the reverse. It is currently selling for over $68 per share, but its predicted price says it should sell for $63.74.

Remember, this analysis is pure math. It is not a deep analysis of each company's intrinsic value. This is just a statistically significant computation comparing the changes in each company's annual dividends with changes in their annual stock prices. Yet, with 90+% correlations for both companies, to ignore what the dividends are saying would be unwise. Indeed, these computations are saying Coke is over 15% more expensive than PepsiCo. A spread that wide would seem to favor PepsiCo at present. Next, however, we all know that the market always looks ahead. Next time I will share with you howe we can adjust the current valuations for a look into the future. In the meantime, let's just see how the the two stocks perform over the next few months.