Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $71. What was the total return? What was the dividend yield? The capital gains yield?

Initial price $79

Dividend paid = 1.45

Ending share price = $71 Complete the following analysis. Do not hard code values in your calculations.

Using Excel sheet