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 npv of the expected cash flows from project

What is the NPV of the expected cash flows from this project? Assume a discount rate of 20%.

  Break-even analysis and leverage

Highland Cable Corporation is planning an expansion of its facilities. Its current income statement is as follows:

  Would this expansion create value for brook enterprises

Would this expansion create value for Brook Enterprises? Perform a NPV (net present value) analysis.

  Multiple choice questions in finance

To pay for her college education, Gina is saving $2,000 at the starting of every year for next 8-years in a bank account paying 12% interest.

  Finance true or false question

The money flow in management such as the LCN is very similar to Corporations where the money flows from the top down.

  What is the new market value of the company

Again, Inc. is proposing a rights offering. Presently, there are 450,000 shares outstanding at $90 each. There will be 80,000 new shares offered at $84 each.

  Describe each of the following statistical terms and where

describe each of the following statistical terms and where applicable define with the appropriate equation range

  What must be price of an at-the-money european call option

what must be price of an at-the-money European call option on stock with 1 year maturity.

  Nominal interest rates-inflation and exchange rates

How much would you expect to receive for a nominal interest rate in Spain if funds can be invested in the U. S. at a rate of 7 % when inflation is expected to be 2.5 % in the U. S. and 7 % in Spain?

  The cost of not taking the discount on trade credit of 210

the cost of not taking the discount on trade credit of 210 net 30 is equal to what

  How much faster would a home sell

How much faster would a home sell if there was a sign that said "financing available" attached to the normal sale sign.

  Computation of maximum sustainable growth rate

Computation of maximum sustainable growth rate and what should its maximum sustainable growth rate be

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