Home > Financial Tools & Institutional Desks > VaR & CVaR Stress-Testing Workbench
Desk 6: Derivatives & Portfolio Risk • Tool #29 BASEL III FRTB RISK ARCHITECTURE

Value-at-Risk (VaR) & Expected Shortfall (CVaR) Workbench

Deterministic multi-asset portfolio downside risk engine. Solve Parametric, Historical Simulation, and Monte Carlo Value-at-Risk (VaR) alongside coherent Expected Shortfall (CVaR). Stress-test portfolio allocations against historical market shocks and evaluate Basel III regulatory traffic-light capital adequacy.

Institutional Presets:
Parametric 99% VaR (1-Day)
$194,500
1.95% of Portfolio
Historical Simulation VaR
$212,300
2.12% (Empirical Quantile)
Monte Carlo 99% VaR
$204,800
2.05% (5,000 Cholesky Paths)
Expected Shortfall (CVaR)
$258,400
2.58% (Average Tail Loss)
Annualized Volatility (σ)
13.28%
Expected Return: 7.45%/yr
Basel III Traffic Light
GREEN
2.1 Exceptions / 250 Days (Pass)

Portfolio & Risk Parameters

Asset Allocation Weights

US Large-Cap Equity (SPY) 60%
Tech & Nasdaq Growth (QQQ) 0%
10Y US Treasuries (IEF) 40%
High Yield Corporate Credit (HYG) 0%
Gold & Commodities (GLD) 0%
Cash & T-Bills (SGOV/SPAXX) 0%
Total Weight: 100%

Tripartite VaR & Expected Shortfall Comparison

Methodology Horizon Loss (%) Dollar Loss ($) Underlying Modeling Assumptions
Parametric (Normal) 1.95% $194,500 Closed-form Gaussian Z-score × Portfolio Volatility
Parametric (Student-t) 2.28% $228,000 Fat-tailed Student-t distribution (df=5 degrees of freedom)
Historical Simulation 2.12% $212,300 Empirical non-parametric percentile of historical returns
Monte Carlo Simulation 2.05% $204,800 5,000 Cholesky-correlated geometric Brownian motion paths
Expected Shortfall (CVaR) 2.58% $258,400 Coherent average loss beyond VaR threshold (Basel III FRTB)

Return Distribution & Tail Cutoff Visualizer

Historical Crisis Tail-Risk Shock Replay

Simulates the exact historical market shocks applied to the current portfolio weights without statistical smoothing.

Historical Shock Event Peak Crisis Drawdown Portfolio Impact (%) Simulated Dollar Loss Survival Evaluation
2008 Lehman Bankruptcy (GFC) -24.8% SPY / +8.2% IEF -11.6% -$1,160,000 Significant Liquidity Strain
2020 Covid Liquidity Shock -19.5% SPY / +5.1% IEF -9.7% -$966,000 Manageable Cushion
2022 Inflation & Rate Shock -18.1% SPY / -14.9% IEF -16.8% -$1,682,000 CORRELATION FAILURE
1987 Black Monday Crash -22.6% SPY / +3.8% IEF -12.0% -$1,204,000 Acute Margin Call Alert

Institutional Downside Risk & Coherent Measures Methodology

Value-at-Risk (VaR) was pioneered by J.P. Morgan in the early 1990s as a universal risk metric to answer a daily CEO question: "What is our maximum potential loss over the next 24 hours?" While revolutionary, standard VaR suffers from a critical mathematical defect: it violates the principle of subadditivity, meaning merging two portfolios can mathematically produce a higher combined VaR than the sum of their individual VaRs.

1. The Subadditivity Failure of VaR vs. Coherent Expected Shortfall

A risk measure $\rho(\cdot)$ is mathematically coherent if and only if it satisfies four axioms: monotonicity, subadditivity, positive homogeneity, and translation invariance. Value-at-Risk fails subadditivity:

VaR(X + Y) > VaR(X) + VaR(Y)   (VaR Penalizes True Diversification in Fat-Tailed Regimes)

CVaR(X + Y) ≤ CVaR(X) + CVaR(Y)   (Expected Shortfall is Always Coherent)

2. Basel Committee Fundamental Review of the Trading Book (FRTB)

Recognizing that VaR completely ignores tail risk severity beyond the quantile threshold (the "cliff effect"), the Basel Committee on Banking Supervision transitioned the regulatory market risk capital framework from 99% VaR to 97.5% Expected Shortfall under the FRTB framework. Expected Shortfall measures the conditional expectation of loss in the tail:

ES_α = E[ L | L ≥ VaR_α ] = (1 / (1 - α)) × ∫_α^1 VaR_u du

Frequently Asked Questions

Why does Parametric VaR understate risk during financial crises?
Parametric (Variance-Covariance) VaR assumes that financial asset returns follow a Gaussian normal distribution. In empirical financial markets, actual return distributions exhibit severe excess kurtosis (fat tails) and negative skewness (sharp drops happen far faster than rallies). A 4-sigma market crash is virtually impossible under a normal distribution (occurring once every 126 years), yet major financial markets experience 4-to-6 sigma shocks every 3 to 7 years.
How does the Cholesky Decomposition work in Monte Carlo simulation?
Assets in a portfolio do not move independently; equities, bonds, and commodities exhibit dynamic cross-correlations. To generate realistic correlated random variables, the algorithm performs a Cholesky decomposition on the asset covariance matrix Σ to find a lower-triangular matrix L such that L × L^T = Σ. Multiplying a vector of independent standard normal random variables ε by L produces a vector of correlated shocks that faithfully preserve empirical asset relationships.
Why did stocks and bonds both fall during the 2022 market shock?
The classic 60/40 portfolio relies on an empirical negative correlation between equities and Treasuries (the "stock-bond hedge"). However, this negative correlation only holds when inflation is low and growth is the dominant macro variable. When inflation spikes unexpectedly, central banks are forced to hike policy rates aggressively, which simultaneously crushes bond prices (via duration discounting) and equity multiples (via rising discount rates). In 2022, the stock-bond correlation flipped from -0.30 to +0.65, rendering traditional 60/40 diversification ineffective.