Free Templates · Basel III IRB
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).
100% live Excel formulas, no macros, no passwords, verified in LibreOffice with 0 formula errors and automated mutation checks.
| Tab | What It Computes |
|---|---|
| IRB_Portfolio | 13 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_Capital | Reconciles $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_SA | Parallel 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_Maturity | Corporate 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). |
| Controls | 10 dynamic regulatory and accounting identity checks (0 hardcoded constants) verifying EAD reconciliation, input floor enforcement, EL/Provision conservation, and Output Floor identities. |
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.
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