Net Stable Funding Ratio (NSFR) Calculator & Basel III Lab
Model Basel III Available Stable Funding (ASF), Required Stable Funding (RSF), 1-year structural duration matching, and balance sheet maturity transformation.
Institutional Funding Profiles & Presets
Balance Sheet & Tenor Inputs
Enter asset and liability figures in thousands of dollars ($000).
1. Available Stable Funding (ASF Liabilities)
2. Required Stable Funding (RSF Assets)
Basel III Structural Balance Sheet Diagnostics
| Core Retail ASF Contribution: | $116,750,000k | 73.08% of total weighted stable funding pool |
| Capital & Term Debt Contribution: | $28,000,000k | 100% factor; permanence anchor |
| Long-Term Loan RSF Burden: | $95,250,000k | 71.16% of total required stable funding requirement |
| Asset Duration Matching Status: | Well Matched | Long-term illiquid assets fully funded by sticky liabilities |
| Wholesale Refinancing Vulnerability: | Low | Short-term interbank debt represents <10% of total balance sheet |
| Max Long-Term Lending Capacity: | +$30,470,588k | Additional 85% RSF corporate loans funded before breaching 100.0% |
Structural Funding Sensitivity Matrices
Sensitivity Grid 1: Total ASF vs Total RSF (NSFR %)
Evaluates how balance sheet expansion, loan origination, and capital growth alter the regulatory NSFR ratio.
Sensitivity Grid 2: Retail Deposit Migration vs Corporate Loan Growth (NSFR %)
Simulates margin pressure and funding drag as deposits migrate to less-stable categories while illiquid loans expand.
Worked Calculation & Mathematical Specification
The Net Stable Funding Ratio (NSFR) was designed by the Basel Committee on Banking Supervision (BCBS) to address structural liquidity risk. While the Liquidity Coverage Ratio (LCR) manages a 30-day panic, the NSFR enforces structural balance sheet discipline across an ongoing 1-year horizon, eliminating destructive maturity mismatches.
$$\text{NSFR} = \frac{\text{Available Stable Funding (ASF)}}{\text{Required Stable Funding (RSF)}} \times 100\% \ge 100\%$$
$$\text{Total ASF} = \sum (\text{Liability Amount}_i \times \text{ASF Factor}_i)$$
$$\text{Total RSF} = \sum (\text{Asset Amount}_j \times \text{RSF Factor}_j)$$
$$\text{Stable Funding Surplus / Deficit} = \text{Total ASF} - \text{Total RSF}$$
$$\text{Maximum Incremental 85\% RSF Lending Capacity} = \frac{\text{Total ASF} - \text{Total RSF}}{0.85}$$
Step-by-Step Calculation Walkthrough (Current Simulation State)
| Category | Balance Sheet Component | Regulatory Weight | Raw Amount ($000) | Weighted Amount ($000) |
|---|
Prudential ALM & Structural Funding Principles
- Ending Destructive Maturity Mismatch: In the run-up to the 2008 crash, institutions funded 30-year subprime mortgages with overnight asset-backed commercial paper (ABCP). The NSFR makes this mathematically impossible: a 65%–85% RSF asset requires long-term capital or sticky core deposits to achieve 100% NSFR.
- Complementary Twin Pillars: LCR guarantees that an institution has enough cash and Treasuries to pay fleeing depositors for 30 days. NSFR guarantees that after 30 days, the bank's underlying loan portfolio is not structurally overleveraged with volatile short-term borrowings.
- Deposit Beta & Stability Migration: In high-rate environments, depositors move funds from non-interest checking (stable 95% ASF) to high-yield savings or brokered CDs (less stable 90% or 50% ASF). Tracking NSFR elasticity prevents hidden structural liquidity deterioration.
Net Stable Funding Ratio (NSFR) Knowledge Check Quiz
Test your understanding of Basel III structural liquidity standards, ASF liability factors, RSF asset requirements, and maturity matching.
1. Over what time horizon is the Basel III Net Stable Funding Ratio (NSFR) measured?
2. What Available Stable Funding (ASF) factor is assigned to regulatory equity capital and subordinated term debt maturing in ≥ 1 year?
3. What Required Stable Funding (RSF) weighting is assigned to long-term commercial loans (≥ 1 year maturity)?
4. What is the fundamental difference between LCR and NSFR in bank asset-liability management?
Frequently Asked Questions
What is the Net Stable Funding Ratio (NSFR) and how is it calculated?
The Net Stable Funding Ratio (NSFR) is a Basel III structural balance sheet standard that requires commercial banks to maintain a stable funding profile in relation to the liquidity characteristics of their assets over a 1-year time horizon: NSFR = (Available Stable Funding [ASF] / Required Stable Funding [RSF]) * 100%. Regulators mandate that banks maintain an NSFR of at least 100%.
What is the difference between LCR and NSFR under Basel III?
The Liquidity Coverage Ratio (LCR) addresses short-term liquidity resilience by requiring banks to hold enough High-Quality Liquid Assets (HQLA) to withstand an acute 30-day stress outflow. In contrast, the Net Stable Funding Ratio (NSFR) addresses structural, medium-to-long-term resilience by limiting maturity transformation and over-reliance on short-term wholesale funding over an ongoing 1-year horizon.
How is Available Stable Funding (ASF) weighted across liabilities?
Available Stable Funding assigns regulatory weights based on funding stickiness: Regulatory Capital and long-term liabilities (>1 year) receive a 100% ASF factor; stable retail demand/term deposits receive 95%; less-stable retail deposits receive 90%; short-term wholesale funding from non-financial corporate clients (<1 year) receives 50%; and volatile funding from financial institutions (<6 months) receives 0%.
What assets carry the highest Required Stable Funding (RSF) weights?
Assets with longer maturities and lower secondary market liquidity require higher stable funding: Performing commercial and corporate loans with maturity >= 1 year carry an 85% RSF factor; residential mortgages (>= 1 year) carry 65%; unencumbered Level 1 sovereign debt carries 5%; cash and central bank reserves carry 0%; and non-performing loans, physical fixed assets, and equity investments carry 100% RSF.