Interest Income Modelling
Executive Summary
Key Takeaways
- ✓ Interest income and expense should be built from forecast asset and liability volumes multiplied by their own segment-level yield or cost assumptions, not from a single blended average balance and rate applied to the whole book.
- ✓ Net interest income is the direct output of the interest income and expense build, and net interest margin annualizes that figure against average earning assets to produce the single most-watched bank profitability measure.
- ✓ The net interest margin bridge should be built as an explicit volume/rate/mix decomposition of the period-over-period change, not left as an implicit consequence of the balance sheet forecast that would require manual reconstruction to explain.
- ✓ Using average balances, not point-in-time period-end balances, to calculate yields and margins avoids materially distorting the result when volumes change significantly within the period.
- ✓ Segment-level granularity in the interest income build (by loan type, deposit type, and funding source) is what makes the volume/rate/mix bridge meaningful, since a single blended balance collapses the very effects the bridge is meant to isolate.
Objective¶
This guide covers how to build interest income and expense, and the resulting net interest margin bridge, within the Banking Financial Modelling pillar — the mechanical core that Banking Business Model identifies as the primary driver of a bank's earnings.
Building the Interest Income and Expense Schedule¶
Interest income and expense should be built at a segment level — by loan type on the asset side, by deposit and funding type on the liability side — with each segment carrying its own volume (average balance) and yield or cost assumption. The segment-level income or expense is the product of the two; totals are then summed across segments.
Segment Interest Income = Average Segment Balance × Segment Yield
Segment Interest Expense = Average Segment Balance × Segment Cost
Total Interest Income = Σ (Asset Segment Interest Income)
Total Interest Expense = Σ (Liability Segment Interest Expense)
Net Interest Income = Total Interest Income – Total Interest Expense
Use average balances, not period-end balances, for this calculation. A loan book that grows materially within a period will understate the true interest earned if yield is applied only to the closing balance; a simple average of opening and closing balances (or a daily average where the underlying data supports it) is standard practice.
The Net Interest Margin Bridge¶
The period-over-period change in net interest margin should be built as its own explicit module, decomposing the change into three effects:
| Effect | What It Isolates | Calculation Approach |
|---|---|---|
| Volume effect | Change in margin from a change in the size of earning assets/funding liabilities, holding rates and mix constant | Prior-period rate applied to the change in balance |
| Rate effect | Change in margin from a change in yields or costs, holding volume and mix constant | Change in rate applied to the current-period balance |
| Mix effect | Change in margin from a shift in the proportion of higher- versus lower-yielding segments | Residual, or calculated directly from the change in segment weighting |
Building this as a labelled, structured output — rather than leaving it as something a reader would have to reverse-engineer from the balance sheet and rate assumptions — is what makes a NIM forecast reviewable and defensible to a credit committee or board.
Segmentation Requirements¶
The bridge is only as meaningful as the segmentation underneath it. A single blended asset balance and yield collapses the very volume, rate, and mix effects the bridge exists to isolate. The interest income build should therefore draw its volumes directly from the segmented balances produced by Loan Portfolio Modelling and Deposit Modelling, not from a separately maintained set of balance assumptions that could silently diverge from those modules.
Common Construction Pitfalls¶
- Applying a single blended yield to the entire loan book, rather than segment-level yields that let the mix effect actually be calculated.
- Using period-end rather than average balances, materially distorting the yield calculation in a period with significant balance growth or shrinkage.
- Leaving the net interest margin bridge unbuilt, so any explanation of a margin movement has to be manually reconstructed after the fact.
- Maintaining separate volume assumptions in the interest income schedule from those used in the loan portfolio and deposit modelling modules, allowing the two to silently diverge.
Continue Reading¶
Prerequisites¶
- Banking Financial Modelling — the parent pillar
- Banking Business Model
Related Technical Guides¶
Related Glossary¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
How should interest income and expense be built in a bank model?
From forecast asset and liability volumes, each segmented by product type, multiplied by their own segment-level yield or cost assumption — not a single blended average balance and rate applied to the whole loan or deposit book.
Why use average balances rather than period-end balances for yield calculations?
Because yields and margins calculated against a period-end balance can be materially distorted when volumes change significantly within the period — an average balance (commonly a simple average of opening and closing, or a daily average where data supports it) gives a more representative yield.
What is the net interest margin bridge, and why build it explicitly?
A structured decomposition of the period-over-period change in net interest margin into volume effects (balance growth or shrinkage), rate effects (yield or cost changes), and mix effects (a shift in the proportion of higher- versus lower-yielding segments). Building it explicitly, rather than leaving it implicit in the balance sheet forecast, makes the driver of any period's result immediately explainable without manual reconstruction.
What level of segmentation does the interest income build need?
Enough granularity — by loan type, deposit type, and funding source — that the volume/rate/mix bridge is meaningful. A single blended asset balance and yield collapses exactly the effects the bridge exists to isolate.
How does this guide relate to Net Interest Margin and Net Interest Income?
This guide covers how to build the mechanics that produce those two figures; the glossary pages for Net Interest Margin and Net Interest Income define the metrics themselves and their standard calculation formulas.
Does the interest income build need to reconcile to the loan and deposit modelling modules?
Yes — the volumes used in the interest income build should be the same segmented balances produced by the loan portfolio and deposit modelling modules, not a separately maintained set of balance assumptions, to avoid the two parts of the model silently diverging.
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.
Banking Business Model
A bank does not sell a product for a price; it intermediates funds, earning a spread between what it charges borrowers and what it pays depositors and wholesale funders, augmented by fee and commission income from services that do not consume balance-sheet capacity. This guide explains how that economic model translates into financial model architecture: why the balance sheet — not a revenue line — is the model's primary driver, how the spread business and the fee business should be modelled as two distinct income streams, and how this shapes the sequencing of every other module in the model.
Net Interest Income
Net interest income (NII) is the difference between total interest income earned on assets and total interest expense paid on liabilities, and it is the primary revenue line for most banks. Unlike a standard corporate revenue line, NII is not a standalone assumption but a derived output of the balance sheet forecast — a function of asset and liability volumes and the yields and costs applied to them.
Net Interest Margin
Net interest margin (NIM) expresses net interest income as a percentage of average earning assets, making it comparable across periods and between institutions of different sizes in a way that a raw net interest income figure is not. It is the single most-watched profitability metric for a bank, and its period-over-period movement is typically decomposed into volume, rate, and mix effects through a net interest margin bridge.
Net Interest Spread
Net interest spread compares the average yield a bank earns on its interest-earning assets to the average cost it pays on its interest-bearing liabilities. It is closely related to, but distinct from, net interest margin: spread is a simple comparison of two average rates, while margin weights net interest income against average earning assets and therefore also reflects how much of the balance sheet is funded by non-interest-bearing sources.
Loan Portfolio Modelling
Loan portfolio modelling is the asset-side counterpart to deposit modelling: the loan book should be segmented by product type, risk grade, or business line, each carrying its own origination, repayment, yield, and expected loss assumptions. This guide covers how to structure that segmentation, how to roll forward segment-level balances period over period, and how the segmented output feeds both the interest income build and credit loss provisioning.
Deposit Modelling
Deposit modelling is the liability-side counterpart to loan portfolio modelling: deposits should be segmented by product type — transactional, savings, and term — each carrying its own volume, cost, and behavioural assumptions. Behavioural modelling matters more on the deposit side than almost anywhere else in a bank model, since a deposit's contractual maturity (or lack of one, for transactional accounts) frequently does not match its actual behavioural stickiness, and that gap is central to both funding and liquidity risk management.
Bank Financial Statements
A bank's three financial statements carry a different structure and internal logic from a standard corporate three-statement model. The balance sheet is the primary earnings driver rather than a supporting schedule; the income statement separates net interest income from fee and other income and shows loan loss provisions as their own distinct line ahead of non-interest expense; and the cash flow statement requires bank-specific adjustments that a corporate model's indirect method does not anticipate. This guide sets out each statement's bank-specific structure and how the three connect.