Skip to content
Omnikalc

NSFR calculator: does a bank have enough stable funding for its assets?

Enter funding sources and assets by category to get the net stable funding ratio, the available and required stable funding and the surplus or shortfall.

Updated on
Your inputs
M

Value out of range

M

Value out of range

M

Value out of range

M

Value out of range

M

Value out of range

M

Value out of range

M

Value out of range

M

Value out of range

M

Value out of range

M

Value out of range

Results

Net stable funding ratio (NSFR)

130.7 %

Meets the 100 % minimum
Available stable funding (ASF)
790.0 M
Required stable funding (RSF)
604.5 M
Surplus or shortfall of stable funding
185.5 M
Extra stable funding needed to reach 100 %
0.0 M

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.

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.

Frequently asked questions

What is the net stable funding ratio?

The NSFR is a Basel III liquidity standard. It compares the amount of stable funding a bank has, such as capital and long-term or sticky deposits, with the amount it needs given the liquidity and maturity of its assets. It aims to stop banks from funding long-term loans with short-term money that can run away.

What is the minimum NSFR?

Banks subject to Basel III must keep the NSFR at 100 % or more on an ongoing basis. The rule has applied in the European Union since June 2021 and in the United States to the largest banks since July 2021. Some jurisdictions apply it to a narrower set of banks.

What is the difference with the liquidity coverage ratio?

The liquidity coverage ratio checks that a bank can survive a 30-day stress with high-quality liquid assets. The NSFR looks at a one-year horizon and the structure of the whole balance sheet. The two rules work together.

Are the factors in this calculator exact?

They follow the Basel III standard for the main categories, but the full rules have many more categories, such as derivatives, off-balance-sheet items, encumbered assets and secured funding transactions. Use the calculator to understand the ratio and not for regulatory reporting.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.