A:

Value at risk (VaR) is one of the most widely known measurements in the process of risk management.  Risk management's aim is to identify and understand exposures to risk, to measure that risk, and then use those measurements to decide how to address those risks. Topically, VaR accomplishes all three; it shows a normal distribution of past losses – of, say, an investment portfolio – and it calculates a confidence interval about the likelihood of exceeding a certain loss threshold; the resulting info can then be used to make decisions and set strategy.

Stated simply, the VaR is a probability-based estimate of the minimum loss in dollar terms we can expect over some period of time.

## Pros and Cons to Value at Risk

There are a few pros and some significant cons to using VaR in risk measurement.  On the plus side, the measurement is widely understood by financial-industry professionals and as a measure, it's easy to understand. Communication and clarity are important, and if a VaR assessment led us to say "We are 99% confident our losses won't exceed \$5 million in a trading day," we have set a clear boundary that most folks could comprehend.

There are several drawbacks to VaR, however.  The most critical is that the "99% confidence" in this example is the minimum dollar figure. In the 1% of occasions where our minimum loss does exceed that figure, there's zero indication of by how much. That 1% could be a \$100 million loss, or many orders of magnitude greater than the VaR threshold.  Surprisingly, the model is designed to work this way because the probabilities in VaR are based on a normal distribution of returns.  But financial markets are known to have non-normal distributions, meaning they have extreme outlier events on a regular basis – far more than normal distribution would predict.  Finally, the VaR calculation requires several statistical measurements like variance, covariance, and standard deviation. With a two-asset portfolio, this is not too hard, but becomes extremely complex for a highly diversified portfolio. More on that below.

## What is the Formula for VaR?

VaR is defined as:

VaR = [Expected Weighted Return of the Portfolio - (z-score of the confidence interval * standard deviation of the portfolio)] * portfolio value

Usually, a timeframe is expressed in years. But if it's being measured otherwise (i.e., by weeks or days), then we divide the expected return by the interval and the standard deviation by the square root of the interval.  For example, if the timeframe is weekly, the respective inputs would be adjusted to (expected return ÷ 52) and (portfolio standard deviation ÷ √52). If daily, use 252 and √252, respectively.

Like many financial applications, the formula sounds easy – it has only a few inputs – but calculating the inputs for a large portfolio are computationally intense,  You have to estimate the expected return for the portfolio, which can be error-prone; you have to calculate the portfolio correlations and variance; and then you have to plug it all in. In other words, it's not as easy as it looks.

## Finding VaR in Excel

Outlined below is the variance-covariance method of finding VaR  [please right-click and select open image in new tab to get full resolution of table]:

RELATED FAQS
1. ### What's the difference between a confidence level and a confidence interval in Value ...

Learn about the value at risk, how confidence intervals and confidence levels are used to interpret the value at risk and ... Read Answer >>
2. ### What is the minimum number of simulations that should be run in Monte Carlo Value ...

Find out how many simulations should be run at minimum for an accurate value at risk when using the Monte Carlo method of ... Read Answer >>
3. ### What is a "non linear" exposure in Value at Risk (VaR)?

Learn about nonlinearity and value at risk and what a nonlinear exposure is in the value at risk of a portfolio of nonlinear ... Read Answer >>
4. ### What is the variance/covariance matrix or parametric method in Value at Risk (VaR)?

Learn about the value at risk and how to calculate the value at risk of an investment portfolio using the variance-covariance, ... Read Answer >>
5. ### What is backtesting in Value at Risk (VaR)?

Learn about the value at risk of a portfolio and how backtesting is used to measure the accuracy of value at risk calculations. Read Answer >>
6. ### What is the difference between standard deviation and z score?

Understand the basics of standard deviation and Z-score; learn how each is calculated and used in the assessment of market ... Read Answer >>
Related Articles
1. Personal Finance

### Backtesting Value-at-Risk (VaR): The Basics

Learn how to test your VaR model for accuracy.
2. Investing

### An Introduction to Value at Risk (VAR)

Volatility is not the only way to measure risk. Learn about the "new science of risk management".

### How To Convert Value At Risk To Different Time Periods

Volatility is not the only way to measure risk. Learn about the "new science of risk management".
4. Investing

### How Investment Risk Is Quantified

FInancial advisors and wealth management firms use a variety of tools based in modern portfolio theory to quantify investment risk.
5. Managing Wealth

### JP Morgan: The Other Side Of The Hedge

A hedge is supposed to decrease overall risk, but when it's instead used to increase profits, the risk can be multiplied.
6. Investing

### Optimize your portfolio using normal distribution

Normal or bell curve distribution can be used in portfolio theory to help portfolio managers maximize return and minimize risk.
7. Investing

### 6 Risks Threatening Your Portfolio Today

Factoring in these risks is crucial when building a portfolio.
8. Personal Finance

### Risk Management Framework (RMF): An Overview

A company must identify the type of risks it is taking, as well as measure, report on, and set systems in place to manage and limit, those risks.

### Trading with Gaussian models of statistics

The study of statistics originated from Carl Friedrich Gauss and helps us understand markets, prices and probabilities, among other applications.
10. Investing

### How to use Monte Carlo simulation with GBM

Learn how to estimate risk with the use of a Monte Carlo simulation to predict future events through a series of random trials.
RELATED TERMS
1. ### Marginal VaR

Marginal VaR includes the change in portfolio VaR resulting from ...
2. ### Value At Risk - VaR

Value at risk - VaR is a statistic that measures and quantifies ...
3. ### Conditional Value At Risk - CVaR

Conditional Value at Risk (CVaR) quantifies the potential extreme ...
4. ### Market Risk

Market risk is the possibility of an investor experiencing losses ...
5. ### Downside Risk

Downside risk is an estimate of a security's potential to suffer ...
6. ### Probability Distribution

A probability distribution is a statistical function that describes ...
Hot Definitions

The business cycle describes the rise and fall in production output of goods and services in an economy. Business cycles ...
2. ### Futures Contract

An agreement to buy or sell the underlying commodity or asset at a specific price at a future date.
3. ### Yield Curve

A yield curve is a line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but ...
4. ### Portfolio

A portfolio is a grouping of financial assets such as stocks, bonds and cash equivalents, also their mutual, exchange-traded ...
5. ### Gross Profit

Gross profit is the profit a company makes after deducting the costs of making and selling its products, or the costs of ...
6. ### Diversification

Diversification is the strategy of investing in a variety of securities in order to lower the risk involved with putting ...