Banking Financial Modelling

Financial Modelling Best Practices for Banking

Bank and financial institution financial models are structurally different from a standard corporate model: they are built balance-sheet-first, with earnings derived from asset and liability volumes and spreads rather than a top-line revenue forecast, and regulatory capital ratios sit as a first-class output rather than a supporting calculation. This page sets out how such a model should be constructed: building the net interest margin bridge explicitly, driving the model from balance-sheet volumes, and structuring regulatory-capital-linked assumptions as visible, named inputs. It addresses the construction question as a discipline applied while the model is built, distinct from the audit-risk perspective covered on Financial Model Auditing, and does not perform or validate any regulatory capital calculation itself.

What Is a Financial Model Audit?

A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.

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.

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.

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.

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.

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.

Banking KPIs

A bank model should expose a defined set of bank-specific KPIs as explicit model outputs, built directly from the model's own calculations rather than computed ad hoc outside the model for a board pack. This guide sets out the core banking KPI set — profitability metrics (net interest margin, return on assets, return on equity), efficiency (cost-to-income ratio), and asset quality (non-performing loan ratio, provision coverage ratio) — how each should be calculated, and how they should be structured as a dedicated output module rather than scattered across the model.

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 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 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.

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.

Allowance for Credit Losses

The allowance for credit losses is a contra-asset account on a bank's balance sheet, representing the reserve held against expected credit losses on the loan portfolio. It is built up through periodic provision charges against the income statement and drawn down as specific loans are written off, following the same roll-forward discipline a corporate model applies to a bad debt reserve, but at a scale and centrality that makes it one of the most closely scrutinized figures on a bank's balance sheet.

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.

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.

Basel Capital Ratios

The Basel III framework defines three core capital ratios — Common Equity Tier 1, Tier 1, and total capital — each measured against risk-weighted assets, layered with additional capital buffers above the hard minimums. This guide sets out the ratio definitions, the minimum and buffer levels the framework establishes, and how a bank model should represent each ratio and buffer as a distinct, named threshold rather than a single blended capital requirement.

CET1 Modelling

Common Equity Tier 1 (CET1) capital is the highest-quality, most loss-absorbing layer of regulatory capital, and it is the numerator of the most closely watched Basel ratio. This guide covers how to build the CET1 capital base in a model: the eligible components (common shares, retained earnings, certain reserves), the regulatory deductions applied (goodwill, certain deferred tax assets, other intangibles), and how the balance should roll forward period over period as retained earnings and other capital actions occur.

CET1 Ratio

The CET1 ratio expresses Common Equity Tier 1 capital — a bank's highest-quality, most loss-absorbing capital — as a percentage of risk-weighted assets. It is the most closely watched capital adequacy metric under Basel III, subject to both a hard minimum requirement and additional capital buffers, and it should be built as a live output of the model's balance sheet forecast rather than a separately calculated reporting figure.

Risk Weighted Assets

Risk-weighted assets (RWA) convert a bank's balance sheet exposures into a common risk-adjusted base, applying higher weights to riskier exposures and lower weights to safer ones. RWA forms the denominator of every Basel capital ratio, making the risk-weighting methodology a first-order driver of reported capital strength. This guide covers the standardized and internal ratings-based (IRB) approaches to calculating RWA, how a model should build the RWA base from segmented exposures, and how risk-weight density should be tracked as its own diagnostic output.

Risk Weight Density

Risk weight density measures risk-weighted assets against total assets, showing how risk-intensive a bank's balance sheet is independent of its capital position. A rising density signals a shift toward higher-risk exposures even before its effect flows through to the capital ratios that risk-weighted assets ultimately feed, making it a useful early diagnostic distinct from the ratios themselves.

Liquidity Coverage Ratio

The liquidity coverage ratio (LCR) tests whether a bank holds enough high-quality liquid assets to survive a defined 30-day acute stress scenario. This guide covers how to model the LCR's two components — the stock of high-quality liquid assets and net cash outflows under the stress scenario — and how the deposit and funding behavioural assumptions built elsewhere in the model feed directly into the outflow calculation.

Net Stable Funding Ratio

The net stable funding ratio (NSFR) tests whether a bank's longer-term assets are backed by a stable enough funding profile over a one-year horizon, complementing the short-term liquidity coverage ratio. This guide covers how to model the NSFR's two components — available stable funding, weighted by the behavioural stability of each funding source, and required stable funding, weighted by the tenor and liquidity of each asset — and how it connects to the balance sheet forecast and deposit modelling already built elsewhere in the model.

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.

Banking Scenario Analysis

Scenario analysis in a bank model means building multiple forward-looking cases — a base case and one or more alternative cases — as parameter variations of the same underlying model structure, not as separate, disconnected workbooks. This guide covers how to structure a bank's scenario framework generally, how scenarios should be selected and switched cleanly, and how stress testing and loan loss forecasting fit as specific, more prescriptive applications of this same underlying discipline.

LCR vs. NSFR

The liquidity coverage ratio (LCR) and net stable funding ratio (NSFR) are the two Basel III liquidity standards, but they test fundamentally different things: the LCR tests short-term survival under a 30-day acute stress scenario, while the NSFR tests structural funding stability over a one-year horizon. This comparison sets out the differences a modeller needs to understand to build and report both correctly, as distinct outputs rather than a single blended liquidity metric.

Standardized vs. IRB Approach

The standardized and internal ratings-based (IRB) approaches represent two fundamentally different methods of calculating risk-weighted assets. The standardized approach applies prescribed risk weights set by the regulatory framework; the IRB approach uses a bank's own modelled probability of default and loss given default, subject to regulatory approval. This comparison sets out the differences a modeller needs to understand when building or reviewing a bank model under either approach.

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.

Insurance Financial Models

An insurance company's financial model shares the balance-sheet-first architecture of a bank model but is driven by an entirely different mechanic: premiums collected and claims paid, with technical reserves — not deposits — as the primary balance sheet liability. This guide covers how an insurance model should be structured: premium and claims forecasting, the reserve build, investment income from the float, and the combined ratio that measures underwriting profitability independent of investment returns.

Asset Management Models

An asset management firm's financial model is driven by assets under management (AUM) and the fee rate charged against them, not by a balance sheet spread — the firm typically holds client assets off its own balance sheet entirely. This guide covers how to structure an asset management model: the AUM roll-forward (opening AUM, net flows, market performance), management and performance fee calculation, and the operating leverage that makes this business model's cost base scale very differently from a bank's.

Investment Banking Models

An investment bank's model must represent several structurally distinct revenue lines — advisory fees, underwriting fees, and trading income — each with a different driver and a materially different volatility profile, rather than blending them into a single fee-income figure the way a simpler institution model might. This guide covers how each revenue line should be modelled, why trading income in particular requires distinct treatment from fee-based revenue, and how capital markets cyclicality should be represented rather than smoothed away.

Commercial Banking Models

Commercial banking serves businesses rather than individual consumers, and this shapes several aspects of how the standard bank model structure from Wave 1 and 2 of this domain should be applied: loan segmentation should reflect business size and industry concentration, fee income includes a materially larger cash management and trade finance component than a retail-focused bank, and credit risk assessment is typically more bespoke and relationship-specific than the standardized scoring common in retail lending.

Retail Banking Models

Retail banking serves individual consumers at high volume, and this shapes the standard bank model structure in specific ways: loan segmentation is driven by product type (mortgages, auto loans, credit cards) and statistical risk scoring rather than bespoke commercial credit assessment, deposit behaviour is dominated by a large base of smaller-balance, individually stable accounts, and the cost structure is shaped by branch and digital channel infrastructure serving high transaction volumes at low per-transaction value.

Islamic Banking Models

An Islamic bank does not earn interest in the conventional sense; instead, it structures financing through Shariah-compliant contracts — murabaha (cost-plus sale), ijarah (leasing), and mudarabah (profit-sharing partnership) among others — each with its own economics that a model must represent structurally rather than simply relabelling conventional interest income. This guide covers how these core contract types should be modelled, how profit-sharing investment accounts differ from conventional deposits, and why treating them as economically identical to conventional banking understates the structural difference.

Development Finance Institution Models

A development finance institution (DFI) pursues development impact alongside, and sometimes in place of, pure commercial return, financing projects a purely commercial lender might not otherwise fund. This guide covers how a DFI model should represent concessional and blended finance structures — where DFI capital is combined with commercial capital at different risk-return positions — the additionality question a DFI investment should be tested against, and how development impact metrics should sit alongside, not replace, standard financial modelling discipline.

Export Credit Agency Models

An export credit agency (ECA) supports national exporters by providing guarantees, insurance, or direct financing against buyer and country non-payment risk, and its portfolio economics differ from a conventional bank's in several structural ways. This guide covers how an ECA model should represent the cover ratio (the percentage of a transaction's risk the ECA actually assumes), premium pricing calibrated to country and buyer risk grade, and the claims-and-recovery cycle that is substantially longer and more variable than conventional bank credit losses.

Sovereign Wealth Fund Models

A sovereign wealth fund manages national wealth across a diversified, multi-asset-class portfolio against a long-horizon mandate, rather than the balance-sheet spread of a bank or the fee-driven AUM model of a conventional asset manager. This guide covers how a sovereign wealth fund model should represent strategic asset allocation across asset classes, the long-horizon mandate's effect on liquidity and risk tolerance, and the co-investment and direct investment structures common to this institution type.

Infrastructure Bank Models

An infrastructure bank finances long-dated infrastructure assets — transport, energy, water, digital infrastructure — typically through project finance structures rather than general-purpose corporate lending. This guide covers how an infrastructure bank model should represent long tenor and drawdown-phased lending, co-financing arrangements with commercial lenders and multilateral partners, and the project-finance-specific credit mechanics (cash flow waterfalls, coverage ratio covenants) that differ from the general bank lending discipline covered elsewhere in this domain.

Bank Financial Model Template

This template sets out how a bank financial model should be structured as a standalone, auditable schedule: a segmented balance sheet forecast (loan and deposit volumes by segment), an interest income and net interest margin bridge module, a credit loss provisioning schedule tied to the allowance roll-forward, and a capital adequacy block calculating risk-weighted assets and capital ratios live from the preceding modules, following the build methodology across this domain's Wave 1 and Wave 2 technical guides. It is a structural template, not a source of specific volume, rate, or loss-rate assumptions, which must be sourced for each specific institution.

Banking Model Risk

Model risk in banking is a distinct, heavily formalized discipline, because banks rely on models for decisions with direct regulatory and financial stability consequences — credit decisions, capital adequacy, and liquidity management chief among them. This guide extends the general Model Risk pillar with the banking-specific model taxonomy (credit, valuation, capital, liquidity models), the three-lines-of-defense structure common to bank model risk management frameworks, and why banking model risk management is typically more formalized than in most other industries.

Banking Model Validation

Banking model validation is the independent, second-line function that tests a bank model's conceptual soundness, implementation accuracy, and ongoing performance against actual outcomes. This guide covers the three pillars of a banking model validation exercise: conceptual soundness review (does the model's design make sense for its intended use), implementation testing (does the model as built actually implement its intended design), and outcomes analysis (does the model's output track what actually happens over time) — and why validation is a distinct discipline from a structural audit.

Regulatory Model Governance

Regulatory model governance is the framework a bank uses to inventory, tier, approve, and monitor every model it relies on for a material business or regulatory purpose. This guide covers the core components of that framework — a comprehensive model inventory, a risk-based tiering methodology, a formal approval process before a model is used in production, and ongoing performance monitoring — and why an incomplete inventory is the single most common gap regulators identify in bank model governance frameworks.

Banking Documentation

Documentation for a bank model must satisfy general model documentation discipline while also evidencing several bank-specific requirements: the sourcing and justification of regulatory-linked assumptions (risk weights, capital thresholds, liquidity run-off rates), the model's assigned risk tier and rating, and its validation and approval history. This guide covers what banking documentation needs beyond the general standard, and why undocumented regulatory assumption sourcing is one of the most common findings in a bank model review.

Banking Model Audit

A structural audit of a bank model tests whether the formulas and logic as actually built calculate correctly — whether the segmented balance sheet, interest income build, credit loss provisioning, and capital adequacy modules covered across this domain are internally consistent and free of the structural errors (broken links, hardcodes, inconsistent formulas) that affect any complex Excel model. This guide covers what a banking-specific structural audit should check, and how it differs from both model validation and any regulatory capital or liquidity calculation review.

Independent Review in Banking

Independent review of a bank model — performed by a party outside the bank's own model risk management function — provides a perspective distinct from internal model validation, even when both disciplines cover similar technical ground. This guide covers why independence from the institution itself matters beyond independence from the first-line business unit, when a bank should seek external independent review in addition to its internal second-line validation function, and how a lending syndicate or regulator might rely on independent review differently than the bank's own governance process.

Regulatory Reporting Models

Regulatory reporting models translate a bank's underlying financial position into the specific format and definitions required by its regulatory returns — capital adequacy, liquidity, and credit exposure reporting among others. This guide covers why these reporting models should reconcile explicitly to the same underlying balance sheet, capital, and liquidity calculations built across this domain rather than being maintained as a separate, disconnected reporting exercise, and the specific reconciliation discipline that keeps regulatory and management reporting internally consistent.

Common Banking Modelling Errors

This guide synthesizes the structural mistakes that recur most often across the banking modelling domain covered on this Knowledge Centre — a single blended loan or deposit balance instead of segment-level detail, an implicit net interest margin bridge with no volume/rate/mix decomposition, a capital ratio maintained as a disconnected reporting figure rather than a live formula, a revenue-first bank model built like a standard corporate model, and a relabelled conventional interest formula presented as an Islamic finance contract. Each entry is drawn from, and cross-referenced to, the full technical guide covering that mechanic in depth, so this page functions as a single navigable index across the domain rather than a duplicate treatment of any one mechanic.

Banking Best Practices

This page synthesizes institutional best practice across the full Banking Financial Modelling domain into a single reference, drawing together the balance-sheet-first construction discipline, capital and liquidity governance, institution-type specialization, and model risk management practices covered in depth elsewhere on this Knowledge Centre. It is the capstone page for this domain, intended as a starting orientation for a reader new to banking financial modelling and a quick reference for an experienced practitioner, in both cases pointing to the full dedicated guide for any practice that needs deeper treatment.

Three-Statement Model

A three-statement model is a financial model in which the income statement, balance sheet, and cash flow statement are dynamically linked into a single integrated system, so that a change in any assumption flows through correctly to all three, and the balance sheet balances in every forecast period as a direct consequence of that linkage rather than as a plug engineered to force it. It is the structural foundation most other financial models — DCF, LBO, project finance — are built on top of.

Workbook Design and Model Architecture

Workbook design and model architecture is the specific skill of deciding how a financial model's worksheets are ordered, how a reader moves through them, how cell types are visually distinguished, and how sheets and files are named. It is distinct from the broader engineering principles covered in Spreadsheet Engineering and the policy-level standards covered in Model Standards — this guide addresses the concrete layout decisions a model builder makes before entering a single formula. A well-architected workbook is not a matter of taste — it determines how quickly a reviewer, lender, or successor analyst can navigate the model and trust what they find.

Model Review and QA Workflow

Model review and QA workflow is the internal process lifecycle a modelling team runs on a financial model before it is relied on externally — build, self-check, peer review, and sign-off. This page is not a description of how FMAE audits a model — that is the subject of Audit Methodologies for Financial Models, a distinct page addressing FMAE's own deterministic rule-based engine. This guide addresses the general process a modelling team runs internally, independent of any specific standard, methodology, or audit tool, and applicable whether or not the model is later submitted for independent audit at all.

Model Documentation Standards for Financial Models

Model documentation standards define what written records must accompany an institutional financial model to enable its outputs to be understood, verified, and relied upon by parties other than its original developer. The minimum documentation package for an institutional financial model includes an assumption log recording the source and rationale for every input, a version history recording all material changes, a model map describing the structure and purpose of each worksheet, instructions for use, and a disclosure of known limitations. The ICAEW Financial Modelling Code and the FAST Standard both establish specific documentation requirements that define institutional expectations.

Version Control for Financial Models

Version control for financial models is the systematic management of changes to a model over time, ensuring that each version of the model is identifiable, that all material changes are recorded with their date and author, and that previous versions can be recovered when needed. Unlike software version control systems (such as Git), financial model version control is typically implemented through a combination of file naming conventions, an in-model change log, and an archive of previous model files. The FAST Standard and the ICAEW Financial Modelling Code both require a version control protocol as a core component of institutional model governance.

FMAE for Banks

Banks and project finance lenders make credit decisions on the basis of financial models they did not build and cannot fully verify using their own internal resources. The borrower, their advisers, or the project company produce the model. The bank's credit team receives it, reviews it, and either approves the credit or requires changes. The quality of that review determines the quality of the credit decision. The fundamental tension for banks is this: the more complex and material the transaction, the more the bank needs to understand the model's reliability — and the less time the credit timeline allows for the bank to do so.