Book · Julian R. Sterling

The LCR and NSFR Handbook

Basel III Bank Liquidity Ratios in Practice: HQLA Eligibility and Caps, 30-Day Net Cash Outflows, Operational Deposits, NSFR ASF and RSF Factors, US Reg WW and EU CRR2 Rules, and ILAAP Stress Testing

About the book

Cover of The LCR and NSFR Handbook

Short-term liquidity survival and structural funding stability are governed by two interlocking Basel III standards: the Liquidity Coverage Ratio (LCR, BCBS LCR10 to LCR40) and the Net Stable Funding Ratio (NSFR, BCBS NSF10 to NSF30). Bank treasurers, ALM managers, and regulatory reporting teams must calculate both ratios accurately across US 12 CFR Part 249 (Regulation WW), EU Delegated Regulation (EU) 2015/61 and CRR2 Articles 428a to 428az, and UK PRA SS24/15 ILAAP stress tests.

One complete commercial bank balance sheet carries every calculation from general ledger trial balance to ALCO execution. In Northbridge Commercial Bank ($20,000.00M total assets, $2,000.00M regulatory capital), unadjusted HQLA appears uncapped at $4,746.00M, yet the LCR30.37 HQLA-for-HQLA secured-transaction unwind exposes a binding $658.67M cap deduction, bringing Eligible HQLA to $4,087.33M and the Basel III LCR to 127.75% against $3,199.50M of 30-day net cash outflows (compared with 130.87% under EU Delegated Regulation 2015/61 Article 17(2), which extends the unwind to non-HQLA secured transactions). Rebalancing $600.00M from Level 2A/2B into Level 1 US Treasuries eliminates the cap waste completely and lifts LCR to 155.52%. On the exact same balance sheet, Basel III NSFR stands at 140.61% ($14,992.50M ASF / $10,662.50M RSF), rising to 142.55% under US Reg WW Category I/II and 143.09% under EU CRR2.

Northbridge Commercial Bank Summary

MetricBasel IIIUS Reg WW (Cat I/II)EU CRR2 / DR 2015/61
Eligible HQLA$4,087.33M$4,087.33M$4,187.33M
30-Day Net Cash Outflows$3,199.50M$3,459.50M$3,199.50M
Liquidity Coverage Ratio (LCR)127.75%118.15%130.87%
Available Stable Funding (ASF)$14,992.50M$14,992.50M$14,992.50M
Required Stable Funding (RSF)$10,662.50M$10,517.00M$10,478.00M
Net Stable Funding Ratio (NSFR)140.61%142.55%143.09%

Companion Excel Workbooks (Free Download)

Download the full 6-tab companion workbook (Dashboard, LCR_HQLA_Caps, LCR_CashFlows, NSFR_ASF_RSF, US_EU_ILAAP_Stress, and dynamic Controls) or try the streamlined 4-tab LCR & NSFR Ratio Calculator template.

Download Full Companion Model (.xlsx) Free LCR & NSFR Calculator Template

Print & Digital Editions

The LCR and NSFR Handbook is available directly in two formats: an instant-download A5 PDF edition and a 6 x 9 inch trade paperback printed on institutional cream/white stock with full tables, checklists, and schedules. Regional paperback shipping options appear below once print fulfillment is active.

Technical Articles from This Handbook