*******ANSWER MUST BE WRITTEN AS AN EXCEL FORMULA ONLY*******

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? 4 Initial price Dividend paid Ending share price S 79 1.45 71 6 10 Complete the following analysis. Do not hard code values in your calculations 12 13 14 15 16 17 18 Total return Dividend vield Capital gains yield