« Calculation of the coefficient of variation | Main | CFM certification will not be available soon »

Covariance and Calculation of Portfolio Variance

Now, let's go to the next step - calculation of the expected return, the variance and the standard deviation of our portfolio, consisting of the two assets: 60% of the asset A and 40% of the asset B. Future returns of the assets A and B are considered as a random variables R A и RB.

Expected return of the asset A is 10% and the standard deviation is 8.66%. Expected return of the asset B is 15%, the standard deviation is 12%.

The calculation of the portfolio expected return is a fairly straightforward. But the calculation of the standard deviation and variance of the portfolio is more complicated, because portfolio variability (standard deviation) is not the weighted-average of the variabilities of the individual assets. Diversification reduces the variability of the portfolio, because the prices of different assets vary differently. In many cases, the decrease in price of one asset is compensated by the price growth for another.

Portfolio expected return is the weighted average of the expected returns of the individual assets held in our portfolio:

r = 0,6*rA + 0,4*rB
r = 0,6*10% + 0,4*15% = 12%

For calculation of the variance σ² and the standard deviation σ of the portfolio return, we need to know the covariance between assets A and B. Covariance is the measure of how much returns of two assets vary together. This is distinct from variance, which measures how much a single asset varies.

The formula for the covariance is:

σ12 = E(RA - rA)(RB - rB)

It follows from the formula above, that the covariance of an asset with itself σ11 is its variance σ1².

The value of the covariance will be given in the exam problems. Or, instead of the covariance, it will be given the value of the coefficient of correlation. The coefficient of correlation is a dimensionless measure and can be expressed as the standardized covariance. The correlation coefficient varies between -1 and +1.

The correlation coefficient formula is:

ρ12 = σ12/σ1σ2

Say ρ12 = 0.7.

The correlation coefficient ρ12  and the covariance σ12 are positive, if the returns of assets move in the same direction (in most cases). Correlation and covariance are negative, when returns move in the opposite directions. If the returns are independent then the correlation coefficient is 0.

For calculation of the portfolio variance we need to fill the following matrix. The (i; j) element is the (XiXj σij ), where Xi - the weights of assets A and B in the portfolio.

 

This matrix is very like covariance matrix. The (i; j) element of covariance matrix is (σij ).  

 

Next, we simply summarized the elements of out matrix and calculate the portfolio variance:
σ² = X1² σ1² + X2² σ2² + 2(X1X2 ρ12 σ1σ2)
or for general case of N assets:
 
Calculation of portfolio variance:
σ² = 0,6² * 8,66² + 0,4² *12² + 2*( 0,6 * 0,4 * 0,7 * 8,66 * 12) = 84,96

Standard deviation is equal the square root of the variance:
σ = √84,96 = 9,22

it is easy to verify that if the correlation coefficient is +1 then portfolio standard deviation is equal the weighted average of the standard deviations of the individual portfolio assets σ = X1 σ1 + X2 σ2. If the correlation coefficient is -1 then portfolio standard deviation is equal σ = x1 σ1 - X2 σ2 and it is possible to achieve the zero portfolio standard deviation by varying the proportion of assets weights X1 and ;X2 in the portfolio. Unfortunately, it is not possible in practice.

 

Technorati Tags:

Posted by mazoo at August 23, 2006 12:49 PM

Related posts:

Calculation of the coefficient of variation Aug 17, 2006
Quantity variance is the sum of mix and yield variances Dec 06, 2005
Simple Linear Regression Equation Part 2 Mar 21, 2005

Comments

if the standard deviation of A is :30% and the standard deviation of B is : 40% and the covariance between assets A and B is :35%
whats the correlation coefficient of the portfolio :
1- 0
2- +1
3- -1
4- 35

Posted by: mariana at October 23, 2007 8:51 PM

aewdsa saf wefrasf adsf sdaf

Posted by: Jessica at January 28, 2008 8:19 PM

aewdsa saf wefrasf adsf sdaf

Posted by: Jessica at January 28, 2008 8:19 PM

Post a comment




Remember Me?