Question: State Probability Return on A Return on B Return on C Boom . State Probability Return A Return B Return C Boom .70 15% 8%

State Probability Return on A Return on B Return on C Boom .

State Probability Return A Return B Return C
Boom .70 15% 8% 4%
Bust .30 10% 6% -2%

Im trying to work out the problem in excel but im not getting it... I know the answer but would like help with how to work...

What is the expected return of a portfolio with 20% of the funds invested in A and the rest evenly divided between B and C?

A. 5.76% B. 6.12% C. 6.54% D. 7.30% E.7.60%

What is the standard deviation of a portfolio with 20% of the funds invested in A and the rest evenly divided between B and C?

A. 1.64 B. 1.72 C. 1.92 D. 2.06 E. 2.41

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Please Provide step by step work All work with methodology and equations used must be shown in detail. The actual equations and careful explanations are required to receive credit for answers, even...

Q:

Use this info for the next two problems. State Probability Return on A Return on B Return on C Boom .70 15% 8% 4% Bust .30 10% 6% -2% 20. What is the expected return of a portfolio with 20% of the...

Q:

1. What is the expected standard deviation of the returns of a portfolio that is invested 25 percent in Stock A, 40 percent in Stock B, and the remainder invested in Stock C? (Hint: create a column...

Q:

6. a required return of 11 percent. What is Stock B's required return? the risk-free rate is 5 percent. Stock A has a beta = 1.0 and Stock Bhas a beta = 1.4. Stock A has a. b. d. e. a. C. e. 12.4%...

Q:

State Probability Return (stock A) Return (stock B) Return (stock C) 1 0.35 10% 15% 20% 2 0.45 5% 7% 10% 3 0.20 4% 12% 6% WA = 10%, WB = 55%, WC = 35% Calculate the portfolio standard d eviation. 2....

Q:

1. What is the expected return for the following portfolio? Asset Return 20% 5% C 7% 12% Weight 1016 4096 20% a. The expected return given the weights above is not enough for your investor. Which...

Q:

A. A portfolio is comprised of 60% of Stock A and 40% of Stock B. Consider the following information, what is the expected return of the portfolio? State Probability Return on Stock A Return on Stock...

Q:

Suppose you are given returns for assets A, B and C in the table below: State Probability (P) Return A (RA) Return B (RB) Return C (RC) Boom 30% 25% -0.2 0.3 Average 50% 15% 0.15 0.2 Recession 20%...

Q:

3. Your broker offers you the opportunity to purchase a bond with coupon payments of $50 per year and a face value of $1000. If the yield to maturity on similar bonds is 6%, this bond should: A) Sell...

Q:

1. If you have one security with an expected return of 7% and a standard deviation of 2% and a second security with an expected return of 13% and a standard deviation of 2.4%, what would be the...

Q:

Find these values. a. Find u75 if un = 2n - 1. b. Find c. Find 75 (2n-1). (2n-1). 2-20

Q:

12) Which of the following assigns a value to the hourlyWagemember of employee[2]? A) employee[2]->hourlyWage = 50.00; B) employee2.hourlyWage = 7.50; C) hourlyWage[2].employee = 29.75 D)...

Q:

6. The masses of two spheres of the same material are 640 kg and 270 kg. Find the ratio of their diameters.

Q:

Correlations change over time. Assets tend to be more strongly positively correlated when the market crashes, and less positively correlated when the market booms. In your opinion, how do these...

Q:

3. How useful are social networking sites for sharing work-related information?

Q:

3. Obtain a copy of the ACAS Code of practice 1: disciplinary and grievance procedures (2009). Use this, and our suggestions in this chapter, to rewrite or modify either of the procedures you used...

Q:

describe the main features of a disciplinary procedure and of a grievance procedure