Portfolio Variance
A statistical value that assesses the degree of dispersion of a portfolio's returns
A statistical value that assesses the degree of dispersion of a portfolio's returns
Portfolio variance is a statistical value that assesses the degree of dispersion of the returns of a portfolio. It is an important concept in modern investment theory. Although the statistical measure by itself may not provide significant insights, we can calculate the standard deviation of the portfolio using portfolio variance.
The calculation of portfolio variance considers not only the riskiness of individual assets but also the correlation between each pair of assets in the portfolio. Thus, the statistical variance analyzes how assets within a portfolio tend to move together. The general rule of portfolio diversification is the selection of assets with a low or negative correlation between each other.
CFI’s Math for Corporate Finance Course explores the financial mathematics concepts required for Financial Modeling.
The variance for a portfolio consisting of two assets is calculated using the following formula:
Where:
Note that covariance and correlation are mathematically related. The relationship is expressed in the following way:
Where:
Knowing the relationship between covariance and correlation, we can rewrite the formula for the portfolio variance in the following way:
The standard deviation of the portfolio variance can be calculated as the square root of the portfolio variance:
Note that for the calculation of the variance for a portfolio that consists of multiple assets, you should calculate the factor 2w_{i}w_{j}Cov_{i.j} (or 2w_{i}w_{j}ρ_{i},_{j,}σ_{i}σ_{j}) for each possible pair of assets in the portfolio.
Fred holds an investment portfolio that consists of three stocks: stock A, stock B, and stock C. Note that Fred owns only one share of each stock. Information about each stock is given in the table below:
Fred wants to assess the risk of the portfolio using portfolio variance and portfolio standard deviation.
Firstly, he needs to determine the weights of each stock in the portfolio. It can be done by dividing the total value of each stock by the total portfolio value. Note that Fred owns only one share of each stock.
In addition, he needs to know the correlation between each pair of stocks. His calculations show the following correlations:
The portfolio variance can be calculated in the following way:
CFI offers the Financial Modeling & Valuation Analyst (FMVA)™ certification program for those looking to take their careers to the next level. To keep learning and advancing your career, the following resources will be helpful:
Get world-class financial training with CFI’s online certified financial analyst training program!
Gain the confidence you need to move up the ladder in a high powered corporate finance career path.
Learn financial modeling and valuation in Excel the easy way, with step-by-step training.