Please solve in Excel format and show step-by-step formulas

6-25. Stocks x, y, and z have expected returns of 7%, 6%, and 10%, respectively, and the following variance-covariance matrix: x y z .01 .001 .001 .001 .04 -.04 .001 ..04 .08 (a) Determine the fraction of the portfolio to hold in each stock so as to minimize the variance of the portfolio subject to a minimum expected return on the portfolio of 8%. (b) Can the variance of the portfolio be smaller than the variance of any individual stock? Explain. (c) Use the Lagrange multiplier information to estimate what would happen to the variance of the optimal portfolio if the minimum expected return were raised to 9%. Compare your estimate with the actual by resolving the model. 6-25. Stocks x, y, and z have expected returns of 7%, 6%, and 10%, respectively, and the following variance-covariance matrix: x y z .01 .001 .001 .001 .04 -.04 .001 ..04 .08 (a) Determine the fraction of the portfolio to hold in each stock so as to minimize the variance of the portfolio subject to a minimum expected return on the portfolio of 8%. (b) Can the variance of the portfolio be smaller than the variance of any individual stock? Explain. (c) Use the Lagrange multiplier information to estimate what would happen to the variance of the optimal portfolio if the minimum expected return were raised to 9%. Compare your estimate with the actual by resolving the model