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
FB | TSLA | BA | |
FB | 0.04% | 0.04% | 0.02% |
TSLA | 0.04% | 0.41% | 0.02% |
BA | 0.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 ...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 StartedRecommended Textbook for
Physics
Authors: Alan Giambattista, Betty Richardson, Robert Richardson
2nd edition
77339681, 978-0077339685
Students also viewed these Business Communication questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App