Pre-loaded with Rheinland-West Commercial Bank AG (EUR 14,400.00M CET1, EUR 96,155.00M U-TREA, EUR 155,868.28M fully loaded S-TREA, 12.74% floored CET1 vs. 14.36% post-optimization). Overwrite the blue input cells with your institution's exposures, risk weights, or floor multiplier and watch every schedule recalculate live.
Get the Excel calculator
One Excel workbook, 6 unlocked tabs, no macros. Enter your email address and the download opens immediately, along with the other free practitioner models.
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 Basel III Output Floor Handbook works through every CRE20 risk weight, EU CRR3 Article 465 transitional rule, UK PRA PS9/24 comparison, and five capital optimization levers on the exact RWCB balance sheet.
Executive_Dashboard: Editable CET1/AT1/T2 capital, MDA trigger, and floor multiplier comparing Unfloored IRB, EU CRR3 Full, EU CRR3 Art. 465 Transitional, UK PRA PS9/24, and Post-Optimization side by side.
CRE20_Credit_RWA: 26 on-balance-sheet portfolios + 3 off-balance-sheet commitment lines with live EU Loan-Splitting formulas, non-credit RWAs (FRTB, CVA, SMA), and SUMIFS asset-class cross-checks.
Phase_In_2025_2033: Complete EU CRR3 2025-2033 phase-in schedules (showing the 1 January 2033 Article 465 cliff edge) alongside the UK PRA PS9/24 2027-2030 schedule.
Real_Estate_SCRA_Tools: Interactive RRE LTV calculator (Whole-Loan vs. Loan-Splitting vs. Art. 465(5)) and ECRA vs. SCRA Grade A Enhanced/A/B/C reference matrix.