= Homework: Spreadsheet Project Question 14, P8-13 (nimi.. Part 1 of 1 HW Score: 2%, 2 of 100 points Points: 0 of 6 Save Portfolio return and standard deviation Personal Finance Problem Jamio Wong is thinking of building an investment portfolio containing two ocks, Land M. Stock L wil represent 40% of the dollar value of the portfolio, and stock M wil account for the other 60% The historical returns over the next years, 2013-2018, for each of these stocks are shown in the following table: B a Calculate the actual portfolio rotum for each of the years b. Calculate the expected value of portfolio ratums, gaver the B-year period. c. Calculate the standard deviation of expected portfolio returns, cover the 5-year period. d. How would you characterize the comelation of returns of the two stocks Land M? e. Discuss any benefits of diversification achieved by Jamie through creation of the portfolio 1. The actual portfolio return for year 2013! %. (Round to two decimal places.) Data table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Year 2013 2014 2015 2016 2017 2018 Expected return Stock L Stock M 15% 22% 16% 20% 17% 18% 19% 16% 21% 14% 23% 12% Print Done