2 Consider the Excel template for the two-asset efficient frontier as provided in theannouncement 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?O About 14.48%About 20.77%O About 18.37%O About 13.45%Question 5Same setup as last question, but consider the minimum standard deviation when the SP500and the TBond are uncorrelated. Does it move down or up relative to the answer to Question4?It moves upIt moves down

Expected Returns and the risk of a portfolio: The expected return of a portfolio is the weighted…

Answered: Consider the Excel template for the…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter8: Analysis Of Risk And Return

Section: Chapter Questions

Problem 18P

See similar textbooks

Similar questions

The Ajax Company uses a portfolio approach to manage their research and development (RD) projects. Ajax wants to keep a mix of projects to balance the expected return and risk profiles of their RD activities. Consider a situation in which Ajax has six RD projects as characterized in the table. Each project is given an expected rate of return and a risk assessment, which is a value between 1 and 10, where 1 is the least risky and 10 is the most risky. Ajax would like to visualize their current RD projects to keep track of the overall risk and return of their RD portfolio. a. Create a bubble chart in which the expected rate of return is along the horizontal axis, the risk estimate is on the vertical axis, and the size of the bubbles represents the amount of capital invested. Format this chart for best presentation by adding axis labels and labeling each bubble with the project number. b. The efficient frontier of RD projects represents the set of projects that have the highest expected rate of return for a given level of risk. In other words, any project that has a smaller expected rate of return for an equivalent, or higher, risk estimate cannot be on the efficient frontier. From the bubble chart in part a, which projects appear to be located on the efficient frontier?
Assume that an investment is expected to generate the following returns: a 10% chance of a $1,400 return, a 50% chance of a $6,600 return, and a 40% chance of a $1,500 return. What is the expected rate of return on this investment? Note: The solution must be displayed on an Excel sheet using Excel functions such as =PV(...) and =FV(...) etc.
Using the information in the above table answer the following questions: a. What is the expected return of a portfolio with 40% in FUSTA and 60% in FANSA? b. What are the portfolio’s variance and standard deviation using the same asset weights from part (c)?
Drew can design a risky portfolio based on two risky assets, Origami and Gamiori. Origami has an expected return of 13% and a standard deviation of 20%. Gamiori has an expected return of 6% and a standard deviation of 10%. The correlation coefficient between the returns of Origami and Gamiori is 0. The risk-free rate of return is 4%. What is the portfolio weight of Gamiori in the minimum variance portfolio? 80.00% 20.00% 13.00% 10.00%
You are constructing a portfolio of two assets, Asset A and Asset B. The expected returns of the assets are 12 percent and 15 percent, respectively. The standard deviations of the assets are 29 percent and 48 percent, respectively. The correlation between the two assets is .25 and the risk-free rate is 5 percent. What is the optimal Sharpe ratio in a portfolio of the two assets? What is the smallest expected loss for this portfolio over the coming year with a probability of 2.5 percent?
You are evaluating various investment opportunities currently available and you have calculated expected returns and standard deviations for five different well-diversified portfolios of risky assets:Portfolio Expected Return Standard DeviationQ 7.8% 10.5%R 10.0 14.0S 4.6 5.0T 11.7 18.5U 6.2 7.5a. For each portfolio, calculate the risk premium per unit of risk that you expect to receive ([E(R) − RFR]/σ). Assume that the risk-free rate is 3.0 percent.b. Using your computations in Part a, explain which of these five portfolios is most likely tobe the market portfolio. Use your calculations to draw the capital market line (CML).c. If you are only willing to make an investment with σ = 7.0%, is it possible for you toearn a return of 7.0 percent?d. What is the minimum level of risk that would be necessary for an investment to earn7.0 percent? What is the composition of the portfolio along the CML that will generatethat expected return?e. Suppose you are now willing to make an investment…
You are evaluating various investment opportunities currently available and you have calculated expected returns and standard deviations for five different well-diversified portfolios of risky assets. PORTFOLIO EXPECTED RETURN STANDARD DEVIATION Q 7.8% 10.5% R 10.0% 14.0% S 4.6% 5.0% T 11.7% 18.5% U 6.2% 7.5% a) For each portfolio, calculate the risk premium per unit of risk that you expect to receive [(E(R) –RFR)/ơ]. Assume that the risk free rate is 3.0%. b) Using…
Which of the following will be a part of Efficient Frontier? A B C D E F Return (%) 8 8 12 4 9 8 Risk (Standard deviation) 4 5 12 4 5 6 Plot them in Risk return graph. Assuming correlation between A and C as 0.3, find the risk and return of the portfolio with 75 % proportion in A and 25 % in C, also interpret the result of such diversification.
Suppose the risk-free rate is 5.1 percent and the market portfolio has an expected return of 11.8 percent. The market portfolio has a variance of .0472. Portfolio Z has a correlation coefficient with the market of .37 and a variance of .3375 According to the capital asset pricing model, what is the expected return on Portfolio Z?
The firm wishes to estimate the beta of a portfolio that consists of two assets X and Y. The investment manager of the firm has gathered the following information on the two assets. Securities Rate of Return Standard Deviation Beta X 20% 20% 1.5 Y 10% 30% 1.0 Risk free asset 5% Calculate: The beta of the portfolio if 75% of the funds are invested in Y and 25% in X The portfolio expected return and the portfolio beta if you invest 35 % in X, 45% in Y and 20 % in the risk-free asset Assuming the CAPM applies, if the market’s expected return is 13 percent, the risk free rate is 8% and stock X’s required rate of return is 16%, what is the stock’s beta coefficient?
Assume that the short-term risk-free rate is 6%, the market index S&P500 is expected to pay returns of 30% with the standard deviation equal to 40%. Asset A pays on average 10%, has a standard deviation equal to 40% and is NOT correlated with the S&P500. Asset B pays on average 16%, also has a standard deviation equal to 40% and has a correlation of 1 with the S&P500. Determine whether asset A and B are overvalued or undervalued, and explain why. (Beta of asset i (?i) = ?i ?iM / ?M, where ?i, ?M are standard deviations of asset i and market portfolio, ?iM is the correlation between asset i and the market portfolio)
Drew can design a risky portfolio based on two risky assets, Origami and Gamiori. Origami has an expected return of 13% and a standard deviation of 20%. Gamiori has an expected return of 6% and a standard deviation of 10%. The correlation coefficient between the returns of Origami and Gamiori is 0.30. The risk-free rate of return is 2%. What is the Sharpe ratio of the optimal risky portfolio? A. 60.26% B. 12.19% C. 9.34% D. 47.78%

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS