NSFR Calculator - Funding Ratio Review

The nsfr calculator compares a bank's available stable funding with its adjusted required stable funding so treasury, risk, and finance teams can review a one-year funding profile. Use it when preparing a board liquidity pack, checking a stress scenario, reviewing a regulatory-category assumption, or explaining why a change in asset mix affects stable funding needs.

• • Treasury planning: Test whether planned debt issuance, deposit runoff, or balance-sheet growth leaves a cushion above the selected NSFR requirement.
• • Risk committee review: Translate weighted ASF and RSF amounts into a ratio, surplus, and buffer that can be discussed without rebuilding a regulatory worksheet.
• • Scenario comparison: Change derivatives RSF or the adjustment percentage to see how category assumptions and trading exposures affect the denominator.
• • Training and controls: Help analysts understand the relationship between ASF, RSF, and the 100% minimum before they work in formal reporting systems.

NSFR stands for net stable funding ratio. It is designed for banking organizations, not ordinary household budgeting, because the inputs are already-weighted regulatory amounts. The tool does not assign ASF or RSF factors to every liability, asset, commitment, or derivative. Instead, it starts after that mapping is complete and checks the resulting ratio.

A result above 100% means the ASF amount exceeds the adjusted RSF amount you entered. A result below 100% means the model shows a funding shortfall against the selected requirement. Treat the output as a planning review, because final compliance depends on the institution's rule scope, reporting date, consolidation treatment, and supervisory definitions.

When the review shifts from bank stable funding to immediate balance-sheet liquidity, the cash ratio calculator gives a simpler cash-to-current-liabilities view.

The calculation has two stages: build the adjusted denominator, then divide ASF by that adjusted RSF amount.

• ASF: Available stable funding, already weighted by the applicable stability factors for capital and liabilities.
• Weighted RSF: Required stable funding from assets and commitments before the selected U.S. adjustment percentage.
• Derivatives RSF: The derivatives component of required stable funding, entered separately so it remains visible in the review.
• RSF adjustment percentage: The selected 100%, 85%, or 70% U.S. adjustment used to scale the denominator.

The calculator also reports the ratio as a decimal because some regulatory material states the minimum as 1.0 while management packs often show 100%. Those presentations are equivalent: a ratio of 1.05 is 105%, and a ratio of 0.95 is 95%.

The surplus or shortfall is not a substitute for remediation planning. It is simply ASF minus adjusted RSF. If the result is negative, the institution would need more eligible stable funding, less funding-intensive assets, lower adjusted RSF, or some combination that fits its business and rule set.

According to eCFR 12 CFR 249.100, a Board-regulated institution's NSFR equals available stable funding divided by required stable funding and must be equal to or greater than 1.0 on an ongoing basis.

For a broader current-assets comparison outside regulatory bank funding, the current ratio calculator can help frame short-term liquidity in ordinary corporate terms.

These terms matter because small classification changes can move the ratio even when the balance sheet total does not change.

The most important control is input quality. If ASF is overstated or RSF is understated, the ratio will look stronger than the underlying profile. Analysts should reconcile source schedules before using the result in a committee deck.

The optional internal buffer is included because many teams manage above the bare minimum. A five-point internal target means a 104% ratio is technically above 100% but still one point short of that internal planning level.

If the question is how long liquid resources can support operating costs, the defensive interval ratio calculator uses a time-based liquidity lens.

Start with the weighted amounts from your liquidity or regulatory reporting schedule, then use the outputs as a reasonableness check.

1. 1 Enter available stable funding: Use the ASF total after capital and liability categories have already been assigned their applicable factors.
2. 2 Enter weighted RSF: Add the required stable funding amount for assets and commitments before the selected adjustment percentage.
3. 3 Add derivatives RSF: Enter zero only when the derivatives RSF amount is not applicable or has already been included in the base RSF amount.
4. 4 Select the adjustment percentage: Use 100%, 85%, or 70% only when that choice matches the institution category and reporting assumptions being reviewed.
5. 5 Review surplus and buffer: Compare the funding surplus, 100% buffer, and internal target buffer before deciding whether a scenario needs escalation.

For example, a treasury analyst testing deposit runoff in the nsfr calculator may reduce ASF by $8 billion while leaving RSF unchanged. If the buffer falls from 12% to 4%, the analyst can show how much room remains before the internal target is missed.

When the same liquidity pack also needs the short-stress horizon, the LCR calculator compares high-quality liquid assets with projected net cash outflows.

A compact ratio model helps teams focus discussion on the funding movement instead of spreadsheet mechanics.

• • Clear denominator review: Separating base RSF, derivatives RSF, and the adjustment percentage makes denominator changes visible to reviewers.
• • Scenario discipline: Users can test one assumption at a time and see whether the ratio, dollar surplus, or internal buffer moves most.
• • Better committee notes: The output gives a percentage, ratio, dollar surplus, and status label that are easier to explain in meeting materials.
• • Training support: New analysts can connect the ASF and RSF definitions to a worked example before handling complete regulatory templates.
• • Control check: A separate calculator can catch obvious transposition or adjustment errors before a larger workbook is reviewed.

The tool is most useful when the weighted source numbers are already controlled. It can compare management cases, but it cannot validate whether a deposit, security, commitment, or derivative was assigned the correct factor.

For a stronger review, keep a short note beside each scenario explaining what changed. A ratio decline caused by loan growth has a different management response than a decline caused by wholesale funding runoff.

When a funding review also needs debt-service capacity context, the cash flow to debt calculator connects operating cash flow with total debt pressure.

NSFR results can move for regulatory, accounting, and business reasons. Review the drivers before acting on a single output.

• • This calculator assumes ASF and RSF inputs have already been weighted correctly. It does not classify every balance-sheet line item.
• • It does not decide whether an institution is subject to full or reduced NSFR treatment, nor does it replace formal regulatory reporting.
• • It does not model consolidation rules, transition timing, supervisory discretion, or jurisdiction-specific differences outside the selected U.S. adjustment choices.

The Basel framework and U.S. rules both depend on detailed factor mapping. That is why the calculator asks for weighted totals instead of raw balance-sheet amounts. If the underlying schedules change, rerun the calculation with the revised ASF and RSF amounts rather than editing only the final ratio.

Use the output as a prompt for review. A low buffer may call for a funding plan, asset mix review, or data-quality check. A high buffer can still deserve attention if it depends on temporary funding, unusual reporting-date balances, or assumptions that may reverse.

According to eCFR 12 CFR 249.105, U.S. required stable funding adjustment percentages are 100%, 85%, or 70% depending on the Board-regulated institution category and wholesale funding condition.

According to Basel Committee on Banking Supervision, ASF is calculated by assigning capital and liabilities to stability categories, multiplying them by ASF factors, and summing the weighted amounts.

For capital-structure pressure outside the NSFR rule set, the debt to capital calculator compares debt with the broader capital base.