Book · Julian R. Sterling

The Basel III IRB Credit Risk Handbook

Internal Ratings-Based Credit Risk Capital Under Basel III (CRE30-CRE36): Foundation vs Advanced IRB, Vasicek ASRF Formula, Input Floors, Downturn LGD, Maturity Adjustments, Specialized Lending Slotting, and Expected Loss Shortfall

About the book

Cover of The Basel III IRB Credit Risk Handbook

Finalized Basel III (BCBS 424 / CRE30 through CRE36, enacted in the EU under CRR3 and in the UK under PRA PS9/24) fundamentally redesigned Internal Ratings-Based (IRB) credit risk capital. Large corporates above EUR 500M in revenue and all financial institutions are restricted to Foundation IRB; equity is removed from IRB; hard PD, LGD, and EAD input floors bind across wholesale and retail books; the legacy 1.06 scaling factor is removed; and the 72.5% Output Floor caps aggregate model relief.

One complete commercial and retail bank carries every calculation from exposure classification to Pillar 3 disclosure. At Northbridge Commercial & Retail Bank ($45,500.00M IRB EAD across 13 facilities), finalized Basel III IRB Credit RWA equals $17,380.34M (38.20% average risk weight), saving $1,042.82M from removing the 1.06 scaling factor. Against $383.29M of IRB Expected Loss, baseline provisions of $320.00M trigger a $63.29M CET1 shortfall deduction (CAP30.13), while Scenario B provisions of $520.00M hit the 0.60% RWA Tier 2 cap ($104.28M). At full phase-in, the 72.5% Output Floor ($23,769.13M) adds $2,188.79M to bank RWA, moving CET1 from 14.07% to 12.78% (-129 bp).

What is inside:

Free: the Basel III IRB RWA Calculator in Excel

5-tab live Excel workbook reproducing all 13 NCRB facilities, Vasicek ASRF formulas (NORMSDIST / NORMSINV), CRE32 input floors, CRE32.9 collateral haircuts, EL Shortfall / Tier 2 0.60% cap, 72.5% Output Floor phase-in, maturity sensitivity, and 10 dynamic audit controls. Zero macros, nothing locked.

Get the free Excel calculator →

Contents

Read first

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

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

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

Updates

Regulatory standards are stated as of November 2026, covering BCBS CRE30 through CRE36, CAP10/CAP30, RBC20, EU CRR3 (effective January 1, 2025), UK PRA PS9/24 (effective January 1, 2027), and EBA IRB Guidelines. Future regulatory updates will be posted here.

Also by Julian R. Sterling

Related banking, regulatory capital, and risk management handbooks. The full list is on the author page.