LUIGIC LIC LULII, HIC LIVIUCHu yici HU UICLOPIGI Youts y Ciu. Calculating Returns and Yields - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 % A A . BIU- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Font f B D E F G H 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 Dividend paid Ending share price 79 1.45 71 $ Complete the following analysis. Do not hard code values in your calculations. O