Need to organize answers and show work in Excel
1. An issue of common stock that paid a dividend yesterday of $3.70, and is currently priced at $60 per share.
Calculate this stock's current dividend yield for the coming year if investors anticipate the company's dividends to grow for the foreseeable future at a rate of 5%. _____________
2. An issue of common stock that paid a dividend yesterday of $2.10, and is currently priced at $79 per share.
Calculate this stock's capital gains yield if investors anticipate the company's dividends to grow for the foreseeable future at a rate of 6%. _____________
3. An issue of common stock that paid a dividend yesterday of $4.90, and is currently priced at $60 per share.
Calculate this stock's total rate of return if investors anticipate the company's dividend to grow for the foreseeable future at a rate of 5.6%. _____________.