{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

A+Minimum+Variance+Portfolio+Exercise+using+the+solver+tool

A+Minimum+Variance+Portfolio+Exercise+using+the+solver+tool...

This preview shows page 1. Sign up to view the full content.

The variance covariance matrix of the returns is a table of I rows and I columns. If a table representing a variance covariance matrix has 10 rows and 10 columns, then the entry in the table (row 1, column 3) is the covariance of the return in the first security with that of the third. The (5,5) term would be the variance of the fifth security. Covariance matrices or tables are symmetric. Let be the rate of return on risky security i . Let be the covariance between two returns and . Of course, . Let be the share of your wealth devoted to security i . Then the expected return of your portfolio is and the variance of the portfolio is. A question we might care about is finding a minimum variance portfolio made up of a given set of securities. The solver tool can handle this. We would set the objective to the EXCEL formula for , we would ask it to minimize this objective, by changing the weights , with the constraints that and all the weights are between 0
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: and 1, so . The spreadsheet “Variance Minimization.xlsx” has an example. As an exercise create your own spreadsheet for a portfolio of 2 stocks with variance covariance matrix 1.5E-06-3.1E-07-3.1E-07 1.99E-06 And mean returns of 0.00808 5 0.002376 Start with weights of ½ and ½ and find the mean return and the variance of the return of such a portfolio. Change the weights by hand (note they must sum to 1) to find a minimum variance portfolio. Now do it using the solver tool. Next add third security. With covariance matrix 1.5E-06-3.1E-07 1.07E-07-3.1E-07 1.99E-06-3.3E-07 1.07E-07-3.3E-07 2.12E-06 And expected returns 0.00808 5 0.002376 0.003128 Start with the solution you got for the first two and weight of zero for the new security. Now add the security and vary weights to find a new minimum variance portfolio made up of the three securities. You can do it by hand, but easier to do it using the solver tool....
View Full Document

{[ snackBarMessage ]}

What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern