Enter Values
Key Formulas
Credit Risk Metrics
Formula Breakdown
Rating Thresholds
| Metric | Green | Yellow | Red |
|---|---|---|---|
| EL % | ≤ 0.5% | 0.5 – 2.0% | > 2.0% |
| NPL Ratio | < 2% | 2 – 5% | > 5% |
| Coverage | > 100% | 50 – 100% | < 50% |
| Texas Ratio | < 50% | 50 – 100% | > 100% |
| NCO Rate | < 0.5% | 0.5 – 1.5% | > 1.5% |
| Reserve/Loans | > 2% | 1 – 2% | < 1% |
| Reserve Gap | ≥ $0 | — | < $0 |
Model Assumptions
- Point-in-time estimates — PD, LGD, and EAD are static snapshots, not forward-looking (IFRS 9/CECL) projections.
- PD is annual — Represents one-year default probability; multi-year cumulative PD not modeled.
- LGD assumes no recovery timing — Does not discount recoveries for time value of money.
- EAD = current exposure — Does not model credit conversion factors for off-balance-sheet items.
- No PD–LGD correlation — Assumes independence between default probability and loss severity.
- Average loans = Total Loans — NCO rate uses period-end total loans as denominator (simplification).
- NPL classification follows 90+ day convention — Standard US regulatory definition; other jurisdictions may differ.
- PD and LGD are exposure-weighted averages — Assumed to represent the same portfolio and reporting date as EAD and Total Loans.
For educational purposes only. Not financial advice. Market conventions simplified.
Understanding Credit Risk & Loan Loss Provisions
What is Expected Loss?
Expected Loss (EL) is the cornerstone of credit risk measurement. It represents the average loss a bank expects from its loan portfolio over a defined period. The formula decomposes credit risk into three components:
Probability of Default × Loss Given Default × Exposure at Default
Key Credit Risk Metrics
NPL Ratio
NPLs / Total Loans
Measures asset quality — the percentage of the loan book that has deteriorated past 90 days due.
Coverage Ratio
Reserves / NPLs
Measures provisioning adequacy — whether the bank has enough reserves for its problem loans.
The Texas Ratio
The Texas Ratio was developed by analyst Gerard Cassidy during the 1980s Texas banking crisis. It compares a bank's non-performing assets to its loss-absorbing capacity:
Values above 100% historically predict bank failure
Basel Framework Context
- Under Basel II/III, banks use PD, LGD, and EAD for risk-weighted asset calculations
- Expected Loss determines provisioning needs; Unexpected Loss determines capital requirements
- The Internal Ratings-Based (IRB) approach allows banks to estimate their own risk parameters
- CECL (Current Expected Credit Losses) requires lifetime expected loss provisioning at origination
Frequently Asked Questions
Disclaimer
This calculator is for educational purposes only. It uses simplified single-period expected loss models and standard regulatory definitions. Actual bank credit risk analysis involves forward-looking models (CECL/IFRS 9), correlation structures, portfolio segmentation, and macroeconomic scenarios. This tool should not be used for regulatory compliance or investment decisions.
Related Articles
- Loanable Funds Market — How interest rates are determined in the market for loanable funds
- Money Supply & Money Creation — How banks create money through the lending process