An NSFR calculator works out a bank's net stable funding ratio: whether the bank's long-term, stable sources of funding are large enough to support its assets over a year of stress. Enter the available stable funding and the required stable funding, and the calculator divides one by the other, shows the ratio as a percentage, and says whether it meets the 100 percent minimum set by the Basel III framework. It also shows how far the available funding is above or below what is required.
The NSFR formula
NSFR = available stable funding (ASF) ÷ required stable funding (RSF)
Requirement: NSFR of at least 100%
The net stable funding ratio is one of the Basel III liquidity requirements. Canada's banking supervisor, OSFI, states it as the amount of available stable funding relative to the amount of required stable funding, and says the ratio should be at least 100 percent on an ongoing basis. The idea is that banks must hold stable funding that covers the funding their assets and activities require over a one-year horizon.
How to use the NSFR calculator
- Enter available stable funding, the weighted total of equity and the liabilities that count as stable.
- Enter required stable funding, the weighted total of the bank's assets and off-balance-sheet items.
- Press Calculate.
Worked example
A bank has $120 billion of available stable funding and its assets and commitments require $100 billion of stable funding. Its NSFR is 120 ÷ 100 = 120 percent, which meets the minimum and leaves a cushion of $20 billion. If its required stable funding rose to $130 billion, for example because it made more long-term loans, the ratio would fall to about 92 percent, below the requirement, and the bank would need to raise more stable funding or hold fewer assets that need it.
Available and required stable funding
Available stable funding is the portion of a bank's capital and liabilities expected to be reliable over the one-year horizon, and the required stable funding comes from its assets, which depends on their liquidity characteristics and residual maturities. The components are not equally weighted: the amount in each category of funding and of assets is multiplied by its own factor. Off-balance-sheet exposures are weighted as well. The precise factors are set by regulators, so use the totals from the bank's regulatory reporting.
NSFR and the liquidity coverage ratio
Basel III has two liquidity requirements that look at different time horizons. The liquidity coverage ratio asks whether a bank holds enough high-quality liquid assets to meet its needs over a 30-day stress scenario. The net stable funding ratio looks over a full year and asks whether the bank's funding structure is stable enough for the assets it holds. Together they discourage a bank from funding long-term lending with short-term borrowing. The LCR calculator covers the 30-day measure.
Why a stable funding ratio is needed
A bank that lends for many years but funds itself with money that can be withdrawn within days is exposed if lenders and depositors become nervous at the same time. It may have to sell assets quickly at poor prices to repay them. By requiring stable funding to match the assets it supports, the NSFR reduces the risk of that mismatch. It is a structural measure, aimed at the match between a bank's funding and its assets.
Reading the ratio
A ratio above 100 percent shows that, on the regulatory weights, the bank has more stable funding than it needs. A ratio just above 100 percent leaves little room if the bank wants to grow its lending. A ratio below 100 percent means the bank would need to change its funding or its assets to comply. Because the inputs depend on regulatory classifications, two banks with similar balance sheets can report different ratios if their funding is classified differently. For the arithmetic of ratios and percentages, the percentage calculator may help.
Testing the effect of growth
Because the ratio compares funding with the assets it supports, it is useful for planning growth. Suppose the bank in the example wants to expand its long-term lending. Each extra dollar of lending raises the required stable funding, so the bank needs either more stable funding or a plan to hold other assets that need less. Entering a higher required figure and seeing the ratio fall shows how much new stable funding would have to be raised to keep above 100 percent. The same exercise works in reverse: a bank that raises more long-term funding can see how much extra lending it could support.
Stress and the one-year horizon
The one-year horizon is what separates this ratio from short-term liquidity measures. Funding that matures in a few days or weeks may be perfectly adequate in normal times, yet disappear in a crisis. The NSFR asks whether the bank could keep going for a year of extended stress without depending on such funding. Keeping the ratio comfortably above 100 percent gives the bank room to absorb surprises in the funding it expected to keep.
Common mistakes
- Using unweighted balances. ASF and RSF are weighted totals.
- Mixing time horizons. The NSFR covers one year; the LCR covers 30 days.
- Mixing units. Enter ASF and RSF in the same currency and units.
- Ignoring local rules. Weightings differ between jurisdictions.
What next
Use this often? Add NSFR to your Home screen.
Frequently asked questions
How does an NSFR calculator work?
It divides available stable funding by required stable funding and shows the result as a percentage.
What is the NSFR with $120bn of ASF and $100bn of RSF?
120 percent, which meets the 100 percent minimum.
What time period does the NSFR cover?
A one-year horizon, according to the Canadian supervisor OSFI's NSFR guidance.
How is the NSFR different from the LCR?
The LCR covers 30 days of stressed outflows; the NSFR looks at funding stability over a year.
Are all funding sources weighted equally?
No. Each category of funding is multiplied by its own factor, and so is each category of assets.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.