Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

(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: W1+W2+W3 = 1 W120 W220 W320 where w1 is an weight allocated to FB, 2 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 FB TSLA BA TSLA BA 0.04% 0.04% 0.04% 0.41% 0.02% 0.02% 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.) 0.00 97.53 0.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Global Finance At Risk

Authors: S. Sen

1st Edition

1349420492, 978-1349420490

More Books

Students also viewed these Finance questions

Question

What would the employee volunteer gain?

Answered: 1 week ago

Question

1. In what ways has flexible working revolutionised employment?

Answered: 1 week ago