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'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 >> 
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 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 >> 
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 variancecovariance, ... Read Answer >> 
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 >> 
What is the difference between standard deviation and z score?
Understand the basics of standard deviation and Zscore; learn how each is calculated and used in the assessment of market ... Read Answer >>

Personal Finance
Backtesting ValueatRisk (VaR): The Basics
Learn how to test your VaR model for accuracy. 
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". 
Trading
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". 
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. 
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
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. 
Investing
6 Risks Threatening Your Portfolio Today
Factoring in these risks is crucial when building a portfolio. 
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
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. 
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.

Marginal VaR
Marginal VaR includes the change in portfolio VaR resulting from ... 
Value At Risk  VaR
Value at risk  VaR is a statistic that measures and quantifies ... 
Conditional Value At Risk  CVaR
Conditional Value at Risk (CVaR) quantifies the potential extreme ... 
Market Risk
Market risk is the possibility of an investor experiencing losses ... 
Downside Risk
Downside risk is an estimate of a security's potential to suffer ... 
Probability Distribution
A probability distribution is a statistical function that describes ...