Please solve by using the cell references in the formula, not hard coding the nu

Question

Please solve by using the cell references in the formula, not hard coding the numbers in. Thank you!

Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of S71. What was the total return? What was the dividend yield? The capital gains yield? Initial price Dividend paid Ending share price $ 79 1.45 S 71 Complete the following analysis. Do not hard code values in your calculations. Total return Dividend yield Capital gains yield

Explanation / Answer

Dividend yield = dividend /initial price per share

=1.45/79

=1.835%

Capital gain yield =( Ending price - beginning price)/ beginning price

=( 71-79)×100 /79

= - 10.126%

Total return = dividend yield + capital gains yield

= 1.835% - 10.126%

= -8.291%

Ask if doubt arises . thankyou

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---