User Account

All Pages

What is the expected portfolio return for the mvp portfolio

Assignment Help Finance Basics
Reference no: EM13517987

Question #1:  Capital Allocation:

Consider the following capital market: a risk-free asset yielding 1.00% per year and a mutual fund consisting of 60% stocks and 40% bonds. The expected return on stocks is 9.75% per year and the expected return on bonds is 2.75% per year. The standard deviation of stock returns is 28.00% and the standard deviation of bond returns 8.50%. The stock, bond and risk-free returns are all uncorrelated.

1. What is the expected return on the mutual fund?

2. What is the standard deviation of returns for the mutual fund?

Now, assume the correlation between stock and bond returns is 0.60 and the correlations between stock and risk-free returns and between the bond and risk-free returns are 0 (by construction, correlations with the risk-free asset are always zero).

3. What is the standard deviation of returns for the mutual fund? Is it higher or lower than the standard deviation found in part 2? Why?

Now, assume that the standard deviation of the mutual fund portfolio is exactly 19.75% per year and a potential customer has a risk-aversion coefficient of 3.25.

4. What correlation between the stock and bond returns is consistent with this portfolio standard deviation?

5. What is the optimal allocation to the risky mutual fund (the fund with exactly 19.75% standard deviation) for this investor?

6. What is the expected return on the complete portfolio?

7. What is the standard deviation of the complete portfolio?

8. What is the Sharpe ratio of the complete portfolio?

Browse Content Collection. Opens a new pop up window.

Question #2:  Markowitz Optimization:

Open the associated Excel file named QPS2 Data Fall 2014 Problem 2 in My Course Content:  Problem Set Spreadsheets. The data file includes 60 months of returns for 11 exchange traded funds; their names and ticker symbols follow:

 

Ticker

Name of Exchange Traded Fund

 

 

1

SPY

SPDR S&P 500 ETF

 

 

 

 

2

MDY

SPDR S&P MidCap 400 ETF

 

 

 

3

IWM

iShares Russell 2000 ETF

 

 

 

4

QQQ

Power Shares QQQ ETF

 

 

 

5

EFA

iShares MSCI EAFE ETF

 

 

 

6

VWO

Vanguard FTSE Emerging Markets Stock Index ETF

 

7

VNQ

Vanguard REIT Index ETF

 

 

 

8

BND

Vanguard Total Bond Market ETF

 

 

9

PFF

iShares US Preferred Stock ETF

 

 

10

GLD

SPDR Gold Shares ETF

 

 

 

11

JNK

SPDR Barclays High Yield Bond ETF

 

 

All students will do problem 2 using 9 of the above ETFs; all students will include the first 8 ETFs listed above:  SPY, MDY, IWM, QQQ, EFA, VWO, VNQ, and BND.  All students will include one of the last 3 ETFs:  PFF, GLD, and JNK as instructed on your version.

Version A:  Include PFF and exclude GLD and JNK. 

Use the data on your 9 ETFs to answer the following questions:

1.  What is the average return for each of the nine indexes?

2.  Show the covariance matrix of returns. Briefly describe how you constructed the covariance matrix.

Consider the simple case where short sales are allowed. Use Excel Solver to find the Minimum Variance Portfolio (MVP).

3.  What is the expected portfolio return for the MVP portfolio?

4.  What is the portfolio standard deviation for the MVP portfolio?

5.  What is the portfolio composition (i.e., what are the weights for the nine ETFs)?

Consider the simple case where short sales are allowed, but short positions must be greater than or equal to -100% and long positions must be less than or equal to 100%. Use Excel Solver to find the Maximum return portfolio with a standard deviation of exactly 6.75%.

6.  What is the expected portfolio return for this portfolio?

7.  What is the portfolio composition (i.e., what are the weights for the nine ETFs)?

Consider the more realistic case where short sales are NOT allowed and no more than 40% of the portfolio and no less than 4% is invested in any ETF. Use Excel Solver to find the Minimum Variance Portfolio (MVP).

8.  What is the expected portfolio return for the MVP portfolio?

9.  What is the portfolio standard deviation for the MVP portfolio?

10. What is the portfolio composition (i.e., what are the weights for the nine ETFs)?

Consider the simple case where short sales are NOT allowed and no more than 50% and no less than 5% of the portfolio is invested in any ETF. Use Excel Solver to find the Market Portfolio if the risk-free rate is 0.1250%/month (1.5%/year).

11.  What is the expected portfolio return for this portfolio?

12.  What is the portfolio standard deviation for this portfolio?

13.  What is the portfolio composition (i.e., what are the weights for the nine ETFs)?

14.  What is the maximum Sharpe ratio?

Reference no: EM13517987

Questions Cloud

Business-to-business organizations are marketing : Today, many business-to-business (B2B) organizations are marketing their products to companies and organizations where the "buyer" is not a single individual. Instead, there may be a variety of people or stakeholders including product users, a..
Evaluate the acitivation energy for the decomposition : Calculate the acitivation energy for the decomposition. b) To test solubility, 0.020 mol of solid lead iodide, PbI2, is added to 0.500 L of water. after eqilibrium has been established 0.00076 mol of Pb^2+ (aq) and 0.00152 mol of I^- (aq) are pres..
Amy morton is marketing manager at gleason printing : Amy Morton is marketing manager at Gleason Printing. For nearly seven months she has been researching the printing needs at Metro Alliance for Wellness, a consortium of hospitals and therapy centers in Uniopolis.
Obtain the current flows in the second wire : A vertical straight wire carrying an upward 21A current exerts an attractive force per unit length of 8.7x10^4 N/m on a second parallel wire 6.0cm away
What is the expected portfolio return for the mvp portfolio : What is the expected portfolio return for the MVP portfolio and what is the portfolio standard deviation for the MVP portfolio?
Market segmentation and targeting : Market Segmentation and Targeting
Calculate the total power radiated by the sun : The intensity of solar radiation at the earth's orbit is about 1360 W/m2. Using 1.5 × 1011 m for the distance from the earth to the sun, calculate the total power radiated by the sun
Compute the radius of its path : A 5.3MeV (kinetic energy) proton enters a 0.15T field, in a plane perpendicular to the field. What is the radius of its path
Calculate the angle of the reflected ray : A light ray strikes this material (from air) at an angle of 34.7° with respect to the normal of the surface. Calculate the angle of the reflected ray

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the effect on the value of the portfolio

Suppose you have a $1 million bond portfolio equally weighted between two bonds, one with duration equal to 4 years and the other with the duration equal to 8 years. What is the effect on the value of the portfolio of an increase in bond yields of..

  What is the maximum contribution margin for the year

The company can do 14,000 set-ups each period, yet there is unlimited demand for each product. What is the maximum contribution margin for the year?

  Explain why corporate governance fails

List some of the "indulgences" other than golden parachutes and poison pills (which are given to managers by the BOD) some managers have given to themselves.

  Will a decision that is based on npv ever change

When using the IRR approach, when can the internal rate of return be determined simply by dividing the initial outlay by the cash flows? Will a decision that is based on NPV ever change if it were based on IRR instead? Why or why not?

  Case study:ohio rubber works, inc.

case study:Ohio Rubber Works, Inc.

  Describing off-balance-sheet assets

What do you mean by off-balance-sheet assets? Recognize the 4 major categories of off-balance-sheet business and use the suitable example to describe each category.

  Effect of inflation on purchasing power of bond

ourteen years ago, the U.S. Aluminum Corporation borrowed $9.9 million. To sustain the original $9.9 million purchasing power, how much must the lender be repaid? (Hint: Multiply the loan amount by one plus cumulative inflation).

  What is the incremental savings of buying the valves

The equipment cannot be used elsewhere in the company, and it has no market value. However, the space occupied by the production of the valve can be used by another production group that is currently leasing space for $55,000 per year.

  What enterprise value do you estimate for creed

Neither Creed nor its acquisition target, Organic and More, uses debt financing at present. However, The VC has offered to provide the acquisition financing in the form of convertible debt that pays interest at a rate of 8 percent per year and is ..

  What is the npv of the project with the highest irr

If the company's WACC is 10%, what is the NPV of the project with the highest IRR?

  Would the expected return of the portfolio rise or fall

Calculate (a) the expected return and (b) the volatility (standard deviation) of a portfolio that consists of a long position of $10,000 in Johnson & Johnson and a short position of $2000 in Walgreen’s.

  Global manufacturing

You're employed by CPA firm that has international client, Global Manufacturing, with home offices in country in the European Union. The company recently entered in a lucrative sales contract with company in South Africa.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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