The analytical portion of the case assignment should be completed in the excel template which can be found in canvas. 1. plot in excel the risky asset opportunity set for portfolios a & b. to do this you will need to create the following table in excel assuming weights of portfolio a & b in 10 percentage point increments. then calculate expected return; standard deviation; and sharpe ratio for each allocation to a & b. your table in the excel file should look like the one below. weight port a weight port b return standard deviation sharpe ratio 0% 100% 10 90 20 80 30 70 40 60 50 50 60 40 70 30 80 20 90 10 100 0 determine the optimal allocation of a & b and draw in the capital allocation line (cal). the approximate optimal allocation can be determined using a table like the one shown above. or you can obtain a more precise optimal allocation using the formula shown in chapter 7 (equation 7.13). some students have used excel’s solver function to find the optimal risky portfolio – that is also acceptable. when drawing the cal on the efficient frontier graph plotted in excel, you can manually draw a line starting at the risk free rate to the tangent point.