3. Given the variance/covariance matrix below and the weights for the five stock portfoloio, first transpose the weights where indicated using the TRANSPOSE function. Then compute the mean return, weights matrix and the portfolio variance using MMULT. Compute the variance of the portfolio using MMULT only and SUMPRODUCT only. (20 points) Variance-covariance, S Weights Matrix Stock B A 0.10 0.01 0.02 0.05 0.05 0.01 0.30 0.06 0.02 0.06 0.25 0.04 0.02 D 0.05 -0.04 0.04 0.35 -0.04 Mean Portfolio E returns E(r) weights 0.05 6% 0.20 0.03 8% 0.25 0.02 10% 0.35 -0.04 15% 0.10 0.4 20% 0.10 A B D E -0.04 E 0.03 Transpose weights here: Portfolio Mean, variance, covariance, correlation Mean, Er) (MMULT) Variance ox? (MMULT) Variance ox? (SUMPRODUCT) 3. Given the variance/covariance matrix below and the weights for the five stock portfoloio, first transpose the weights where indicated using the TRANSPOSE function. Then compute the mean return, weights matrix and the portfolio variance using MMULT. Compute the variance of the portfolio using MMULT only and SUMPRODUCT only. (20 points) Variance-covariance, S Weights Matrix Stock B A 0.10 0.01 0.02 0.05 0.05 0.01 0.30 0.06 0.02 0.06 0.25 0.04 0.02 D 0.05 -0.04 0.04 0.35 -0.04 Mean Portfolio E returns E(r) weights 0.05 6% 0.20 0.03 8% 0.25 0.02 10% 0.35 -0.04 15% 0.10 0.4 20% 0.10 A B D E -0.04 E 0.03 Transpose weights here: Portfolio Mean, variance, covariance, correlation Mean, Er) (MMULT) Variance ox? (MMULT) Variance ox? (SUMPRODUCT)