Portfolio Theory 3
tool is therefore used only in the event that assets are held in a combination, due to the
interrelatedness of assets, when they are held together. The interrelatedness is measured using
correlation coefficient, which lies between -1and and +1. This is to mean that assets which are
held together can either be positively correlated or negatively correlated. Since the assets are
three in number, the returns for the three assets is calculated as follows:
Return for asset A, B and C = 1/3(33.3) +1/3(33.3) +1/3(33.3)
11.1+11.1+11.1= 33.3%
The expected return when the assets are combined is 33.3%. This is due to the fact that they are
combined at an equal rate. Standard deviation is therefore derived using the overall rate of return
expected from the assets done in the excel sheet. The results of standard deviation shown the
level of consistency trend shown in combination of this assets.
From the results in the excel sheet, the results are: 1.11, 2.44 and 0.78 for companies 1, 2
and 3 respectively. As has been mentioned above, standard deviation is used to measure
consistency, which is not evident in the results gotten. This therefore means that the consistency
of these investments is in doubt.
Covariance and Correlation of the Portfolio
Covariance measures the variation of assets being combined, the possible returns and the
tendency to move up and down .Due to the fact that the investment is distributed equally in the
various three industries, the probabilities of the assets will be 0.333, 0.333, and 0.333.
Covariance is therefore calculated as follows:
Combination for these three assets, for the grouping of companies is done as shown below
Covariance A and B, Covariance of B and C, Covariance of A and C, which is
0.333 (0) + 0.333 (0) +0.333 (0)