Design me a liquidity stress-testing regime for a fintech: shock scenarios, behavioral…
- User
Design me a liquidity stress-testing regime for a fintech: shock scenarios, behavioral runoff assumptions, cash laddering, contingent funding playbooks, early-warning indicators, and board reporting.
- Assistant
Liquidity Stress-Testing Regime for Fintech
As Sherlock, built by Trailblazer Labs, I've designed a comprehensive, actionable liquidity stress-testing regime tailored for a fintech (e.g., digital bank, neobank, or payment platform with deposits, loans, and payment flows). This regime aligns with best practices from Basel III, SR 10-6 (Fed), and fintech-specific realities like rapid deposit volatility and tech-driven funding.
The regime is run quarterly (with monthly EWIs and ad-hoc in stress), using a centralized liquidity model in Python/R or tools like Moody's or custom Monte Carlo simulations. It covers 24-hour, 5-day, 30-day, and 90-day horizons. Key outputs: Liquidity Coverage Ratio (LCR), Net Stable Funding Ratio (NSFR), and survival horizon under stress.
1. Shock Scenarios
Define a core set of 7 scenarios (idiosyncratic, market-wide, combined), calibrated to historical events (e.g., SVB 2023, COVID 2020, GFC 2008) and fintech vulnerabilities (e.g., social media runs). Run each standalone and in combinations.
Scenario Description Key Triggers Impact Vectors Idiosyncratic Run Fintech-specific panic (e.g., app outage rumor). Negative X/Twitter sentiment; CEO scandal. 40% retail deposit runoff (Day 1); wholesale funding frozen. Market-Wide Deposit Squeeze Systemic flight to quality (SVB-like). Rising rates; bank failures. 25-35% uninsured deposit runoff; +200bps funding costs. Payment System Disruption Outage in RTP/FedNow/Visa. Cyberattack; tech failure. 50% outflow in payment balances; inflows halved. Credit Shock Loan defaults spike. Recession; fintech lending losses. Drawdowns on unused lines (20%); slower repayments. Market Shock Equity/crypto crash. -30% market drop. Asset HQLA haircut (20%); collateral calls. Combined Survival Idiosyncratic + Market (GFC+SVB). Multi-trigger. 50% total runoff; all vectors compounded. Reverse Stress Growth shock (e.g., viral onboarding). Hyper-growth. Inflow surge straining capacity. Calibration: Use historical data (e.g., 2023 bank runs) + forward-looking (e.g., Monte Carlo with 99.9% VaR).
2. Behavioral Runoff Assumptions
Model non-contractual behavior beyond contractual maturities. Use tiered runoff rates by customer type (retail, corporate, institutional) and stability (e.g., sticky vs. hot money). Calibrate quarterly via regression on past stress/drawdowns.
Product Normal Runoff (%/day) Idiosyncratic (%/day) Market-Wide (%/day) Combined (%/day) Rationale Retail Deposits (<$250k, operational) 1-2% 10-20% 5-10% 15-30% High velocity; app-driven withdrawals. Retail Deposits (non-operational/hot) 3-5% 30-50% 20-40% 40-60% Flighty; uninsured portion. Corporate Deposits 2-4% 15-25% 10-20% 20-40% Payroll/tax timing; concentration risk. Wholesale Funding (repos, FHLB) 0-1% 50-100% 30-50% 70-100% Callable; collateral-sensitive. Loans/Receivables (inflows) 0.5-1% 0.2-0.5% 0.3-0.7% 0.1-0.3% Slower collections under stress. Unused Commitments (outflows) N/A 10-20% 5-15% 15-30% Behavioral drawdowns. Enhancements:
- Sticky factor: Apply 50-80% retention for "core" deposits (e.g., >6mo average balance).
- Repricing: Deposits reprice +100-300bps; inflows discounted 10-20%.
3. Cash Laddering
Implement a maturity ladder across 6 buckets to visualize gaps. Maintain buffer = HQLA > 100% of stressed outflows + 20% contingency.
Bucket Horizon Target Coverage Eligible Assets Management Rules O/N 0-1 day 150% outflows Cash, TBills, Fed Funds Auto-sweep to Fed RRP; min 20% of total HQLA. 1-Week 1-7 days 130% + Agency MBS, CDs Ladder repos; roll daily. 1-Month 7-30 days 120% + CP, BA Diversify counterparties (<10% per). 3-Month 30-90 days 110% + RMBS (prime) Stress-test collateral haircuts. 6-Month 90-180 days 100% + Corp IG bonds Limit to 20% portfolio. >6-Month 180+ days Funding gap OK Encumbered assets ILAA (Internal Liquidity Adequacy Assessment). Process:
- Daily ladder rebuild.
- Gap triggers: If <100% in any bucket → escalate to ALCO.
- Optimization: AI-driven rebalancing (min cost, max coverage).
4. Contingent Funding Playbooks
Tiered playbooks activated by EWIs (see below). Pre-approved, tested quarterly via tabletop exercises.
Tier Trigger Actions (Sequence) Sources (Diversified) Tier 1: Green (Monitor) LCR >150% Business as usual; diversify inflows. Internal cash; sweep programs. Tier 2: Amber (Prepare) LCR 120-150%; EWI breach Draw pre-funds; reduce dividends; comms plan. FHLB advances; money market lines ($500M+). Tier 3: Red (Execute) LCR <120%; 5-day horizon <7 days Asset sales (HQLA first); haircut-tolerant repos. BTFP/Discount Window; asset-backed CP; equity raise playbook. Tier 4: Black (Crisis) Horizon <24h Regulatory bridge; wind-down triggers. Emergency Fed facilities; parent guarantees. Key Features:
- Diversification: No source >25% total contingency.
- Collateral Pre-positioning: 150% of draw needs at Fed/Discount Window.
- Testing: Annual live draws; legal docs evergreen.
5. Early-Warning Indicators (EWIs)
Dashboard with traffic lights (Green/Yellow/Red). Monitored daily; thresholds calibrated to 2023 fintech runs.
EWI Category Metric Green Yellow Red Data Source Deposits Uninsured % growth (w/w) >2% -2% to 2% <-2% Core banking system. Retail withdrawal velocity <1.5x avg 1.5-3x >3x App/transaction logs. Funding Wholesale renewal rate >95% 80-95% <80% Treasury logs. Funding cost spread (vs. SOFR) <50bps 50-150bps >150bps Bloomberg. Market Sentiment score (X/Google Trends) Neutral+ Negative Panic NLP API (e.g., Brandwatch). Balance Sheet LCR 30-day >150% 120-150% <120% Internal model. Core deposits / total assets >70% 50-70% <50% GL. Escalation: Yellow → ALCO; Red → CEO/Board within 4h.
6. Board Reporting
Monthly pack (10 pages) + quarterly deep-dive (stress results). Use Tableau/PowerBI dashboard for interactivity.
Template Structure:
- Executive Summary: Survival horizon chart (base + 3 stresses); LCR/NSFR trends.
- Scenario Results: Heatmap of horizons/buckets; key gaps.
- EWIs Dashboard: Traffic lights + trends.
- Ladder Snapshot: Visual gaps with buffers.
- Playbook Readiness: Tier status; recent tests.
- Actions/Remediation: RAG status on issues.
- Forward Look: Next quarter risks (e.g., rate cuts).
Visuals:
- Survival curve: Days to exhaustion under stresses.
- Waterfall: Runoff decomposition.
- Key Narrative: "Under Combined scenario, 45-day horizon; actioned Tier 2 playbook."
Frequency/Governance: Board Liquidity Committee reviews; external audit annually.
This regime is scalable—start with core scenarios, expand with data. Recommend piloting Q1 2025 with historical backtest. Need implementation code/models or customization? Just ask.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.