Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(EXCEL Question) You are asked to create an optimal tangent portfolio using three stocks (FB, TSLA, BA) assuming a risk- free rate is zero. Find
(EXCEL Question) You are asked to create an optimal tangent portfolio using three stocks (FB, TSLA, BA) assuming a risk- free rate is zero. Find optimal weights for the tangent portfolio satisfying the following condition: w+w+w 1 2 3 w > W 2 W 3 = 1 where W1 is a weight allocated to FB, w2 is a weight allocated to TSLA, and w3 is a 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 TSLA BA 0.04% 0.04% 0.02% 0.04% 0.41% 0.02% 0.02% 0.02% 0.04% %. (Note: round to the nearest hundredth.) 1. The optimal weight for FB is 50.00 2. The optimal weight for TSLA is 0.00 3. The optimal weight for BA is 50.00 %. (Note: round to the nearest hundredth.) %. (Note: round to the nearest hundredth.)
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