What is the minimum variance portfolio

Assignment Help Risk Management
Reference no: EM132183784

Investments Assignment - Risk/Return Trade-off (Markowitz Efficient Frontier)

This is an INDIVIDUAL assignment designed to provide a better understanding of the concepts of diversification, risk and return trade-off, and the efficient frontier. It will also help you upgrade your Excel skills. You are required to use Excel in order to draw the efficient frontier for a set of given securities (stocks and bonds) and identify the minimum variance portfolio. You are also asked to discuss the different shapes of the frontier under different correlation scenarios.

Project Description - Assume the market is formed of only two securities (a bond fund and a stock fund). Use the following numbers in Excel:

 

E(r)

σ(r)

Corr(B, S)

Bonds (B)

0.13

0.23

 

Stocks (S)

0.22

0.32

0.15

Take the following steps:

1. Consider alternative two-asset portfolios formed by varying the weights for the two funds provided above. That is, start with a portfolio that has 0% in the stock fund and 100% in the bond fund and calculate E(rP) and σP. Repeat the exercise by increment of 2% for the weight of the stock fund (i.e. recalculate E(rP) and σP for a portfolio that has 2% in stocks, then 4%, then 6% etc). Note that as long as you know the weight of the stock fund in the portfolio of two assets, the weight of the bond fund is also known (the two weights should add to 1).

2. Graph these data points - the resulting figure should be your investment opportunity set. What is your efficient frontier? Why?

3. The first question to ask at this point is what is the minimum variance portfolio? Is it among the ones you found in step 1 (this would be very unlikely)? How can you find the minimum variance portfolio? Determine its return and standard deviation. What are the weights for stocks and bonds in this portfolio?

4. Repeat steps 1 through 3 when the correlation between stocks is 0, and then with a correlation of -.9. How and why does the shape of your investment opportunity set change? What is the new minimum variance portfolio in each one of these cases? Explain!

5. What is the optimal portfolio for each one of the frontiers (i.e. the portfolio that optimizes your Sharpe ratio)? Assume that your particular degree of risk aversion dictates that you invest 35% of your wealth in the risk free asset and 65% in the optimum portfolio. Consider a risk free rate of 2%. Can you describe your overall allocation for each one of the three cases above?

Report Description - Keep in mind that this is an individual project! Your submitted report should include:

Your Excel Worksheet with your numbers (you will have three of them because of the three different correlation numbers). Identify the formulas you used for calculating E(rP) and σP.

Graph each of the investment opportunity sets separately and then put them together on the same graph.

Make sure your graphs identify the minimum variance portfolios. Describe the formulas you used for obtaining them.

Discuss each one of the questions identified in the project description.

Reference no: EM132183784

Questions Cloud

Firm implementing low-cost business strategy : We should observe for a firm implementing a low-cost business strategy?
Build an ethical reputation : How should managers foster ethical behavior though their own actions? What can a company as a whole do to build an ethical reputation?
Define legal and ethical considerations for group and family : Post an explanation of how legal and ethical considerations for group and family therapy differ from those for individual therapy.
Impact of the layoff in employees : What will you do to minimize the impact of the layoff in employees?
What is the minimum variance portfolio : FIN 3300 Investments Assignment - Risk/Return Trade-off (Markowitz Efficient Frontier), University of Denver, USA. What is the minimum variance portfolio
Briefly describe the creator of the document : Briefly describe the creator of the document. (To answer this question, you may need to use information obtained from the introduction to the source).
Explain the differences between call and puts : Explain the differences between call and puts, not just in definition, but in actual workings of the option, price changes, time value, the Greeks,
Estimate of the proportion of employees : MIS171 Business Analytics - Deakin University - Does there appear to be any relationship between an employee's hours worked and their gender
Describe what score you made and why you think you got : Describe what score you made and why you think you got the score.

Reviews

len2183784

12/2/2018 11:22:16 PM

Organize your Report - Make sure your report is professional and easy to read. Here are some suggestions on what you should include: Cover page (name, title, course name etc), Page Numbers, Discussion/Sections and Appendix - use some of the skills you learned working on your Portfolio Project! For example: Include your excel worksheet with your numbers in the Appendix and number them (there should be three of them, one for each correlation coefficient). Make sure each Appendix has a name. Use the appendix numbers to refer to in your discussion. Try to separate your discussion into sections to make it easy to follow (for example, you can use sections like "Investment Opportunity Sets"; "Minimum Variance Portfolio" etc) Make sure your discussion covers each one of the questions identified in the project description.

Write a Review

 

Risk Management Questions & Answers

  Do you believe the credit risk has increased

Do you believe the credit risk has increased? Have the owners of the Hypothetical Manufacturing Ltd withdrawn funds from the business as dividends

  What is the best estimate of the after-tax cost of debt

What is the best estimate of the after-tax cost of debt? Based on the CAPM, what is the firm’s cost of equity?

  Find the break-even stock price

FIN368/Financial Derivatives and Risk Management Homework. This is September, and you have $4,000 to invest for three months. Find the break-even stock price

  Explain why a chooser option is less expensive than straddle

For each outcome at t, there are two possible outcomes at T, ST 2" X or ST X. Explain why a chooser option is less expensive than a straddle.

  Business cycles and the general level of interest rates

What is the relation between business cycles and the general level of interest rates? Why is the relationship this way?

  Accounting break-even level of sales if firm pays no taxes

What is the accounting break-even level of sales if the firm pays no taxes? What is the NPV break-even level of sales if the firm pays no taxes?

  How organization better capitalize on non-financial factors

How might the organization better capitalize on non-financial factors such as market share, reputation, human resources, physical facilities, or patents? Support your response with relevant research and analysis.

  Explain how you would create a synthetic stock position

Explain how you would create a synthetic stock position and identify the cost. Suppose you observe a $100 stock price, identify any arbitrage opportunities.

  Insurance policy contract that provides that the beneficiary

Julia Baker died, leaving to her husband Morgan insurance policy contract that provides that beneficiary (Morgan) can choose any one of four options.

  Sketch the results of a sensitivity analysis

Sketch the results of a sensitivity analysis on P(Deal Succeeds) for a risk-neutral decision maker. How high does P(Deal Succeeds) have to before before the decision maker should engage in the business deal?

  Risk management with example case and discussion

Decision Making Techniques for Supply Chain Management - application contributes to evidence-based decision making and supply chain performance

  What were the consequences of the risks

What types of business risks have you experienced or seen in the media lately? What were the consequences of the risks and how could the risks have been.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd