Intel Corporation is a leading manufacturer of semiconductor chips. The firm was incorporated in 1968 in Santa Clara, CA and represents one of the greatest success stories of the computer age. Although Intel continues to grow, the industry in which it operates has matured so that there is some question as to whether the firm should continue to be evaluated as a high or stable growth company. For example, in December of 2007 the firm's shares were trading for $20.88 which represented a price-earnings ratio of only 17.61. Compared to Google Corporation's price-earnings ratio of 53.71 on the same date it would appear that the decision has already been made by the market. Intel's expected earnings for 2007 are $1.13 per share and its payout ratio is 48%. Furthermore, selected financial data for the sector, industry, and seven of the largest firms (including Intel) is found below: See excel template a. Is Intel's current stock price of $20.88 reasonable in light of its sector, industry, and comparison firms? b. Intel has a beta coefficient equal to 1.66. If we assume that the risk free rate of 5.02% and a market risk premium of 5%, what is your estimate of the required rate of return for Intel's stock using the CAPM? What rate of growth in earnings is consistent with Intel's policy of paying out 48% of earnings in dividends and the firm's historical return on equity? Using your estimated growth rate, what is the value of Emerson's shares using the Gordon (single-stage) growth model? Analyze the reasonableness of your estimated value per share using the Gordon model. c. Using your analysis in part b above, what growth rate is consistent with Intel's current share price of $20.88? d. Analysts expect Intel's earnings to grow at a rate of 12% per year over the next five years. What rate of growth from year 6 forward (forever) is needed to warrant Intel's current stock price (use your CAPM estimate of the required rate of return on equity)? (Hint: use a two stage growth model where Intel's earnings grow for 5 years at 12% and for years 6 forward at a constant rate.)

Intel Corporation is a leading manufacturer of semiconductor chips. The firm was incorporated in 1968 in Santa Clara, CA and represents one of the greatest success stories of the computer age. Although Intel continues to grow, the industry in which it operates has matured so that there is some question as to whether the firm should continue to be evaluated as a high or stable growth company. For example, in December of 2007 the firm's shares were trading for $20.88 which represented a price-earnings ratio of only 17.61. Compared to Google Corporation's price-earnings ratio of 53.71 on the same date it would appear that the decision has already been made by the market. Intel's expected earnings for 2007 are $1.13 per share and its payout ratio is 48%. Furthermore, selected financial data for the sector, industry, and seven of the largest firms (including Intel) is found below: See template tab 8-7 a. Is Intel's current stock price of $20.88 reasonable in light of its sector, industry, and comparison firms? b. Intel has a beta coefficient equal to 1.66. If we assume that the risk free rate of 5.02% and a market risk premium of 5%, what is your estimate of the required rate of return for Intel's stock using the CAPM? What rate of growth in earnings is consistent with Intel's policy of paying out 48% of earnings in dividends and the firm's historical return on equity? Using your estimated growth rate, what is the value of Emerson's shares using the Gordon (single-stage) growth model? Analyze the reasonableness of your estimated value per share using the Gordon model. c. Using your analysis in part b above, what growth rate is consistent with Intel's current share price of $20.88? d. Analysts expect Intel's earnings to grow at a rate of 12% per year over the next five years. What rate of growth from year 6 forward (forever) is needed to warrant Intel's current stock price (use your CAPM estimate of the required rate of return on equity)? (Hint: use a two stage growth model where Intel's earnings grow for 5 years at 12% and for years 6 forward at a constant rate.) PROBLEM 8-9 Given Beta Dividend payout ratio EPS for 2007 Stock Price (12/07/06) Anticipated growth rate in EPS (5 years) Description Sector: Technology Industry: Semiconductor - Broad Line Intel Corp. Texas Instruments Inc. STMicroelectronics NV Advanced Micro Devices Inc. Analog Devices Inc. Maxim Integrated Products Inc. National Semiconductor Corp. 1.66 48% 1.13 20.88 12% $ $ = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output Market Cap 5344.81B 252.89B 120.51B 44.62B 16.35B 11.79B 11.48B 10.28B 8.04B P/E Return on Equity Long-term Debt % Dividend Yield % to Equity 27.716 14.77% 1.90% 0.691 19.9 16.20% 1.30% 0.096 17.622 19.63% 1.90% 0.064 11.08 22.94% 0.50% 0.004 24.959 7.81% 0.70% 0.209 21.152 12.61% 0.00% 0.138 22.667 15.42% 1.90% NA 23.025 16.93% 1.90% NA 18.049 25.67% 0.60% 0.012 Solution Intel Comparison to Industry a. P/E ROE Dividend Yield LTD to Equity Price to Book Net Profit Margin Price to Cash Flow b. Estimated cost of equity Estimated growth rate DCF Estimate of Share Price c. Imputed growth rate d. Estimated future dividends Year 2007 $ 2008 2009 2010 2011 Future growth rate Value of Intel Shares (2-stage) 2007-2011 2011 and beyond Estimated equity value Solution Legend Earnings 1.13 Dividends The growth rate in earnings that makes the value of Intel's shares $20.88 is found using Goal Seek. Price to Book Value Net Profit Margin 5.588 10.39% 3.42 15.50% 3.437 18.72% 3.71 18.67% 1.764 8.24% 2.088 10.13% 3.342 21.48% 3.681 21.39% 4.481 22.18% Price To Free Cash Flow 55.435 193.3 121.039 -5577.55 -11.219 -58.916 311.392 NA 154.483