Please see and use the attached spreadsheet! Thank you!
Intel Corporation is a leading manufacturer of semiconductor chips. The firm was incorporated in 1968 in Santa Clara, California, 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 there in some question whether the firm should be evaluated as a high-growth company or stable-growth company from now on. 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, Inc.'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)are found in Exhibit 6-7.1 (attached spreadsheet)
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 a 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 Intel'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 five years at 12% and from Year 6 forward at a constant rate.)
This solution is comprised of answers related with rate of growth and estimated value per share.