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.
SREP_Capital_Stack: Full RCB capital stack, risk-by-risk P2R decomposition, CRD V Article 104a(4) 56.25%/18.75%/25% split, TSCR, CBR, OCR, automatic AT1/T2 shortfall spillover, binding MDA headroom, ECB four-bucket P2G lookup, and Leverage Ratio Pillar 2.
MDA_Quartiles_Breach: Interactive CRD V Article 141 MDA quartile detector (60%/40%/20%/0%), euro payout cap on distributable profits, and distribution waterfall across AT1 coupons, staff bonuses, and common dividends.
Normative_3Y_ICAAP: 2026 to 2029 Baseline and Adverse trajectories with CRR3 output floor phase-in, dynamic spillover, and Adverse Year 2 Management Actions comparison.
Economic_ICAAP: IFRS Equity to Normative CET1 to Economic Internal Capital bridge, 10-risk 1-year 99.9% Economic Capital schedule, editable diversification cap, and live ECAR vs RAS limit verdict.
UK_PRA_vs_US_SCB: Side-by-side interactive models for UK PRA (Pillar 2A incl. pension risk, TCR, PRA Buffer gross/offset/net) and US Fed CCAR (peak-to-trough + 4Q dividend SCB with 2.50% floor and Regulation Q Eligible Retained Income).
Controls: Ten 100% dynamic cross-tab reconciliation checks verifying every statutory identity and model tie-out.