Answered You can hire a professional tutor to get the answer.
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}...