Question

In: Finance

Stock A’s expected return and standard deviation are E[rA] = 6% and σA= 12%, while stock...

Stock A’s expected return and standard deviation are E[rA] = 6% and σA= 12%, while stock B’s expected return and standard deviation are E[rB] = 10% and σB= 20%.
(a) Using Excel to compute the expected return and standard deviation of the return on a portfolio with weights wA=0, 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, and 1, for the following alternative values of correlation between A and B: ρAB=0.6 and ρAB= -0.4. Under the two different correlations, plot the expected return—standard deviation pairs on a graph (with the standard deviations on the horizontal axis, and the expected returns on the vertical axis).
(b) How would you construct a portfolio p with expected return of 8% using Stock A and Stock B? What is the standard deviation of the portfolio? (Assume ρAB = 0.4)
(c) How would you construct a portfolio q with standard deviation of 15% using Stock A and Stock B? What is the expected return of the portfolio? (Assume ρAB = 0.4)
(d) If you want to have the minimum variance for your portfolio z, what will be your portfolio weights? In this case, what are the expected return and variance of your portfolio? (Assume ρAB = 0.4)

Solutions

Expert Solution

(a)

(b)

Expected Return = 0.08

Let Weight of A = x

Let Weight of B = 1-x

Expected Returns = Weight of A * Return of A + Weight of B * Return of B

0.08 = x * 0.06 + ( 1 - x ) * 0.10

0.08 = 0.06x + 0.10 - 0.10x

x = 0.5

So, Weight of A and B are 50% and 50% respectively.

Variance of Portfolio = Weight(A)2 * StDev(A)2 + Weight(B)2 * StDev(B)2 + 2 * Weight(A) * Weight(B) * Standard Deviation of A * Standard Deviation of B * Correlation

= 0.52 * 0.122 + 0.52 * 0.202 + 2 * 0.5 * 0.5 * 0.12 * 0.20 * 0.4

= 1.84%

Standard Deviation = Sqrt of Variance

SquareRoot of 1.84% is 13.56%

(c)

Stock A Stock B
Expected Returns 6% 10%
Standard Deviation 12% 20%
Weights 36% 64% 100%
Portfolio:-
Expected Return 8.54%
Standard Deviation 0.15
Correlation 0.4

Using Excel Solver, We got Expected return is 8.54%

(d)

Using Excel Solver:-

Weight of A is 86.36%

Weight of B is 13.64%

Portfolio Return is 6.55%

Portfolio Standard Deviation is 11.72%


Related Solutions

Stock 1 has a expected return of 12% and a standard deviation of 15%. Stock 2...
Stock 1 has a expected return of 12% and a standard deviation of 15%. Stock 2 has a expected return of 10% and a standard deviation of 12%. Correlation between the two stocks is 0.3. What is the investment proportion of stock 1 in the minimum variance portfolio?
Consider the following two assets: Asset A’s expected return is 15% and return standard deviation is...
Consider the following two assets: Asset A’s expected return is 15% and return standard deviation is 20%. Asset B’s expected return is 10% and return standard deviation is 15%. The correlation between assets A and B is 0.5. (a) w1=0.75, w2=.50, find out expected returns and SD/VARIANCE (b) Instead of a correlation of 0.5 between assets A and B, consider a correlation of - 0.5 and re-compute the above.
Suppose Merck stock offers an expected rate of return of 12% and a standard deviation of...
Suppose Merck stock offers an expected rate of return of 12% and a standard deviation of 25%. The risk-free rate is 5%. (a) Graph the Capital Allocation Lines (CAL) for Merck stock. (b) What is the Sharpe (reward-to-volatility) ratio of Merck stock? (c) If you have a portfolio of $15,000 with $5,000 invested in a risk free security and $10,000 in Merck stock, what is the expected rate of return of your portfolio? What is your portfolio's standard deviation? What...
1A) The XYZ Stock has an expected return of 12% and a standard deviation of 8%....
1A) The XYZ Stock has an expected return of 12% and a standard deviation of 8%. Assuming that returns are adequately explained by a normal distribution, what is the range of return you would expect to see 95% of the time? a. -12% to 36% b. 0% to 16% c. 4% to 20% d. -4% to 28% 1B) Which of the following statements correctly explains the coefficient of variation (CV)? (1) The CV is a relative measure of risk/return. (2)...
Stock A has an expected return of 12%, a standard deviation of 24% on its returns,...
Stock A has an expected return of 12%, a standard deviation of 24% on its returns, and a beta of 1.2. Stock B has an expected return of 15%, a standard deviation of 30% on its returns, and a beta of 1.5. The correlation between the two stocks is 0.8. If we invested $30,000 in Stock A and $20,000 in Stock B, what is the beta of our portfolio? Select one: a. 1.03 b. 1.25 c. 1.32 d. 1.40 e....
What is the expected standard deviation of stock A’s returns based on the information presented in...
What is the expected standard deviation of stock A’s returns based on the information presented in the table? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098. Note that figures in the table are presented in decimal format, not as percentages. Outcome Probability of outcome Stock A return in outcome Good 0.2 0.8 Medium 0.5 0.1 Bad ? -0.5
Stock X has an expected return of 11% and the standard deviation of the expected return...
Stock X has an expected return of 11% and the standard deviation of the expected return is 12%. Stock Z has an expected return of 9% and the standard deviation of the expected return is 18%. The correlation between the returns of the two stocks is +0.2. 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 90% Stock X and 10% Stock Z? Will any...
What are the expected return and standard deviation of stock A and stock B?
Consider the following information:            State    Probability      A           B                    Boom 0.6                    20%     -5%                    Bust     0.4                    -10% 10%What are the expected return and standard deviation of stock A and stock B?If you invest 50% of your money in stock A and 50% of your money in stock B, what are the expected return and standard deviation for the portfolio as a whole (considering both states of the economy)?Use the results...
The expected rate of return for Stock A is? The​ investment's standard deviation for stock A?...
The expected rate of return for Stock A is? The​ investment's standard deviation for stock A? COMMON STOCK A       COMMON STOCK B   PROBABILITY   RETURN   PROBABILITY   RETURN 0.20   11%   0.10   -4% 0.60   16%   0.40   7% 0.20   19%   0.40   14%        0.10   22%
The expected return on stock W is 10% and its standard deviation is 15%. Expected return...
The expected return on stock W is 10% and its standard deviation is 15%. Expected return on stock V is 16% and its standard deviation is 24%. The correlation between returns of W and V is 20%. calculate expected return and standard deviation of a portfolio that invests 40% in W and 60% in V. determine the minimum variance combination of W and V and determine its expected return and standard deviation. If the risk-free rate is 4%, determine the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT