Suppose a stock had an initial price of $52 per share, paid a dividend of $1.00 per share during the year, and had an ending share price of $46.

Compute the percentage total return.(Do not round intermediate calculations. Negative amount should be indicated by a minus sign. Enter your answer as a percent rounded to 2 decimal places (e.g., 32.16).)

What was the dividend yield and the capital gains yield?(Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answers as a percent rounded to 2 decimal places (e.g., 32.16).)

Can you please show me how to solve the problem via Excel so I can learn?