This preview shows page 1. Sign up to view the full content.
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
This document was uploaded on 03/18/2012.
- Spring '12