Free Templates · Basel III IRB

Basel III IRB RWA Calculator in Excel

Live 5-tab workbook covering Vasicek ASRF, CRE32 input floors, CRE33 slotting, EL vs. provisions, and the 72.5% Output Floor. Pre-loaded with Northbridge Commercial & Retail Bank ($45,500.00M EAD).

Download Basel_III_IRB_RWA_Calculator.xlsx (24 KB, .xlsx)

100% live Excel formulas, no macros, no passwords, verified in LibreOffice with 0 formula errors and automated mutation checks.

Download Excel Calculator (.xlsx)

What is inside the five tabs

TabWhat It Computes
IRB_Portfolio13 facilities (F-IRB, A-IRB, Slotting, Defaulted A-IRB), live Vasicek ASRF (NORMSDIST / NORMSINV), CRE32 PD/LGD/EAD floors, 1.25x AVC, SME sales adjustment, CRE32.9 collateral haircut check, and 1.00x / 1.06x scaling switch.
EL_Provisions_CapitalReconciles $383.29M IRB Expected Loss vs. Scenario A ($320.00M, $63.29M CET1 shortfall) and Scenario B ($520.00M, $104.28M Tier 2 add-back under the $104.28M 0.60% RWA cap).
Output_Floor_SAParallel IRB ($17,380.34M) vs. Standardized Approach ($28,585.00M) Credit RWA, Non-Credit RWA ($4,200.00M), 72.5% Output Floor ($23,769.13M, add-on $2,188.79M), and 2025 to 2030 phase-in schedule.
Stress_MaturityCorporate Maturity Adjustment b(PD) and MA sensitivity grid (M = 1.0Y to 5.0Y) plus live portfolio stress links (PD multiplier and A-IRB LGD add-on).
Controls10 dynamic regulatory and accounting identity checks (0 hardcoded constants) verifying EAD reconciliation, input floor enforcement, EL/Provision conservation, and Output Floor identities.

Built for The Basel III IRB Credit Risk Handbook

Every formula, regulatory citation (BCBS CRE30 through CRE36, EU CRR3, UK PRA PS9/24), and worked schedule behind this workbook is explained line by line in The Basel III IRB Credit Risk Handbook.

Explore the handbook →

Related technical guides

Basel III IRB RWA Formula: Vasicek ASRF Step-by-Step Worked Example

Foundation IRB vs. Advanced IRB Under Basel III: Scope Restrictions and Input Floors

Expected Loss Shortfall and Excess Provisions: CET1 Deduction and the 0.6% Tier 2 Cap