If you're a fan of the Dow Jones Industrial Average, then you know that it's been awhile since it crossed a major milestone. In fact, on May 6, 2006, it had been seven years since the Dow first passed the 11,000 mark.
On October 19, 2006, the Dow finally crossed the 12,000 mark roughly seven years and five months after reaching 11,000. Below is an article written using the tools and techniques described elsewhere on this website. While our prediction of June 2007 did not come true, the techniques described in this article still serve as a useful example of the thought process an analyst should go through when solving this type of problem.
Before we get to the prediction of when the Dow will pass the 12,000 mark, let's briefly discuss what we're not going to talk about. We're not going to discuss momentum or charting in our version of the Dow at 12,000. Our prediction is going to be made based on fundamental data: earnings per share, P/E ratios, and growth in earnings.
In fact, the prediction we're going to share isn't even ours. We're going to leverage the information that stock analysts and industry experts publish to the marketplace to figure out when they believe the Dow is going to pass the 12,000 mark.
Calculating the DJIA is very straightforward. Only three bits of data are needed to do the calculation:
The DJIA is calculated by multiplying each of the stock prices times the DJIA Divisor and summing the results.
The Dow Jones Divisor is a mechanism used to preserve the historical trending of the averages. When it was first developed, the DJIA was computed by adding up all the prices of the underlying stocks. This method worked well until stock splits began occurring or when the components themselves started to change.
The Divisor was developed to normalize for stock splits and companies that entered and exited the DJIA. Each time a stock in the Dow splits, or a new company is introduced into the average, the Divisor changes. By introducing a Divisor into the calculation, the DJIA could make each transition smoother, and more meaningful, by preserving the numerical history of the Dow.
Once we grabbed our list of the companies making up the Dow, we pulled the earnings estimates the analysts made for year-end 2006. We also wanted to know what the earnings growth rate was for next year - 2007. By using these two values, we could derive the earnings estimates for both 2006 and 2007.
This information, along with the forward P/E ratio for each company appears in the table below:
|Company Name||2006 Earnings Estimate||EPS Growth Next Yr||2007 EPS||Forward Year P/E|
|American Express Company||2.96||12.6||3.33||18.2|
|Boeing Company, The||3.43||26.0||4.32||21.4|
|DU PONT DE NEMOURS||2.61||14.5||2.99||15.7|
|Home Depot, Inc.||3.08||12.5||3.47||13.7|
|Honeywell International Inc.||2.47||17.1||2.89||16.9|
|International Business Machines Corp.||5.80||9.2||6.33||13.8|
|Johnson & Johnson||3.70||9.5||4.05||15.5|
|JPMorgan Chase & Co.||3.38||13.0||3.82||12.3|
|MERCK AND CO INC||2.33||2.4||2.39||15.1|
|The Coca-Cola Company||2.28||8.8||2.48||18.3|
|The Walt Disney Company||1.45||11.3||1.61||19.4|
|Wal-Mart Stores, Inc.||2.92||13.8||3.32||15.5|
If we want to predict the future price of a stock, we need to multiply the future earnings per share by the P/E ratio. In this example, we are using the forward P/E because this is where analysts think the P/E ratio for each company will be a year from now.
Finally, if we take those projected stock prices and divide by the Dow Divisor, then we can see each company's contribution to the Dow Jones Industrial Average. By adding that information together, we can see where the analysts think the Dow is heading.
|Company Name||YE Price 2006||YE Price 2007||DJIA 2006||DJIA 2007|
|American Express Company||53.87||60.66||431.21||485.55|
|Boeing Company, The||73.40||92.49||587.54||740.30|
|DU PONT DE NEMOURS||40.98||46.92||328.00||375.56|
|Home Depot, Inc.||42.20||47.47||337.75||379.97|
|Honeywell International Inc.||41.74||48.88||334.13||391.26|
|International Business Machines Corp.||80.04||87.40||640.67||699.61|
|Johnson & Johnson||57.35||62.80||459.05||502.66|
|JPMorgan Chase & Co.||41.57||46.98||332.78||376.04|
|MERCK AND CO INC||35.18||36.03||281.62||288.38|
|The Coca-Cola Company||41.72||45.40||333.98||363.37|
|The Walt Disney Company||28.13||31.31||225.16||250.61|
|Wal-Mart Stores, Inc.||45.26||51.51||362.28||412.27|
|Dow Jones Industrial Average||11,018.49||12,490.48|
The Dow Jones Divisor at the time of writing was 0.12493117. To develop this prediction we also had to make one slight adjustment to the General Motors information. Because their EPS was negative in 2006, this throws the forward P/E ratio out of whack. We substituted their 5-year average P/E ratio to compute their stock price in 2007.
Individuals interested in learning more about some of the terms used in this calculation are encouraged to read the topic: understanding financial ratios.
We turned to the experts for their opinions and estimates to answer this question. Anyone thinking the Dow is going to hit 12,000 in 2006 is in the minority. The analysts predict very little movement in the Dow.
According to the experts, the Dow is going to hit 12,490 by year end in 2007. A reasonable guess is June 2007. We think this method is as realistic, and accurate, as any other we've seen published.
About the Author - Dow Jones Industrial Average at 12,000