How Can I Measure Portfolio Variance?

Portfolio variance is a measure of the dispersion of returns of a portfolio. It is the aggregate of the actual returns of a given portfolio over a set period of time.

Portfolio variance is calculated using the standard deviation of each security in the portfolio and the correlation between securities in the portfolio.

Modern portfolio theory (MPT) states that portfolio variance can be reduced by selecting securities with low or negative correlations in which to invest, such as stocks and bonds.

Key Takeaways

  • Portfolio variance is essentially a measurement of risk.
  • The formula helps to determine if the portfolio has an appropriate level of risk.
  • Modern portfolio theory states that portfolio variance can be reduced by selecting a mix of assets with low or negative correlations.

Calculating the Portfolio Variance of Securities

To calculate the portfolio variance of securities in a portfolio, multiply the squared weight of each security by the corresponding variance of the security and add two multiplied by the weighted average of the securities multiplied by the covariance between the securities.

To calculate the variance of a portfolio with two assets, multiply the square of the weighting of the first asset by the variance of the asset and add it to the square of the weight of the second asset multiplied by the variance of the second asset. Next, add the resulting value to two multiplied by the weights of the first and second assets multiplied by the covariance of the two assets.

The general formula is

Portfolio variance = w12σ1+ w22σ2+ 2w1w2Cov1,2

Where:

  • w1 = the portfolio weight of the first asset
  • w2 = the portfolio weight of the second asset
  • σ1= the standard deviation of the first asset
  • σ2 = the standard deviation of the second asset
  • Cov1,2 = the covariance of the two assets, which can thus be expressed as p(1,2)σ1σ2, where p(1,2) is the correlation coefficient between the two assets

Sample Calculation

For example, assume you have a portfolio containing two assets, stock in Company A and stock in Company B. While 60% of your portfolio is invested in Company A, the remaining 40% is invested in Company B. The annual variance of Company A's stock is 20%, while the variance of Company B's stock is 30%.

The wise investor seeks an efficient frontier. That's the lowest level of risk at which a target return can be achieved.

The correlation between the two assets is 2.04. To calculate the covariance of the assets, multiply the square root of the variance of Company A's stock by the square root of the variance of Company B's stock. The resulting covariance is 0.50.

The resulting portfolio variance is 0.36, or ((0.6)^2 * (0.2) + (0.4)^2 * (0.3) + (2 * 0.6 * 0.4 * 0.5)).

Portfolio Variance and Modern Portfolio Theory

Modern portfolio theory (MPT) is a framework for constructing an investment portfolio. MPT takes as its central premise the idea that rational investors want to maximize returns while minimizing risk, sometimes measured using volatility.

Therefore, investors seek what is called an efficient frontier, or the lowest level of risk and volatility at which a target return can be achieved.

Measuring Risk

Following MPT, risk can be lowered in a portfolio by investing in non-correlated assets. That is, an investment that might be considered risky on its own can actually lower the overall risk of a portfolio because it tends to rise when other investments fall.

This reduced correlation can reduce the variance of a theoretical portfolio. In this sense, an individual investment's return is less important than its overall contribution to the portfolio in terms of risk, return, and diversification.

The level of risk in a portfolio is often measured using standard deviation, which is calculated as the square root of the variance. If data points are far away from the mean, the variance is high and the overall level of risk in the portfolio is high as well.

Standard deviation is a key measure of risk used by portfolio managers, financial advisors, and institutional investors. Asset managers routinely include standard deviation in their performance reports.

What Is the Formula for the Variation of the Portfolio?

The formula for finding the variation of a portfolio is:

  • portfolio variance = w12σ12 + w22σ22 + 2w1w2Cov1,2

Is Variance the Same As Standard Deviation?

No, variance is not the same as standard deviation. When trying to understand variance vs. standard deviation, remember that variance is the average distance from the mean, while standard deviation is the square root of that variance.

How Do You Find the Variance of a Portfolio in Excel?

If you'd like to find the variance of a portfolio in Excel, you can use the VAR , VAR.S, or VARA functions on a set, or VAR, VAR.P, or VARPA on a population.

The Bottom Line

Diversifying a portfolio requires assets that don't rise or fall together, so you can lower risk and benefit from market changes no matter which direction it moves. When you know how to calculate the variance of a portfolio, you'll be equipped to identify assets within the portfolio with low or negative correlation with each other. You can find the variance of a portfolio by multiplying the squared weight of each security by the corresponding variance of the security. Then, add two multiplied by the weighted average of the securities multiplied by the covariance between the securities.

Article Sources
Investopedia requires writers to use primary sources to support their work. These include white papers, government data, original reporting, and interviews with industry experts. We also reference original research from other reputable publishers where appropriate. You can learn more about the standards we follow in producing accurate, unbiased content in our editorial policy.
  1. Markowitz, Harry. "Portfolio Selection." The Journal of Finance, vol 7, no. 1, 1952, pp. 77-91.

Take the Next Step to Invest
×
The offers that appear in this table are from partnerships from which Investopedia receives compensation. This compensation may impact how and where listings appear. Investopedia does not include all offers available in the marketplace.