IFRS 9 staging calculator
Automate IFRS 9 loan staging from a pasted list, with each loan’s stage, trigger and balance by stage.
Loan list
Use one loan per row with columns loan_id, balance, dpd, pd_origination, pd_now, forborne, watchlist and default. Enter PD as a percentage or decimal and flags as 1 or 0.
400 loans read, 0 rows skipped because the balance or days past due was not a number.
The list is read in your browser and is not uploaded.
The 400 loans in the demo are made up.
Balance outside Stage 1
102 loans with €2,002,010 are in Stage 2, and 18 loans with €446,000 are in Stage 3, accounting for 27.9% of the balance.
Loans and balance by stage
What moved loans out of Stage 1
Loans in Stage 2 and 3
| Loan ID | Balance | Days past due | PD ratio | Stage | Trigger |
|---|
95 more loans are in the download.
After staging
Get the result by email
Run the same staging rules as a decision flow across your whole book each month, then test threshold changes on past months before they go live. Start your trial
Staging rules
PD ratio = PD now ÷ PD at origination Stage 3 = Default flag | Days past due > Days past due for Stage 3 Stage 2 = Days past due > Days past due for Stage 2 | PD ratio ≥ PD ratio for Stage 2 | Forborne | Watchlist Stage 1 = All other loans Balance outside Stage 1 = (Stage 2 + Stage 3) ÷ Total balance
These thresholds are your policy settings. The page applies them as written and does not audit the policy or any standard. A loan with no PD at origination is staged using its other columns.
What IFRS 9 staging works out
IFRS 9 staging assigns each loan to Stage 1, Stage 2 or Stage 3. This tool uses days past due, the change in probability of default, and forborne, watchlist and default flags.
The stage balances are used before the expected credit loss is calculated. Review the loans and the trigger for each one, then take the stage balances to the expected credit loss calculator.
Common questions
How does IFRS 9 staging classify loans?
The tool assigns each loan to Stage 1, Stage 2 or Stage 3 using days past due, PD change, and default, forborne and watchlist flags. It records the first trigger that applies.
What puts a loan in Stage 2 under IFRS 9?
A loan moves to Stage 2 when days past due are above your threshold, its PD ratio reaches your threshold, or it is forborne or on the watchlist. The thresholds are your policy settings.
What is a significant increase in credit risk?
In this tool, the PD ratio is PD now divided by PD at origination. A loan moves to Stage 2 when that ratio reaches the threshold you set, if both PDs are given and PD at origination is above zero.
Does 30 days past due move a loan to Stage 2?
With the default Stage 2 threshold, a loan moves on days past due above 30. The threshold is adjustable and is your policy setting.
How do I calculate the Stage 2 and 3 balance share?
Add the Stage 2 and Stage 3 balances, then divide by the total balance. The calculator shows that share alongside the balance in each stage.