Loan Loss Provision & Credit Risk Calculator
Calculate expected credit loss (ECL = EAD × PD × LGD) for a single loan or an IFRS 9 staged portfolio — with provision coverage ratio and scenario comparison.
Frequently Asked Questions
What is a loan loss provision?
A loan loss provision (allowance for credit losses) is an expense a lender recognises to cover expected defaults in its loan book. It reduces the net carrying amount of loans on the balance sheet and absorbs losses when borrowers fail to repay. Under IFRS 9 and US CECL, provisions are forward-looking — based on expected credit losses rather than waiting for actual default events.
How is expected credit loss (ECL) calculated?
The standard formula is ECL = EAD × PD × LGD. EAD (exposure at default) is the amount outstanding if the borrower defaults; PD (probability of default) is the likelihood of default over the measurement horizon; LGD (loss given default) is the share of the exposure lost after collateral and recoveries. Example: a $1,000,000 loan with a 2.5% PD and 45% LGD carries an ECL of $11,250.
What are the three stages of IFRS 9?
Stage 1 (performing): no significant credit deterioration — recognise 12-month ECL; interest on gross amount. Stage 2 (underperforming): significant increase in credit risk (e.g. 30+ days past due) — recognise lifetime ECL. Stage 3 (credit-impaired): objective evidence of default (typically 90+ days past due) — lifetime ECL with PD near 100%, and interest is recognised on the net amount.
What is a good provision coverage ratio?
The coverage ratio = total provisions ÷ gross loans (or ÷ non-performing loans for NPL coverage). Healthy banks typically hold total provisions of 1–3% of gross loans, and NPL coverage of 50–150% depending on collateral quality and jurisdiction. Rising coverage signals deteriorating credit expectations; falling coverage can flag under-provisioning. Regulators and auditors scrutinise both the models and the macro-economic scenarios behind these numbers.