7. Herbert Investments wants to prepare a portfolio comprising three stocks. They would like to earn at least a 9% return at lowest possible risk. MEAN RETURN STDEV OF RETURN (0) CORRELATIONS (R) LLR LZR TFE LLR 0.07 0.05 LLR 1 0.7 0.3 LZR 0.09 0.15 LZR 0.7 1 0.5 TFE 0.1 0.18 TFE 0.3 0.5 1 a. Find the optimal solution using an Excel spreadsheet model and Solver. Attach your spreadsheet model with the optimal solution. LLR: % LZR: % TFE: % Portfolio standard deviation:

7. Herbert Investments wants to prepare a portfolio comprising three stocks. They would like to earn at least a 9% return at lowest possible risk. MEAN RETURN STDEV OF RETURN (0) CORRELATIONS (R) LLR LZR TFE LLR 0.07 0.05 LLR 1 0.7 0.3 LZR 0.09 0.15 LZR 0.7 1 0.5 TFE 0.1 0.18 TFE 0.3 0.5 1 a. Find the optimal solution using an Excel spreadsheet model and Solver. Attach your spreadsheet model with the optimal solution. LLR: % LZR: % TFE: % Portfolio standard deviation:

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset: Portfolio X Y Z Market Risk-free Rp 11.0% ор 33.00% 10.0 28.00 8.1 10.4 5.2 18.00 23.00 Ө вр 1.45 1.20 0.75 1.00 Ө Assume that the correlation of returns on Portfolio Y to returns on the market is 0.66. What percentage of Portfolio Y's return is driven by the market? Note: Enter your answer as a decimal not a percentage. Round your answer to 4 decimal places. R-squared
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset: Portfolio Y Z Market Risk-free Rp 13.5% бр 35.00% 12.5 30.00 7.1 20.00 10.6 4.4 25.00 0 Вр 1.55 1.20 0.80 1.00 0 Assume that the correlation of returns on Portfolio Y to returns on the market is 0.70. What percentage of Portfolio Y's return is driven by the market? Note: Enter your answer as a decimal not a percentage. Round your answer to 4 decimal places. × Answer is complete but not entirely correct. R-squared 0.9785
Assume the APT equation for portfolios A and B with the following system of equations: E[rA] = λ0 + (λ1)3 + (λ2)0.2 = 11.0 E[rB] = λ0 + (λ1)2 + (λ2)1 = 13.0 Assume the following: . The risk free rate is λ0 = Rf = 5 . The expected return on the market portfolio is RM = 10 . Expected returns are consistent with the CAPM. . (hint: note that λ1 = E[RA] − Rf and λ2 = E[RB] − Rf ). Answer the following: (a) What are λ1 and λ2? (b) What is the CAPM β associated with the pure portfolio associated with factor 1? (c) What is the CAPM β associated with the pure portfolio associated with factor 2?
1. Given the following summary statistics, Mean S.D. 1.235 0.997 Asset A 0.52 Asset B. 0.44 (a) If the correlation between the two financial series is 0.25. What are the optimal portfolio weights to minimize risk? (b) What are the expected return and standard deviation of the optimal port- folio? (c) Compute the 1% Value-at-Risk for the next 5 days (d) Compute the expected shortfall
Use the following CAPM equation for a portfolio to answer the questions that follow:E(RP) = RF + βP (RM – RF) = 1 + 0.8 (5 – 1) = 4.2% a) Is the portfolio defensive or aggressive. Why? b) If the actual portfolio return is 6%, what is the portfolio’s alpha?
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset: Portfolio X Y Z Market Risk-free Rp 14.0% 13.0 .8.5 12.0 7.2 Ор 39.00% 34.00 24.00 29.00 0 Bp 1.50 1.15 0.90 1.00 0 Assume that the correlation of returns on Portfolio Y to returns on the market is 0.90. What percentage of Portfolio Y's return is driven by the market? Note: Enter your answer as a decimal not a percentage. Round your answer to 4 decimal places. R-squared
If E(rX)=0.12 and E(rY)=0.08, what would be the expected rate of return of a portfolio made of 30% of X and 70% of Y? A. 0.080 B. 0.120 C. 0.108 D. 0.092 E. 0.100
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset: 8p 1.70 1.30 0.85 1.00 Portfolio X Y Z Market Risk-free Rp 11.5% 10.5 7.2 10.9 4.6 R-squared op 38.00% 33.00 23.00 28.00 0 Assume that the correlation of returns on Portfolio Y to returns on the market is 0.76. What percentage of Portfolio Y's return is driven by the market? Note: Enter your answer as a decimal not a percentage. Round your answer to 4 decimal places.
The risk free rate is 3%. The optimal risky portfolio has an expected return of 9% and standarddeviation of 20%. Answer the following questions.a) Assume the utility function of an investor is U = E(r) − 0.5Aσ2. What is condition ofA to make the investors prefer the optimal risky portfolio than the risk free asset? b) Assume the utility function of an investor is U = E(r) − 2.5σ2. What is the expectedreturn and standard deviation of the investor’s optimal complete portfolio?
Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA = 3.50% + 0.65RM + еA RB ом = -1.60% +0.80RM + eB = = 21%; R-squareд 0.22; R-squareg = 0.14 Assume you create a portfolio Q, with investment proportions of 0.50 in a risky portfolio P, 0.30 in the market index, and 0.20 in T-bill. Portfolio P is composed of 60% Stock A and 40% Stock B. Required: a. What is the standard deviation of portfolio Q? Note: Calculate using numbers in decimal form, not percentages. For example use "20" for calculation if standard deviation is provided as 20%. Do not round intermediate calculations. Round your answer to 2 decimal places. b. What is the beta of portfolio Q? Note: Calculate using numbers in decimal form, not percentages. For example use "20" for calculation if standard deviation is provided as 20%. Do not round intermediate calculations. Round your answer to 2 decimal places. c. What is the "firm-specific" risk of portfolio Q? Note:…
Suppose we have the following information: Securit Amount Invested Expected Return Beta Stock A RM1 ,OOO 8% 0.80 Stock B RM2,OOO 12% 0.95 Stock C RM3,OOO 15% 1.10 Stock D RM4,OOO 18% a) Compute the expected return on this portfolio. b) Calculate the beta of the portfolio. c) Does this portfolio have more or less systematic risk than an average asset? Explain.
Consider an investment portfolio that consists of three different stocks, with the amount invested in each asset shownbelow. Assume the risk-free rate is 2.5% and the market risk premium is 6%. Use this information to answer thefollowing questions.Stock Weights BetasChesapeake Energy 25% 0.8Sodastream 50% 1.3Pentair 25% 1.0a) Compute the expected return for each stock using the CAPM and assuming that the stocks are all fairly priced.b) Compute the portfolio beta and the expected return on the portfolio.c) Now assume that the portfolio only includes 50% invested in Pentair and 50% invested in Sodastream (i.e., a twoassetportfolio). The yearly-return standard deviation of Pentair is 48% and the yearly-return standard deviation ofSodastream is 60%. The correlation coefficent between Pentair’s returns and Sodastream’s returns is 0.3 What is theexpected yearly-return standard deviation for this portfolio?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS