# Lognormal vs Arithmetic Parametric VaR Formula Guide

> Prevent impossible >100% long-only VaR losses on volatile assets and multi-month horizons using exact lognormal geometric VaR and ES formulas.

Canonical: https://quantcalctools.com/guides/lognormal-vs-arithmetic-return-var-large-drawdown-horizon-error
Last updated: 2026-11-14T19:37:34.217Z

**Publication:** QuantCalc Tools
**Category:** Parametric Var Expected Shortfall
**Published:** 2026-11-14T10:00:25.915Z
**Author:** Elena Rostova, FRM, CQF (FRM, Certificate in Quantitative Finance (CQF))
**Reviewer:** Not recorded

## Answer-first summary

Linear arithmetic VaR reports absurd 116% losses on unlevered 50%-volatility positions over 1-year horizons; exact lognormal transformation bounds losses below 100% while accounting for Ito drift.

## Key takeaways

- Linear arithmetic VaR approximates exp(x) - 1 ~ x, which breaks whenever z * sigma * sqrt(T) > 0.15—reporting impossible >100% losses on unlevered high-volatility long positions.
- Exact lognormal VaR applies Ito’s -0.5*sigma^2*T variance drain and exponentiates 1 - exp(q_log), strictly bounding unlevered long losses below 100% across all horizons.
- For short sellers, exponential convexity works in reverse: at 55% annual volatility, true 1-year 99% lognormal short-squeeze VaR hits 209.0%, exceeding linear VaR (128.0%) by +63.4%.
- Exact closed-form lognormal Expected Shortfall W*[1 - exp(mu*T)*Phi(-z_alpha - sigma*sqrt(T))/(1 - alpha)] avoids numerical integration via Girsanov normal tail shifting.

## Related financial entities

- **Basel III FRTB 97.5% Expected Shortfall (ES) Tail Metric** (FRTB-ES-975) — license: Basel III FRTB 97.5% Expected Shortfall (ES) Tail Metric (FRTB-ES-975) refers to an institutional financial benchmark and regulatory standard monitored by BIS Basel Committee MAR33 (INTL), currently calibrated at 97.5% (Confidence Interval) as of October 2026.
- **Black-Scholes-Merton Newton-Raphson Implied Volatility Solver** (BSM-IMPLIED-VOL) — product: Black-Scholes-Merton Newton-Raphson Implied Volatility Solver (BSM-IMPLIED-VOL) refers to an institutional financial benchmark and regulatory standard monitored by CME Options Pricing Standard (US), currently calibrated at 1e-8 (Convergence Tolerance) as of October 2026.

## Analysis

Plug an unlevered $$10,000,000$ long position in a $55\%$-annual-volatility biotechnology or digital-asset basket into a naive 1-year linear arithmetic 99% VaR formula ($VaR = W \cdot z_{0.99} \cdot \sigma_a$), and the spreadsheet outputs **$VaR_{99} = \$10\text{M} \times 2.32635 \times 0.55 = \$12,794,925$—a 127.95% loss on an unlevered cash asset that cannot legally drop below $$0$!** That embarrassing mathematical impossibility arises whenever risk analysts conflate **continuously compounded log returns** $r_{log} = \ln(S_T / S_0)$ with **discrete percentage wealth changes** $R_{simple} = (S_T - S_0)/S_0 = e^{r_{log}} - 1$. Compare 1-day linear approximations in our [Value at Risk (VaR) calculator](/calculators/value-at-risk-calculator), inspect long-horizon compounding in our [CAGR calculator](/calculators/cagr-calculator), and review our [Parametric VaR & Expected Shortfall calibration guide](/guides/parametric-var-expected-shortfall-fat-tail-calibration-guide).

## Exact Geometric Brownian Motion Lognormal VaR & Expected Shortfall

Suppose asset price $S_t$ follows Geometric Brownian Motion $dS_t / S_t = \mu\,dt + \sigma\,dW_t$, where $\mu$ is annualized arithmetic drift and $\sigma$ is annualized log-return volatility. By **Itô's Lemma**, terminal log return over horizon $T$ (in years) is normally distributed with **variance-drained geometric mean** $(\mu - \frac{1}{2}\sigma^2)T$:
$$\ln\!\left(\frac{S_T}{S_0}\right) \sim \mathcal{N}\!\Big(\big(\mu - \tfrac{1}{2}\sigma^2\big)T,\;\; \sigma^2 T\Big)$$
Exponentiating the left-tail quantile $q_{log} = (\mu - \frac{1}{2}\sigma^2)T - z_\alpha\sigma\sqrt{T}$ yields **Exact Lognormal Relative VaR** (strictly bounded inside $[0, W)$ for all $\sigma, T < \infty$), and integrating the lognormal lower tail yields **Exact Closed-Form Lognormal Expected Shortfall**:

$$VaR_{\alpha}^{log} = W\left[1 - \exp\!\Big(\big(\mu - \tfrac{1}{2}\sigma^2\big)T - z_\alpha \sigma\sqrt{T}\Big)\right]$$

$$ES_{\alpha}^{log} = W\left[1 - \frac{e^{\mu T}}{1 - \alpha}\,\Phi\!\left(-z_\alpha - \sigma\sqrt{T}\right)\right]$$

## Worked 1-Year Distressed-Vol VaR Audit: Linear >100% Bug vs Exact Lognormal

```formula
Worked 1-Year 99% VaR & 97.5% ES: Linear Arithmetic vs Exact Lognormal ($10,000,000 Unlevered Position)
Inputs: W = $10,000,000, Horizon T = 1.00 Year, Annualized Volatility sigma = 55.0% (0.55)
Arithmetic Expected Return mu = +12.0% => Geometric Log Drift = 0.12 - 0.5*(0.55)^2 = -0.03125 (-3.125%!)

1) Naive Linear Arithmetic 99% VaR (Broken Formula: W * (z_0.99 * sigma - mu)):
 VaR_99(linear) = $10,000,000 * (2.32635 * 0.55 - 0.12) = $11,594,925 (115.95% LOSS — IMPOSSIBLE!)
 Zero-Mean Linear 99% VaR = $12,794,925 (127.95% LOSS — IMPOSSIBLE!)

2) Exact Lognormal 99.0% VaR (z_0.99 = 2.32635):
 Log Quantile q_0.01 = -0.03125 - 2.32635 * 0.55 = -0.03125 - 1.27949 = -1.31074
 Terminal Wealth Ratio S_T / S_0 = exp(-1.31074) = 0.26962 (Asset falls to 26.96 cents on the dollar)
 Exact Lognormal VaR_99 = $10,000,000 * (1 - 0.26962) = $7,303,799 (73.04% Loss — Physically Valid!)

3) Exact Lognormal 97.5% Expected Shortfall (z_0.975 = 1.95996, 1 - alpha = 0.025):
 Shifted Normal Argument = -1.95996 - 0.55 = -2.50996 => Phi(-2.50996) = 0.0060373
 ES_97.5(lognormal) = $10,000,000 * [ 1 - (exp(0.12) / 0.025) * 0.0060373 ]
 = $10,000,000 * [ 1 - 45.0999 * 0.0060373 ] = $7,277,185 (72.77% Tail Mean Loss!)
```

Look at the beauty of that closed-form Lognormal ES equation $W[1 - \frac{e^{\mu T}}{1 - \alpha}\Phi(-z_\alpha - \sigma\sqrt{T})]$: notice it uses the exact same Girsanov measure-change shift ($-z_\alpha - \sigma\sqrt{T}$) as $d_1$ vs $d_2$ inside the [Black-Scholes-Merton pricing formula](/entities/bsm-implied-vol-black-scholes-merton-newton-raphson-implied-volatility-solver)! And notice how $-\frac{1}{2}\sigma^2 = -15.125\%$ variance drag flipped a $+12.0\%$ arithmetic expected return into a **$-3.125\%$ median geometric log drift**!

![Decision and conversion workflow between arithmetic 1-day VaR and exact Ito lognormal multi-horizon VaR](/api/figure?type=flow&title=Horizon%20%26%20Volatility%20Regime%20Switch%3A%20Arithmetic%20vs%20Lognormal%20VaR&subtitle=Preventing%20Taylor%20truncation%20error%20and%20%3E100%25%20unlevered%20loss%20artifacts%20as%20z*sigma*sqrt%28T%29%20grows.&steps=1.%20Check%20z*sigma*sqrt%28T%29%3A%3ALinear%20error%20exceeds%205%25%20once%20z*sigma*sqrt%28T%29%20%3E%200.10%7C2.%20Subtract%20Ito%20Drag%3A%3AConvert%20arithmetic%20mu%20to%20log%20drift%20%28mu%20-%200.5*sigma%5E2%29*T%7C3.%20Exponentiate%20Quantile%3A%3ALong%20VaR%20%3D%20W*%281%20-%20exp%28q_log%29%29%3B%20Short%20VaR%20%3D%20W*%28exp%28q_up%29%20-%201%29%7C4.%20Girsanov%20Tail%20ES%3A%3AEvaluate%20Phi%28-z_alpha%20-%20sigma*sqrt%28T%29%29%20exact%20integral&metrics=1-DAY%20EQUITIES%20%281.2%25%29%3A%3A0.04%25%20Gap%3A%3A1%20-%20exp%28-0.028%29%20vs%200.028%20identical%7C10-DAY%20OIL%20%283.0%25%2Fd%29%3A%3A11.4%25%20Gap%3A%3ALinear%20overstates%20long%20loss%20by%2011%25%7C1-YEAR%20VOL%20%2855%25%29%3A%3A73%25%20vs%20128%25%3A%3AFixes%20impossible%20%3E100%25%20cash%20loss%7CSHORT%20SQUEEZE%2099%25%3A%3A%2B259%25%20Loss!%3A%3Aexp%28%2B1.28%29%20-%201%20%3D%20%2B259.5%25%20short%20VaR!)

## The Flip Side: Linear VaR Massively UNDERSTATES Short-Position Squeeze Risk!

While linear arithmetic VaR **overstates** long-only losses ($1 - e^{-x} < x$ for $x > 0$), Taylor concavity flips in the **exact opposite direction for short sellers** ($e^{+x} - 1 > x$)! Suppose a hedge fund shorts $$10\text{M}$ of that same $55\%$-volatility biotech stock ($\mu = 0$):
- **Linear 1-Year 99% Short VaR**: $2.32635 \times 55\% = \mathbf{127.95\%}$ ($$12.79\text{M}$ loss).
- **Exact Lognormal 1-Year 99% Short VaR**: $\exp(-0.5(0.55)^2 + 2.32635(0.55)) - 1 = \exp(1.1282) - 1 = \mathbf{209.02\%}$ ($$20.90\text{M}$ loss — **$$8.11\text{M}$ larger than linear VaR!**)!

## Arithmetic Linear VaR vs Exact Lognormal VaR Across Volatility Horizons

| Horizon & Volatility Scenario ($z_{0.99} = 2.32635, \mu = 0$) | $x = z\sigma\sqrt{T}$ | Naive Linear VaR ($x$) | Exact Long Lognormal VaR ($1 - e^{-0.5\sigma^2 T - x}$) | Exact Short Lognormal VaR ($e^{-0.5\sigma^2 T + x} - 1$) |
| :--- | :--- | :--- | :--- | :--- |
| 1-Day G10 FX ($\sigma_a = 10\%$) | $1.465\%$ | $1.47\%$ | $1.46\%$ ($-0.7\%$ diff) | $1.48\%$ ($+0.7\%$ diff) |
| 10-Day Equity Index ($\sigma_a = 22\%$) | $10.228\%$ | $10.23\%$ | $9.81\%$ ($-4.1\%$ diff) | $10.65\%$ ($+4.1\%$ diff) |
| 60-Day HY Credit / Oil ($\sigma_a = 38\%$) | $43.249\%$ | $43.25\%$ | $36.22\%$ ($-16.3\%$ diff) | $51.49\%$ ($+19.1\%$ diff) |
| 1-Year Biotech / Crypto ($\sigma_a = 55\%$) | $127.949\%$ | $127.95\%$ (Impossible) | $76.09\%$ (Bounded $<100\%$) | $209.02\%$ ($+63.4\%$ squeeze!) |
| 1-Year Venture / Token ($\sigma_a = 90\%$) | $209.372\%$ | $209.37\%$ (Impossible) | $91.78\%$ (Bounded $<100\%$) | $441.25\%$ ($+110.8\%$ squeeze!) |

![Divergence between linear arithmetic VaR, exact long lognormal VaR, and exact short-seller lognormal VaR at 55% volatility](/api/figure?type=bars&title=Asymmetric%20Long%20vs%20Short%201-Year%2099%25%20VaR%20at%2055%25%20Volatility%20%28%25%20Principal%29&subtitle=Linear%20VaR%20breaches%20the%20100%25%20cash%20floor%20on%20longs%20while%20missing%20%2B81%25%20of%20compounding%20short-squeeze%20loss.&steps=Long%20Exact%20Lognormal%3A%3A76.1%25%20max%2099%25%20loss%20%28bounded%20strictly%20%3C%20100%25%29%7CLong%20Linear%20%28Broken%29%3A%3A128.0%25%20impossible%20loss%20%28%3E100%25%20unlevered%20cash%29%7CShort%20Linear%20%28Broken%29%3A%3A128.0%25%20understates%20exponential%20rally%20compounding%7CShort%20Exact%20Lognormal%3A%3A209.0%25%20true%2099%25%20squeeze%20loss%20on%20short%20principal!&metrics=LONG%20EXACT%2099%25%20VAR%3A%3A76.09%25%3A%3AZero-drift%20Ito%20lognormal%20bound%7CLINEAR%20BROKEN%20VAR%3A%3A127.95%25%3A%3ASymmetric%20Taylor%20tangent%20line%7CSHORT%20EXACT%2099%25%20VAR%3A%3A209.02%25%3A%3A%2B63.4%25%20worse%20than%20linear!%7CITO%20DRIFT%20PENALTY%3A%3A-15.13%25%3A%3A-0.5%20*%20%280.55%29%5E2%20geometric%20drain)

## Portfolio Caveat: Weighted Sum of Exponentials Is Not Exact Lognormal

One final mathematical nuance for multi-asset risk engines: while log returns add linearly **across time** ($r_{0 \to T} = \sum_{t=1}^T r_t$), simple arithmetic returns add linearly **across portfolio weights** ($R_P = \sum_{i=1}^N w_i (e^{r_i} - 1)$). Over 60-to-250-day horizons (such as 120-day buckets in [Basel FRTB liquidity horizon bucketing](/guides/basel-frtb-975-expected-shortfall-liquidity-horizon-bucketing) or Solvency II 1-year insurer SCR models), approximate portfolio sums via Fenton-Wilkinson moment matching or simulate correlated log returns directly inside [Cholesky covariance Monte Carlo VaR](/guides/cholesky-covariance-matrix-positive-definiteness-monte-carlo-var). Explore the full cluster on the [Parametric VaR & Expected Shortfall Topic Hub](/topics/parametric-var-expected-shortfall).

## Frequently asked questions

### When is it safe to use simple arithmetic VaR instead of lognormal VaR?

On 1-day horizons for assets with daily volatility below 1.5% (so z_0.99 * sigma <= 3.5%), 1 - exp(-0.035) = 3.44% sits within 1.7% of 3.50%. Once holding periods reach 10+ days or annualized volatility exceeds 30%, switch to exact lognormal formulas.

### Why must -0.5 * sigma^2 * T be subtracted inside the lognormal VaR exponent?

By Ito’s Lemma (and Jensen’s inequality E[e^X] = exp(m + 0.5*v)), if an asset’s arithmetic expected return is mu, its continuously compounded log-return mean is mu - 0.5*sigma^2. Omitting -0.5*sigma^2 overstates median wealth and understates long-horizon VaR.

### Why does linear VaR dangerously underestimate risk for short positions?

Long losses are bounded at -100% as S_T -> 0, whereas short losses grow exponentially without bound as S_T = S_0 * exp(r_log) rallies. Replacing exp(+x) - 1 with linear +x drops all positive quadratic and cubic compounding terms.

### What is the difference between Absolute Lognormal VaR and Mean-Relative Lognormal VaR?

Absolute VaR measures shortfall relative to today’s initial wealth W_0 (loss = W_0 - W_T). Mean-Relative VaR measures shortfall relative to expected terminal wealth E[W_T] = W_0 * exp(mu*T), canceling drift mu*T in Solvency II-style economic capital.


## Source URLs

- https://www.eiopa.europa.eu/rulebook/solvency-ii_en
- https://www.bis.org/basel_framework/chapter/MAR/33.htm
- https://www.garp.org/frm/study-materials

## Citation

- APA: Elena Rostova, FRM, CQF. (2026). Lognormal vs Arithmetic Parametric VaR: Multi-Month Horizon Math Guide. QuantCalc Tools. https://quantcalctools.com/guides/lognormal-vs-arithmetic-return-var-large-drawdown-horizon-error
- Canonical article: [Lognormal vs Arithmetic Parametric VaR: Multi-Month Horizon Math Guide](https://quantcalctools.com/guides/lognormal-vs-arithmetic-return-var-large-drawdown-horizon-error)
- Site research index: [QuantCalc Tools](https://quantcalctools.com/llms-full.txt)
