Consider the Excel template for the two-asset efficient frontier as provided in the announcement for the quiz. Set the mean return for the SP500 to be 10% with 20 % standard deviation (green box) Set the mean return for the TBond to be 5% with 10% standard deviation (green box) Set the correlation between the SP500 and the TBond to be 10% (green box) Set the target portfolio return to be 10% in expectation (yellow box) Find the minimum standard deviation using Excel's solver (blue box). What is it?

Consider the Excel template for the two-asset efficient frontier as provided in the announcement for the quiz. Set the mean return for the SP500 to be 10% with 20 % standard deviation (green box) Set the mean return for the TBond to be 5% with 10% standard deviation (green box) Set the correlation between the SP500 and the TBond to be 10% (green box) Set the target portfolio return to be 10% in expectation (yellow box) Find the minimum standard deviation using Excel's solver (blue box). What is it?

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

Suppose that optimal risky portfolio has an expected return of 16% and a varianceof 0.04. The risk-free rate is 4%.a) Find the slope of Capital Market Line (Optimal Capital Allocation Line)?b) What is the expected return of a portfolio C, which is on Capital Market Line and has astandard deviation of 0.08?
Suppose the risk free rate is 5% and the market portfolio has an expected return of 10%. Portfolio Z has a correlation coefficient with the market of 0.1 and a variance of 0.16. The market portfolio has a variance of 0.09. According to the CAPM, what is the beta of portfolio Z?
Consider an environment of 40 individual risky securities and one risk free asset. One investoris selecting between the Markowitz mean-variance frontier framework and the index model inthe portfolio analysis. Answer the following questions: (a) How many parameters are used as the input to construct the mean-variance frontier (b) How many inputs are used for the index model? calculate aswell
Suppose an investor uses two stocks A and B to build a risky portfolio. The following information is given: E(r_A)=10%,E(r_B)=12%,0_A=15%,o_B=20%, p_AB=0.4,r_f=2%. Denote the optimal risky portfolio investor can achieve with the highest Sharpe ratio by portfolio O. Calculate the weights of A and B (w_A and w_B) in the optimal risky portfolio O. Calculate the expected return and standard deviation of return for portfolio O. Calculate the Sharpe ratio of portfolio O.
Following is information for the required returns and standard deviations of returns for A, B, and C. The correlation coefficients for each pair also are shown below in a matrix. Which is the portfolio you will recommend AB, AC, or BC, and why? A B C Required Rate of return 7% 10% 20% Standard Deviation 33% 54% 90% Coefficient A,B 0.16 Coefficient A,C 0.19 Coefficient B,C 0.17
A single mispriced asset has an alpha a = 3.0%, a beta ẞ = 1, and unsystematic risk σ² = 9%. The market risk premium is 5.0% and the market's standard deviation is 0.1. What is the information ratio of the mispriced asset? In constructing an optimal allocation between this mispriced asset and the market portfolio, what proportion of your investment would you place in the mispriced asset? Oa. 0.1; 6.67% O b. 0.33; 6.67% O c. 0.33; 6.90% O d. 0.1; 66.67% O e. 0.1; 6.90%
Calculate the optimal risky portfolio for the following cases when short-sales are allowed. Compute its expected return and the standard deviation of its returns. 1. Two risky assets: Rp = 3, R' = [6, 9], and 4 5 5 20 2. Three risky assets: Rp = 4, R' = [5,9, 8], and [10 0 0 E=0 40 0 0 20 3. Three risky assets: Rp = 5, R' = [12, 9, 8], and 40 10 -5] E= 10 20 0 5 0 30 4. Five risky assets: Rp = 2, R' = [5, 3, 18, 9, 2], and %3D 2 16 0. -12 5 -12 20 16 10 7 14 27 14 9. -13 8. 7 27 13
An investment has been found to have two different IRRs, one at 14% and the other at 20%. When a required return of 17% is used, the NPV of the investment is negative. Knowing this: a. What range of required returns will generate a negative NPV? b. What range of required returns will generate a positive NPV?
4. Suppose there are three uncorrelated assets. Each has a variance of 1.0 and expected rates of return are 1, 2, and 3, respectively. For this example, short sales are allowed. Do the following: a. Find the minimum variance portfolio for the following desired expected portfolio rates of return: 1.0, 1.5, 2.0, 2.5, and 3.0. b. Sketch these on the return versus risk plot (you will need to use the standard deviation of the portfolio, which clearly equals sqrt(w1^2+w2^2+w3^3), where wi are the weights). c. Suppose we have a risk-free asset with a return of 2%. Modify your plot for b.
Asset W has an expected return of 13.15 percent and a beta of 1.28. If the risk free rate is 4.53 percent, complete the following table for portfollos of Asset W and a risk-free asset. Note: Leave no cells blank- be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your portfolio expected return answers as a percent rounded to 2 decimal places, e.g., 32.16. Enter your portfolio beto answers rounded to 3 decimal places, e.g. 32.161. Percentage of Portfolio Expected Portfolio in Asset W Return 0% 25 50 25 100 125 150 453 % 669% 184% 11.00% 13.15 % 15.31% 17.46% Portfolio Beta 0250 0640 1024 1.200 6057 006
Rank the following risky investment projects based on stochastic dominance. Project P Project Q Payoff Probability Payoff Probability 20 0.3 30 0.25 40 0.4 50 0.25 70 0.2 60 0.25 80 0.1 90 0.25
Explain well all question with proper answer. And type the answer step by step.

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