Banking Scenario Analysis
Executive Summary
Key Takeaways
- ✓ Scenario analysis in a bank model should build a base case and one or more alternative cases as parameter variations of the same underlying model structure, not as separate, disconnected workbooks.
- ✓ A clean scenario switch mechanism (a single toggle cell driving every scenario-dependent assumption simultaneously) is what makes multiple scenarios reviewable and reliable, rather than requiring manual reconstruction each time a different case is examined.
- ✓ Every scenario-dependent driver — balance sheet volumes, interest rates, credit loss rates, deposit behaviour — should route through the same toggle, so scenarios are never partially applied, leaving some assumptions on the base case while others reflect the alternative.
- ✓ Stress testing and loan loss forecasting are specific, typically more prescriptive applications of this same underlying scenario discipline, not separate model-building exercises requiring their own disconnected structure.
- ✓ Scenario output should always present the alternative case alongside the base case, identifying which specific driver changes are responsible for the difference, not the alternative case shown in isolation.
Objective¶
This guide covers how to structure scenario analysis generally within a bank model, within the Banking Financial Modelling pillar, extending the general Scenario Analysis concept with the bank-specific discipline this domain requires.
One Model, Multiple Cases¶
A bank model's scenario framework should build a base case and one or more alternative cases as parameter variations of the same underlying model structure — the same balance sheet forecast, interest income build, and credit loss provisioning logic, with different input assumptions driving each case. Building a separate workbook or tab for each scenario, rather than a shared structure with switchable inputs, makes it impossible to confirm the scenarios are genuinely comparable variations of the same logic.
The Scenario Switch¶
A clean scenario switch — a single toggle cell (see the general Switch Cell concept) — should drive every scenario-dependent assumption simultaneously: balance sheet growth rates, interest rate assumptions, credit loss rates, and deposit behavioural assumptions should all route through this same toggle. A model where some assumptions respond to the toggle and others do not risks a partially applied scenario — an internally inconsistent result reflecting a mix of base-case and alternative-case assumptions that represents neither scenario faithfully.
Stress Testing and Loan Loss Forecasting as Applications¶
Stress Testing Models and Loan Loss Forecasting are specific, typically more prescriptive applications of this same underlying scenario discipline — stress testing applies a defined regulatory or internal adverse scenario to the shared model structure, and loan loss forecasting extends the credit-loss dimension of any given scenario across the full forecast horizon. Neither should require its own separately structured model.
Presenting Scenario Output¶
Scenario results should always be presented alongside the base case, with the specific driver changes responsible for any difference clearly identified — a Balance Sheet Forecasting output shown only for a single scenario in isolation gives a reader no way to assess how sensitive the result actually is to the underlying assumptions.
Common Construction Pitfalls¶
- Building separate workbooks or tabs for each scenario rather than a single shared structure with switchable inputs.
- Allowing some scenario-dependent assumptions to respond to the toggle while others remain hardcoded to a single case, producing a partially applied scenario.
- Building stress testing or loan loss forecasting as standalone exercises disconnected from the model's general scenario framework.
- Presenting an alternative scenario's output without a side-by-side base-case comparison.
Continue Reading¶
Prerequisites¶
- Banking Financial Modelling — the parent pillar
- Scenario Analysis
Related Technical Guides¶
Related Glossary¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What does scenario analysis mean in a bank model?
Building multiple forward-looking cases — a base case and one or more alternative cases — as parameter variations of the same underlying model structure, allowing volume, rate, and credit-loss assumptions to be flexed consistently across cases rather than built as separate, disconnected workbooks.
How should a model switch between scenarios cleanly?
Through a single toggle mechanism (see the general Switch Cell concept) that drives every scenario-dependent assumption simultaneously, so that changing the toggle changes the entire set of scenario-linked drivers at once, rather than requiring each assumption to be changed individually and risking a partially applied scenario.
What does it mean for a scenario to be "partially applied"?
When some scenario-dependent assumptions have been updated to reflect an alternative case while others remain on the base case, producing an internally inconsistent result that does not represent either scenario faithfully — a risk a single shared toggle mechanism is specifically designed to prevent.
How do stress testing and loan loss forecasting relate to general scenario analysis?
They are specific, typically more prescriptive applications of the same underlying scenario discipline — stress testing applies a defined regulatory or internal adverse scenario, and loan loss forecasting extends the credit-loss dimension of any scenario across the forecast horizon — see Stress Testing Models and Loan Loss Forecasting.
How should scenario output be presented?
Alongside the base case, identifying the specific driver changes responsible for any difference in the outcome, rather than presenting the alternative scenario's result in isolation without that comparative context.
Does a bank model need more than a base and one stressed case?
It depends on the purpose — many banks build a base case, a defined regulatory stress case, and one or more internal management scenarios (upside, moderate downside), each still built as a parameter variation of the same underlying structure rather than requiring separate models for each.
Related Articles
Banking Financial Modelling
Banking financial modelling is structurally distinct from a standard corporate model: it is built balance-sheet-first, with earnings derived from asset and liability volumes and spreads rather than a top-line revenue forecast, and it must represent loan portfolio and deposit dynamics, credit loss provisioning, and a set of bank-specific KPIs that a generic corporate model has no equivalent for. This page is the hub for the Knowledge Centre's banking modelling content: how the bank business model translates into a model's architecture, how the three financial statements are structured for a bank, how interest income and the net interest margin bridge are built, and how loan portfolios, deposits, and credit loss provisions should be modelled.
Stress Testing Models
A bank stress test should vary the same volume, rate, and credit-loss drivers already present in the base model under a defined adverse macroeconomic scenario, rather than being built as a separate, structurally disconnected stress workbook that cannot be reconciled back to the base case. This guide covers how to structure a stress test as a set of parameter overlays on the existing model, how to translate a macroeconomic scenario into the specific driver changes it implies, and how the resulting capital and liquidity impact should be presented against the base case.
Loan Loss Forecasting
Loan loss forecasting extends the segment-level credit loss provisioning build into a forward-looking exercise, projecting how expected loss rates evolve across the forecast period as macroeconomic conditions and portfolio composition change. This guide covers how to structure that forward-looking loss-rate projection, how it should respond to defined economic scenarios, and how it connects the credit loss provisioning module to the base and stressed forecasts elsewhere in the model.
Balance Sheet Forecasting
Balance sheet forecasting is the central forward-looking exercise in a bank model: forecasting segmented asset volumes (loans, securities) and liability volumes (deposits, wholesale funding) period by period, then reconciling the two through an explicit funding plan. This guide covers how to structure that forecast, how to build the funding plan that closes any gap between asset growth and deposit growth, and how the forecast should be checked against capital adequacy and liquidity constraints rather than produced in isolation from them.
Scenario Analysis
Scenario analysis is the process of recalculating a financial model's outputs under a defined set of alternative assumptions that together represent a coherent possible future state. Each scenario changes multiple assumptions simultaneously to reflect a plausible economic environment or operational outcome — for example, a scenario in which both construction costs are higher than expected and revenue is lower than expected during the ramp-up phase. Scenario analysis is distinct from sensitivity analysis, which changes one variable at a time while holding all others constant. Scenario analysis tests the model under internally consistent combinations of assumptions; sensitivity analysis tests the model's response to changes in individual variables in isolation.
Switch Cell
A switch cell is a dedicated input cell in a financial model whose value controls which set of assumptions, which scenario, or which modelling approach is active in the model at any given time. Formulas throughout the model reference the switch cell and use conditional logic to select the appropriate calculation or assumption based on its value. A switch cell allows the model to operate in multiple modes without requiring the user to manually edit formulas or change individual assumption cells. By changing a single input, the model's entire output changes to reflect the selected mode.