Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. You are given the following information: Use the Variance -Covariance matrix in the Excel file: Efficient Portfolios Data. C. Construct a model to determine

image text in transcribed
image text in transcribed
3. You are given the following information: Use the Variance -Covariance matrix in the Excel file: Efficient Portfolios Data. C. Construct a model to determine the following: a. Calculate an envelope portfolio assuming the risk-free rate is 3%. b. Calculate an envelope portfolio assuming the risk-free rate is 12%. Create a one-way data table that determines the different means and standard deviations for combinations of Envelope Portfolio 1 and Envelope Portfolio 2 by varying the proportion of Portfolio 1 from -5 to +5 in increments of 0.50. d. Graph the combinations of the portfolios from the one-way data table and add the individual asset means and standard deviations to the graph. e. Provide a title on the graph and label the axes of the graph. f. Could the portfolio combinations be on the efficient frontier? Why or why not? Efficient Portfolios Data Variance - Covariance Matrix B 0.0003 B D E 0.0030 0.0003 -0.0001 -0.0001 0.0021 0.0160 0.0023 0.0029 0.0350 0.0021 0.0050 0.0023 D -0.0004 0.0050 0.0023 0.0077 0.0022 E -0.0007 0.0023 0.0029 0.0022 0.0090 Means 1.7000% 1.7300% 4.0100% 1.9600% . -0.0004 -0.0007 0.1200% 3. You are given the following information: Use the Variance -Covariance matrix in the Excel file: Efficient Portfolios Data. C. Construct a model to determine the following: a. Calculate an envelope portfolio assuming the risk-free rate is 3%. b. Calculate an envelope portfolio assuming the risk-free rate is 12%. Create a one-way data table that determines the different means and standard deviations for combinations of Envelope Portfolio 1 and Envelope Portfolio 2 by varying the proportion of Portfolio 1 from -5 to +5 in increments of 0.50. d. Graph the combinations of the portfolios from the one-way data table and add the individual asset means and standard deviations to the graph. e. Provide a title on the graph and label the axes of the graph. f. Could the portfolio combinations be on the efficient frontier? Why or why not? Efficient Portfolios Data Variance - Covariance Matrix B 0.0003 B D E 0.0030 0.0003 -0.0001 -0.0001 0.0021 0.0160 0.0023 0.0029 0.0350 0.0021 0.0050 0.0023 D -0.0004 0.0050 0.0023 0.0077 0.0022 E -0.0007 0.0023 0.0029 0.0022 0.0090 Means 1.7000% 1.7300% 4.0100% 1.9600% . -0.0004 -0.0007 0.1200%

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

The Heretics Guide To Global Finance Hacking The Future Of Money

Authors: Brett Scott

1st Edition

0745333508, 1849648808, 9780745333502, 9781849648806

More Books

Students also viewed these Finance questions