x] A Calculating yields - Excel ? 5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial - 12 A A % Paste B I U Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font C3 fx Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per A B D E F G H I J K LA 1 2 3 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 $88. What was the dividend yield? The capital gains yield? 4 5 6 7 Initial price Dividend paid $ Ending share price $ A A A 79 1.45 88 8 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 Dividend yield 14 15 Capital gains yield 16 17 18 19 Sheet1 READY HE 100% Attempt(s) Hint