Question: Please do problems on excel showing the formulas. All three questions are together 1. Calculating Returns [LO1] Suppose a stock had an initial price of

![are together 1. Calculating Returns [LO1] Suppose a stock had an initial](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f8edf56b5fd_87766f8edf50eb53.jpg)
Please do problems on excel showing the formulas. All three questions are together
1. Calculating Returns [LO1] Suppose a stock had an initial price of $65 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $71. Compute the percentage total return. 2. Calculating Yields [LOL] In Problem 1, what was the dividend yield? The capital gains yield? 3. Return Calculations [L01] Rework Problems 1 and 2 assuming the ending share price is $58
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
