Learning Outcomes. After watching this video you will be able to explain the Two-fund Separation Theorem. Solve for optimal weights of a portfolio using Solver in Excel. Find an efficient portfolio given two efficient portfolios. Two Fund Separation. In the last video, we define the efficient frontier. In this video, we will use two fund separation to help us draw the efficient fund there when we have three risky assets. So what is two fund separation? It says that any efficient portfolio may be obtained by combining two efficient portfolios. To plot the efficient frontier, let's start by identifying two portfolios on the efficient frontier. Remember, the expected returns and standard deviation of x are 10% and 7%, respectively. Those of y are 20% and 10%, respectively. And those of Z are 15% and 12% respectively. Correlation between X and Y is .1. That would mean Y and Z is .9 and that between X and Z is 0. Let's pick two expected returns, 16% and 22%. We want identify portfolios of x, y, and z that have returns of 16% and 22% and have the least risk at these levels of expected returns. In others words, we want to minimize sigma sub p squared, which equals wx squared x 0.07 squared plus w-y squared times 0.1 squared plus w-z squared times 0.12 squared plus 2 times w-x, w-y times 0.1 times 0.07 times 0.1 plus 2 times w-y, w-z times 0.9 times 0.1 times 0.12, Plus 2 times wx wz times 0 times 0.07 times 0.12. Subject to the portfolio expected returns, Sub p which is wx times 0.1 plus wy times 0.2 plus wz times 0.15 being equal to 0.16 and wx plus wy plus wz being equal to 1. This is a difficult problem to solve by hand but solver in Excel makes it easy to solve for wx, wy, and wz. Set up your excel spreadsheet exactly as you see on the screen. Use the SUMPRODUCT function to calculate the portfolio expected return. Fill in the formula the long one for portfolio variants as you see on your screen. Then, click on Solver in the data tab on your Excel screen. Your objective is to minimize the portfolio variance. So set objective should be linked to cell B7. And you want to minimize that. You want to minimize the variance by changing the weights of x, y, and z. So by changing variable cells should B 2 go to B 4. The two constraints are that the expected return should be .16 and then weights should add to one. Re add those constraints as you can see. Once everything is set up you can have Excel solve for the rates. We find that by wx is 0.54, wy is 0.74, and wz is -0.28. With these rates, the lowest possible variance of 0.004118. Is achieved at an expected return of 16%. You can verify that the weights add to one. The negative weight for z says that you need to sell z. There is a positive weights on x and y say that you need to buy them. We can similarly find the efficient portfolio with an expected return of 22%. You can verify that the rates are .2625, 1.6625, and negative .925 for x, y, and z respectively. Every other portfolio on the efficient frontier can be determined as a combination of these two efficient portfolios. Let's say you want to identify the efficient portfolio with an expected return of 20%. We need Sub P to be equal to .12 which is equal to w times 0.16. +(1- w)0.22. Solving this for w, we get get w= one third. So what are the weights of x, y, and z in the efficient portfolio with an expected return of 20%? wx = one third times 0.54 plus two thirds times 2625 which equals .355. WY equals 1/3 x .74 ) 2/3 x 1.6625, which equals 1.355. WZ equals 1/2 x -.28. Plus two-thirds times negative 0.925 which equals negative 0.71. Given these weights, you can now calculate the variance of this efficient portfolio. You can verify that this is 0.0783. You can see where this lies on the efficient frontier. In this manner you can identify an efficient portfolio at each level of expected return and then join them to draw the efficient frontier. All you need is just two efficient portfolios to start with. This is the idea behind two front separation. Next time we will revisit the concept of diversification and see how much risk can actually be diversified away.