Question: Construct the Capital Allocation Line from the risk free asset through the Optimal Portfolio (tangent to the Efficient Frontier of risky assets) Create an X-Y

Construct the Capital Allocation Line from the risk free asset through the Optimal Portfolio (tangent to the Efficient Frontier of risky assets)

Create an X-Y Graph showing the Efficient Frontier and the Capital Allocation Line

please show formulas in excel

Input Data

Summary Statistics

Asset

A

B

C

Rf

E(r )

8%

15%

4%

2%

SD

10%

22%

8%

Covariance Matrix of Risky Assets

A

B

C

A

0.0100

0.0066

0.0000

B

0.0066

0.0484

0.0044

C

0.0000

0.0044

0.0064

Correlation Matrix of Risky Assets

A

B

C

A

1.000

0.300

0.000

B

0.300

1.000

0.250

C

0.000

0.250

1.000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!