I NEED HELP WITH C AND D.

Using the Yahoo! Finance Web site (https://finance.yahoo.com) get the current price and five-year dividend history for Intel Corporation (Nasdaq:INTC). Use the same procedure as in the Internet Exercise of Chapter 9 to gather this data. In addition, get the beta for INTC from its Summary page on Yahoo! Finance, and the five-year U.S. Treasury yield (ticker: AFVX). Note that you will need to divide the index value by 100 to get the yield. a. Calculate the annualized dividend growth rate from the five-year dividend history using the same procedure as in Chapter 9. b. Using the stock's current price, dividend, and growth rate, calculate the cost of retained earnings for INTC. C. Assuming that the average market return over the next five years will be 10%, calculate the cost of retained earnings using the CAPM. Use the actual beta and five-year Treasury yield (risk-free rate) in the model. d. To get your final estimate of the cost of retained earnings, simply average the results from parts b and c. D E F G H J 1 2 2018 0 m 3 2020 0.33 4.76% 2019 0.315 5.00% 0.3 2017 0.273 5.00% 4 9.89% 5 Year Dividend per Share Yearly Growth Rate # of Years Annualized Growth Rate Stock's current price Forward Dividend & Yield 6 2021 0.348 5.45% 5 6.02% $50.76 $1.39 2.7% 0.51 5.44% 7 8 9 10 A Intel Corporation Date Dividends % Change 2/3/2017 0.26 0% 5/3/2017 0.273 5% 8/3/2017 0.273 0% 11/6/2017 0.273 0% 2/6/2018 0.3 10% 5/4/2018 0.3 0% 8/6/2018 0.3 0% 11/6/2018 0.3 0% 2/6/2019 0.315 5% 5/6/2019 0.315 0% 8/6/2019 0.315 0% 11/6/2019 0.315 0% 2/6/2020 0.33 5% 5/6/2020 0.33 0% 8/6/2020 0.33 0% 11/5/2020 0.33 0% 2/4/2021 0.348 5% 5/6/2021 0.348 0% 8/5/2021 0.348 0% 11/4/2021 0.348 0% Beta Cost of Retained Earnings 11 b. Pay per share 2021 1.392 2020 1.32 2019 1.26 2018 1.20 2017 1.092 Cost of Retained Earnings (CAPM) c. 12 13 14 15 16 17 18 19 20 21 22 a. . Using the Yahoo! Finance Web site (https://finance.yahoo.com) get the current price and five-year dividend history for Intel Corporation (Nasdaq:INTC). Use the same procedure as in the Internet Exercise of Chapter 9 to gather this data. In addition, get the beta for INTC from its Summary page on Yahoo! Finance, and the five-year U.S. Treasury yield (ticker: AFVX). Note that you will need to divide the index value by 100 to get the yield. a. Calculate the annualized dividend growth rate from the five-year dividend history using the same procedure as in Chapter 9. b. Using the stock's current price, dividend, and growth rate, calculate the cost of retained earnings for INTC. C. Assuming that the average market return over the next five years will be 10%, calculate the cost of retained earnings using the CAPM. Use the actual beta and five-year Treasury yield (risk-free rate) in the model. d. To get your final estimate of the cost of retained earnings, simply average the results from parts b and c. D E F G H J 1 2 2018 0 m 3 2020 0.33 4.76% 2019 0.315 5.00% 0.3 2017 0.273 5.00% 4 9.89% 5 Year Dividend per Share Yearly Growth Rate # of Years Annualized Growth Rate Stock's current price Forward Dividend & Yield 6 2021 0.348 5.45% 5 6.02% $50.76 $1.39 2.7% 0.51 5.44% 7 8 9 10 A Intel Corporation Date Dividends % Change 2/3/2017 0.26 0% 5/3/2017 0.273 5% 8/3/2017 0.273 0% 11/6/2017 0.273 0% 2/6/2018 0.3 10% 5/4/2018 0.3 0% 8/6/2018 0.3 0% 11/6/2018 0.3 0% 2/6/2019 0.315 5% 5/6/2019 0.315 0% 8/6/2019 0.315 0% 11/6/2019 0.315 0% 2/6/2020 0.33 5% 5/6/2020 0.33 0% 8/6/2020 0.33 0% 11/5/2020 0.33 0% 2/4/2021 0.348 5% 5/6/2021 0.348 0% 8/5/2021 0.348 0% 11/4/2021 0.348 0% Beta Cost of Retained Earnings 11 b. Pay per share 2021 1.392 2020 1.32 2019 1.26 2018 1.20 2017 1.092 Cost of Retained Earnings (CAPM) c. 12 13 14 15 16 17 18 19 20 21 22 a