Net Stable Funding Ratio Calculator Excel Template
Net Stable Funding Ratio Calculator Excel Template
Interactive Excel Financial Model
Download, customize, and integrate into your own analysis
What's Included
- Interactive financial model with live Excel formulas
- All formulas visible and fully editable
- Professional formatting with color-coded inputs & outputs
- Formula reference sheet with variable definitions
- Step-by-step instructions sheet
- Compatible with Microsoft Excel 2016 and later
Download Template
Price range: $0.00 through $20.00
Professional NSFR calculator template with Basel III weights. Calculate Available Stable Funding, Required Stable Funding, and compliance status instantly.
Online Calculator vs Excel Template
| Feature | Online | Excel |
|---|---|---|
| Instant use — no download | ✓ | — |
| Works offline | — | ✓ |
| Customize formulas & layout | — | ✓ |
| Save & share with colleagues | — | ✓ |
| Integrate into your own models | — | ✓ |
| Print-ready formatting | — | ✓ |
About This Template
Calculate your Net Stable Funding Ratio (NSFR) with this professional Excel template. The NSFR is a Basel III regulatory requirement that measures whether a bank has sufficient stable funding to support its assets over a one-year time horizon. Use this template to analyze structural liquidity compliance, identify funding gaps, and understand how different funding sources and asset types affect your NSFR.
What You Can Calculate
This template calculates five key NSFR metrics:
- Net Stable Funding Ratio — The core compliance metric (ASF/RSF × 100%). Must be ≥100% to meet Basel III requirements.
- Compliance Status — Instant pass/fail determination against the regulatory threshold.
- Total Available Stable Funding (ASF) — Weighted sum of your funding sources based on their stability characteristics.
- Total Required Stable Funding (RSF) — Weighted sum of your assets based on their liquidity characteristics.
- Funding Surplus/Deficit — The dollar amount of excess stable funding or shortfall requiring remediation.
Required Inputs
Enter values for 13 balance sheet items across two categories:
- ASF (6 inputs): Regulatory capital, stable retail deposits, less stable retail deposits, and wholesale funding by maturity bucket (>1 year, 6-12 months, <6 months).
- RSF (7 inputs): Cash, Level 1 and 2A securities, interbank loans, residential mortgages, other loans, and illiquid assets.
Methodology
The template applies Basel III standardized weights to each funding source and asset category. ASF weights range from 100% (most stable) for regulatory capital to 0% for short-term wholesale funding. RSF weights range from 0% (most liquid) for cash to 100% for illiquid assets. The ratio formula is:
NSFR = Available Stable Funding ÷ Required Stable Funding × 100%
Assumptions & Limitations
- Uses simplified Basel III weights for educational purposes
- Excludes off-balance-sheet exposures, derivatives, and encumbered assets
- Aggregate totals only — per-category breakdowns available in the web calculator
- Actual regulatory calculations may vary by jurisdiction
Frequently Asked Questions
The template uses Basel III standardized weights: ASF weights range from 100% (regulatory capital, long-term wholesale) to 0% (short-term wholesale). RSF weights range from 0% (cash) to 100% (illiquid assets). All weights are visible in the input labels and hover comments.
Yes. Unprotect the Calculator sheet to add rows. For each new category, apply the appropriate Basel III weight in the ASF or RSF formula. The template structure supports customization for bank-specific reporting.
This template is for educational analysis and internal planning. For official regulatory submissions, consult your compliance team u2014 actual NSFR calculations require additional factors (off-balance-sheet items, derivatives, encumbered assets) and jurisdiction-specific rules not captured in this simplified model.
A fully interactive financial model with live Excel formulas, an Instructions sheet with usage guide, and a Formula Reference sheet with variable definitions and model assumptions. All formulas are visible and editable.
Microsoft Excel 2016 or later. The template uses standard Excel formulas only — no macros, VBA, or add-ins required.
Yes. All cells are fully editable. You can modify any formula, add your own calculations, change formatting, or integrate the model into your existing spreadsheets.
The online calculator runs in your browser for quick calculations. This Excel template gives you a portable, offline financial model you can customize, save, share with colleagues, and integrate into your own analysis.
This template is provided for educational and personal use. You may use it in your own professional analysis and presentations. Redistribution or resale of the template itself is not permitted.
You can re-download the latest version from your account or by requesting a new download link. Free downloads are limited to 5 per email address per month.
