Credit Loss Provisions
Executive Summary
Key Takeaways
- ✓ Credit loss 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 loan book.
- ✓ The provision charge for a period builds up the allowance for credit losses, a balance sheet contra-asset account, which is then drawn down as specific loans are written off.
- ✓ Segment-level loss rates should reflect each segment's actual risk profile — a granular commercial loan risk grade will typically carry a materially different loss rate than a low-risk residential mortgage segment.
- ✓ The provision charge is distinct from an actual write-off — a provision recognizes expected future loss before it crystallizes, while a write-off removes a specific loan balance once loss is realized and confirmed.
- ✓ The provisioning build should be explicitly reconciled to the allowance roll-forward on the balance sheet, so a reviewer can trace the income statement charge through to the reserve balance it builds.
Objective¶
This guide covers how to model credit loss provisions, within the Banking Financial Modelling pillar, drawing on the segmented balances produced by Loan Portfolio Modelling.
Segment-Level Provisioning¶
Provisions should be derived from portfolio-segment loss-rate assumptions applied to segmented loan balances, not a single blended rate applied to the whole book:
Segment Provision Charge = Segment Loan Balance × Segment Expected Loss Rate
Total Provision Charge = Σ (Segment Provision Charges)
Loss-rate assumptions should reflect each segment's actual risk profile — a granular commercial loan risk grade will typically carry a materially different loss rate than a low-risk residential mortgage segment, and collapsing them into a single blended rate either understates expected loss on higher-risk segments or overstates it on lower-risk ones.
Provision vs. Write-Off¶
A provision is an income statement charge that recognizes expected future credit loss before it crystallizes. A write-off removes a specific loan balance once the loss is realized and confirmed. The two are not the same event: the provision builds up a reserve in anticipation of loss, and the write-off later draws down that same reserve rather than generating a second income statement charge.
The Allowance Roll-Forward¶
Closing Allowance for Credit Losses = Opening Allowance
+ Current-Period Provision Charge
− Write-Offs
+ Recoveries (on previously written-off amounts, if any)
This roll-forward should be built as its own explicit schedule, connecting the income statement provision charge to the balance sheet allowance balance — see Allowance for Credit Losses and Bank Financial Statements for where this sits within the three statements.
Forward-Looking Provisioning¶
Provisioning under modern accounting frameworks is typically forward-looking (expected credit loss over the life of the exposure, or over a defined horizon, rather than losses already incurred), which means the segment-level loss-rate assumptions should be reviewed and updated as economic conditions or portfolio risk profiles change, rather than held static. See Loan Loss Forecasting for the scenario-based extension of this build.
Common Construction Pitfalls¶
- Applying a single blended provisioning rate to the entire loan book rather than segment-specific loss rates.
- Charging a write-off directly to the income statement rather than drawing it down against the allowance for credit losses already built up through provisions.
- Building the provisioning schedule without an explicit allowance roll-forward connecting it to the balance sheet.
- Holding segment-level loss-rate assumptions static rather than reviewing them as economic conditions or portfolio composition change.
Continue Reading¶
Prerequisites¶
- Banking Financial Modelling — the parent pillar
- Loan Portfolio Modelling
Related Technical Guides¶
Related Glossary¶
Related Technical Guides (Forecasting)¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
How should credit loss provisions be modelled?
Derived from portfolio-segment loss-rate assumptions (by product type or risk grade) applied to segmented loan balances, not a single blended provisioning rate applied to the entire loan book, since default risk varies substantially across segments.
What is the difference between a provision and a write-off?
A provision is an income statement charge recognizing expected future credit loss before it crystallizes, building up the allowance for credit losses on the balance sheet. A write-off removes a specific loan balance once the loss is realized and confirmed, drawing down that same allowance rather than hitting the income statement again.
How does the provision charge connect to the balance sheet?
The period's provision charge is added to the allowance for credit losses (a contra-asset account), and confirmed write-offs are then deducted from that same balance: Opening Allowance + Provision Charge − Write-Offs (+ Recoveries) = Closing Allowance — see Allowance for Credit Losses.
Why does segment-level loss-rate granularity matter?
Because default risk varies substantially by product type and risk grade — a single blended loss rate either understates the true expected loss on higher-risk segments or overstates it on lower-risk segments, and either error distorts the resulting provision charge.
How does the provisioning build connect to loan portfolio modelling?
The segmented loan balances produced by the loan portfolio module are the base against which segment-specific loss rates are applied — the two modules should share the same segmentation rather than maintaining separate, potentially inconsistent loan balance figures.
What is the relationship between provisions and the provision coverage ratio?
The provision coverage ratio measures the resulting allowance balance against non-performing loans, indicating how well the accumulated provisions cover recognized problem exposure — see Provision Coverage Ratio.
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.
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.
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.
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.
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.
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.
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.