Expected return and standard deviation of portfolio

Assignment Help Financial Management

Reference no: EM132044307

Stock X has an expected return of 12% and the standard deviation of the expected return is 20%. Stock Z has an expected return of 7% and the standard deviation of the expected return is 15%. The correlation between the returns of the two stocks is +0.3. These are the only two stocks in a hypothetical world.

A. What is the expected return and the standard deviation of a portfolio consisting of 80% Stock X and 20% Stock Z? Will any rational investor hold this portfolio (in this hypothetical two stock world)? Explain why or why not.

B. What is the expected return and the standard deviation of a portfolio consisting of 20% Stock X and 80% Stock Z? Will any rational investor hold this portfolio (in this hypothetical two stock world)? Explain why or why not. (You might want to do Part C first).

C. What is the maximum amount of Stock Z a rational investor will hold in his or her portfolio? What is the expected return and the standard deviation of this portfolio? The maximum amount is a percentage between 0% and 100%, and to receive full credit your answer should be within 1 percentage points of the correct answer. (Hint: Set up Excel to calculate the portfolio expected return and standard deviation as a function of the portfolio weights, which must sum to 100%. You can find the correct answer to this part by manually changing the portfolio weights, or by using the Solver function on Excel).

D. Explain why different rational investors might hold different portfolios of these two stocks. Identify the range of portfolios a rational investor might hold. Your answer should take this form: A rational investor will hold a maximum of ___% in Stock X (with ___% in Z), or a minimum of _____% in Stock X (with _____ in Z). The set of feasible portfolios will fall within the range defined by these two end points.

Could you please show the excel formulas and its details.

Reference no: EM132044307

Questions Cloud

Difference between asset allocation and capital allocation : What is a complete portfolio? Please explain the difference between asset allocation and capital allocation.

Calculate annual operating CFs for miniature golf facility : Calculate annual operating CFs for the miniature golf facility for years 1-4. Calculate total CF for year 4 including the after-tax selling price.

Analyzing the cost of debt for firm : You are analyzing the cost of debt for a firm. What is the after-tax cost of debt for this firm if it has a 30 percent marginal and average tax rate?

Which stock is more liquid and why : Which stock is more liquid and why?

Expected return and standard deviation of portfolio : What is the expected return and the standard deviation of a portfolio consisting of 20% Stock X and 80% Stock Z?

The correct cost of common equity for the firm : The current cost of common equity for the firm % Link to Text What does management believe is the correct cost of common equity for the firm?

You are able to achieve your retirement objective : To ensure that you are able to achieve your retirement objective, what percentage of your after-tax monthly income must you save?

Three piggies enterprises has no debt : Three Piggies Enterprises has no debt. Its current total value is $76 million. What will its overall value be if it sells $35 million in debt?

What is the intrinsic value and time value of option today : What is the intrinsic value and the time value of the option today? What is the break-even future stock price associated with the options?

User Account

All Pages