Dow Jones Industrial Average at 12,000

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.

Update to the Dow at 12,000

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.

Predicting the Dow at 12,000

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.

The Dow Jones Industrial Average

Calculating the DJIA is very straightforward. Only three bits of data are needed to do the calculation:

• The companies that make up the Dow, also known as the components of the Dow Jones Industrial Average
• The stock prices for each of these components
• The Dow Jones Divisor

The DJIA is calculated by multiplying each of the stock prices times the DJIA Divisor and summing the results.

The Dow Jones Divisor

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.

DJIA Prediction

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:

DJIA Earning Estimates and Forward P/E Ratio

 Company Name 2006 Earnings Estimate EPS Growth Next Yr 2007 EPS Forward Year P/E 3M Company 4.59 11.0 5.09 15.9 AIG-AMERIC.INT.GRP 3.57 56.2 5.58 18.3 Alcoa Inc. 2.15 4.6 2.25 14.1 ALTRIA GROUP 5.27 7.7 5.68 13.7 American Express Company 2.96 12.6 3.33 18.2 AT&T Inc. 1.99 9.5 2.18 14.1 Boeing Company, The 3.43 26.0 4.32 21.4 Caterpillar Inc. 4.95 13.1 5.60 15.1 Citigroup Inc. 4.23 9.7 4.64 10.9 DU PONT DE NEMOURS 2.61 14.5 2.99 15.7 ExxonMobil Corporation 5.82 (3.4) 5.62 10.5 GENERAL ELECTRIC 1.98 13.3 2.24 16.7 GENERAL MOTORS (0.25) 796.5 1.77 (75.5) Hewlett-Packard Company 1.94 13.5 2.20 17.1 Home Depot, Inc. 3.08 12.5 3.47 13.7 Honeywell International Inc. 2.47 17.1 2.89 16.9 Intel Corporation 1.24 18.5 1.47 16.3 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 MCDONALDS CORP 2.18 7.9 2.35 16.0 MERCK AND CO INC 2.33 2.4 2.39 15.1 Microsoft Corporation 1.33 15.0 1.53 20.3 Pfizer Inc. 2.01 5.8 2.13 13.1 PROCTER GAMBLE 2.62 15.1 3.02 22.7 The Coca-Cola Company 2.28 8.8 2.48 18.3 The Walt Disney Company 1.45 11.3 1.61 19.4 UNITED TECHNOLOGIE 3.52 12.3 3.95 16.4 Verizon Communications 2.52 3.1 2.60 13.3 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.

DJIA Future Stock Prices and Contributions

 Company Name YE Price 2006 YE Price 2007 DJIA 2006 DJIA 2007 3M Company 72.98 81.01 584.17 648.43 AIG-AMERIC.INT.GRP 65.33 02.05 522.94 816.83 Alcoa Inc. 30.32 31.71 242.65 253.82 ALTRIA GROUP 72.20 77.76 577.91 622.41 American Express Company 53.87 60.66 431.21 485.55 AT&T Inc. 28.06 30.72 224.60 245.93 Boeing Company, The 73.40 92.49 587.54 740.30 Caterpillar Inc. 74.75 84.54 598.29 676.67 Citigroup Inc. 46.11 50.58 369.06 404.86 DU PONT DE NEMOURS 40.98 46.92 328.00 375.56 ExxonMobil Corporation 61.11 59.03 489.15 472.52 GENERAL ELECTRIC 33.07 37.46 264.67 299.88 GENERAL MOTORS 18.88 21.77 151.08 174.26 Hewlett-Packard Company 33.17 37.65 265.54 301.39 Home Depot, Inc. 42.20 47.47 337.75 379.97 Honeywell International Inc. 41.74 48.88 334.13 391.26 Intel Corporation 20.21 23.95 161.79 191.72 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 MCDONALDS -CORP 34.88 37.64 279.19 301.25 MERCK AND CO INC 35.18 36.03 281.62 288.38 Microsoft Corporation 27.00 31.05 216.11 248.53 Pfizer Inc. 26.33 27.86 210.76 222.99 PROCTER GAMBLE 59.47 68.45 476.05 547.94 The Coca-Cola Company 41.72 45.40 333.98 363.37 The Walt Disney Company 28.13 31.31 225.16 250.61 UNITED TECHNOLOGIE 57.73 64.83 462.08 518.91 Verizon Communications 33.52 34.55 268.28 276.59 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.

When Will the Dow Hit 12,000?

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