In: Finance
Find the average return and standard deviation of an equal-weighted (1/3 in each) portfolio consisting of the three stocks. Explain how a portfolio’s standard deviation can be lower than any of the three stock’s standard deviations that make up that portfolio. Year LAX return UWL return WIS return 2013 5% 2% 10% 2014 10% 4% 12% 2015 -3% 3% 8% 2016 12% -2% 9% 2017 1% 5% 15%
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -