Free Excel templates

A free FRTB Standardised Approach & IMA Capital Calculator in Excel

Seven live worksheets covering SBM Delta, Vega, and Curvature across High, Medium, and Low correlation scenarios, DRC with Hedge Benefit Ratio, RRAO, IMA Expected Shortfall, PLA Amber Surcharge, and the 72.5% Output Floor.

Pre-loaded with Northbridge Capital Markets Bank (NCMB) in USD millions ($M): Full FRTB-SA capital equals $92.650M ($1,158.13M RWA), combining SBM ($85.558M), DRC ($6.442M), and RRAO ($0.650M). Hybrid IMA+SA capital totals $72.158M (saving $20.492M or 22.12%) after a $3.704M Desk 2 PLA Amber surcharge and Desk 3 Red fallback ($22.488M).

Get the Excel calculator

One Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.

FRTB_SBM_Capital_Calculator.xlsx (26 KB)

You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.

The book behind this calculator

The FRTB Handbook walks through every MAR21-MAR33 equation, risk weight table, PLA test threshold, and implementation control for Northbridge Capital Markets Bank across SA, IMA, and the 72.5% Output Floor.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is inside the 7 tabs

Related reading