Calculate the weights of the minimum variance portfolio

Assignment Help Portfolio Management

Reference no: EM131454042

Assignment: Risk and Return of the Risky Portfolio

Find the spreadsheet labeled "Optimal Portfolio Weights - 2017 - for students" in the Resources section of our class' Isidore page.

1. Construction of the investment opportunities set: In the tab labeled "Risk and Return Info" you will find the holding period returns you calculated during Excel Assignment #1. You will also find arithmetic average returns, standard deviations, variance, covariance and correlation coefficients.

Use this data to construct the investment opportunities set, which is the set of all possible portfolios that can be built with different weights of TSLA and GM. Calculate the standard deviation and expected returns of 100 portfolios with weights of TSLA ranging between 0% and 100% in increments of 1%.

2. Graph the investment opportunities set in a mean-variance graph. This is, a chart in which standard deviation is recorded in the horizontal axis and expected return is recorded in the vertical axis.

Copy the figure in the space below. What shape does the investment opportunities set typically take?

Use the spreadsheet to perform sensitivity analysis on the shape of the investment opportunities set relative to the correlation coefficient. Recalculate the standard deviation of the investment opportunities set is correlation coefficients of +1, +0.5, 0. -0.5, and -1. Describe what happens to the shape of the curve and the correlation coefficient declines.

3. Calculate the weights of the minimum variance portfolio. Use the formulas in the footnote of page 156 in your textbook to calculate these weights. Use these weights to calculate the expected return, standard deviation, and Sharpe ratio of the minimum-variance portfolio. Draw the Capital Allocation line of the minimum-variance portfolio along with the Investment Opportunities set in the mean-variance graph. Copy your figure in the space below and explain what does the minimum-variance portfolio represent? Is this portfolio mean-variance efficient?

4. Calculate the weights of the optimal portfolio. Use equation 6.10 in page 160 in your textbook to calculate these weights. Use these weights to calculate the expected return, standard deviation and Sharpe ratio of this portfolio. Draw the Capital Allocation line of the optimal portfolio along with the Investment Opportunities set in the mean-variance graph. Copy your figure in the space below and explain what does the minimum-variance portfolio represent? Is this portfolio mean-variance efficient? How do you know?

Attachment:- Attachments.rar

Reference no: EM131454042

Questions Cloud

Conduct a trend analysis for the last three to five years : Conduct a trend analysis for the last three to five year. What trends can you identify? What do they indicate? What are your company's strengths and weaknesses?

What are the driving forces behind this shift : Do you see a major shift from analog to digital in the humanitarian model? If so, what are the driving forces behind this shift?

Analyze the branches of government of your state : From the second e-Activity, analyze the branches of government of your state with respect to the extent that each branch is associated with health care

Develop a list of customer requirements as the inputs : This problem is contingent on successful completion of preceding Problem. Based on the house of quality developed in Problem, develop the second matrix in

Calculate the weights of the minimum variance portfolio : Calculate the weights of the minimum variance portfolio. Use the formulas in the footnote of page 156 in your textbook to calculate these weights.

The nature-history of hospitality : For this assignment, students will demonstrate their understanding of the history of the hospitality/tourism industry and how it relates to the industry today.

Explain the goals and restrictions on the prosecutor : What parallels can be drawn between the modern criminal trail and these "legal battle" of the Middle Ages?

Develop the house of quality in qed : Consider some existing product with which you arc familiar. If you work for a manufacturing company, consider a product that is manufactured by your company.

How a police agency can effectively engage : prepare a three to five page report analyzing how a police agency can effectively engage the community in community policing

User Account

All Pages