IRRBB Methodology & Implementation Framework

Interest Rate Risk in the Banking Book — Comprehensive Approach
Author: Anindya Kundu — Independent Banking Risk & SAS Consultant
Document Type: Methodology & Architecture Reference
Status: Illustrative Framework (Synthetic Data)
Web: anindyakundu.in

1. Executive Summary

This document defines the methodology for measuring Interest Rate Risk in the Banking Book (IRRBB) for an Indian commercial bank. It covers:

The approach is aligned with RBI Master Direction on IRRBB (2023) and Basel Committee BCBS 368.

2. Regulatory Background

2.1 RBI Requirements

The Reserve Bank of India requires all scheduled commercial banks to:

2.2 Basel BCBS 368 Framework

2.3 Indian Context

3. Scope & Definitions

TermDefinition
EVEEconomic Value of Equity = PV(Assets) − PV(Liabilities)
ΔEVEChange in EVE under a shocked yield curve vs base curve
NIINet Interest Income = Interest Income − Interest Expense
ΔNIIChange in NII under shocked rates over 1-year horizon
NMDNon-Maturity Deposit — no contractual maturity (savings, current)
AIROAutomatic Interest Rate Option — embedded optionality
CPRConditional Prepayment Rate
Core DepositsStable portion of NMD balances unlikely to be withdrawn
Volatile DepositsPortion of NMD sensitive to rate changes

4. Model Inventory

4.1 Product-to-Model Mapping

ProductCashflow TypeModel RequiredComplexity
G-Sec (fixed coupon)ContractualNone (known CFs)Low
Corporate loans (MCLR/EBLR)RepricingRepricing scheduleLow
Retail home loans (fixed)Contractual + behaviouralCPR / PrepaymentMedium
Retail savings accountsNo contractual maturityNMD behaviouralHigh
Current accountsNo contractual maturityNMD behaviouralHigh
Retail term depositsContractual + behaviouralPremature withdrawalMedium
Wholesale term depositsContractual + optionalityAIRO (Hull-White)High
Borrowings (fixed)ContractualNoneLow

4.2 Behavioural Model Inventory

ModelProductsMethodology
BM-01: Retail NMDSavings, Current accountsCore/volatile decomposition, decay function
BM-02: Wholesale NMDLarge institutional depositsConcentration-adjusted decay
BM-03: Term DepositRetail FDsRate-incentive prepayment model
BM-04: Fixed-Rate LoansHome loans (fixed)CPR based on refinancing incentive
BM-05: AIROWholesale term depositsHull-White, Bermudan swaption

5. Data Requirements

5.1 Source Systems

SourceDataFrequencyGranularity
Core Banking (CBS)Account positions, balances, rates, datesDailyAccount-level
Treasury SystemG-Sec, money-market, swapsDailyDeal-level
General LedgerGL balances for validationMonthlyGL-code level
RBI DBIE / FBILGovernment security yield dataDailyTenor-level

5.2 Key Data Fields — Deposits

FieldPurpose
Account IDUnique identifier
Product CodeMaps to risk category
Outstanding BalanceCurrent position
Interest Rate (booked)Current paying rate
Rate TypeFixed / Floating / Administered
Maturity DateFor term products
Customer SegmentRetail / Wholesale / Institutional

6. EVE Methodology

6.1 Concept

EVE = Present Value of all future asset cashflows − Present Value of all future liability cashflows

ΔEVE = EVE(shocked curve) − EVE(base curve)

This measures how the bank's economic net worth changes when interest rates move.

6.2 Computation Steps

Step 1: Identify all banking book positions Step 2: Generate cashflows (contractual + behavioural) Step 3: Map cashflows to time buckets (O/N, 1M, 3M, 6M, 1Y, 2Y, 3Y, 5Y, 7Y, 10Y, 15Y, 20Y, 30Y+) Step 4: Obtain base yield curve (INR zero-coupon rates from FBIL) Step 5: Discount all cashflows: PV = Σ CF(t) / (1 + r(t))^t Step 6: EVE(base) = PV(assets) − PV(liabilities) Step 7: For each shock scenario: a. Apply shock to base curve b. Re-discount all cashflows c. ΔEVE = EVE(shocked) − EVE(base) Step 8: Report ΔEVE as % of Tier 1 capital

6.3 EVE Treatment by Product

ProductCashflow Treatment
Fixed-rate loansScheduled principal + interest to maturity
Floating-rate loansPrincipal at next reset date (repricing assumption)
G-Sec (fixed coupon)Coupon + principal at maturity
NMD (savings/current)Behavioural cashflows from NMD model
Term depositsContractual CFs adjusted by prepayment model
Wholesale TDOption-adjusted CFs from AIRO model

7. NII Methodology

7.1 Concept

ΔNII = NII(shocked rates) − NII(base rates) over 1-year horizon.

This captures near-term earnings risk from rate movements.

7.2 Key Assumptions

7.3 Pass-Through Assumptions

ProductRate BehaviourPass-Through
MCLR-linked loansReprices at reset100% at reset
EBLR-linked loansReprices immediately100% immediate
Fixed-rate loansNo repricing0% within 1Y
Savings accountsAdministered30–50% partial, lagged
Term deposits (existing)Locked in0% for existing
Wholesale depositsNegotiated80–100%

8. Rate Shock Scenarios

#ScenarioShort EndLong EndDescription
1Parallel Up+200 bps+200 bpsEntire curve shifts up uniformly
2Parallel Down−200 bps−200 bpsEntire curve shifts down (floor at 0)
3Steepener−100 bps+100 bpsShort rates fall, long rates rise
4Flattener+100 bps−100 bpsShort rates rise, long rates fall
5Short Rate Up+300 bps0 bpsOnly short end rises (graduated)
6Short Rate Down−300 bps0 bpsOnly short end falls (graduated)

9. Behavioural Models Overview

Why behavioural models are needed: Contractual cashflows assume all products behave exactly as their contract states. In reality, NMD deposits have no maturity, term deposits can be withdrawn early, and fixed-rate loans can be prepaid. Behavioural models convert contractual positions into realistic expected cashflows.

10. Retail NMD Model

10.1 Methodology: Core/Volatile Decomposition

  1. Historical analysis: Collect 36+ months of monthly aggregate savings balances
  2. Core identification: Statistical decomposition — core = stable floor (typically 68–75% for Indian savings)
  3. Volatile balance: Total − Core (placed in O/N bucket)
  4. Decay function: Core decays exponentially: Balance(t) = Core × e−λt
  5. Repricing: Savings rate adjusts by β × ΔMarket_Rate with lag L months
  6. Cashflow generation: Bucketed using decay: CF(bucket) = Core × [Surv(start) − Surv(end)]

10.2 Illustrative Parameters

ParameterSavingsCurrent
Core %72%55%
Decay rate (λ)0.15 p.a.0.25 p.a.
Half-life4.6 years2.8 years
Pass-through (β)40%N/A (zero rate)
Repricing lag4 monthsN/A
Max effective maturity7 years5 years

11. Term Deposit Prepayment Model

11.1 Methodology

Depositors may withdraw before contractual maturity. Likelihood depends on rate differential between current market rate and booked rate, penalty, remaining tenor, and deposit size.

CPR Model: CPR = Base_CPR + Sensitivity × max(0, Rate_Differential − Penalty)

11.2 Illustrative Parameters

ParameterValue
Base CPR (no incentive)3–5% p.a.
Sensitivity per 100bps2–4% p.a. additional
Penalty (typical)1% of deposit rate

12. AIRO — Hull-White Model

12.1 Concept

Wholesale term deposits carry an implicit early-withdrawal option (AIRO). Valued using Hull-White one-factor short-rate model.

12.2 Short-Rate Dynamics

dr(t) = [θ(t) − α·r(t)] dt + σ dW(t) Where: r(t) = instantaneous short rate α = mean reversion speed θ(t) = time-dependent drift (fits current term structure) σ = short-rate volatility dW(t) = Wiener process

12.3 Calibration

  1. Estimate α: OLS regression on discretized rate changes using historical 91-day T-Bill data
  2. Estimate σ: Standard deviation of regression residuals, annualized
  3. Calibrate θ(t): Fit to current INR zero-coupon curve (RBI DBIE / FBIL)

12.4 Option Valuation

13. Architecture & Data Flow

┌─────────────────────────────────────────────────────────────┐ │ SOURCE SYSTEMS │ │ CBS │ Treasury │ GL │ Market Data (RBI) │ └────┬─────┴──────┬───────┴──────┬──────┴───────────┬──────────┘ │ │ │ │ ▼ ▼ ▼ ▼ ┌─────────────────────────────────────────────────────────────┐ │ ETL LAYER │ │ Extract → Cleanse → Map products → Generate cashflows │ │ → Apply behavioural models → Construct yield curves │ └────────────────────────────┬────────────────────────────────┘ ▼ ┌─────────────────────────────────────────────────────────────┐ │ MODEL ENGINE │ │ NMD model → TD prepay → Loan CPR → AIRO/Hull-White │ │ → Cashflow bucketing → Discounting → EVE/NII computation │ └────────────────────────────┬────────────────────────────────┘ ▼ ┌─────────────────────────────────────────────────────────────┐ │ REPORTING LAYER │ │ EVE by scenario → NII by scenario → ΔEVE/Tier1 │ │ → Product contribution → Limit monitoring → Reg submission │ └─────────────────────────────────────────────────────────────┘

14. ETL & Performance Considerations

ChallengeSolution
Repeated expensive table joinsPre-join instrument × product_map × cashflow once, reuse downstream
Range-based bucket classificationReplace with format/lookup-based classification (single-pass)
Repeated UNION ALL processingSingle-pipeline architecture — each record processed once
Sequential bucket-by-bucket loopsVectorized computation — all buckets simultaneously
Data volume (20M+ rows)Minimize I/O, reduce table scans, parallel by product
Result: Architecture redesign achieved approximately 70% reduction in overnight batch run-time with zero change to final computation outputs.

15. Validation Approach

Validation TypeMethod
Conceptual soundnessMethodology review against BCBS 368 / RBI standards
Data integrityReconcile model inputs with GL / source balances
Implementation correctnessIndependent recalculation on sample positions
Back-testingApply model to historical period, compare predicted vs actual
Sensitivity analysisVary parameters ±10–20%, measure output impact
Mass balanceSum of bucketed cashflows = total portfolio balance

16. Implementation Considerations

Phased Approach

PhaseDurationDeliverables
Phase 13–4 monthsData sourcing, basic EVE/NII, simple NMD model, regulatory submission
Phase 22–3 monthsAll 5 behavioural models, Hull-White calibration, enhanced reporting
Phase 3OngoingAutomation, performance optimisation, quarterly recalibration

Common Challenges in Indian Banks

ChallengeMitigation
Product-code proliferation (300+ codes)Master mapping table, validate with business
Missing data fieldsPhased approach: start with available, enhance over time
No historical behavioural dataConservative assumptions initially, refine with data
Stakeholder alignmentJoint workshops, documented decisions
Regulatory timeline pressurePhased delivery with early regulatory submission capability

17. Governance & Recalibration

ModelRecalibrationAd-Hoc Trigger
NMD (Retail)QuarterlyBalance shift >15%
NMD (Wholesale)QuarterlyLarge depositor entry/exit
TD PrepaymentSemi-annualRate regime change
Loan CPRSemi-annualMajor rate cut/hike
AIRO (Hull-White)Semi-annualYield curve shape change