i need help to calculate the maximum sharpe the y=mx*b. wb for mon var.portfolio

You are interested in forming a portfolio with Stock Sand Bond B. Stock S has an expected return of 18.1% and a standard deviation of returns of 14.7%. Bond B has an expected return of 6.3% and a standard deviation of returns of 5.2%. The correlation coefficient of the returns of S and B is 0.25. The risk-free rate of return is 3% Using increments of one percentage point, fill in the template posted and plot both efficient frontiers (with vs. without the risk-free asset.) When plotting the line for the frontier with the risk-free asset, use a range from 0 to 30 for the X values. Please put the Wb and Ws for the maximum-Sharpe-ratio portfolio in the last row of your data. Please do not forget that the weight in the bond (Wb) for the minimum-variance portfolio needs to be inserted numerically within the Wb column. Bryanstale instructure.com/courses/2694/files?preview=485157 -signment.xlsx 0 - 200M + 18 Com 0.17 0.18 0 19 0.2 0.21 0.22 0.23 0.24 Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute 19 Compute 20 Compute 21 Compute 22 compute 23 Compute 24 Compute 25 Compute 26 Compute 27 Compute 21 Compute 2 Compute 39 Compute 0.26 0.27 0.28 0.31 0.32 Compute Com 0.34 Compute Compute Comoute 0.36 0.37 0.38 0.39 0.33 Compute compute 0.82 Compute Compute 0.81 Compute Compute 0.8 Compute Compute 0.79 Compute Compute 0.78 Compute Compute 0.77 Compute Compute 0.76 Compute Compute 0.75 Compute Compute 0.74 Compute Compute 0.73 Compute Compute 0.72 Compute Compute 0.71 Compute Compute 0.7 Compute Compute 0.69 Compute Compute 0.68 Compute Compute 0.67 Compute Compute 0.66 Compute Compute 0.65 Compute Compute 0.64 Compute Compute 0.63 Compute Compute 0.62 Compute Compute 0.61 compute Compute 0.6 Compute Compute 0.59 Compute Compute 0.55 Compute Compute 0.57 compute Compute 0.56 Compute Compute 0.55 Compute Compute 0.54 Compute Compute 0.53 Compute Compute 0.52 Compute Compute 051 Compute Compute 0.5 Compute Compute 0.49 Compute compute 0.48 Compute compute 0.47 Compute compute 0.46 Compute Compute 0.45 Compute Compute 0.44 Compute Compute 043 Compute compute 0.42 Computer Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compte Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute computer Compute Compute Compute compute Compute Compute Comu Compute Como 0.42 0.43 0.44 Compute Compute Compute 0.45 0.46 0.47 0.45 Compute Compute Compute 0.51 Compute Compute Compute 0.52 0.53 0.54 Compute 0.57 0.58 E F Assignmen....do... Template --EF....xlsx A Portfolio Assig....pdf nonfolinsside CF Assignment.xlsx 0 - 200 Compute Compute 0.58 0.59 0.6 0.61 0.62 0.63 0.64 0.65 0.66 0.67 0.68 Compute Compute 0.69 0.7 0.71 0.72 0.73 0.74 0.75 0.76 0.77 0.78 0.79 0.42 Compute Compute 0.41 Compute Compute 0.4 Compute Compute 0.39 Compute Compute 0.38 Compute Compute 0.37 Compute Compute 0.36 Compute Compute 0.35 Compute Compute 0.34 Compute Compute 0.33 Compute Compute 0.32 Compute Compute 0.31 Compute Compute 03 Compute Compute 0.29 Compute Compute 0.28 Compute Compute 0.27 Compute Compute 0.26 Compute Compute 0.25 Compute Compute 0.24 Compute Compute 0.23 Compute Compute 0.22 Compute Compute 0.21 Compute Compute 0.2 Compute Compute 0.19 Compute Compute 0.18 Compute Compute 0.17 Compute Compute 0.16 Compute Compute 0.15 Compute Compute 0.14 Compute Compute 0.13 Compute Compute 0.12 Compute Compute 0.11 Compute compute 0.1 Compute compute 0.09 Compute Compute 0.08 Compute Compute 0.07 Compute Compute 0.06 Compute Compute 0.05 Compute Compute 0.04 Compute Compute 0.03 Compute Compute 0.02 Compute Compute 0.01 Compute Compute teamed Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Com Compute Compute Compute Compute Comoute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute m ittee Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute comodamente Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compte Compute compute Compute Compute Compute Compute Compute Compute 0.81 0.82 Computer Comoure Compute Compute 0.84 0.85 0.86 087 0.88 0.89 0.9 0.91 0.92 0.93 0.94 0.95 0.96 097 0.98 0.99 Computer Compute Compute Compute Compute Compute Compute FF Assignmen... ZUUM wb for optimal Sharpe Ratio: Term 1 Term 2 Term 3 Total numerator: Compute Compute Compute denominator: Compute Compute Compute Compute Answer: Total Num / Total Demon at (0,rf) = (0, T- w we need to with highest Maximum Sharpe Ratio. (This is our slope.) Find points on line. Computex Sharpe Ratio Compute Compute Compute Compute Compute y=mx+b O Compute 1 Compute 2 Compute 3 Compute 5 Compute You are interested in forming a portfolio with Stock Sand Bond B. Stock S has an expected return of 18.1% and a standard deviation of returns of 14.7%. Bond B has an expected return of 6.3% and a standard deviation of returns of 5.2%. The correlation coefficient of the returns of S and B is 0.25. The risk-free rate of return is 3% Using increments of one percentage point, fill in the template posted and plot both efficient frontiers (with vs. without the risk-free asset.) When plotting the line for the frontier with the risk-free asset, use a range from 0 to 30 for the X values. Please put the Wb and Ws for the maximum-Sharpe-ratio portfolio in the last row of your data. Please do not forget that the weight in the bond (Wb) for the minimum-variance portfolio needs to be inserted numerically within the Wb column. Bryanstale instructure.com/courses/2694/files?preview=485157 -signment.xlsx 0 - 200M + 18 Com 0.17 0.18 0 19 0.2 0.21 0.22 0.23 0.24 Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute 19 Compute 20 Compute 21 Compute 22 compute 23 Compute 24 Compute 25 Compute 26 Compute 27 Compute 21 Compute 2 Compute 39 Compute 0.26 0.27 0.28 0.31 0.32 Compute Com 0.34 Compute Compute Comoute 0.36 0.37 0.38 0.39 0.33 Compute compute 0.82 Compute Compute 0.81 Compute Compute 0.8 Compute Compute 0.79 Compute Compute 0.78 Compute Compute 0.77 Compute Compute 0.76 Compute Compute 0.75 Compute Compute 0.74 Compute Compute 0.73 Compute Compute 0.72 Compute Compute 0.71 Compute Compute 0.7 Compute Compute 0.69 Compute Compute 0.68 Compute Compute 0.67 Compute Compute 0.66 Compute Compute 0.65 Compute Compute 0.64 Compute Compute 0.63 Compute Compute 0.62 Compute Compute 0.61 compute Compute 0.6 Compute Compute 0.59 Compute Compute 0.55 Compute Compute 0.57 compute Compute 0.56 Compute Compute 0.55 Compute Compute 0.54 Compute Compute 0.53 Compute Compute 0.52 Compute Compute 051 Compute Compute 0.5 Compute Compute 0.49 Compute compute 0.48 Compute compute 0.47 Compute compute 0.46 Compute Compute 0.45 Compute Compute 0.44 Compute Compute 043 Compute compute 0.42 Computer Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compte Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute computer Compute Compute Compute compute Compute Compute Comu Compute Como 0.42 0.43 0.44 Compute Compute Compute 0.45 0.46 0.47 0.45 Compute Compute Compute 0.51 Compute Compute Compute 0.52 0.53 0.54 Compute 0.57 0.58 E F Assignmen....do... Template --EF....xlsx A Portfolio Assig....pdf nonfolinsside CF Assignment.xlsx 0 - 200 Compute Compute 0.58 0.59 0.6 0.61 0.62 0.63 0.64 0.65 0.66 0.67 0.68 Compute Compute 0.69 0.7 0.71 0.72 0.73 0.74 0.75 0.76 0.77 0.78 0.79 0.42 Compute Compute 0.41 Compute Compute 0.4 Compute Compute 0.39 Compute Compute 0.38 Compute Compute 0.37 Compute Compute 0.36 Compute Compute 0.35 Compute Compute 0.34 Compute Compute 0.33 Compute Compute 0.32 Compute Compute 0.31 Compute Compute 03 Compute Compute 0.29 Compute Compute 0.28 Compute Compute 0.27 Compute Compute 0.26 Compute Compute 0.25 Compute Compute 0.24 Compute Compute 0.23 Compute Compute 0.22 Compute Compute 0.21 Compute Compute 0.2 Compute Compute 0.19 Compute Compute 0.18 Compute Compute 0.17 Compute Compute 0.16 Compute Compute 0.15 Compute Compute 0.14 Compute Compute 0.13 Compute Compute 0.12 Compute Compute 0.11 Compute compute 0.1 Compute compute 0.09 Compute Compute 0.08 Compute Compute 0.07 Compute Compute 0.06 Compute Compute 0.05 Compute Compute 0.04 Compute Compute 0.03 Compute Compute 0.02 Compute Compute 0.01 Compute Compute teamed Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Com Compute Compute Compute Compute Comoute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute m ittee Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute compute Compute Compute Compute Compute Compute Compute Compute Compute Compute comodamente Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compute Compte Compute compute Compute Compute Compute Compute Compute Compute 0.81 0.82 Computer Comoure Compute Compute 0.84 0.85 0.86 087 0.88 0.89 0.9 0.91 0.92 0.93 0.94 0.95 0.96 097 0.98 0.99 Computer Compute Compute Compute Compute Compute Compute FF Assignmen... ZUUM wb for optimal Sharpe Ratio: Term 1 Term 2 Term 3 Total numerator: Compute Compute Compute denominator: Compute Compute Compute Compute Answer: Total Num / Total Demon at (0,rf) = (0, T- w we need to with highest Maximum Sharpe Ratio. (This is our slope.) Find points on line. Computex Sharpe Ratio Compute Compute Compute Compute Compute y=mx+b O Compute 1 Compute 2 Compute 3 Compute 5 Compute