You are here

A two security portfolio

29 April, 2015 - 17:42

When building a portfolio, it is important not only to consider the individual securities in a portfolio, but also how they interact with one another. For example, consider a portfolio that contains two stocks, XYZ and ABC.

The following formula finds the variance of a portfolio using the correlation (rho) between two stocks in a portfolio:

\sigma^2_{portfolio} = x^2_1 \sigma^2_1 + x^2_2 \sigma^2_2 + 2(x_1x_2\rho_{12}\sigma_1\sigma_2)

Where x represents the weight of each security in the portfolio.

So, let us suppose the following information:

  XYZ ABC
Price $50 $60
Shares 20 15
Variance 0.02 0.04
Std. Dev. 0.1414 0.2
 

And the correlation between the two is 0.25

Find the variance of this portfolio.

The first thing we must do is determine the relative weights of each stock. We see that we have $1000 in XYZ, and 900 in ABC. Therefore x1=0.53 and x2=0.47. The other relevant information is listed, so we simply plug it into the equation:

\sigma^2_p = 0.53^2 (0.02) + .47^2 (0.04) + 2(0.53*0.47*0.25*0.1414*0.2) = 0.01798

Now let us say we were trying to find the Beta of the XYZ company, and we know that the market has a variance of 0.04. The following formula will allow us to do so:

\beta_i = \frac{\sigma_{im}}{\sigma^2_m}

First, we will need to find the covariance (\sigma_{12}) between the market and XYZ. For that, we will use the following formula:

\sigma_{12} = \rho_{12}\sigma_1\sigma_2

For this exercise we will need to know the correlation between the market and XYZ, which we will say is 0.75. Therefore:

\sigma_{12} = 0.75*0.1414*0.2 = 0.02121

Applying our covariance of 0.02121 to the formula for beta, we find that:

\beta_i = \frac{0.02121}{0.04} = 0.53