Building an ILAAP in Excel
Construct a production-grade Internal Liquidity Adequacy Assessment Process model from scratch. Master contractual gap schedules, behavioral deposit overlays, dynamic stress testing engines, and regulatory counterbalancing capacity in Excel.
Like Duolingo, but for Building an ILAAP in Excel. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
24 levels across 4 sections, about 48 minutes end to end, roughly 10 days at five minutes a day. It moves through The Core Liquidity Ledger, Stress Testing and Rupture Mechanics, Counterbalancing and Survival Horizons, and Enterprise Integration and Regulatory Alignment.
Free forever · No credit card · iPhone & Android
Key ideas in Building an ILAAP in Excel
- Monthly time buckets lump aggregate inflows at month-end against front-loaded outflows (e.g., wholesale maturities on Day 11 vs deposit roll on Day 30), masking cliff-edge deficits.
- Daily time-series vectors across the 1-90 day horizon pinpoint intraweek settlement asymmetries and specific liquidity drain inflection dates that monthly bucket averages net out.
- Regulatory reporting intervals (like LCR reporting) rely on aggregate 30-day horizons, which hide intraday and multi-day buffer depletion events that cause technical default in an ILAAP framework.
- Contractual principal repayments must roll off at par and replenish the liquid asset buffer or fund liabilities without rate sensitivity, whereas coupon flows vary directly with interest rate benchmark vectors in floating-rate books.
- Blending coupon and principal makes it impossible to apply behavioral reinvestment rate curves or liquidity haircuts independently to yields versus redeemed principal capital.
- Under steepening or inverted yield curves, decoupling principal amortizations from interest cash flows prevents the ILAAP model from overestimating liquidity generated by interest cash flows whose base rates drop.
- Pure contractual cash flows must be modeled as a frozen, independent baseline array using functions like SCAN or dynamic SUMPRODUCT prior to any dynamic liquidity action.
- Contractual gaps must be calculated as a pure unmitigated deficit series first; mitigation layers (commercial paper rollover, repo facilities, central bank collateral drawing) are then evaluated sequentially as overlay vectors.
- Directly linking deficit-triggered borrowing back into the closing cash position in the same vector creates a circular iteration loop that crashes large multi-scenario Excel workbooks.
- Unconditionally revocable lines can be legally cancelled without notice, but contractual modeling must reflect practical notification periods and counterparty reputational contagion.
- Financial counterparty facilities exhibit severe step-function liquidity drawdowns under stress compared to retail commitments, requiring separate vector partitioning.
- Gross currency-specific contractual cash flows must be tracked in autonomous sub-ledgers (e.g., USD, EUR, GBP) without pre-converting net positions, preserving the currency-specific gross deficit.
- Cross-currency swap maturities must explicitly map gross leg exchanges (e.g., outflow of foreign currency and inflow of domestic currency) rather than net mark-to-market valuations.
- A dynamic FX translation matrix must link to stress rate vectors to demonstrate that liquid assets held in domestic currency may suffer translation haircuts when deployed to cover foreign-denominated contractual holes during FX market illiquidity.
- Replicating portfolio models in Excel isolate the volatile layer of NMDs to absorb immediate liquidity outflows in the Day 1 bucket
- Operational core deposits exhibit behavioral stickiness due to clearing and cash management integration, justifying extended synthetic maturities
You've tried the other tabs
Thirty open tabs. Four facts you actually kept.
You watched. You nodded. By Sunday it was gone.
One answer, then back to scrolling.
Eight weeks. You meant to finish. You didn't.
Tomo gives Building an ILAAP in Excel the Duolingo treatment: levels, streaks, and quick quizzes that test what you just learned. That game loop is what the tabs above never had, so it's the one you actually finish.
Here's what playing it feels like
A real question from this course. Take your best guess.
Why does an ILAAP model use daily time-series vectors across the first 90 days rather than monthly averages?
Get it right to open this lesson and 23 more in the app.
Where Building an ILAAP in Excel takes you
- 1
The Core Liquidity Ledger
- Contractual Cash Flow Architecture
- Behavioral Overlays and Non-Maturing Balances
- 2
Stress Testing and Rupture Mechanics
- Multi-Horizon Stress Scenario Engines
- Reverse Stress Testing in Excel
- 3
Counterbalancing and Survival Horizons
- Counterbalancing Capacity and Asset Monetization
- Survival Horizons and Early Warning Dashboards
- 4
Enterprise Integration and Regulatory Alignment
- Regulatory Metric Reconciliation: LCR and NSFR
- Funds Transfer Pricing and Supervisory Defense
4 sections · 8 units · 24 levels. Built to play, not to enroll.
You pick the voice
Building an ILAAP in Excel is taught in the The Professor style: clear, structured, thorough. Want a different feel? In the app you can spin up the same topic in any of Tomo's teaching styles. Same facts, totally different vibe.
More Business on Tomo
Startup Mechanics: Idea to Revenue
Bridge the gap between having an idea and building a repeatable, revenue-generating business. Master behavioral demand validation, value-based pricing, early traction channels, and realistic unit economics.
Applied Equity Valuation and Financial Modeling
Bridge the gap between accounting mechanics and institutional-grade equity research. Learn to build resilient DCF models, expose hidden cash flow distortions, and uncover mispriced securities through rigorous valuation engineering.
Starting a Business from Scratch
Learn how to turn an initial idea into a working, profitable company. Discover how to test demand before spending money, win your first paying customers, manage cash flow, and avoid critical early founder mistakes.
Product Strategy, Metrics, and Economics
Sharpen your product leadership with rigorous unit economics, counter-intuitive experimentation mechanics, and post-mortems of high-stakes failures. Master the metrics, trade-offs, and capital allocation frameworks that separate senior product operators from feature managers.
How Business Actually Works
Learn the foundational mechanics of starting and running a business without falling into classic first-timer traps. Discover how to test demand, talk to customers honestly, read your real numbers, and fix sales problems before they cost you.
Building Profitable Businesses
Move beyond basic accounting to master the strategic levers of profitability, cash flow management, and scalable growth. Learn to build a business that generates real wealth through disciplined financial engineering and market positioning.
Start Building an ILAAP in Excel today.
Download Tomo, search Building an ILAAP in Excel, and play your first lesson in under a minute.