Using the table attached below, plot the opportunity set of risky assets in Excel. Then vary the correlation between stocks and bonds from + 1 to -1 and describe the changes in shape of the efficient frontier as you do so. Upload the Excel file that contains the table & graph. Also include in Excel file a description of the efficient frontier's shape as you vary the correlation.

D E F Return B 1 Ertn) Stock 10% 2 Volatility of Stock 15% 3 Ertn) Bonds 6% 4 Volatility of bonds 8% 5 Correlation cofficient 25% 6 Risk free return 3% 7 Stock Allocation Bond Allocation 8 0% 100% 9 5% 95% 10 10% 90% 11 15% 85% 12 20% 80% 13 25% 75% 14 30% 70% 15 35% 65% 16 40% 60% 17 45% 55% 18 50% 50% 19 55% 45% 20 60% 40% 21 65% 35% 22 70% 30% 23 75% 25% 24 80% 20% 25 85% 15% 26 90% 10% 27 95% 5% 28 100% 0% 29 30 31 43.50% 56.500607533414300% 32 33 34 OPTIMAL WEIGHT OF STOCK 43.499392466585700% 35 OPTIMAL WEIGHT OF BOND 56.500607533414300% 36 RETURN 7.74% 37 RISK 8.82% 38 SHARPE RATIO 0.54 6.00% 6.20% 6.40% 6.60% 6.80% 7.00% 7.20% 7.40% 7.60% 7.80% 8.00% 8.20% 8.40% 8.60% 8.80% 9.00% 9.20% 9.40% 9.60% 9.80% 10.00% Risk 8.00% 7.82% 7.71% 7.68% 7.72% 7.83% 8.01% 8.26% 8.57% 8.93% 9.34% 9.79% 10.28% 10.80% 11.34% 11.91% 12.50% 13.10% 13.72% 14.36% 15.00% Sharp Ratio 0.3750 0.4091 0.4408 0.4689 0.4924 0.5108 0.5241 0.5326 0.5368 0.5374 0.5353 0.5311 0.5254 0.5187 0.5114 0.5038 0.4961 0.4885 0.4810 0.4737 0.4667 7.74% 8.82% 0.54 D E F Return B 1 Ertn) Stock 10% 2 Volatility of Stock 15% 3 Ertn) Bonds 6% 4 Volatility of bonds 8% 5 Correlation cofficient 25% 6 Risk free return 3% 7 Stock Allocation Bond Allocation 8 0% 100% 9 5% 95% 10 10% 90% 11 15% 85% 12 20% 80% 13 25% 75% 14 30% 70% 15 35% 65% 16 40% 60% 17 45% 55% 18 50% 50% 19 55% 45% 20 60% 40% 21 65% 35% 22 70% 30% 23 75% 25% 24 80% 20% 25 85% 15% 26 90% 10% 27 95% 5% 28 100% 0% 29 30 31 43.50% 56.500607533414300% 32 33 34 OPTIMAL WEIGHT OF STOCK 43.499392466585700% 35 OPTIMAL WEIGHT OF BOND 56.500607533414300% 36 RETURN 7.74% 37 RISK 8.82% 38 SHARPE RATIO 0.54 6.00% 6.20% 6.40% 6.60% 6.80% 7.00% 7.20% 7.40% 7.60% 7.80% 8.00% 8.20% 8.40% 8.60% 8.80% 9.00% 9.20% 9.40% 9.60% 9.80% 10.00% Risk 8.00% 7.82% 7.71% 7.68% 7.72% 7.83% 8.01% 8.26% 8.57% 8.93% 9.34% 9.79% 10.28% 10.80% 11.34% 11.91% 12.50% 13.10% 13.72% 14.36% 15.00% Sharp Ratio 0.3750 0.4091 0.4408 0.4689 0.4924 0.5108 0.5241 0.5326 0.5368 0.5374 0.5353 0.5311 0.5254 0.5187 0.5114 0.5038 0.4961 0.4885 0.4810 0.4737 0.4667 7.74% 8.82% 0.54