Question

In: Statistics and Probability

Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500...

Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are $42.76, $81.33, and $58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3, respectively. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the table below.

Means

Stdevs

A

B

C

A

B

C

-30%

-25%

-15%

17%

10%

12%

-3%

4%

8%

10%

8%

6%

20%

25%

22%

15%

10%

10%

a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year.

Round your portfolio value answer to a whole number, and, if necessary, round your portfolio return answer to three decimal digits.

Portfolio value $
Portfolio return

How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? If necessary, round your answers to three decimal digits.

Pr(Portfolio return < 0%)
Pr(Portfolio return > 25%)

b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the file P16_20.xlsx. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a.

Great
Portfolio value $
Portfolio return
Pr(Portfolio return < 0%)
Pr(Portfolio return > 25%)

Repeat this if you learn that the economy is going to be awful.

Awful
Portfolio value $
Portfolio return
Pr(Portfolio return < 0%)
Pr(Portfolio return > 25%)

Solutions

Expert Solution


Related Solutions

You have a portfolio of three stocks: Stock A, Stock B, and Stock C.  The expected return...
You have a portfolio of three stocks: Stock A, Stock B, and Stock C.  The expected return of Stock A is 8%, the expected return of Stock B is 10%, and the expected return of Stock C is 12%.  The expected return of the portfolios is 10.5%. If the weight of asset B is three times the weight of asset A, what are the weights for the three assets?
Suppose Stocks A, B and C are the only three component stocks in a benchmark index....
Suppose Stocks A, B and C are the only three component stocks in a benchmark index. The number of shares outstanding of Stocks A, B and C are 371,000 shares, 312,000 shares, and 234,000 shares, respectively. The prices of Stocks A, B and C for Days 1, 2, 3 and 4 are given in the table below: Stock A Stock B Stock C Day 1 30.37 41.70 81.85 Day 2 31.03 40.61 78.65 Day 3 32.05 42.03 79.28 Day 4...
You own a portfolio consisting of the following stocks:
You own a portfolio consisting of the following stocks: Stock        % of Portfolio        Beta        Historical Return   Required Return 1 13% 1.15 .11 2 44% 0.95 .08   3 19% 1.60 .14   4 24% 1.30 .12 The risk-free rate is 5% and the expected market return is 10%. a. Calculate the required return for each stock.   b. Calculate the historical return on the portfolio.   c. Calculate the portfolio beta. d. Calculate the required return...
You currently Own a portfolio of two stocks. JH Chemical has an expected return of 11%...
You currently Own a portfolio of two stocks. JH Chemical has an expected return of 11% with a standard deviation of 15% while AAC Agriculture has an expected return of 15% with a standard deviation of 20%. The correlation coefficient between these two stocks is 0.30. A. If you invest $14,000 in JH and $6,000 in AAC, what is the expected return and standard deviation of the portfolio? Was risk reduced relative to the individual risk of each security? Why?...
Suppose we have three events, A, B, and C such that: - A and B are...
Suppose we have three events, A, B, and C such that: - A and B are independent - B and C are independent - P[AUBUC]=0.90 -P[A]= 0.20 - P[C]= 0.60 Compute P [C | AUB]
You have combined two stocks, A and B, into an equally weighted portfolio (Stable) and it...
You have combined two stocks, A and B, into an equally weighted portfolio (Stable) and it has a variance of 35%. The covariance between A and B is 25%. A is a resource stock and has a variance twice that of B. You have formed another portfolio (Growth) that has an expected return of 17% and a variance of 50%. The expected return on the market is 15% and the risk free rate is 7% Covariance (A,Market) = 22% and...
You are given the following three stocks and you have been asked to propose a portfolio...
You are given the following three stocks and you have been asked to propose a portfolio for a wealthy client. The client wants either a 2 asset (A-B, B-C, or A-C) or a 3 asset(A-B-C) portfolio. In any case, the portfolios must be equal weighted. Which of the four portfolios do you suggest to the client? Why? Show your work step by step. Stocks Mean Return Std of Return X 1.5 4 Y 4 8 Z 7 1 Correlations X...
You are given the following three stocks and you have been asked to propose a portfolio...
You are given the following three stocks and you have been asked to propose a portfolio for a wealthy client.  The client wants either a 2 asset (A-B, B-C, or A-C) or a 3 asset(A-B-C) portfolio. In any case, the portfolios must be equal weighted.  Which of the four portfolios do you suggest to the client? Why? Show your work step by step. Stocks Mean Return Std of Return X 1.5 4 Y 4 8 Z 7 1 Correlations X and Y...
(5) Suppose you have three test tubes with three substances, A, B, and C with nearly...
(5) Suppose you have three test tubes with three substances, A, B, and C with nearly the same melting point. Describe how would you proof experimentally (having only melting point apparatus in hand) that these are not the same substances.
I currently own a portfolio of stocks worth $10 million that has a beta of 1.2.  It...
I currently own a portfolio of stocks worth $10 million that has a beta of 1.2.  It has perfect positive correlation with the S&P500 index.  The risk-free rate is 3%, and the market risk premium for the S&P500 is 8%.  The S&P500 is currently valued at 2500.  The notional value of one contract is $250*S&P value. Calculate the one-year futures price on the S&P500 index. If I want to own a risk-free bond instead of the index, explain how I can do this without...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT