Question: (EXCEL Question) You are asked to create an optimal minimum variance portfolio using three stocks (FB, TSLA, BA). Find optimal weights for the minimum variance

(EXCEL Question) You are asked to create an optimal minimum variance portfolio using three stocks (FB, TSLA, BA). Find optimal weights for the minimum variance portfolio satisfying the following condition:

where w1 is an weight allocated to FB, w2 is an weight allocated to TSLA,  and  w3 is an weight allocated to BA. The average returns for FB, TSLA, BA are -0.28%, 0.99%, -0.39%, respectively. The covariance matrix is given by

FBTSLABA
FB0.04%0.04%0.02%
TSLA0.04%0.41%0.02%
BA0.02%0.02%0.04%

1. The optimal weight for FB is [A]%. (Note: round to th nearest hundredth.)

2. The optimal weight for TSLA is [B]%. (Note: round to th nearest hundredth.)

3. The optimal weight for BA is [C]%. (Note: round to th nearest hundredth.)


22.22

2.78

75.00


Step by Step Solution

3.48 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The standard deviation of a portfolio is given by Where Wi is the weight ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Communication Questions!