Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(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

Step: 1

The standard deviation of a portfolio is given by Where Wi is the weight ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Physics

Authors: Alan Giambattista, Betty Richardson, Robert Richardson

2nd edition

77339681, 978-0077339685

More Books

Students also viewed these Business Communication questions

Question

2. What is the x2 value?

Answered: 1 week ago