1. Using the Yahoo! Finance Web site (https:/ance.yahoo.corn) get the current price and ve-year dividend history for 5M Company. To gather this data. enter the ticker symbol (MMM) in the search box at the top of the page. and select 5m Company from the list. Record the cunent price from this page. Now. click on the Historical Data link. To get a table of previous dividends select Dividends Only in the Show list. set the Time Peritxi to five years prior to today's date, and click the Apply button. Click the Download Data link to download a file with this data. You may have the choice of either saving the file or opening it directly in Excel. It is easier to let it open in Excel. Otherwise. save the .csv (comma separated vari ables) file. and then open it with Excel. It shouldn't need any further processing. You now have the dividends in a worksheet. a. Because MMM pays dividends quarterly. for each quarter calculate the per centage change in the dividends. Now. calculate the compound quarterly growth rate of the dividends using the Gm function. b. Now. annualize the quarterly dividend growth rate. c. Calculate the intrinsic value of the stock using a 12% required rate of return and the calculated annual growth rate. Use the sum of the most recent l'our dividencb as D\". (1. Now assume that MMMs dividend growth rate will remain the same for the next ve years. and then fall to 75% of its current rate. What is the value of the stock using the two-stage dividend discount model? e. If the dividend grth rate begins declining immediater from the current level to its long-term rate over 20 years (15-year transition plus the initial 5 years). what is the value of the stock according to the H-Model? What is the value using the three-stage model? Use the same assumptions as in part d