In: Finance
Your boss has asked for your assistance regarding the company’s investments. One of their current investments has $10 million invested in long-term corporate bonds. This bond portfolio's expected annual rate of return is 9%, and the annual standard deviation is 10%.
An external firm was contacted to see if the company could improve their return. Their recommendation has the company invested in an index fund that closely tracks the Standard & Poor's 500 Index. The index has an expected return of 14%, and its standard deviation is 16%.
After consideration, you suggest the company puts all these funds into a combination evenly split between the index fund and corporate fund. Your boss likes the suggestion but wants to see proof that your return is better than the outside organization. She all wants to make certain that you considered risk when making your suggestion.
How do you determine the correlation coefficient?
What is the rate of return for a 50/50 mix of the two portfolios?
What is the standard deviation for a 50/50 mix of the two portfolios?
In the question, followings values are given,
Expected return of bond portfolio (let us assume it to ERX) = 9%,
Standard Deviation of bond portfolio (SDX) = 10%,
Expected return of index portfolio (let us assume it to ERy) = 14%,
Standard Deviation of index portfolio (SDY) = 16%
Let denote Weightage of bond portfolio as WX and index portfolio as WY. Therefore, WX = WY = 0.5
Now, the correlation coefficient can be found by using the following formula,
Correlation Coefficient(X,Y) = COV(X,Y)/ (SDX*SDY) ; where COV(X,Y) = Covariance of X and Y; SDX and SDY refers to Standard Deviation of X and Y respectively
And formula for COV(X,Y) is,
COV(X,Y) = ERX * ERY / (Number of Assets) = (9%*14%)/2 = 0.0063
Correlation Coefficient = COV(X,Y)/ (SDX*SDY). = 0.0063/ (10%*16%) = 0.39
Rate of return or a 50/50 mix of the two portfolios = WX * ERX + WY * ERY = 0.5*9% + 0.5 *14%
Or, Rate of return or a 50/50 mix of the two portfolios = 11.5%
Standard deviation for a 50/50 mix of the two portfolios = (WX2 * SDX2 + 2* WX * WY * SDX * SDY * Coefficient Correlation +WY2 * SDY2)^(1/2) = (0.5^2*10%^2 + 2*0.5*0.5*10%*16%*0.39 + 0.5^2 * 16%^2)^(1/2) = (0.0025 + 0.00312 + 0.0064)^(1/2)
Or, Standard deviation for a 50/50 mix of the two portfolios = 10.96%