Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started