Please show all Excel formulas used and Calculate the portfolio expected returns & standard deviations based on the portfolio weights (B35:B55 and C35:C55) and the five input items (B6:B10). You should have portfolio weights in increments of .05. The formula for variance of a two-asset portfolio is shown below as well.

Portfolio Variance =x+x7o3 + 2(xjX2P12002) A B D E F 1 2 3 Investment Opportunity Set 4 5 6 S&P 500 Annual Return 7 S&P 500 Standard Deviation 8 Stock Annual Return 9 Stock Standard Deviation 10 Correlation Coefficient 11 Input 0.10 0.20 0.06 0.10 0.01 12 31 32 33 34 35 Output Investment Opportunity Set Calculations Portfolio Portfolio Portfolio Portfolio Weight of Weight of Expected Standard S&P 500 Stock Return Deviation 0.00 1.00 0.05 0.95 0.10 0.90 0.15 0.85 36 37 38 39 0.20 0.80 40 0.25 0.75 41 0.30 0.70 42 0.35 0.65 43 0.40 0.60 0.55 0.45 44 45 0.50 0.50 46 0.55 0.45 47 0.60 0.40 0.35 48 49 50 51 0.65 0.70 0.75 0.80 0.85 0.90 0.95 1.00 52 0.30 0.25 0.20 0.15 0.10 0.05 0.00 53 54 55 56 57 Portfolio Variance =x+x7o3 + 2(xjX2P12002) A B D E F 1 2 3 Investment Opportunity Set 4 5 6 S&P 500 Annual Return 7 S&P 500 Standard Deviation 8 Stock Annual Return 9 Stock Standard Deviation 10 Correlation Coefficient 11 Input 0.10 0.20 0.06 0.10 0.01 12 31 32 33 34 35 Output Investment Opportunity Set Calculations Portfolio Portfolio Portfolio Portfolio Weight of Weight of Expected Standard S&P 500 Stock Return Deviation 0.00 1.00 0.05 0.95 0.10 0.90 0.15 0.85 36 37 38 39 0.20 0.80 40 0.25 0.75 41 0.30 0.70 42 0.35 0.65 43 0.40 0.60 0.55 0.45 44 45 0.50 0.50 46 0.55 0.45 47 0.60 0.40 0.35 48 49 50 51 0.65 0.70 0.75 0.80 0.85 0.90 0.95 1.00 52 0.30 0.25 0.20 0.15 0.10 0.05 0.00 53 54 55 56 57