NEED THE ***********FORMULA ****************AS THE ANSWER. Thank you

Calculating Returns and Yields Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW B I u EE A Alignment Number Conditional Format as Cell Cells Editing Paste Formatting Table Styles Font Styles Clipboard A1 A C 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 79 Dividend paid 1.45 Ending share price 71 Complete the following analysis. Do not hard code values in your calculations. Total return 14 Dividend yield 15 Capital gains yield 17 20 Sheet1 100%