π° Financial Models
Balance Sheet Analytics & ALM
Asset-Liability Management (ALM) is how banks ensure they can meet obligations (deposits, withdrawals, loans) while maximizing profitability. The ALCO (Asset Liability Committee) is the executive body that makes these decisions β typically meeting monthly. ModernFi's analytics product replaces the quarterly spreadsheets and batch reports with **real-time deposit composition, intraday flows, accounts at risk, and liquidity gap analysis**.
2
Minutes
3
Concepts
+15+30
Read+Quiz
1
How It Works
What Banks Track (and how they currently do it): Deposit Composition: βββ Core deposits (stable, relationship-driven, low rate β low "deposit beta") βββ Non-core deposits (rate-sensitive, likely to leave β high "deposit beta") βββ Uninsured deposits (>$250K, highest flight risk) βββ Concentration risk (% from top 10 depositors) βββ Surge balances (rate-chasers with significantly higher betas) 2023 shift: time deposits grew 42% YoY, reaching ~25% of total deposits (rate-chasing) Key Metrics: NIM (Net Interest Margin) = (Interest Income β Interest Expense) / Avg Earning Assets β Typical community bank NIM: 3.0β3.5% β Compressed NIM = funding cost problem = ModernFi's value prop Liquidity Gap = Assets maturing β Liabilities maturing (per time bucket) β Positive gap: more assets maturing than liabilities (reinvestment risk) β Negative gap: more liabilities maturing (funding risk) "Accounts at Risk" β banks lose ~15% of customers/year (5-10% is acceptable): β Low engagement scores = 20-30x greater chance of leaving β Top drivers: high fees, unattractive rates β ML models can reduce attrition by 7% in a single quarter How SVB Failed (ALM perspective): 1. 89% uninsured deposits (highest of any major bank vs ~40-50% industry avg) 2. $91.3B in HTM securities (44% of assets), $86B in MBS with 10+ year maturities 3. Had breached own internal IRR limits on and off since 2017 4. Rates rose β HTM portfolio had $15.1B unrealized losses (HTM accounting hid them) 5. March 8: announced $1.8B realized loss + $2B capital raise 6. March 9: $42B withdrawn in a single day β fastest bank run in history 7. March 10: seized by FDIC