Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the Excel Template and the following Input Data to: 1)Find the minimum variance portfolio of risky assets 2)Construct the Efficient Frontier of risky assets

Use the Excel Template and the following Input Data to:

1)Find the minimum variance portfolio of risky assets

2)Construct the Efficient Frontier of risky assets

3)Find the Optimal Portfolio of risky assets by maximizing the Sharpe Ratio

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

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

Capital Markets Institutions Instruments And Risk Management

Authors: Frank J. Fabozzi

5th Edition

0262029480, 9780262029483

More Books

Students also viewed these Finance questions

Question

Identify ways to increase your selfesteem.

Answered: 1 week ago