excel please

A B C D E F G Suppose a stock had an initial price of $74 per share, paid a dividend of $1.65 per share during the year, and had an ending share price of $83. Compute the total percentage return. What was the dividend yield? 2 The capital gains yield? 3 4 Input area: 5 6 Initial price $74 7 Dividend paid $1.65 8 Ending share price $61 9 10 (Use cells A6 to B8 from the given information to complete this question.) 11 12 Output area: 13 14 Total return 15 Dividend yield U G H E 5 6 Initial price $74 7 Dividend paid $1.65 8 Ending share price $61 9 10 (Use cells A6 to B8 from the given information to complete this question.) + 12 Output area: 13 14 Total return 15 Dividend yield 16 Capital gains yield 17 18 19 20 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your 21 Nothing in this area will be graded, but it will be submitted with your assignment