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

(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

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

Microsoft Dynamics Ax 2012 R3 Financial Management

Authors: Mohamed Aamer

1st Edition

1784390984, 978-1784390983

More Books

Students also viewed these Accounting questions

Question

a. How will the leader be selected?

Answered: 1 week ago

Question

b. Will new members be welcomed?

Answered: 1 week ago