Free Excel templates

A free Pillar 2 SREP & MDA Calculator in Excel

CRD V P2R/P2G capital stacking, automatic AT1/Tier 2 shortfall spillover, Article 141 MDA quartiles, 3-year Normative ICAAP, 99.9% Economic ICAAP, and UK PRA vs US SCB.

Pre-loaded with Rheinburg Commercial Bank AG (EUR 40,000.00M TREA, 13.90% CET1, 2.40% P2R, 4.75% CBR, 1.50% P2G). Change AT1 in cell B8 from 640 to 780 to watch the 0.35% spillover disappear and binding MDA headroom jump immediately from 2.95% (EUR 1,180.00M) to 3.30% (EUR 1,320.00M), or paste your own institution's balance sheet into the blue input cells.

Get the Excel calculator

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

Pillar_2_SREP_MDA_Calculator.xlsx (23 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 Pillar 2 ICAAP and SREP Handbook walks through the entire Rheinburg Commercial Bank AG case: SREP scoring, P2R/P2G calibration, AT1 spillover, MDA waterfalls, Normative vs Economic ICAAP, UK PRA Pillar 2A/2B, US CCAR SCB, and a 30/60/90-day remediation playbook.

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

What is inside the 6 tabs

Related reading