In: Finance
Ms. Smith wants to invest in two securities, ABC and PQR, and the relevant information is below: State of the Economy Probability Return on ABC (%) Return on PQR (%) Bear 0.25 -15% 4% Moderate 0.5 5% 4% Bull 0.25 20% 4%
a. Calculate expected returns and standard deviations of two securities.
b. Ms. Smith shorts $1,000 of PQR and invests all proceeds from this short sale as well as $3,000 of her own money into ABC. What is the expected return and the standard deviation of her portfolio?
Total Portfolio value = Value of ABC + Value of PQR |
=4000+-1000 |
=3000 |
Weight of ABC = Value of ABC/Total Portfolio Value |
= 4000/3000 |
=1.3333 |
Weight of PQR = Value of PQR/Total Portfolio Value |
= -1000/3000 |
=-0.3333 |
ABC | |||||
Scenario | Probability | Return% | =rate of return% * probability | Actual return -expected return(A)% | (A)^2* probability |
Bear | 0.25 | -15 | -3.75 | -18.75 | 0.008789063 |
Moderate | 0.5 | 5 | 2.5 | 1.25 | 0.000078125 |
Bull | 0.25 | 20 | 5 | 16.25 | 0.006601563 |
Expected return %= | sum of weighted return = | 3.75 | Sum=Variance ABC= | 0.01547 | |
Standard deviation of ABC% | =(Variance)^(1/2) | 12.44 | |||
PQR | |||||
Scenario | Probability | Return% | =rate of return% * probability | Actual return -expected return(A)% | (B)^2* probability |
Bear | 0.25 | 4 | 1 | 0 | 0 |
Moderate | 0.5 | 4 | 2 | 0 | 0 |
Bull | 0.25 | 4 | 1 | 0 | 0 |
Expected return %= | sum of weighted return = | 4 | Sum=Variance PQR= | 0 | |
Standard deviation of PQR% | =(Variance)^(1/2) | 0 | |||
Covariance ABC PQR: | |||||
Scenario | Probability | Actual return% -expected return% for A(A) | Actual return% -expected return% For B(B) | (A)*(B)*probability | |
Bear | 0.25 | -18.75 | 0 | 0 | |
Moderate | 0.5 | 1.25 | 0 | 0 | |
Bull | 0.25 | 16.25 | 0 | 0 | |
Covariance=sum= | 0 | ||||
Correlation A&B= | Covariance/(std devA*std devB)= | 0 | |||
Expected return%= | Wt ABC*Return ABC+Wt PQR*Return PQR | ||||
Expected return%= | 1.3333*3.75+-0.3333*4 | ||||
Expected return%= | 3.67 | ||||
Variance | =( w2A*σ2(RA) + w2B*σ2(RB) + 2*(wA)*(wB)*Cor(RA, RB)*σ(RA)*σ(RB)) | ||||
Variance | =1.3333^2*0.12437^2+-0.3333^2*0^2+2*1.3333*-0.3333*0.12437*0*0 | ||||
Variance | 0.0275 | ||||
Standard deviation= | (variance)^0.5 | ||||
Standard deviation= | 16.58% |