Stocks M and W have the following historical returns:

Year Stock M Stock W
2007 -19% -13.50%
2008 33% 22.75%
2009 16% 34.50%
2010 -0.30% -7.83%
2011 27% 23.30%

a. Calculate the average rate of return for each stock during the 5-year period.
b. Assume that you are planning to hold a portfolio consisting of 30% of Stock M and 70% of Stock W. What is the realized rate of return on the portfolio in each year?
c. What is the average return on the portfolio for the 5 year period?
d. What is the standard deviation of returns for each stock and for the portfolio?
e. Calculate the coefficient of variation for each stock and for the portfolio?
f. If you are a risk averse investor, assuming these are your only choices, would you prefer to hold Stock M, Stock W, or the portfolio? Why?

Solution Summary

Solution depicts the steps to calculate average return, standard deviation and coefficient of variation of the given portfolio. Calculations are carried out with the help of suitable built-in formulas in MS Excel.

Statistics: Measures of central tendency - constructing confidence interval. 1.Given the data set. Values of X. 13,12,9,15,11,16,17,8,12,7,12. A. Calculate the ...

Statistics - 2.1 Calculate the most appropriate measures of ... 2.2 Calculate the most appropriate measures of dispersion for ... (b) Mean = This is calculated as the ...

... gives complete steps of calculating descriptive statistics...Calculate SS, variance, and standard deviation ... Tendency -- is a statistical measure that identifies ...

... It is calculated as ... You calculate it by taking the square of each value minus the mean ... You use the standard deviation a lot when doing statistical tests in order ...

... Again, when calculating the range, you want to start ... Once you've calculated the variance, the standard deviation ... In this case, we would calculate the standard ...

... df (as specified by your prof) and then compare the r you calculate to the ... If your calculated value is smaller than the table value, you fail to reject your ...

...Statistical area 02 03. ... a. Calculate the mean for worked hours worked per week. b.Compare the value of the mean with those you have already calculated for the ...

... can take a weighted approach to calculating the mean ... Using the weighted approach, calculate the average number ... these percentages have been calculated, how might ...

... Dinner we can calculate the weighted mean. ... The last figure that is calculated is the mode. ... and calculating the cost savings it make sense to buy an additional ...

... vs actual distance with some examples of how to calculate the numerical ... p and form that we can calculate the value ... 1 (this is the values we calculated from the ...