Free Excel templates

A free Basel III Output Floor & CRE20 RWA Calculator in Excel

72.5% output floor engine, 29-line CRE20 IRB-to-SA bridge, EU CRR3 2025-2033 phase-in with Article 465 reliefs, UK PRA PS9/24, RRE LTV & SCRA calculators, and 5 optimization levers.

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.

Basel_III_Output_Floor_RWA_Calculator.xlsx (28 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 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.

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

What is inside the 6 tabs

Related reading