Banks that fund long-term loans with short-term money are exposed to runs. The NSFR calculator takes the main funding sources and asset categories of a bank, applies the Basel III stable funding factors, and gives the net stable funding ratio, the available stable funding, the required stable funding, the surplus or shortfall and the extra funding needed to reach 100 %.
How the calculation works
- Enter the bank’s stable funding sources in millions: regulatory capital, stable and less stable retail deposits, and wholesale funding from non-financial companies under one year. Each has an available stable funding factor.
- Enter the assets that need stable funding: Level 1 and Level 2A securities, residential mortgages, other performing loans over one year and other assets. Each has a required stable funding factor.
- Funding with a 0 % factor and cash or central bank reserves do not change the result, so only the main categories are listed.
- The NSFR is available stable funding ÷ required stable funding. Banks must keep it at 100 % or more.
Example
A bank has 80 M of capital, 400 M of stable and 200 M of less stable retail deposits, and 300 M of wholesale funding. Its available stable funding is 80 + 0.95 × 400 + 0.90 × 200 + 0.50 × 300 = 790 M. Its assets are 150 M of Level 1 securities, 80 M of Level 2A securities, 350 M of residential mortgages, 350 M of other loans and 60 M of other assets. Required stable funding is 7.5 + 12 + 227.5 + 297.5 + 60 = 604.5 M. The NSFR is 130.7 %, a surplus of 185.5 M.
Why it matters
The NSFR shows if the structure of a balance sheet is sound over a one-year horizon. It helps students, analysts and treasurers to see which categories drive the result and how shifting deposits from less stable to stable, or lending less on long maturities, changes the ratio.
Good to know
The calculator uses simplified factors for the main categories only. It ignores derivatives, off-balance-sheet commitments, interdependent assets and liabilities, and local variations of the rules. The result is for learning and analysis and not for regulatory reporting.
Related tools
The liquidity coverage ratio calculator tests the 30-day side of bank liquidity, the debt to equity calculator measures leverage, and the loan to value calculator looks at the quality of mortgage collateral.