Suppose a stock had an initial price of $$74$ per share,$$paid a dividend of $$1\mathrm{.}65$ per share during the year, and had an ending share price of$$$$83.$ Compute the total percentage return. What was the dividend yield? The capital gains yield?

Input area:

Initial price $$74$

Dividend paid $$1\mathrm{.}65$

Ending share price $$61$

$($Use cells A$6$ to B$8$ from the given information to complete this question.$)$

Output area:

Total return $($SOLVE IN EXCEL FORMULA$)$

Dividend yield $($SOLVE IN EXCEL FORMULA$)$

Capital gains yield $($SOLVE IN EXCEL FORMULA$)$