Click to see additional instructions

Note: The following question can easily answered on Excel, however, you will not have Excel available to you when you write your exam! The value of each individual question on your exam is worth $5x$ more toward your course grade than this question. I highly recommend that you use this as an opportunity to practice these calculations.

Suppose that an investment has yielded the following historical annual returns for the past $5$ years:

Year $1=38\%$

Year $2=18\%$

Year $3=-9\%$

Year $4=20\%$

Year $5=1\%$

Express your answers to the following questions in percentage terms $($eg$.46\mathrm{.}7\%)$ and round according to the instructions.

What is the arithmetic average annual return for the past $5$ years?

$\%($Round your answer to $1$ decimal place$)$

What is the geometric average rate of return for the past $5$ years $($CAGR$)?$

$\%($Round your answer to $2$ decimal places$).$

What is the standard deviation in returns for the past $5$ years?

$\%($Round your answer to $1$ decimal place$).$