Question

In: Statistics and Probability

A second version of the Markowitz portfolio model maximizes expected return subject to a constraint that...

A second version of the Markowitz portfolio model maximizes expected return subject to a constraint that the variance of the portfolio must be less than or equal to some specified amount. Consider the Hauck Financial Service data. We list the data again below along with the return of the S&P 500 Index. Hauck would like to create a portfolio using the funds listed, so that the resulting portfolio matches the return of the S&P 500 index as closely as possible.

Click on the datafile logo to reference the data.

Mutual Fund Year 1 Year 2 Year 3 Year 4 Year 5
Foreign Stock 10.06   13.12   13.47   45.42   -21.93  
Intermediate-Term Bond 17.64   3.25   7.51   -1.33   7.36  
Large-Cap Growth 32.41   18.71   33.28   41.46   -23.26  
Large-Cap Value 32.36   20.61   12.93   7.06   -5.37  
Small-Cap Growth 33.44   19.40   3.85   58.68   -9.02  
Small-Cap Value 24.56   25.32   -6.70   5.43   17.31  
S&P 500 Return 25   20   8   30   -10  
(a) Develop an optimization model that will give the fraction of the portfolio to invest in each of the funds so that the return of the resulting portfolio matches as closely as possible the return of the S&P 500 Index. Hint: Minimize the sum of the squared deviations between the portfolio's return and the S&P 500 Index return for each year in the data set.
Let:
FS = proportion of portfolio invested in the foreign stock mutual fund
IB = proportion of portfolio invested in the intermediate-term bond fund
LG = proportion of portfolio invested in the large-cap growth fund
LV = proportion of portfolio invested in the large-cap value fund
SG = proportion of portfolio invested in the small-cap growth fund
SV = proportion of portfolio invested in the small-cap value fund
Ds= the difference between the portfolio return and the S&P 500 return, years
If required, round your answers to two decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) If the constant is "1" it must be entered in the box. If your answer is zero enter “0”.
Min D12 + D22 + D32 + D42 + D52
s.t
FS +  IB +  LG +  LV +  SG +  SV + - Select your answer -≤≥<>=Item 8 D 1
FS +  IB +  LG +  LV +  SG +  SV + - Select your answer -≤≥<>=Item 16 D 2
FS +  IB +  LG +  LV +  SG +  SV + - Select your answer -≤≥<>=Item 24 D 3
FS +  IB +  LG +  LV +  SG +  SV + - Select your answer -≤≥<>=Item 32 D 4
FS +  IB +  LG +  LV +  SG +  SV + - Select your answer -≤≥<>=Item 40 D 5
FS +  IB +  LG +  LV +  SG +  SV - Select your answer -≤≥<>=Item 47
FS, IB, LG, LV, SG, SV - Select your answer -≤≥<>=Item 49
(b) Solve the model developed in part (a).
If required, round your answers to two decimal places. If your answer is zero enter “0”.
FS %
IB %
LG %
LV %
SG %
SV %

Solutions

Expert Solution

FS=30.3339%

IB=0%

LG=0%

LV=36.498%

SG=22.6551%

SV=10.513%

PLEASE LIKE & SUPPORT

IT IS VERY IMPORTANT FOR ME NOW


Related Solutions

Essay Selection of Asset Portfolio by Markowitz model
Essay Selection of Asset Portfolio by Markowitz model
What is the expected return on a portfolio? How can the expected return on a portfolio...
What is the expected return on a portfolio? How can the expected return on a portfolio be manipulated to minimize the risk on that portfolio? Justify your answer
The following are the expected returns on a portfolio of investments. What is the expected rate of return on the portfolio?
The following are the expected returns on a portfolio of investments. What is the expected rate of return on the portfolio? Investment # of shares Price per share Expected returnA. 2000 $20 10%B. 3000 $10 15%C. 1000 $15 8%
4. Assume that the portfolio expected return for asset one is 0.15 and the expected return...
4. Assume that the portfolio expected return for asset one is 0.15 and the expected return for asset two is 0.10. The variance of both returns is one and the correlation between the returns is 0.75. Assume equal weighting for each asset. Compute the expected return and variance of the portfolio. Assume that the risk free rate is 0.05. Compute the Sharpe ratio of the portfolio. Now allocate 0.60 to asset one and 0.40 to asset two. Recompute all the...
Calculate the expected return and standard deviation of the portfolio.
A portfolio consists of two stocks:   Stock                 Expected Return            Standard Deviation             Weight   Stock 1                          10%                                     15%                            0.30 Stock 2                          13%                                     20%                            ???   The correlation between the two stocks’ return is 0.50   Calculate the expected return and standard deviation of the portfolio. Expected Return: Standard Deviation: (i) Briefly explain, in general, when there would be “benefits of diversification” (for any       portfolio of two securities).               (ii) Describe whether the above portfolio would...
The risk free rate of return is 3%, the expected return on themarket portfolio is...
The risk free rate of return is 3%, the expected return on the market portfolio is 11% and the stock of Xyr Corp has a beta coefficient of 1.2. Kyr pays out 35% of its earnings in dividends and the latest earnings announced were $7.50/share. Dividends were just paid and are expected to be paid annually. You expect that Xyr will earn an RoE of 19% per year on all reinvested earnings forever.a. What is the intrinsic value of a...
The expected return of market portfolio is 10%. The standard deviation of market portfolio is 20%....
The expected return of market portfolio is 10%. The standard deviation of market portfolio is 20%. Risk free interest rate is 2%. There is an investor with mean-variance utility function  Answer the following questions. 1) Calculate the optimal weight to be invested in the market portfolio for the investor with A=5 . Calculate the expected return and standard deviation of the optimal complete portfolio for the investor. 2) According to the CAPM, calculate the expected returns of two stocks (stock 1...
You are the manager of a portfolio of risky securities. Your portfolio has an expected return...
You are the manager of a portfolio of risky securities. Your portfolio has an expected return (E(rP)) of 12% and a standard deviation (P) of 18%. The risk free rate (rf) is 6%. The following two clients want to invest some portions of their investment budget in your portfolio and the balance in the risk free asset: Client 1 needs an expected return of 10% from her complete portfolio. Client 2 needs a complete portfolio with a standard deviation of...
The risk-free rate of return is 6%, the expected rate of return on the market portfolio...
The risk-free rate of return is 6%, the expected rate of return on the market portfolio is 15%, and the stock of Xyrong Corporation has a beta coefficient of 2.3. Xyrong pays out 45% of its earnings in dividends, and the latest earnings announced were $9.00 per share. Dividends were just paid and are expected to be paid annually. You expect that Xyrong will earn an ROE of 18% per year on all reinvested earnings forever. a. What is the...
The risk-free rate of return is 10.0%, the expected rate of return on the market portfolio...
The risk-free rate of return is 10.0%, the expected rate of return on the market portfolio is 17%, and the stock of Xyrong Corporation has a beta coefficient of 1.6. Xyrong pays out 30% of its earnings in dividends, and the latest earnings announced were $15 per share. Dividends were just paid and are expected to be paid annually. You expect that Xyrong will earn an ROE of 20% per year on all reinvested earnings forever. a. What is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT