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 probabilitybased 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 financialindustry 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 nonnormal 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 twoasset 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  (zscore 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 errorprone; 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 variancecovariance method of finding VaRÂ [please rightclick and selectÂ open image in new tabÂ to get full resolution of table]:

What does Value at Risk (VaR) say about the "tail" of the loss distribution?
Learn about value at risk and conditional value at risk and how both models interpret the tail ends of an investment portfolio's ... Read Answer >> 
What is a "linear" exposure in Value at Risk (VaR) calculation?
Learn how the valueatrisk (VaR) calculation is used for portfolios with linear risk as opposed to nonlinear risk, and understand ... Read Answer >> 
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 >> 
Should you calculate Value at Risk (VaR) for counterparty credit risk?
Learn how value at risk (VaR) may be used to determine the risk of counterparty default for credit default swaps and other ... Read Answer >> 
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 >> 
What is stress testing in Value at Risk (VaR)?
Discover the difference between Value at Risk, or VaR, and stress testing, and learn how the two concepts might be used together ... Read Answer >>

Investing
Value at Risk (VaR)
Value at risk, often referred to as VaR, measures the amount of potential loss that could happen in an investment or a portfolio of investments over a given time period. 
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". 
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. 
Investing
Understanding Liquidity Risk
Make sure that your trades are safe by learning how to measure the liquidity risk. 
Investing
Why Standard Deviation Should Matter to Investors
Think of standard deviation as a thermometer for risk, or better yet, anxiety. 
Investing
Quantitative Analysis Of Hedge Funds
Hedge fund analysis requires more than just the metrics used to analyze mutual funds. 
Investing
Understanding The Sharpe Ratio
The Sharpe ratio describes how much excess return you are receiving for the extra volatility that you endure for holding a riskier asset. 
Investing
Using Historical Volatility To Gauge Future Risk
Use these calculations to uncover the risk involved in your investments. 
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. 
Investing
A Simplified Approach To Calculating Volatility
Though most investors use standard deviation to determine volatility, there's an easier and more accurate way of doing it.

Marginal VaR
Marginal VaR includes the change in portfolio VaR resulting from ... 
Incremental Value At Risk
The amount of uncertainty added to or subtracted from a portfolio ... 
Value At Risk  VaR
A statistical technique used to measure and quantify the level ... 
Conditional Value At Risk  CVaR
A risk assessment technique often used to reduce the probability ... 
Probability Distribution
A statistical function that describes all the possible values ... 
Risk Management
Risk management occurs anytime an investor or fund manager analyzes ...