(Excel Formulas) You are considering an investment in the stock market and have identified two potential stocks (OMG and BRB) to purchase. The historical returns for the past five years are shown in the table below. A B D OMG BRB Portfolio 1 Year Return Return Return 2 2013 12.35% 22.28% 18.31% 3 2014 17.01% 8,75% 4 2015 13.18% 17.78% 15.94% 5 2016 8.51% 19.66% 15.20% 6 2017 16.85% 4.03% 9.16% 7 8 Average Retum 13.58% 14.50% 9 Standard Deviation 3.53% 7.76% 10 Covariance Type in the Excel formulas you should enter in the cells with bold borders in the table above to solve the following problems a. Calculate the covariance between the two stocks. (2 Points) For Questions b, c, and d, suppose that you own a portfolio consisting of 40% in OMG and 60% in BRB over the past five years. (Type in Excel formulas) b. Calculate the return of the portfolio in 2014. (2 Points) Calculate the average return of the portfolio over the past five years. (2 Points) d. Use two methods/formulas to calculate the standard deviation of portfolio returns over the past five years. (4 points) For Questions e and f, suppose that you have identified three possible future scenarios. The probability distribution and possible future stock returns are presented in the table below. You are now considering investing in a portfolio consisting of 40% in OMG and 60% in BRB. (Type in Excel formulas) B 11 Scenario Probability 12 Recession 20% 13 Normal 40% 14 Expansion 40% 15 16 Expected Return 17 Expected Standard Deviation OMG Return 30% 3% -15% D BRB Return -10% 5% 20% E Portfolio Return 6.00% 4.20% 6.00% 1.20% 2.72% 8% 1.26% e. Calculate the expected return of the portfolio (3 Points) 1. Calculate the expected standard deviation of portfolio returns. (4 points)