Enter Values

$M
Total bank assets
$M
Total bank liabilities
$M
Rate-sensitive assets
$M
Rate-sensitive liabilities
years
Macaulay duration of asset portfolio
years
Macaulay duration of liability portfolio
%
Current market interest rate
bps
Hypothetical parallel rate shift
Key Formulas
Income Gap: Gap = RSA − RSL
Duration Gap: DG = DA − (L/A) × DL
RSA = Rate-sensitive assets | RSL = Rate-sensitive liabilities | DA = Asset duration | DL = Liability duration
Ryan O'Connell, CFA
Calculator by Ryan O'Connell, CFA

Analysis Results

Income Gap (RSA − RSL) -- --
Gap ($M) --
Gap Ratio --
ΔNII (per period) --
Duration Gap -- --
Duration Gap (yrs) --
ΔEquity ($M) --
%ΔEquity --

Rate Sensitivity Analysis

Interest rate sensitivity analysis showing impact of rate changes from -200 to +200 basis points
Rate Change ΔNII ($M) % of Equity
-200 bps----
-150 bps----
-100 bps----
-50 bps----
Current (0 bps)----
+50 bps----
+100 bps----
+150 bps----
+200 bps----

Gap Visualization

RSA
--
RSL
--
Gap: --

Formula Breakdown

Gap = RSA − RSL

Model Assumptions

  • Parallel yield curve shift only (no twist or butterfly movements)
  • Linear duration approximation (no convexity adjustment)
  • Macaulay duration convention — formula converts to modified duration sensitivity via (1+i) denominator
  • Single repricing bucket — ΔNII represents one repricing period
  • Common interest rate applied to both asset and liability portfolios
  • Static balance sheet (no growth, runoff, or new business)
  • No prepayment or behavioral optionality
  • Risk thresholds are illustrative teaching heuristics, not regulatory standards

For educational purposes. Not financial advice. Market conventions simplified.

Understanding Interest Rate Gap & Duration Gap Analysis

Income Gap Analysis

Income gap analysis is a fundamental tool in bank asset-liability management (ALM). It measures the difference between rate-sensitive assets (RSA) and rate-sensitive liabilities (RSL) within a given repricing period. When rates change, the gap determines how net interest income (NII) is affected.

A negative gap (RSL > RSA) means the bank is liability-sensitive: rising rates hurt NII because expenses increase faster than income. A positive gap (RSA > RSL) means the bank is asset-sensitive: rising rates boost NII.

Duration Gap Analysis

Duration gap analysis takes a market-value perspective, measuring how the economic value of equity (EVE) changes when interest rates shift. The duration gap formula accounts for leverage by weighting liability duration by the ratio of liabilities to assets.

A positive duration gap means asset durations exceed leverage-adjusted liability durations. When rates rise, asset values fall more than liability values, reducing equity. The magnitude of the duration gap determines the bank's exposure to rate movements.

Managing Interest Rate Risk

Banks manage interest rate risk through balance sheet restructuring (adjusting the mix of fixed vs variable rate instruments), interest rate derivatives (swaps, caps, floors, futures), and duration matching strategies. Effective ALM requires monitoring both income and market-value exposures.

Limitations

Both gap and duration analysis have important limitations. They assume parallel rate shifts, use single repricing buckets, and treat all rate-sensitive items as equally responsive to rate changes. Duration analysis also uses a linear approximation that ignores convexity. These tools provide useful approximations for educational understanding but real-world ALM uses more sophisticated models.

Download This Calculator as an Excel Template Interactive model with editable formulas — customize, save, and share.
Get Excel Template

Frequently Asked Questions

Interest rate gap analysis measures a bank's exposure to interest rate changes by comparing rate-sensitive assets (RSA) to rate-sensitive liabilities (RSL) within a repricing period. The gap (RSA minus RSL) indicates how much net interest income (NII) will change when rates move. A negative gap means the bank is liability-sensitive and its NII falls when rates rise. A positive gap means the bank is asset-sensitive and its NII rises when rates rise. Gap analysis is a fundamental tool in bank asset-liability management (ALM).

Duration gap measures the sensitivity of a bank's economic value of equity (EVE) to interest rate changes, using the formula Duration Gap = DA − (L/A) × DL. While income gap focuses on short-term NII effects over a repricing period, duration gap captures the approximate market-value impact on the entire balance sheet under small parallel rate shifts. A positive duration gap means rising rates reduce the bank's equity value more than its liability value, decreasing net worth.

A negative income gap (RSL > RSA) means the bank has more rate-sensitive liabilities than rate-sensitive assets. When interest rates rise, the bank's interest expenses increase faster than its interest income, reducing NII. Conversely, when rates fall, the bank benefits as expenses decrease faster than income. Banks with negative gaps often hold long-term fixed-rate assets funded by short-term variable-rate deposits.

Banks manage interest rate risk through several strategies: (1) Balance sheet restructuring — adjusting the mix of fixed vs variable rate assets and liabilities to close the gap. (2) Interest rate derivatives — using swaps, futures, options, and caps/floors to hedge rate exposure without changing the balance sheet. (3) Duration matching — aligning asset and liability durations to minimize duration gap. (4) Setting internal limits on acceptable gap ratios and duration gap levels as part of ALM policy.

Gap analysis has several limitations: (1) It assumes parallel rate shifts — rates may not move uniformly across maturities. (2) It uses a single repricing bucket, ignoring that assets and liabilities may reprice at different times within the period. (3) It treats all rate-sensitive items as equally sensitive, when in practice some rates (e.g., savings deposits) may adjust sluggishly. (4) It is a static analysis that does not account for changes in balance sheet composition over time. (5) Duration gap analysis uses a linear approximation and ignores convexity effects for larger rate movements.

The duration gap formula (DA − (L/A) × DL) weights the liability duration by the leverage ratio (L/A). This is necessary because a bank's liabilities are typically smaller than its assets (the difference being equity). A $1 change in asset value has a different impact on equity than a $1 change in liability value. By multiplying DL by L/A, the formula converts liability duration to an asset-equivalent basis, making the two terms comparable and giving the true sensitivity of equity to rate changes.
Disclaimer

This calculator is for educational purposes only. It uses simplified assumptions including parallel rate shifts, single repricing buckets, linear duration approximation without convexity, and a static balance sheet. Risk assessment thresholds are illustrative teaching heuristics, not regulatory standards. For actual bank ALM analysis, consult professional risk management tools and regulatory guidelines.