Free Template · Bank Liquidity

Basel III LCR and NSFR Ratio Calculator (Excel)

Unlocked 4-tab Excel model covering HQLA haircuts, LCR30.37 HQLA-for-HQLA secured-transaction unwind, 40% and 15% caps, 30-day cash outflows and 75% inflow cap, full NSFR ASF/RSF reconciliation, and dynamic accounting controls.

Direct Download: LCR_NSFR_Ratio_Calculator.xlsx

Pre-loaded with Northbridge Commercial Bank's reconciled $20,000.00M balance sheet (Basel III LCR 127.75%, NSFR 140.61%). Blue cells are editable inputs; black cells are live Excel formulas with pre-cached calculated values. Zero macros, zero locked sheets.

Download LCR_NSFR_Ratio_Calculator.xlsx

What Is Inside the Workbook

Want the Complete 15-Chapter Practitioner Handbook?

The LCR and NSFR Handbook walks through every formula, US Reg WW ยง 249.30 maturity mismatch ladder, EU CRR2 / UK PRA divergence, ILAAP stress test, and Liquidity FTP calculation in full detail.

Explore The LCR and NSFR Handbook