
ALM & Treasury: NII Gap, Duration Gap, VaR & LCR/NSFR
BFM + ABFM (BFM Module B & C — Market Risk, ALM, Interest Rate Risk & Liquidity (LCR/NSFR)) — 3 Solved Case Sets & Interactive Calculator
Master every Treasury & Risk Management numerical tested in CAIIB BFM: Earnings Perspective (NII = Gap × ΔR), Economic Value of Equity (ΔE ≈ -DGAP × Assets × Δy), Macaulay vs Modified Duration & Basis Point Value (BPV), Scaling 1-Day VaR to 10-Day VaR (√T rule), and Basel III Liquidity Coverage Ratio (HQLA Level 1/2A/2B haircuts).
Core Formulas, RBI Benchmarks & Examiner Traps
| Concept / Metric | Exact Mathematical Formula | RBI Regulatory Norm / Benchmark | Common IIBF Examiner Trap |
|---|---|---|---|
| Earnings Perspective: Net Interest Income (NII) Sensitivity | Rate Sensitive Gap (RSG) = RSA - RSL; ΔNII = RSG × ΔR | Positive Gap (RSA > RSL) is Asset Sensitive (benefits when rates rise); Negative Gap (RSA < RSL) is Liability Sensitive (loses when rates rise) | Fixed-rate loans and non-interest-bearing current accounts/capital over the 1-year horizon are excluded from RSA/RSL. |
| Modified Duration & Bond Price Sensitivity | Modified Duration (D_mod) = Macaulay Duration / (1 + y/m); % ΔPrice ≈ -D_mod × Δy; BPV (PV01) = Bond Value × D_mod × 0.0001 | Measures percentage price fall for a 1% (100 bps) rise in yield; BPV measures ₹ change for 1 bps (0.01%) yield shift | For semi-annual coupon bonds, divide annual YTM by 2 in the denominator (1 + y/2) when converting Macaulay Duration (in years) to Modified Duration! |
| Duration Gap (DGAP) & Economic Value of Equity (EVE) | DGAP = DA - (L / A) × DL; ΔEVE ≈ -DGAP × Total Assets × [Δy / (1 + y)] | When DGAP > 0 (DA > (L/A)×DL), an upward interest rate shock (+Δy) REDUCES the bank’s Economic Value of Equity (Net Worth) | Always weight Liability Duration (DL) by the leverage ratio (L / A), where L = Total Liabilities and A = Total Assets! |
| Value at Risk (VaR) Time Scaling & Confidence Intervals | T-Day VaR = 1-Day VaR × √T; 1-Day VaR = Portfolio Value × Daily Volatility (σ) × Z-Score | Standard Z-Scores (One-Tailed Normal): 95% Confidence = 1.645 (or 1.65); 99% Confidence = 2.326 (or 2.33) | Basel Market Risk requires 10-Day 99% VaR: multiply 1-Day VaR by √10 = 3.1623 (never multiply by 10!). |
ALM Rate-Sensitive Gap (NII Impact) & Duration Gap (Economic Value of Equity Impact)
The Asset-Liability Management Committee (ALCO) of Bharat Bank reviews its balance sheet as on 31st March 2026: Total Assets (A) = ₹50,000 Crore; Total Liabilities excluding Equity (L) = ₹45,000 Crore; Net Worth / Equity (E) = ₹5,000 Crore. Within the 1-year re-pricing bucket, Rate Sensitive Assets (RSA) are ₹32,000 Crore and Rate Sensitive Liabilities (RSL) are ₹26,000 Crore. The Modified Duration of Total Assets (DA) is 3.80 years and the Modified Duration of Total Liabilities (DL) is 2.00 years.
| ALM Metric | Value |
|---|---|
| Total Assets (A) | Total Liabilities (L) | Equity (E) | ₹50,000 Cr | ₹45,000 Cr | ₹5,000 Cr |
| 1-Year Rate Sensitive Assets (RSA) | ₹32,000 Crore |
| 1-Year Rate Sensitive Liabilities (RSL) | ₹26,000 Crore |
| Modified Duration of Assets (DA) | 3.80 Years |
| Modified Duration of Liabilities (DL) | 2.00 Years |
What is the 1-Year Rate Sensitive Gap (RSG), and what is the impact on Annual Net Interest Income (NII) if interest rates across the curve rise by 75 bps (+0.75%)?
RSG = RSA - RSL; ΔNII = RSG × ΔR- Step 1: Rate Sensitive Gap (RSG) = ₹32,000 Cr (RSA) - ₹26,000 Cr (RSL) = +₹6,000 Crore (Asset Sensitive).
- Step 2: Rate Shock (ΔR) = +75 bps = +0.75% = +0.0075.
- Step 3: ΔNII = +₹6,000 Crore × 0.0075 = +₹45 Crore (NII increases by ₹45 Crore).
Calculate the Leverage-Adjusted Duration Gap (DGAP) of Bharat Bank.
DGAP = DA - (L / A) × DL- Step 1: Leverage Ratio (L / A) = ₹45,000 Cr / ₹50,000 Cr = 0.90.
- Step 2: DGAP = 3.80 - (0.90 × 2.00) = 3.80 - 1.80 = +2.00 Years.
Using the Modified Duration Gap (DGAP = 2.00 years), what is the approximate change in the Economic Value of Equity (ΔEVE) if market yields rise by 100 bps (+1.00%)?
ΔEVE ≈ -DGAP × Total Assets (A) × Δy- Step 1: ΔEVE = -2.00 × ₹50,000 Crore × (+0.01) = -₹1,000 Crore.
- Step 2: Percentage erosion of ₹5,000 Cr Equity = (-1,000 / 5,000) × 100 = -20%.
What is the Modified Duration of Equity (DE) of Bharat Bank?
Duration of Equity (DE) = DGAP × (Total Assets / Equity) = DGAP × Leverage Multiplier- Step 1: Leverage Multiplier (A / E) = ₹50,000 Cr / ₹5,000 Cr = 10x.
- Step 2: Duration of Equity (DE) = DGAP (2.00 years) × 10 = 20.00 Years (meaning a 1% rate rise causes a 20% fall in Equity value).
To immunize the bank’s Economic Value of Equity against interest rate shocks (i.e., achieve DGAP = 0) without changing Asset/Liability sizes or Liability Duration (DL = 2.00), to what level must ALCO reduce the Asset Duration (DA)?
For DGAP = 0: DA = (L / A) × DL- Step 1: Set DA - (L / A) × DL = 0.
- Step 2: Required DA = 0.90 × 2.00 = 1.80 Years (achievable by shifting fixed-rate long-term bonds into floating-rate loans or Paying Fixed in Interest Rate Swaps).
Treasury Bond Duration, BPV (PV01) & Value at Risk (VaR) Scaling
The Treasury AFS Desk holds a ₹200 Crore market-value position in 7.26% GOI 2033 Bonds. The bond has a Macaulay Duration of 6.24 years and is currently trading at an annual Yield to Maturity (YTM) of 8.00% (compounded semi-annually). The daily yield volatility is 8 bps (or daily price return volatility σ = 0.48% per day). Given Z(99%) = 2.33 and √10 = 3.1623.
| Bond Portfolio Metric | Value |
|---|---|
| Market Value of Bond Portfolio | ₹200 Crore |
| Macaulay Duration | 6.24 Years |
| Current YTM (Semi-Annual Compounding) | 8.00% p.a. (4.00% per half-year) |
| Daily Price Return Volatility (σ_daily) | 0.48% per day |
| Normal Z-Score (99% One-Tailed) | √10 | 2.33 | 3.1623 |
What is the Modified Duration of the 7.26% GOI 2033 Bond (considering semi-annual coupon compounding at 8.00% p.a. YTM)?
Modified Duration = Macaulay Duration / (1 + YTM / 2)- Step 1: Macaulay Duration = 6.24 Years; Semi-annual yield (y/2) = 8.00% / 2 = 4.00% = 0.04.
- Step 2: Modified Duration = 6.24 / (1 + 0.04) = 6.24 / 1.04 = 6.00 Years.
What is the Basis Point Value (BPV / PV01) of the ₹200 Crore bond portfolio (change in value for a 1 bps = 0.01% shift in yield)?
BPV = Portfolio Market Value × Modified Duration × 0.0001- Step 1: Portfolio Market Value = ₹200 Crore; Modified Duration = 6.00.
- Step 2: BPV for 1 bps (0.01% = 0.0001) = ₹200 Crore × 6.00 × 0.0001 = ₹0.12 Crore = ₹12,00,000.
If the RBI Monetary Policy Committee (MPC) unexpectedly hikes the Repo Rate and bond yields jump by 35 bps (+0.35%), what is the approximate Mark-to-Market (MTM) capital loss on the ₹200 Crore portfolio?
MTM Loss = BPV × Yield Change in bps = Portfolio × D_mod × Δy- Step 1: Using BPV: ₹12,00,000 per bps × 35 bps = ₹4,20,00,000 = ₹4.20 Crore.
- Step 2: Verification using % formula: -6.00 × 0.35% = -2.10% of ₹200 Crore = -₹4.20 Crore.
What is the 1-Day Value at Risk (VaR) at the 99% confidence level (Z = 2.33, Daily price volatility σ = 0.48%)?
1-Day VaR (99%) = Portfolio Value × σ_daily × Z(99%)- Step 1: 1-Day Dollar Volatility (1 SD) = ₹200 Crore × 0.48% = ₹0.96 Crore (note: 8 bps daily yield volatility × ₹0.12 Cr BPV also equals ₹0.96 Crore!).
- Step 2: 1-Day 99% VaR = ₹0.96 Crore × 2.33 = ₹2.2368 Crore.
What is the 10-Day 99% Value at Risk (VaR) required for Basel Market Risk regulatory capital calculation?
10-Day VaR = 1-Day VaR × √10- Step 1: 1-Day 99% VaR = ₹2.2368 Crore.
- Step 2: Multiply by √10 (3.1623): ₹2.2368 Crore × 3.1623 = ₹7.0734 Crore.
Basel III Liquidity Coverage Ratio (LCR) & HQLA Level 1 / 2A / 2B Haircuts
Compute the Basel III Liquidity Coverage Ratio (LCR) for Dakshin Bank from the following liquid asset and 30-day stressed cash flow data:
| HQLA / Cash Flow Category | Gross Amount (₹ Crore) | Basel III Haircut / Run-off Factor |
|---|---|---|
| Cash in Hand, Excess CRR & Eligible SLR G-Secs (Level 1 HQLA) | ₹2,100 Crore | 0% Haircut (100% counted) |
| AA- and Above Rated Corporate Bonds & PSE Bonds (Level 2A HQLA) | ₹800 Crore | 15% Haircut (85% counted) |
| BBB- to A+ Corporate Bonds & Nifty 50 Equities (Level 2B HQLA) | ₹400 Crore | 50% Haircut (50% counted) |
| Total Stressed Cash Outflows over next 30 Calendar Days | ₹3,600 Crore | Gross Outflows |
| Total Stressed Contractual Cash Inflows over next 30 Calendar Days | ₹900 Crore | Capped at 75% of Total Outflows |
What is the post-haircut value of Level 2A HQLA (₹800 Cr @ 15% haircut) and Level 2B HQLA (₹400 Cr @ 50% haircut)?
Adjusted Level 2A = Gross 2A × (1 - 0.15); Adjusted Level 2B = Gross 2B × (1 - 0.50)- Step 1: Post-haircut Level 2A HQLA = ₹800 Cr × 0.85 = ₹680 Crore.
- Step 2: Post-haircut Level 2B HQLA = ₹400 Cr × 0.50 = ₹200 Crore.
What is the Total Stock of High Quality Liquid Assets (HQLA) after verifying the Basel III 40% cap on Total Level 2 assets and 15% cap on Level 2B assets?
Total HQLA = Level 1 + Adjusted Level 2A + Adjusted Level 2B (subject to Level 2 ≤ 40% and Level 2B ≤ 15% of Total HQLA)- Step 1: Uncapped Total HQLA = ₹2,100 (L1) + ₹680 (L2A) + ₹200 (L2B) = ₹2,980 Crore.
- Step 2: Check Level 2 Share = (680 + 200) / 2,980 = 29.53% (≤ 40% ceiling).
- Step 3: Check Level 2B Share = 200 / 2,980 = 6.71% (≤ 15% ceiling). Both caps are satisfied, so Total HQLA = ₹2,980 Crore.
What is the Total Net Cash Outflows over the next 30 calendar days?
Net Cash Outflows = Total Outflows - Min(Total Inflows, 75% of Total Outflows)- Step 1: 75% cap on Cash Inflows = 75% of ₹3,600 Cr = ₹2,700 Crore.
- Step 2: Actual Stressed Cash Inflows = ₹900 Crore (well below the ₹2,700 Cr cap).
- Step 3: Total Net Cash Outflows = ₹3,600 Cr - ₹900 Cr = ₹2,700 Crore.
What is the Liquidity Coverage Ratio (LCR %) of Dakshin Bank, and does it meet the RBI minimum requirement of 100%?
LCR (%) = (Stock of HQLA / Total Net Cash Outflows over 30 Days) × 100- Step 1: Stock of HQLA = ₹2,980 Crore; Net Cash Outflows = ₹2,700 Crore.
- Step 2: LCR = (₹2,980 / ₹2,700) × 100 = 110.37%. Since 110.37% ≥ 100%, the bank complies.
If the bank also computes its Net Stable Funding Ratio (NSFR — 1-year structural liquidity horizon) and has Available Stable Funding (ASF) of ₹38,500 Crore against Required Stable Funding (RSF) of ₹35,000 Crore, what is the NSFR?
NSFR (%) = (Available Stable Funding [ASF] / Required Stable Funding [RSF]) × 100 ≥ 100%- Step 1: ASF = ₹38,500 Crore; RSF = ₹35,000 Crore.
- Step 2: NSFR = (₹38,500 / ₹35,000) × 100 = 110.00% (Complies with ≥ 100% norm).
Want More Practice on ALM & Treasury? Generate Case Study Set #4
Click to synthesize a brand-new 5-question (10-mark) IIBF numerical case study for BFM + ABFM on the fly. Every newly generated set is also automatically deduplicated and merged into our global Cloudflare KV question bank.
Try With Your Own Numbers: Live ALM & Treasury Calculator
Modify any input below to watch the step-by-step IIBF formula outputs update in real time.
Frequently Asked IIBF Exam Questions (BFM + ABFM)
Why are inflows capped at 75% of outflows in the Basel III LCR formula?
To prevent banks from relying solely on anticipated contractual inflows to meet liquidity needs during a 30-day systemic crisis, Basel III caps recognized inflows at 75% of total cash outflows. This forces every bank to hold a minimum HQLA buffer equal to at least 25% of gross 30-day cash outflows.
What is the difference between Macaulay Duration and Modified Duration?
Macaulay Duration (measured in years) is the present-value-weighted average time until cash flows are received. Modified Duration = Macaulay Duration / (1 + y/m) measures the percentage change in a bond’s price for a given change in yield.

Welcome Back
Sign in to save reports and access premium credit tools.