Excel Activity: Evaluating Risk and Return

shown here. Stock prices are reported for December $31$ of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends.

negative values, if any.

Download spreadsheet Ch$02$ P$15$ Build a Model$-3768$fd$.$xlsx

already included in the index. Also, you cannot calculate the rate of return for $2016$ because you do not have $2015$ data.$)$ Round your answers to two decimal places.

answers to two decimal places.