REALIZED RATES OF RETURN

NEED TO BE DONE USING EXCEL!!!!

Stocks A and B have the following historical returns:

Year	Stock A's Returns, rA	Stock B's Returns, rB
2011	- 24.00%	- 12.10%
2012	20.50	23.70
2013	17.75	31.90
2014	- 5.25	- 11.70
2015	25.75	2.95

1. Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. % Calculate the average rate of return for stock B during the period 2011 through 2015. Round your answer to two decimal places. %
2. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would the realized rate of return on the portfolio have been each year? Round your answers to two decimal places. Enter a negative answer with a minus sign.

   Year	Portfolio
   2011	%
   2012
   2013
   2014
   2015

   What would the average return on the portfolio have been during this period? Round your answer to two decimal places. %
3. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places.

   	Stock A	Stock B	Portfolio
   Standard Deviation	%	%	%

4. Calculate the coefficient of variation for each stock and for the portfolio. Round your answers to two decimal places.

   	Stock A	Stock B	Portfolio
   CV

5. Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio?

NEED TO BE DONE USING EXCEL!!!!