Select a dividend paying company. Use the previous 5+ years (20 quarters, dividends are paid quarterly, but typically only change annually so you will have 4 growth rates) to find the arithmetic and geometric average growth rate of dividends. Then use the current stock price, recent dividend, and geometric growth rate to find the firm’s discount rate. Excel sheets/tables are fine to illustrate the information, but should be accompanied with written work summarizing your findings. What is the stock’s cost of equity according to the SML (CAPM) method?
Show excel formulas-