Non-Performing Loan Ratio
Executive Summary
Key Takeaways
- ✓ The non-performing loan ratio expresses non-performing loans as a percentage of total loans, the core asset-quality indicator for a bank's loan book.
- ✓ A loan is typically classified as non-performing once payments are significantly overdue (commonly 90 days past due) or repayment in full is otherwise considered unlikely without recourse to collateral.
- ✓ The NPL ratio should be tracked at the segment level, not only in aggregate, since a stable aggregate ratio can mask deterioration concentrated in a specific product type or risk grade.
- ✓ The NPL ratio should always be read alongside the provision coverage ratio, since a rising NPL ratio without a corresponding increase in provisioning coverage indicates building, unrecognized credit risk.
- ✓ The NPL ratio is a lagging indicator — it reflects loans already in difficulty, and should be complemented with forward-looking indicators (delinquency trends, early-warning risk-grade migration) for a complete asset-quality picture.
Definition¶
The non-performing loan (NPL) ratio expresses non-performing loans — those in significant default or otherwise 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 for a bank's loan portfolio.
Calculation¶
Non-Performing Loan Ratio = Non-Performing Loans ÷ Total Loans
A loan is typically classified as non-performing once payments are significantly overdue — commonly 90 days past due — or full repayment is otherwise considered unlikely without recourse to collateral, though the precise classification threshold depends on the applicable regulatory or accounting framework in use.
Segment-Level Tracking¶
The NPL ratio should be tracked at the segment level (by product type or risk grade), not only in aggregate. A stable aggregate ratio can mask deterioration concentrated in a specific segment — a rising NPL rate in one commercial loan risk grade, for instance, can be offset in the aggregate figure by continued strong performance elsewhere, delaying recognition of the actual emerging problem. This is why Loan Portfolio Modelling segments the loan book in the first place.
Reading NPL Alongside Provision Coverage¶
The NPL ratio alone does not tell a reader whether the bank has adequately reserved against the recognized problem exposure. A rising NPL ratio without a corresponding increase in the provision coverage ratio signals that recognized problem loans are growing faster than the allowance held against them — a warning sign the NPL ratio in isolation would not reveal.
A Lagging Indicator¶
The NPL ratio reflects loans already in difficulty; it does not by itself predict future deterioration. It should be complemented with forward-looking indicators — delinquency trend data and risk-grade migration analysis — for a complete asset-quality picture, rather than treated as the sole signal of portfolio health.
Audit Considerations¶
- Confirm the NPL classification threshold applied is consistent with the applicable regulatory or accounting framework and disclosed.
- Confirm the NPL ratio is tracked at the segment level, not only in aggregate.
- Confirm the NPL ratio is presented alongside the provision coverage ratio, not in isolation.
Common Errors¶
| Error | Description | Risk |
|---|---|---|
| Aggregate-only tracking | NPL ratio shown only at the total loan book level | Segment-specific deterioration is masked by stronger performance elsewhere |
| Isolated presentation | NPL ratio shown without provision coverage context | Reader cannot assess whether recognized problem exposure is adequately reserved |
| Inconsistent classification | Non-performing threshold applied inconsistently across periods or segments | Ratio trend becomes non-comparable |
Continue Reading¶
Prerequisites¶
- Loan Portfolio Modelling — the parent guide
- Credit Loss Provisions
Related Glossary¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is the non-performing loan ratio?
Non-performing loans expressed as a percentage of total loans, the core asset-quality indicator for a bank's loan portfolio.
How is a loan classified as non-performing?
Typically once payments are significantly overdue — commonly 90 days past due — or full repayment is otherwise considered unlikely without recourse to collateral, though the precise classification threshold depends on the applicable regulatory or accounting framework.
How is the NPL ratio calculated?
Non-Performing Loan Ratio = Non-Performing Loans ÷ Total Loans.
Why should the NPL ratio be tracked at the segment level?
Because a stable aggregate NPL ratio can mask deterioration concentrated in a specific product type or risk grade — segment-level tracking is what allows early identification of where credit quality is actually declining.
Why read the NPL ratio alongside the provision coverage ratio?
Because a rising NPL ratio without a corresponding rise in provisioning coverage signals that recognized problem exposure is growing faster than the reserve held against it — building, unrecognized credit risk that would otherwise not be visible from the NPL ratio alone.
Is the NPL ratio a forward-looking indicator?
No — it is a lagging indicator, reflecting loans already in difficulty. It should be complemented with forward-looking indicators such as delinquency trends and risk-grade migration to give a complete picture of emerging, not just realized, asset-quality deterioration.
Related Articles
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.
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.
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.
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.
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.