Using the table 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.

E(rtn) Stocks	0.1
Volatility Stocks	0.15
E(rtn) Bonds	0.06
Volatility Bonds	0.08
Correlation	0.25
Risk-free Rate	0.03

Stock Allocation	Bond Allocation	Return	Risk	Sharpe Ratio
0%	100%	0.06	0.08	0.375
5%	95%	0.062	0.078212851	0.409139927
10%	90%	0.064	0.077129761	0.440815577
15%	85%	0.066	0.076780531	0.468868857
20%	80%	0.068	0.077175126	0.49238663
25%	75%	0.07	0.078302299	0.510840685
30%	70%	0.072	0.080131143	0.524140786
35%	65%	0.074	0.082615071	0.532590474
40%	60%	0.076	0.085697141	0.536774032
45%	55%	0.078	0.089315452	0.537421004
50%	50%	0.08	0.093407708	0.535287728
55%	45%	0.082	0.097914504	0.531075562
60%	40%	0.084	0.102781321	0.525387292
65%	35%	0.086	0.107959483	0.518713117
70%	30%	0.088	0.113406349	0.511435211
75%	25%	0.09	0.119085054	0.503841567
80%	20%	0.092	0.124963995	0.49614291
85%	15%	0.094	0.13101622	0.488489134
90%	10%	0.096	0.137218803	0.480983643
95%	5%	0.098	0.143552255	0.473695101
100%	0%	0.1	0.15	0.466666667