Answer in Excel Format and fill in all the blanks missing in the input section.

Calculating Returns [L01] 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 $61. Compute dollar total return, dividend income, and capital gain (or loss). Compute the total percentage return, dividend yield, and capital gains yield. Input area: Output area