XD Calculating yields - Excel ? X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 8 ES - Calibri 11 - A A % Paste BIU- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 X A B D E F G H 1 J 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 $ 79 1.45 88 8 9 10 11 12 Complete the following analysis. Do not hard code values in your calculations. 13 Dividend yield 14 15 Capital gains yield 16 17 18 19 Sheet1 READY + 100% Attempt(s) Hint