Learning Outcomes, after watching this video you will be able to explain how the mean-variance efficient portfolio Calculate the Sharpe ratio for the mean-variance efficient portfolio. Calculate the weights of the risky assets in the mean-variance efficient portfolio using Excel. Let’s go back to our two risky assets X and Y. X has an expected return of 10% and the standard deviation of returns of 7%, and y has an expected return of 20% and a standard deviation of returns of 10%. The correlation coefficient of the expected returns is 0.10. Now we add a risk free asset with a return of five percent to the mix. By definition, risk free means no risk and so it's standard deviation of returns is zero, and it's correlation coefficient with both the risky assets are zero. We have the original mean variants right here for x and y. That is a that runs through x and y Where will the risk-free asset lie on this picture. It has zero risk and so it will lie on the vertical axis. Now, how do we include the risk-free asset in our portfolio. We could form a portfolio with x and the risk-free asset. All combinations of these two lie on the red capital allocation line. Can we do better than this in terms of risk and returns? The answer is yes. Why? Remember non-satiation. We can always get higher utility by moving towards the top left. So what gives us a higher utility? A portfolio of Y and a risk free asset, the blue line has a steeper allocation line. Can we do even better than this? The answer is, yes. Make the capital allocation line from the risk free asset steeper until it is tangential to the mean variance frontier between x and one. This is the gray line from the risk-free asset through the point MVE, which lies on the mean-variance frontier. MVE stands for the mean-variance efficient portfolio. Now, can we do even better than this? Remember, we want to keep moving towards the top left as part of being nonsatiated. However, the answer now is no. As a capital allocation line would no longer pass through or touch any point on the mean variance frontier. Increasing the slope any further would simply lead us to risk return combinations that are infeasible given x, y and the risk free asset. The mean variance efficient portfolio Is that the point of tangency of the capital allocation line from the risk free asset to the mean radiance frontier. It provides the maximum reward to risk ratio which is also called the sharp ratio. How do we calculate the weights of x and y in the mean radiance efficient portfolio? We want to identify a portfolio that maximizes the Sharpe Ratio. We want to calculate a pair of weights that maximizes the difference between the expected return of the portfolio and the risk-free rate of return, divided by the standard deviation of the portfolios returns. Such that the E(rp) = wE(X) + (1-w) E(Y) and the standard deviation of the portfolio's return is the square root of w squared. Times the variance of x's returns plus 1- w times the variance of y's returns plus 2 times w times 1- w times to co-variance between x and y's returns. W, where is the weight of x in the portfolio and 1- w is the weight of Y in the portfolio. We can solve for the weights using excel. Enter the expected return for X in cell C2 and standard deviations of returns in Cell D2, the expected return for y in cell C3 and it's standard deviation of returns in cell D3. Also enter the correlation coefficient between the returns in cell E3 and the risk free return in cell C4. Enter the formula for the MVE portfolios expected return in cell C5 And the formula for standard deviation in cell D5. Enter the formula for the sharp ratio in cell C6. Now open in Excel, set objective should be linked to Excel C6 since we want to maximize the sharp ratio. Click on the button to the left of Macs. Under cells, select cell B2 as we want to maximize the ratio by changing the weight affects of the portfolio. Then click on solve. You will be able to see that B2 now shows the value of 0.3607. To calculate the rate of Y in the portfolio, in cell B3, enter the formula =1-B2. Cell B3 will now display a value of 0.6393. So the rate of x in the portfolio is 36.07% and that of Y is 63.93%. The sharp ratio of the MVE portfolio is 1.6%. That is for every 1% at risk then the portfolio gives an excess return of 1.06%. Next time we will introduce a third risky asset z and see how the investment opportunity set changes.