Transcribed Image Text
You have been given the following return data on 3 assets; A, Band C over the period of 2013 -2016.Expected returnYearAsset AAsset BAsset C2013161714201417161520151815162016191417Using these assets, you have isolatedthree investment alternatives:OptionInvestment1100% of asset A250% of asset A and 50% of asset B350% of asset A and 50% of asset CCalculate the portfolio return over the four year period ofeach of the three alternatives.Calculate the standard deviation of returns over the four yearperiod for each of the three alternatives.You have been given the following return data on 3 assets; A, Band C over the period of 2013 -2016.Expected returnYearAsset AAsset BAsset C2013161714201417161520151815162016191417Using these assets, you have isolatedthree investment alternatives:OptionInvestment1100% of asset A250% of asset A and 50% of asset B350% of asset A and 50% of asset CCalculate the portfolio return over the four year period ofeach of the three alternatives.Calculate the standard deviation of returns over the four yearperiod for each of the three alternatives.PLEASE STATE ALL THE FORMULAS CLEARLY AND DUN ANS IN EXCEL.