Company A

Monthly stock price $62.13999939

Monthly Holding Period Return .0311982

Dividends $0.39

Company B

Monthly stock price $115.21

Monthly Holding Period Return 0.0351302

Dividends $0.80

Using the Gordon Dividend Model, calculate the cost of equity for both companies. Use dividend data from the past 10 years when estimating the constant growth rate for future dividends. Note: This is not a supernormal growth dividend model situation.

Please show work in excel