In: Finance
Using the data in the following table, answer parts (i) – (v).
Year |
Stock X |
Stock Y |
2012 |
-11% |
-5% |
2013 |
15% |
25% |
2014 |
10% |
15% |
2015 |
-5% |
-15% |
2016 |
5% |
-5% |
2017 |
8% |
-2% |
2018 |
7% |
10% |
2019 |
5% |
15% |
Average return |
||
Standard deviation |
||
Correlation between Stock X and Stock Y |
0.7567 |
i. The average return for stock X, is
= 4.25%
The average return for stock Y, is
= 4.75%
Hence, the average return for stock X is 4.25 and stock Y is 4.75%.
---------------------------------------------------------------------------------------------------------------------
ii. The standard deviation for stock X, is
= 8.362
The standard deviation for stock Y, is
= 13.488
Hence, the standard deviation for stock X is 8.362% and stock Y is 13.488%.
------------------------------------------------------------------------------------------------------------------------------------
iii. The expected return of the portfolio, is
= 4.375%
Therefore, the expected return of the portfolio is 4.375% .
--------------------------------------------------------------------------------------------------------------------------------
iv. The standard deviation of the portfolio, is
= 9.095%
Therefore, the standard deviation of the portfolio is 9.095%
-----------------------------------------------------------------------------------------------------------------------------
v. If the correlation is reduced to 0.35, we compute the standard deviation
= 8.094%
Thus, we can say that when the correlation is reduced to 0.35, the standard deviation of the portfolio is also reduced.