◆Financial Derivatives — In Progress Please await announcements of new courses and upcoming batches. Course Updates →
The Mountain Path Academy
← Financial Risk Management

FUNDAMENTALS → INTERMEDIATE · FINANCIAL RISK MANAGEMENT

Liquidity Risk in Banks
and Its Management

How banks meet cash obligations, manage funding fragility and measure the cost of turning assets into cash.

By Prof. V. Ravichandran · The Mountain Path Academy
Updated 1 November 2026 · Worked examples, Excel formulas and two interactive laboratories

THE MOUNTAIN PATH ACADEMY · FINANCIAL RISK MANAGEMENTSearch the guide

Bank liquidity at a glance

Funding · Markets · Cash timing · Basel ratios · Collateral · Management

CASH READINESS

Meet each payment, in the right currency, at the right time

Capital absorbs losses. Liquidity meets payments. Funding stress and asset-sale discounts can reinforce each other.

Funding liquidity

Cash availability by amount, currency, entity and date

Cash-flow gaps, withdrawals and refinancing dependence

Market liquidity

Ability to sell without excessive cost

Bid–ask spreads, market depth, price impact and liquidation time

30-day buffer

Liquidity Coverage Ratio (LCR)

Adjusted High-Quality Liquid Assets (HQLA) ÷ net stressed outflows. Normal-times Basel minimum: 100%.

Stable funding

Net Stable Funding Ratio (NSFR)

Available Stable Funding (ASF) ÷ Required Stable Funding (RSF). Basel minimum: 100% on an ongoing basis.

Cash timing and survival

Maturity ladder and survival horizon

Bucket gaps, cumulative cash deficits and the first payment shortfall

Stress and reverse tests

Resilience under withdrawals and funding disruption

Run-off, rollover failure, margin calls, reduced inflows and failure boundaries

Governance and response

Asset–Liability Committee (ALCO) and Contingency Funding Plan (CFP)

Limits, warning indicators, tested funding actions, owners and model validation

TEACHING MOMENT

A bank can be solvent yet short of cash. A Liquidity Coverage Ratio or Net Stable Funding Ratio above 100% does not guarantee every intraday payment. Read both ratios alongside cash-flow gaps, stress tests and funding concentration.

LEARNING SECTION 01

What is liquidity risk in a bank?

Key concept: Funding liquidity concerns cash payments. Market liquidity concerns trading without excessive cost. Solvency concerns loss absorption.

Liquidity risk is the risk that a bank cannot meet payment obligations when due without incurring unacceptable losses. The obligation can arise from a deposit withdrawal, a maturing loan, a payment settlement, a credit-line drawdown or a collateral call.

Banks transform maturities: depositors may want cash quickly while borrowers repay over years. This supports credit creation, but creates a need for reliable cash forecasting, liquid assets and funding contingency plans.

ConceptQuestionExample
Funding liquidityCan the bank obtain usable cash in the required amount, currency and time?A wholesale lender refuses to renew a deposit.
Market liquidityCan the bank sell or hedge an asset without an excessive discount or price impact?A corporate-bond position attracts only deeply discounted bids.
SolvencyDo assets and loss-absorbing capital support the bank’s obligations?Loan losses erode equity even though cash payments continue today.

A solvent bank can face a cash shortfall. A bank with cash today can still have an unsustainable capital position. Capital and liquidity assessments must therefore work together.

LEARNING SECTION 02

How a liquidity spiral develops

Imagine a bank holding long-term securities funded by concentrated deposits. A rate rise reduces securities values. Concern about the bank causes withdrawals. The bank sells securities, realises losses and weakens confidence further.

StageImmediate effectPossible next effect
Funding withdrawalsCash leaves the bankThe bank sells assets or seeks secured borrowing.
Asset sale at a discountSale proceeds are below carrying or reference valueLosses weaken capital and market confidence.
Collateral haircut risesEach pledged asset raises less cashMore collateral or cash becomes necessary.
Confidence deterioratesMore depositors and lenders withdrawThe bank’s funding options become narrower.

A hedge can protect economic value while generating a margin call before its offsetting cash benefit arrives. Liquidity planning must track settlement timing as well as gains and losses.

REAL-WORLD LIQUIDITY LESSONS

Three crises, three funding lessons

Silicon Valley Bank, 2023: concentrated uninsured deposits and interest-rate risk made the bank vulnerable to rapid withdrawals. Securities losses, confidence and funding pressure interacted. Federal Reserve review.

Northern Rock, 2007: reliance on wholesale funding became a critical vulnerability when markets froze; emergency liquidity support was followed by a retail run. UK Treasury Committee report.

Yes Bank, India, 2020: deteriorating liquidity and capital, alongside the absence of a credible capital-infusion plan, led to a moratorium and reconstruction. This illustrates how funding confidence and solvency concerns can reinforce each other. RBI reconstruction announcement.

These events had different causes and resolution mechanisms. They illustrate related vulnerabilities rather than an identical sequence of events.

LEARNING SECTION 03

What should a liquidity dashboard measure?

MeasureWhat it revealsManagement use
Bid–ask spreadImmediate trading cost relative to a reference priceTrading limits and exit planning
Market depth and price impactWhether quoted prices survive a large tradePosition sizing and liquidation schedules
Contractual and behavioural cash gapsWhen expected inflows and outflows differFunding plans by maturity bucket
Survival horizonFirst cash shortfall under stated stress assumptionsLiquidity-buffer and contingency targets
Funding concentrationDependence on a few depositors, markets or maturitiesDiversification and concentration limits
Asset encumbranceAssets already pledged or otherwise unavailableCollateral capacity and mobilisation
Liquidity Coverage Ratio and Net Stable Funding RatioShort-term stressed buffer and structural funding resilienceRegulatory monitoring alongside internal metrics

The dashboard should distinguish currencies, legal entities and operating time zones. Surplus cash in one subsidiary may be unavailable to another because of legal, regulatory or operational restrictions.

LEARNING SECTION 04

Bid–ask spreads: the cost of an immediate exit

Key concept: A one-way sale from midpoint to bid costs half the quoted spread, provided market depth is sufficient.

The bid is the price at which a dealer buys from you. The ask is the price at which a dealer sells to you. The midpoint is their average. For a long position marked at the midpoint, an immediate sale at the bid sacrifices half the quoted spread, assuming sufficient depth.

Midpoint = (bid + ask)/2
Proportional spread s = (ask − bid)/midpoint
One-way exit cost versus midpoint ≈ ½ × s × midpoint position value

With bid ₹99.50 and ask ₹100.50, the midpoint is ₹100 and the proportional spread is 1%. Selling a ₹50 crore long holding costs approximately ½ × 1% × 50 = ₹0.25 crore, or ₹25 lakh, relative to its midpoint value.

A short position is closed by buying at the ask. A buy-and-sell round trip incurs the full spread under unchanged quotes. Fees, market impact and changing prices add further costs.

LEARNING SECTION 05

A portfolio liquidity-cost illustration

Hypothetical assetMidpoint value (₹ crore)Full proportional spreadOne-way cost (₹ crore)
Large-cap shares400.2%0.040
Government securities300.1%0.015
Corporate bonds201.0%0.100
Mid-cap shares102.0%0.100
Total1000.51% (value-weighted)0.255

The ₹30 crore corporate-bond and mid-cap positions create ₹0.20 crore of the ₹0.255 crore exit cost, about 78.43%. A smaller, less liquid allocation can dominate trading costs.

The formula assumes each position can trade at the displayed bid or ask. A large order can walk through the order book, so the realised cost may exceed half the spread.

Value-weighted full spread = (40 × 0.2% + 30 × 0.1% + 20 × 1.0% + 10 × 2.0%) / 100 = 0.51%
One-way exit cost = ½ × 0.51% × ₹100 crore = ₹0.255 crore.

LEARNING SECTION 06

Liquidity-adjusted Value at Risk

Key concept: Adding an exit cost to Value at Risk is an approximation. It does not automatically produce an exact combined loss quantile.

Value at Risk (VaR) is a loss quantile at a stated confidence level and horizon. A simple Liquidity-adjusted Value at Risk (LVaR) adds an estimated liquidation cost to a market-risk measure.

Constant-spread approximation: LVaR = market VaR + ½Σ(spreadᵢ × position valueᵢ)

If market Value at Risk is ₹3.49 crore and the preceding exit cost is ₹0.255 crore, the additive result is ₹3.745 crore.

For a directly comparable stress on the same ₹100 crore portfolio, use its 0.51% value-weighted mean full spread, an assumed spread standard deviation of 0.5 percentage point and multiplier 2.33. The stressed full spread is 0.51% + 2.33 × 0.5% = 1.675%. Half-spread cost is ½ × 1.675% × 100 = ₹0.8375 crore; adding market VaR of ₹3.49 crore gives ₹4.3275 crore, compared with ₹3.745 crore at constant spreads. The spread-volatility and multiplier inputs are illustrative modelling assumptions, not regulatory parameters.

These are approximations, not a universal regulatory formula. Adding two tail estimates does not generally produce the exact quantile of their sum. Price losses, spread widening and funding stress can depend on one another, and a normal spread approximation can produce implausible values.

LEARNING SECTION 07

Market depth, liquidation time and collateral haircuts

Key concept: An asset’s market value, sale proceeds and borrowing capacity are different amounts. Haircuts and encumbrance reduce usable cash.

A position worth ₹60 crore in a market with ₹20 crore average daily turnover cannot necessarily be sold at quoted prices in one transaction. At an assumed participation limit of 10% of daily turnover, planned sales are ₹2 crore a day, implying 30 trading days before price changes, volume shifts and execution constraints.

Slower sales may reduce market impact but leave exposure open longer. A liquidity-horizon assumption is therefore a modelling choice, rather than a guarantee that every position can be exited within that period.

Borrowing capacity = eligible collateral market value × (1 − haircut)

Collateral valued at ₹100 crore raises ₹95 crore under a 5% haircut. At a 15% haircut, it raises ₹85 crore, a ₹10 crore reduction even before a market-price decline.

Encumbered assets already secure an obligation and may be unavailable for another use. Do not count one security simultaneously as sale proceeds and as collateral supporting a new borrowing.

LEARNING SECTION 08

Cash-flow maturity ladder: where does the gap occur?

Key concept: A balanced day-30 total can conceal an earlier funding failure. Timing matters as much as the aggregate amount.
BucketInflowsOutflowsNet flowCumulative net flowCash after ₹200 crore opening buffer
Day 1300450−150−15050
Days 2–7500600−100−250−50
Days 8–14400350+50−2000
Days 15–30700500+2000200

All amounts are ₹ crore. The bank returns to an aggregate balanced flow by day 30, but faces a ₹50 crore funding gap in the days 2–7 bucket. Future inflows cannot pay earlier obligations without bridging funding.

The ladder locates a shortfall somewhere in that bucket. Exact survival time requires daily or intraday timing. At day 7, the ₹250 crore cumulative net deficit is 250/(450+600) = 23.81% of cumulative outflows. For a covered commercial bank, this exceeds the RBI day-7 cumulative mismatch limit of 10%; the opening cash buffer is shown separately in this simplified ladder.

Contractual maturities need behavioural adjustments for early withdrawals, loan prepayments, committed-line drawdowns and realistic renewal rates. Those adjustments should be transparent and independently challenged.

RBI commercial-bank cumulative mismatch limits

Bucket endMaximum net cumulative negative mismatch / cumulative outflows
Next day5%
Days 2–710%
Days 8–1415%
Days 15–3020%

The case gives day-1 mismatch of 150/450 = 33.33%, day-7 mismatch of 250/1,050 = 23.81%, day-14 mismatch of 200/1,400 = 14.29% and day-30 mismatch of 0.00%. The first two exceed these limits. This is an illustrative comparison of the displayed cash flows, not a completed regulatory SLS: actual reporting must follow RBI slotting rules, including treatment of cash and other assets. RBI Commercial Banks ALM Directions, paragraph 43. NBFCs use a different schedule.

LEARNING SECTION 09

Survival horizon and reverse liquidity stress

Key concept: A survival horizon depends on which resources, inflows and facilities are genuinely available under stress.

Survival horizon is the first time usable resources fail to meet cumulative stressed cash needs, given an explicit definition of available funding. A constant-burn shortcut is:

Survival days ≈ usable cash buffer / daily net cash outflow

A ₹120 crore buffer with a steady ₹15 crore daily net burn lasts eight days. This assumes the buffer is immediately usable and daily burn stays constant.

A reverse run-off calculation

Assume ₹150 crore usable resources, ₹50 crore credible inflows, ₹80 crore other payments and ₹1,000 crore deposits. The aggregate withdrawal fraction that exhausts cash is:

Run-off boundary = (150 + 50 − 80)/1,000 = 12%

At 12% withdrawal, simplified ending cash reaches zero. Above 12%, there is a shortfall. Earlier payment timing can cause failure before that aggregate threshold is reached.

Test an institution-specific shock, a market-wide shock and a combination. Include deposit concentration, loss of unsecured funding, collateral calls, reduced collections and asset-sale discounts.

LEARNING SECTION 10

Liquidity Coverage Ratio: a 30-day buffer

Key concept: The Liquidity Coverage Ratio uses adjusted eligible assets and caps recognised inflows at 75% of gross stressed outflows.

The Liquidity Coverage Ratio (LCR) compares eligible, unencumbered High-Quality Liquid Assets (HQLA), after required haircuts and composition caps, with net cash outflows in a prescribed 30-calendar-day stress.

LCR = adjusted HQLA / net stressed cash outflows
Net outflows = gross outflows − min(eligible inflows, 75% × gross outflows)

The Basel normal-times minimum is 100%. The inflow cap ensures that a bank holds liquid assets rather than relying entirely on expected inflows. With outflows of ₹400 crore and inflows of ₹350 crore, recognised inflows are capped at ₹300 crore and net outflows remain ₹100 crore.

During actual stress, banks may draw on the buffer and fall below 100%, subject to the applicable supervisory response. A reported ratio above 100% does not prove that cash is available in every currency or at every point during the day.

LEARNING SECTION 11

High-Quality Liquid Assets: eligibility, haircuts and caps

Key concept: Eligibility, haircuts, composition caps and operational access all matter when determining the usable liquid-asset buffer.
Basel categoryGeneral treatmentImportant qualification
Level 1Generally no Basel composition cap and a 0% Basel haircut for qualifying assetsEligibility and operational availability matter. National rules may impose valuation adjustments.
Level 2AGenerally a 15% haircutTotal Level 2 assets cannot normally exceed 40% of the buffer after required adjustments.
Level 2BDepending on eligible asset type, haircuts can be 25% or 50%Level 2B is subject to a 15% cap and also sits inside the total Level 2 cap.

A high credit rating alone does not establish eligibility. Assess market liquidity, currency, issuer restrictions, encumbrance and whether treasury can monetise the asset operationally. Cap calculations can require adjustments for secured transactions maturing within the stress period.

India: SLR carve-outs and valuation haircuts

Eligible government securities above minimum SLR can enter Level 1. Within mandatory SLR, RBI permits the MSF carve-out (2% of NDTL) and FALLCR carve-out (16% of NDTL), subject to eligibility and operational conditions. FALLCR means Facility to Avail Liquidity for Liquidity Coverage Ratio; it is not an unrestricted cash balance.

From 1 April 2026, Level 1 government securities are valued at no more than current market value after applicable LAF/MSF haircuts. Do not treat every SLR security as freely available or count the same security twice. RBI ALM Directions, Level 1 assets; April 2025 amendment.

The worked example below has only Level 1 and Level 2A assets, with the Level 2A share comfortably below the cap. It assumes the Level 1 input is already eligible and adjusted.

LEARNING SECTION 12

Worked LCR: Bank Tunga

All amounts are hypothetical ₹ crore. Assume adjusted eligible Level 1 assets of 900 and Level 2A market value of 300 with a 15% haircut. The run-off rates below are explicit case inputs, rather than a complete deposit-classification rule.

ComponentCalculationAmount
Level 1 liquid assetsAlready adjusted and eligible900
Level 2A liquid assets300 × 85%255
Adjusted buffer900 + 2551,155
Stable digital-enabled retail deposits6,000 × 7.5%450
Less-stable digital-enabled retail deposits2,000 × 12.5%250
Non-operational non-financial corporate deposits1,000 × 40%400
Short-term financial-institution funding300 × 100%300
Gross outflows450 + 250 + 400 + 3001,400
Eligible inflowsmin(400, 75% × 1,400)400
Net outflows1,400 − 4001,000
LCR = 1,155 / 1,000 = 115.50%

The Level 2A share is 255/1,155 = 22.08%, below the 40% total Level 2 cap in this simple portfolio.

If gross outflows rise to ₹1,600 crore and eligible inflows fall to ₹300 crore, net outflows become ₹1,300 crore. With the buffer unchanged, the ratio falls to 88.85%, creating a ₹145 crore buffer shortfall relative to 100%.

These retail factors follow the RBI circular of 21 April 2025, effective 1 April 2026: an additional 2.5 percentage points applies to qualifying retail deposits enabled for internet/mobile banking, including UPI. Thus stable deposits use 7.5% and less-stable deposits 12.5%, against the 5% and 10% baseline factors. Classification still depends on deposit insurance, relationships and other prescribed criteria; digital access alone does not establish stability.

LEARNING SECTION 13

Net Stable Funding Ratio: the funding structure

Key concept: The Net Stable Funding Ratio weights both funding and assets. Nominal balance-sheet totals alone do not measure structural stability.

The Net Stable Funding Ratio (NSFR) tests structural resilience over a one-year horizon. It compares weighted Available Stable Funding (ASF) with weighted Required Stable Funding (RSF).

NSFR = ASF / RSF ≥ 100%

Available funding weights reflect its likely stability. Required funding weights reflect assets’ liquidity, maturity, encumbrance and other characteristics. A short contractual maturity does not automatically mean funding receives no stable-funding recognition.

Illustrative Basel itemSideFactor or qualification
Eligible capital and funding with residual maturity at least one yearASFGenerally 100%
Qualifying stable / less-stable retail funding under one yearASFGenerally 95% / 90%
Certain short-term non-financial corporate fundingASF50%, subject to classification
Cash / qualifying unencumbered Level 1 securitiesRSF0% / generally 5%
Certain performing non-financial loans under one yearRSF50%, subject to conditions
Certain performing loans at least one year, with risk weights above 35%RSF85%, subject to conditions

These examples do not replace the full rulebook. Derivatives, secured funding, off-balance-sheet commitments, financial-sector transactions and encumbered assets have additional treatments.

LEARNING SECTION 14

Worked NSFR: a balanced funding example

Consider this separate hypothetical ₹10,500 crore balance sheet. It illustrates weighted funding rather than every regulatory adjustment. All figures are ₹ crore.

Funding sourceBalanceASF factorWeighted ASF
Capital and long-term debt1,200100%1,200
Qualifying stable retail deposits6,00095%5,700
Qualifying less-stable retail deposits2,00090%1,800
Qualifying non-financial corporate funding1,00050%500
Financial-institution funding under six months3000%0
Total10,5009,200
Asset categoryBalanceRSF factorWeighted RSF
Performing long-term loans meeting the assumed 85% category7,00085%5,950
Qualifying short-term non-financial loans2,00050%1,000
Qualifying unencumbered Level 1 securities9005%45
Qualifying unencumbered Level 2A securities30015%45
Other assets assigned 100% for this case300100%300
Total10,5007,340
NSFR = 9,200 / 7,340 = 125.34%

If ₹2,000 crore of stable retail funding is replaced by funding that qualifies for 0% Available Stable Funding, weighted funding falls by ₹1,900 crore to ₹7,300 crore. With Required Stable Funding unchanged, the ratio becomes 99.46%. The nominal balance sheet still balances, but its funding quality has deteriorated.

LEARNING SECTION 15

LCR versus NSFR: why a bank needs both

Key concept: The two Basel ratios serve different horizons. Neither replaces cash-flow stress testing and concentration monitoring.
FeatureLiquidity Coverage Ratio (LCR)Net Stable Funding Ratio (NSFR)
Main purposeAbsorb a prescribed short-term cash stressSupport a more stable funding structure
Horizon30 calendar daysOne year
NumeratorAdjusted High-Quality Liquid AssetsAvailable Stable Funding
DenominatorStressed net cash outflowsRequired Stable Funding
Basel standardAt least 100% in normal timesAt least 100% on an ongoing basis
LimitationDoes not guarantee survival beyond its assumptions or every intraday paymentDoes not guarantee payment capacity today

A bank may meet the 30-day buffer requirement while depending heavily on renewals just beyond day 30. Another may have stable long-term funding but face a temporary settlement or collateral shortfall. Neither ratio replaces a cash-flow ladder, concentration limits and stress testing.

LEARNING SECTION 16

Management: funding, buffers and contingency actions

Key concept: A contingency plan needs named owners, credible cash amounts, execution times and tested access to funding.

The board sets liquidity risk tolerance. The Asset–Liability Committee (ALCO) translates it into funding strategy, limits and escalation. Treasury executes funding and collateral actions. Risk teams provide independent monitoring and challenge.

Management toolActionTrade-off or constraint
Diversified fundingBroaden depositor, market, maturity and currency sourcesNominal diversification can conceal common behavioural exposure.
Liquid-asset bufferHold usable assets and test monetisationLiquidity protection has a cost and requires operational access.
Collateral preparationIdentify eligible assets and pre-position them where appropriateEligibility, settlement time and haircuts limit borrowing capacity.
Term fundingReduce reliance on daily renewalLonger funding may cost more or be unavailable in stress.
Contingency Funding Plan (CFP)Assign triggers, actions, owners, sequence and communicationA plan needs executable transactions and tested systems.
Internal funding chargesAllocate liquidity costs to products and business linesBad assumptions can encourage unstable funding or misleading profitability.

A contingency plan should show cash available today, actions possible within one day, and actions needing longer lead times. Distinguish committed from uncommitted facilities. State whether normal central bank access is included. Emergency assistance is not an unconditional funding promise.

Internal liquidity-transfer pricing can charge a long-dated illiquid loan for the stable funding and buffer it consumes. This makes business profitability reflect funding needs.

LEARNING SECTION 17

Early warnings, intraday liquidity and model controls

Key concept: A repricing gap measures interest-rate reset timing. A cash-flow gap measures actual payment timing.
Warning or controlWhat to monitor
Deposit behaviourLarge-account withdrawals, uninsured concentration and renewal patterns
Market fundingWider spreads, shorter offered tenors and declining lender limits
CollateralRising haircuts, more encumbrance and settlement failures
Customer drawdownsUse of undrawn commitments and contingent obligations
Intraday paymentsPeak cash needs, payment timing and available intraday credit
Model validationBacktest behavioural assumptions and compare projected flows with realised flows

Model risk arises when deposit stability, rollover, collateral access or asset-sale assumptions are wrong or misused. Test combined adverse changes rather than relying only on an average historical withdrawal rate.

Asset–Liability Management (ALM) also manages interest-rate risk. A repricing gap concerns when assets and liabilities reset their rates. A cash-flow gap concerns when cash is paid. A floating-rate loan may reprice tomorrow but repay principal years later, so those gaps are different.

ALCO reporting should show capital and liquidity effects together. Interest-rate hedges can reduce valuation risk but create collateral cash needs.

LEARNING SECTION 18

Interactive laboratories: liquidity costs and ratios

Use the two laboratories to reproduce the examples. Amounts are ₹ crore unless the field says price. Enter percentage numbers, so 15 means 15%. These are simplified teaching calculators.

Lab 1: portfolio-equivalent bid–ask exit cost

Defaults represent the ₹100 crore portfolio as an equivalent holding priced around ₹100 with a 0.51% full spread: bid ₹99.745 and ask ₹100.255. This reproduces ₹0.255 crore exit cost and ₹3.745 crore additive LVaR. For section 4, enter bid 99.50, ask 100.50 and value 50; its exit cost is ₹0.25 crore. Enter a VaR appropriate to that holding separately.

Lab 2: simplified liquidity ratios

Only Level 1 and Level 2A assets enter this calculator. It applies the simple 40% Level 2 composition limit without secured-transaction unwind adjustments. Inputs must already meet asset eligibility rules. The separate stable-funding inputs are weighted amounts.

LEARNING SECTION 19

Excel formulas and practice questions

Use the following cell map so every result updates when an input changes. Monetary values are ₹ crore. Enter the haircut as an Excel percentage.

CellInputBase value
B2 / B3Bid / ask99.745 / 100.255
B4 / B5Position value / market VaR100 / 3.49
B8 / B9 / B10Adjusted Level 1 / Level 2A market value / haircut900 / 300 / 15%
B11 / B12Gross outflows / eligible inflows1,400 / 400
B13 / B14Weighted ASF / weighted RSF9,200 / 7,340
Result cell and taskExcel formula
Midpoint, B6=AVERAGE(B2:B3)
Full proportional spread, B7=(B3-B2)/B6
One-way exit cost, B16=0.5*B7*B4
Additive LVaR, B17=B5+B16
Recognised Level 2A, B18=MIN(B9*(1-B10),B8*40%/(1-40%))
Adjusted HQLA, B19=B8+B18
Recognised inflows, B20=MIN(B12,75%*B11)
Net stressed outflows, B21=B11-B20
LCR, B22=IF(B21>0,B19/B21,NA())
NSFR, B23=IF(B14>0,B13/B14,NA())
Extra buffer to reach 100% LCR, B24=MAX(0,B21-B19)

For LCR stress, set B11 to 1,600 and B12 to 300: LCR becomes 88.85% and B24 becomes ₹145 crore. For NSFR stress, set B13 to 7,300: NSFR becomes 99.46%.

Format ratios as percentages with two decimals. The simplified 40% Level 2 cap is built into B18; secured-transaction unwind adjustments are outside this illustration.

Why does the example cost half the spread rather than the full spread?

The position starts marked at the midpoint and exits once at the bid. A round trip uses both sides under unchanged quotes.

Does a zero day-30 cumulative gap prove the bank survives?

No. Day 30 ends with balanced net flows, but the days 2–7 bucket shows cash of −₹50 crore after the opening buffer. Later inflows cannot pay earlier obligations without bridging funding.

Can 100% of expected inflows offset LCR outflows?

No. Recognised inflows are capped at 75% of gross outflows. With ₹400 crore outflows and ₹350 crore inflows, recognise only ₹300 crore; net outflows remain ₹100 crore.

How can the funding ratio deteriorate without balance-sheet growth?

Replacing ₹2,000 crore of stable retail funding (95% ASF) with funding assigned 0% removes ₹1,900 crore ASF. ASF falls from ₹9,200 crore to ₹7,300 crore, and NSFR falls from 125.34% to 99.46%, with RSF unchanged.

LEARNING SECTION 20

Sources and related reading

All numerical case amounts and stress shocks are hypothetical. Regulatory factors are identified and sourced separately.

Basel standards and national implementation can differ. Consult the current Reserve Bank of India directions for the bank’s regulatory classification, asset haircuts, deposit categories, concentration limits and reporting requirements.

Related guide: Financial Risk & Banking Stress Testing