P3.14 Peter Tanaka is interested in starting a stock portfolio. He has heard many financial reporters talk about the Dow Jones Industrial Average (DJIA) as being a proxy for the overall stock market. From visiting various online investment sites, Peter is able to track the variability in the Dow. Peter would like to develop an average or index that will measure the price performance of his selected portfolio over time. He has decided to create a price-weighted index, similar to the Dow, where the stocks are held in proportion to their share prices. He wishes to form an index based on the following 10 high-quality stocks and has designated October 13, 1977, as the base year. The number of shares outstanding has remained constant over the time period 1977 through 2011. The implication is that the closing stock prices will behave just like the closing market values. Given the data below, create a spreadsheet to model and analyze the use of an index. Prices Stocks 10/13/2011 10/13/2007 10/13/1977 ABCDEFGHI 45 12 52 50 55 9 15 37 37 37 65 66 67 36 42 48 26 35 43 75 68 59 35 38 30 67 74 81 84 88 92 Questions

a. The divisor is 1.00 on October 13, 1977, 0.75 on October 13, 2007, and 0.85 on October 13, 2011. Using this information and the data supplied above, calculate the market average,

using the same methodology used to calculate the Dow averages, on each of the three dates- October 13, 1977, 2007, and 2011.

b. The DJIA is the most widely cited stock market indicator, yet there are criticisms of the model. One criticism is that the higher-priced securities in the portfolio will impact the Dow more than the relatively lower-priced stocks. Assume that Stock J increases by 10%. Recalculate the market averages on each of the three dates.

c. Next, assume Stock J is back to its original level and Stock B increases by 10%. Recalculate the market averages on each of the three dates. Compare your findings in all three scenarios. Do you find support for the criticism of the Dow? Explain.