Using a Spreadsheet to Calculate Stock Returns: At the beginning of the year, you purchased a share of stock for $50. Over the year the dividends paid on the stock were $4.50 per share. Calculate the return if the price of the stock at the end of the year is $40,

$48, $50, and $55. (LG 8-5)

Price at Beginning of Year Dividends Price at End of Year

⇒

The Return Is

$50 $4.50 $40 −11.00%

50 4.50 48 5.00 50 4.50 50 9.00 50 4.50 55 19.00 AppendixLO1