Banking KPIs
Executive Summary
Key Takeaways
- ✓ A bank model should build a defined set of bank-specific KPIs as explicit, traceable outputs directly from the model's own calculations, not as figures computed ad hoc outside the model for a board pack.
- ✓ The core KPI set spans three categories — profitability (net interest margin, return on assets, return on equity), efficiency (cost-to-income ratio), and asset quality (non-performing loan ratio, provision coverage ratio) — and no single category alone gives a complete performance picture.
- ✓ Return on assets and return on equity should both be shown, since a bank can improve ROE through leverage alone without any improvement in the underlying return on the assets it holds.
- ✓ The cost-to-income ratio should be built from the model's own revenue and expense line items, not a separately maintained figure, so it moves consistently with every other output as assumptions change.
- ✓ KPIs should be built as their own dedicated output module referencing the model's core schedules, not scattered as one-off formulas across different tabs, so the full KPI set updates consistently whenever an assumption changes.
Objective¶
This guide sets out the core set of bank-specific KPIs a financial model should expose as explicit outputs, within the Banking Financial Modelling pillar, extending the general Key Performance Indicator concept and Management Reporting and KPI Dashboard Model Structure with the specific ratios a bank model needs.
The Core Banking KPI Set¶
| Category | KPI | What It Measures |
|---|---|---|
| Profitability | Net Interest Margin | Net interest income as a percentage of average earning assets |
| Profitability | Return on Assets (ROA) | Net income as a percentage of average total assets |
| Profitability | Return on Equity (ROE) | Net income as a percentage of average shareholders' equity |
| Efficiency | Cost-to-Income Ratio | Operating expense as a percentage of operating income |
| Asset Quality | Non-Performing Loan Ratio | Non-performing loans as a percentage of total loans |
| Asset Quality | Provision Coverage Ratio | Allowance for credit losses as a percentage of non-performing loans |
| Funding | Loan-to-Deposit Ratio | Total loans as a percentage of total deposits |
Why ROA and ROE Should Both Be Shown¶
Return on equity can be improved purely through increased leverage — a smaller equity base carrying the same asset base and generating the same return produces a higher ROE without any genuine improvement in how effectively the underlying assets are deployed. Return on assets isolates that underlying asset-level return, independent of capital structure. Showing both prevents a leverage-driven ROE improvement from being misread as an operating performance gain.
Return on Assets = Net Income ÷ Average Total Assets
Return on Equity = Net Income ÷ Average Shareholders' Equity
Building the Cost-to-Income Ratio¶
The cost-to-income ratio should be calculated directly from the model's own income statement line items:
Cost-to-Income Ratio = Operating Expense ÷ (Net Interest Income + Fee and Other Non-Interest Income)
Building it from the model's own live formulas, rather than as a separately maintained figure, ensures it moves consistently with every other output as assumptions change.
Structuring the KPI Module¶
These KPIs should be built as their own dedicated output module, referencing the model's core schedules (the income statement, balance sheet, loan portfolio, and allowance roll-forward), rather than scattered as one-off formulas across different tabs. A dedicated module lets a reviewer see the full KPI set together and confirms every KPI updates consistently whenever an underlying assumption changes. See Management Reporting and KPI Dashboard Model Structure for the general dashboard structuring discipline this applies.
Common Construction Pitfalls¶
- Calculating KPIs outside the model, from a static extract, so they silently drift out of consistency as the model is updated.
- Showing ROE without ROA, allowing a leverage-driven improvement to be read as genuine operating performance gain.
- Scattering KPI formulas across different tabs rather than building a single dedicated output module.
- Presenting profitability metrics without the accompanying asset-quality metrics needed to assess whether the profitability is sustainable.
Continue Reading¶
Prerequisites¶
- Banking Financial Modelling — the parent pillar
- Key Performance Indicator
Related Technical Guides¶
Related Glossary¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What are the core banking KPIs a model should expose?
At minimum, net interest margin and return on assets/equity (profitability), the cost-to-income ratio (efficiency), and the non-performing loan ratio and provision coverage ratio (asset quality) — together giving a rounded view no single metric provides alone.
Why show both return on assets and return on equity?
Because a bank can improve its return on equity purely through increased leverage (a smaller equity base relative to the same asset return), without any genuine improvement in how effectively its assets are being deployed — showing both prevents a leverage-driven ROE improvement from being read as an operating performance gain.
How is the cost-to-income ratio calculated?
Cost-to-Income Ratio = Operating Expense ÷ Operating Income (net interest income plus fee and other non-interest income) — see Cost-to-Income Ratio.
Why should these KPIs be built inside the model rather than calculated separately for a board pack?
Because a KPI calculated outside the model, from a static extract of its outputs, will silently drift out of consistency as the model itself is updated — building the KPIs as live formulas referencing the model's own schedules ensures they always reflect the current state of the model.
Should banking KPIs be built as a separate module, or embedded across different schedules?
As a dedicated output module referencing the relevant schedules elsewhere in the model, so the full KPI set can be reviewed together and updates consistently whenever an underlying assumption changes, rather than scattered as one-off formulas that are easy to miss during review.
How does this KPI set relate to the general Key Performance Indicator concept?
These are the bank-specific application of the general key performance indicator concept — see Key Performance Indicator for the general definition, and Management Reporting and KPI Dashboard Model Structure for how a KPI dashboard should be structured regardless of industry.
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.
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.
Cost-to-Income Ratio
The cost-to-income ratio divides operating expense by operating income (net interest income plus fee and other non-interest income), giving the standard measure of how efficiently a bank converts revenue into profit before credit costs. A lower ratio indicates greater efficiency, though the ratio should be read alongside profitability and asset-quality metrics rather than optimized in isolation.
Non-Performing Loan Ratio
The non-performing loan (NPL) ratio measures non-performing loans — those in significant default or unlikely to be repaid in full without recourse to collateral — as a percentage of a bank's total loan book. It is the core asset-quality indicator, and should be read alongside the provision coverage ratio, since a rising NPL ratio without a corresponding increase in provisioning coverage signals building, unrecognized credit risk.
Provision Coverage Ratio
The provision coverage ratio measures the allowance for credit losses against non-performing loans, indicating how well a bank's accumulated provisions cover the problem exposure it has already recognized. A low or declining coverage ratio, particularly alongside a rising non-performing loan ratio, signals that reserves may be insufficient relative to recognized risk — a combination that should prompt closer review rather than being read from either ratio alone.
Loan-to-Deposit Ratio
The loan-to-deposit ratio compares total loans to total deposits, giving a core indicator of how much of a bank's lending is funded from its deposit base versus wholesale or other funding sources. A ratio above 100% means the bank is lending more than it holds in deposits, funding the difference through wholesale markets — a funding structure that carries more refinancing and liquidity risk than deposit-funded lending.
Key Performance Indicator (KPI)
A key performance indicator (KPI) is a defined metric selected to track performance against a specific business objective, calculated with a single documented formula and data source, and tracked consistently across reporting periods so that period-over-period comparison reflects an actual change in performance rather than a change in how the metric was calculated. In a financial model, a KPI should be formula-linked to its source data rather than re-keyed each period, and its formula should be maintained in one location and referenced consistently wherever it is reported.
Management Reporting and KPI Dashboard Model Structure
A management reporting or KPI dashboard model is not a separate calculation engine — it is a presentation layer that extracts, re-derives, and re-presents figures already produced by an underlying three-statement model. This guide covers how that layer should be structured: every dashboard figure formula-linked back to its source in the underlying model rather than re-keyed or pasted, KPIs defined once with a documented formula rather than calculated inconsistently across different reports, and a clear separation between the calculation engine (where figures are produced) and the reporting layer (where they are selected, formatted, and presented) so that a change to the underlying model flows through to every report automatically.