Bank Financial Model Template
Executive Summary
Key Takeaways
- ✓ The template separates the segmented balance sheet forecast, interest income and NIM bridge, credit loss provisioning, and capital adequacy block into distinct, formula-driven modules, with capital ratios calculated live rather than entered as static figures.
- ✓ Loan and deposit volumes are segmented by product type from the outset, so the interest income build and credit loss provisioning can reference the same underlying segment detail rather than maintaining separate, potentially inconsistent balance assumptions.
- ✓ The net interest margin bridge decomposes period-over-period change into volume, rate, and mix effects as its own explicit block, not an implicit consequence of the balance sheet forecast.
- ✓ Capital ratios are calculated as live formulas referencing the model's own capital and risk-weighted asset build, so any change to the balance sheet forecast immediately flows through to the reported ratios.
- ✓ This is a structural template for how to organize a bank model, not a source of specific volume, yield, cost, or loss-rate assumptions — every figure must be sourced and justified for the specific institution being modelled.
Purpose¶
This template sets out how a bank financial model should be structured as a standalone, auditable schedule, following the build methodology in this domain's Wave 1 and Wave 2 technical guides. It is a structural template — it does not provide specific volume, yield, cost, or loss-rate assumptions, which must be sourced and justified for each institution.
Template Structure¶
Section 1 — Segmented Balance Sheet Forecast
| Line | Value | Notes |
|---|---|---|
| Loan segments (by product type/risk grade) | [input, average balance per segment, per period] | See Loan Portfolio Modelling |
| Deposit segments (by product type) | [input, average balance per segment, per period] | See Deposit Modelling |
| Funding plan (wholesale funding closing the gap) | = calculated (Asset Growth − Deposit Growth) |
Named, not a balancing plug — see Balance Sheet Forecasting |
Section 2 — Interest Income and NIM Bridge
| Line | Value | Notes |
|---|---|---|
| Segment interest income/expense | = Average Segment Balance × Segment Yield/Cost |
See Interest Income Modelling |
| Net interest income | = Total Interest Income − Total Interest Expense |
|
| NIM bridge (volume/rate/mix) | = calculated decomposition |
Explicit block, not implicit |
Section 3 — Credit Loss Provisioning
| Line | Value | Notes |
|---|---|---|
| Segment provision charge | = Segment Loan Balance × Segment Loss Rate |
See Credit Loss Provisions |
| Allowance roll-forward | = Opening + Provision − Write-Offs + Recoveries |
Section 4 — Capital Adequacy
Risk-Weighted Assets = Σ (Segment Exposure × Segment Risk Weight)
CET1 Ratio = CET1 Capital ÷ Risk-Weighted Assets
Capital ratios should always be live formulas referencing the capital tier build and risk-weighted asset calculation, never a static value reconciled separately — see Capital Adequacy Models.
How to Use This Template¶
Populate the segmented balance sheet forecast first, from loan and deposit volume assumptions by product type, then build the interest income schedule and NIM bridge referencing those same segments directly. Build credit loss provisioning from the same loan segments, rolling the allowance forward explicitly. Calculate risk-weighted assets and capital ratios as live outputs of the capital tier build and the balance sheet forecast, so any change in growth assumptions flows through automatically.
This structure directly supports the checks in the Bank Capital Adequacy Checklist, particularly the requirement that capital ratios be calculated live rather than as a separately maintained figure.
Common Pitfalls¶
Modelling loans and deposits as single blended balances rather than segmenting from the outset, which collapses the detail the NIM bridge and credit loss provisioning both depend on.
Leaving the funding plan as an unexplained balancing plug rather than a named, explicit wholesale funding assumption.
Calculating NIM without the volume/rate/mix bridge, leaving any margin change unexplained.
Maintaining capital ratios as a separate, static calculation reconciled only periodically to the balance sheet forecast, rather than as live formulas.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Checklists¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Does this template provide specific volume, rate, or loss-rate assumptions?
No. This is a structural template for organizing a bank model — every segment volume, yield, cost, and loss-rate assumption must be sourced and justified for the specific institution being modelled, following the guidance in this domain's technical guides.
Why does the template segment loans and deposits from the outset?
So the interest income build, credit loss provisioning, and liquidity metrics can all reference the same underlying segment-level balances, rather than each module maintaining its own separate set of volume assumptions that could silently diverge from one another.
How does the template handle the net interest margin bridge?
As its own explicit block, decomposing the period-over-period change in margin into volume, rate, and mix effects, referencing the segmented balance sheet directly rather than calculating NIM as a single output with no visible decomposition of what drove its change.
How are capital ratios calculated in this template?
As live formulas referencing the model's own capital tier build and risk-weighted asset calculation, so that any change to the balance sheet forecast's growth assumptions immediately flows through to the reported capital ratios, rather than requiring a separate, manual reconciliation.
Can this template be adapted for a specific institution type covered elsewhere in this domain?
Yes — the base structure applies generally, and the segment definitions, fee income lines, and additional modules (technical reserves for an insurer, AUM roll-forward for an asset manager) should be adapted per the relevant institution-type technical guide.
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.
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.
Interest Income Modelling
Interest income modelling is the core mechanic of a bank financial model: interest income and expense are derived from forecast asset and liability volumes and their associated yields and costs, not from a standalone revenue assumption. This guide covers how to structure that build at a segment-by-segment level, how net interest income and net interest margin are calculated from it, and how to construct the net interest margin bridge that separates a period's margin change into volume, rate, and mix effects — the single most useful diagnostic output in a bank model.
Credit Loss Provisions
Credit loss provisioning is the income statement charge that builds up the allowance for credit losses held against a bank's loan portfolio. Provisions should be derived from portfolio-segment loss-rate assumptions applied to segmented loan balances — not a single blended provisioning rate applied to the total book — since default risk varies substantially by product type and risk grade. This guide covers how to structure that segment-level provisioning build and how it connects to the allowance roll-forward on the balance sheet.
Capital Adequacy Models
Capital adequacy modelling represents the constraint regulatory capital requirements place on how much risk-weighted balance sheet a bank can carry against its available capital base. This guide covers how to structure a capital adequacy model — the capital tiers, the risk-weighted asset base they are measured against, minimum ratio and buffer requirements — and how it should be built as a live check against the balance sheet forecast rather than a standalone reporting exercise calculated after the forecast is already complete.
Bank Capital Adequacy Checklist
This checklist covers the structural construction of a bank model's capital adequacy build, from capital tier segmentation and deductions through risk-weighted asset calculation, minimum ratio and buffer thresholds, and the live connection between the balance sheet forecast and the resulting capital ratios. It is a construction-discipline checklist, distinct from validating whether any specific regulatory capital calculation itself is correct.