Free Templates · Counterparty Credit Risk

SA-CCR EAD and MAR50 CVA Capital Excel Calculator

An 8-tab, 100% formula-driven Excel workbook implementing BCBS CRE52 SA-CCR (all five asset classes, Black-Scholes supervisory delta, 10d/20d MPOR, NICA multiplier) and BCBS MAR50 BA-CVA Reduced, BA-CVA Full, and SA-CVA.

Direct download (free, no registration required)

Includes editable blue inputs, dynamic accounting identity checks in the Controls tab (0 formula errors verified in Excel and LibreOffice), and the full Meridian Capital Bank N.A. worked portfolio ($4,650.00M notional, $268.22M EAD).

Download SACCR_EAD_CVA_Calculator.xlsx Explore The SA-CCR and CVA Handbook →

What the Workbook Computes Dynamically

TabScope & Formulas
Executive_SummaryLive dashboard linking Total EAD ($268.22M), CCR RWA ($206.31M), BA-CVA Reduced ($14.98M), BA-CVA Full ($9.08M), SA-CVA ($8.87M), and CET1 ratio (12.40%).
ParametersEditable blue cells for CRE52 supervisory factors, correlations, alpha (1.4 / 1.0 US commercial end-user), MAR50 beta (0.25), DS (0.65), and SA-CVA disallowance R (1%).
SA_CCR_Trades20-trade schedule computing Supervisory Duration (SD), Black-Scholes supervisory delta via NORMSDIST, unmargined and margined Maturity Factors, and Effective Notional.
SA_CCR_NettingSetsIR 3-bucket correlation, FX pair add-ons, Credit/Equity/Commodity single-factor aggregation, RC with TH/MTA/NICA, PFE multiplier, EAD, and CCR RWA.
BA_CVAStandalone SCVA_c, supervisory discount factor DF_NS, Reduced BA-CVA (0.65 scalar), Single-Name/Proxy/Index CVA hedges (SNH, HMA, IH), and Full BA-CVA.
SA_CVASensitivity-based Delta and Vega across Counterparty Credit Spread, Interest Rate, and FX risk classes with hedging disallowance R = 0.01 and cross-bucket gamma_bc.
WWR_and_CapitalSpecific Wrong-Way Risk Jump-to-Default EAD uplift ($27.60M), General WWR +50% stress ($63.31M), and CET1 ratio impact.
Controls10 live mathematical identity checks (0 hardcoded constants) verifying portfolio reconciliation even when you mutate inputs.

Need the full regulatory walkthrough behind every formula?

The SA-CCR and CVA Handbook explains every CRE52 and MAR50 rule, transatlantic divergence (US 12 CFR 217.132, EU CRR3, UK PRA PS9/24), and Pillar 3 reporting schedule line by line.