PLEASE SHOW EXCEL FORMULAS so I can learn to do this problem.

Problem 6-13 Historical Realized Rates of Return Stocks A and B have the following historical returns: FA Year 2012 2013 2014 2015 2016 2012 2013 2014 -5.25 33.00 a. Calculate the average rate of return for each stock during the 5-year period. Round your answers to two decimal places. Stock A % Stock B 2015 2016 Average return -20.30% % Std. Dev. 30.00 15.25 b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate of return on the portfolio in each year? What would have been the average return on the portfolio during this period? Round your answers to two decimal places. Year Portfolio -Select- % % rA % % % % -12.80% % TB 23.80 34.90 c. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places. % -14.60 21.40 rB Portfolio % d. If you are a risk-averse investor then, assuming these are your only choices, would you prefer to hold Stock A, Stock B, or the portfolio?

Problem 6-13 Historical Realized Rates of Retum Stocks A and B have the following historical returns: a. Calculate the average rate of return for each stock during the 5 -year period. Round your answers to two decimal places. Stock A % % b. Assume that someone held a portfolio consisting of 50% of Stock A and 50\% of Stock B. What would have been the realized rate of return on the portfolio in each year? What would have been the average return on the portfolio during this period? Round your answers to two decimal places. c. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places. d. If you are a risk-averse investor then, assuming these are your only choices, would you prefer to hold Stock A, Stock B, or the portfolio