Please show equation you would put into excel

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? 79 Initial price Dividend paid Ending share price 1.45 $ 71 Complete the following analysis. Do not hard code values in your calculations. Total return Dividend yield Capital gains yield