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

Data			Optimal Risky Portfolio
E(rtn) stocks	0.1		Optimal Stock	0.43499392
Volatility stocks	0.15		Optimal Bonds	0.56500608
E(rtn) bonds	0.06
Volatility bonds	0.08
The correlation between stocks & bonds	0.25
Risk-free rate	0.03
Stock Allocation	Bond Allocation	Return	Risk	Sharpe Ratio
0%	100%	0.06	0.080	0.375
10%	90%	0.064	0.077	0.44081558
20%	80%	0.068	0.077	0.49238663
30%	70%	0.072	0.080	0.52414079
40%	60%	0.076	0.086	0.53677403
50%	50%	0.08	0.093	0.53528773
60%	40%	0.084	0.103	0.52538729
70%	30%	0.088	0.113	0.51143521
80%	20%	0.092	0.125	0.49614291
90%	10%	0.096	0.137	0.48098364
100%	0%	0.1	0.150	0.46666667