Answered You can hire a professional tutor to get the answer.

QUESTION

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....

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?

Initial Price of stock Closing PriceDividend Capital gain Total Return Total return pe re cntage Capital gain vield Dividend vield $52$62 $1 Closing stock price - opening Stock52-52 toss» D34}...
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question