MBA Finance Project Report on Asset-Liability Management Simulation for IRRBB

MBA Finance Project Report on Asset-Liability Management Simulation is a high-impact topic that blends risk analytics with practical balance sheet strategy. This article guides you to scope, model, validate, and present an Asset-Liability Management Simulation suitable for academic evaluation, with clear steps to defend methodology and results.

Project context: aligning ALM with IRRBB and liquidity goals

Asset-liability management aligns a financial institution’s assets and liabilities under changing interest rates and liquidity conditions. The study should explain how duration gap, liquidity gaps, and behavioral assumptions jointly influence net interest income (NII), economic value of equity (EVE), and regulatory buffers, providing a defensible framework for IRRBB assessment.

Precise objectives for an Asset-Liability Management Simulation

Your report should target measurable objectives that examiners can verify and discuss in viva:

• Quantify NII and EVE sensitivity to parallel and non-parallel yield curve shifts.
• Measure duration gap and convexity at portfolio and total balance sheet levels.
• Map liquidity gaps across time buckets and estimate survival horizons.
• Incorporate behavioral deposit modeling and prepayment for retail portfolios.
• Compare baseline versus stressed scenarios with back-testing where feasible.
• Recommend repricing, hedging, and term-structure adjustments informed by analytics.

Data foundation and time-bucket construction

Use anonymized or public datasets mirroring banking book positions: loan pools by tenor and rate type, securities by duration and coupon, deposits by maturity and behavior, wholesale funding, and equity. Clean for missing rates, inconsistent tenors, and outliers. Construct time buckets such as overnight, 1-7D, 8-30D, 31-90D, 91-180D, 181-365D, 1-3Y, 3-5Y, and 5Y+ to support gap tables and cash flow ladders.

Methodology that links gap analysis to a simulation engine

Build an ALM engine that connects repricing schedules, projected cash flows, and scenario curves. Combine static gap analysis with dynamic balance sheet evolution under policy rules so reinvestment and rollover effects enter NII and EVE projections coherently.

Core IRRBB metrics and practical formulas

Implement duration and convexity to estimate EVE impacts via present value shifts. Project NII sensitivity over a 12-month horizon using reset dates and deposit betas. Capture basis and curve risk via steepener, flattener, and pivot shocks that alter tenor-specific rates while preserving realism.

Liquidity profiling and funding structure

Perform contractual versus behavioral maturity mapping for non-maturity deposits, then generate gap tables by bucket and cumulative gaps focused on near-term liquidity coverage. Add contingent outflows from committed credit lines and stress multipliers where relevant.

Scenario design and sensitivity analysis

Design parallel shocks such as ±100 and ±200 bps and non-parallel twists to capture term-structure dynamics. Impose rate floors and pass-through limits for sticky deposits to reflect partial repricing. Combine rate and liquidity stress with funding spread widening to test resilience under composite shocks.

Behavioral assumptions and calibration

Document deposit beta ranges, decay rates for non-maturity deposits, prepayment speeds for mortgages, and credit spread add-ons for securities. Calibrate using historical evidence or literature benchmarks and justify with sensitivity bands that demonstrate stability of conclusions.

Computation flow and reproducibility practices

Create a transparent pipeline that supports audit and replication:

1. Ingest balance sheet snapshots and map positions to a standardized product taxonomy.
2. Generate cash flow ladders and repricing schedules per product.
3. Apply scenario yield curves and spread paths to discount and project cash flows.
4. Compute NII, EVE, duration gap, and liquidity gaps by scenario.
5. Run sensitivities on key behavioral parameters, including deposit betas and prepayments.
6. Produce dashboards and appendix tables to preserve an audit trail and versioned outputs.

Validation, challenger tests, and limited back-testing

Validate by reconciling to starting balances and checking that margin changes are reasonable against scenario shocks. Where data allow, conduct limited back-testing against historical quarters. Use challenger assumptions to identify model risk and report parameter elasticities to support robust conclusions.

Interpreting results into managerial levers

Synthesize how shocks influence earnings versus value, locate pockets of long or short duration, and spotlight liquidity buckets with elevated runoff risk. Translate findings into action themes such as repricing cadences, hedge overlays, liability terming, or adding floating-rate assets to rebalance exposure.

System architecture and modular project scope

Organize the build into distinct yet connected modules:

• Core IRRBB module: duration, convexity, NII/EVE sensitivity, and curve/basis views.
• Liquidity module: contractual and behavioral gaps with survival horizon estimation.
• Extensions: basis risk and multi-currency views via cross-currency assumptions.
• Reporting module: NII bridges, EVE by portfolio, and liquidity ladders for clear narration.

What you will learn by completing this study

Students gain hands-on proficiency with duration gap analysis and NII/EVE simulations, the ability to design defensible behavioral models for deposits and prepayments, and competence in scenario generation, sensitivity testing, and documentation. You will also refine communication skills to present ALM findings for decision-making and viva defense.

Suggested timeline and deliverables cadence

Week 1-2: Literature review and data schema. Week 3-4: Cash flow laddering and baseline. Week 5-6: Stress scenarios, parameter calibration, and validation. Week 7: Result synthesis and draft report with visuals. Week 8: Review, viva preparation, and final submission package.

Presentation structure and visuals that persuade examiners

Open with an executive summary of headline NII/EVE impacts under key shocks. Use heatmaps for duration concentrations and cumulative liquidity gaps. Provide waterfall charts for NII drivers split by volumes, spreads, and betas. Append detailed assumption tables and sensitivity matrices to anchor transparency.

Referencing credible sources for IRRBB practice

Anchor your methodology with recognized guidance on interest rate risk and liquidity risk. For definitions and practices on interest rate risk in the banking book, consult the Bank for International Settlements standard: BIS IRRBB framework.

FAQs on building an Asset-Liability Management Simulation

How detailed should behavioral deposit modeling be?

Start with tiered beta and decay assumptions by product, then test ranges. Add caps, floors, and seasonality only where data support them to avoid overfitting.

What tools are suitable for computation?

Excel with VBA or Python is effective. Prioritize transparent formulas, version control, and exportable tables to support auditability and viva discussion.

How many scenarios are sufficient for a strong defense?

Provide a baseline, at least two parallel shocks, one twist, and one combined rate-liquidity stress, plus parameter sensitivities on betas and prepayments.

Can hedging be included in recommendations?

Yes. Discuss interest rate swaps, caps, and balance sheet mix shifts, but separate analytical attribution from policy overlays to keep conclusions clear.

Further reading and related MBA finance projects

For broader examples of structure and documentation, explore the curated list in MBA Finance Project Reports. If you are evaluating margin dynamics, see the related study on banking net interest margin drivers for complementary perspectives.

Short enquiry and feedback

Need mentoring or a quick review of your ALM setup? Share your outline via Contact EmptyDoc to request academic guidance and feedback.

Conclusion: unifying analytics in an Asset-Liability Management Simulation

An Asset-Liability Management Simulation equips you to connect duration gap, NII/EVE sensitivity, and liquidity resilience into a coherent, defensible study. By documenting assumptions, calibrating behaviors, and testing scenarios rigorously, you present a practical framework that stands up to examiner scrutiny and supports clear, action-oriented insights.