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.

Staging rules

A default flag puts a loan in Stage 3 whatever its days past due. Forborne and watchlist loans go to Stage 2. The thresholds are your lender’s policy settings.

Balance outside Stage 1

27.9%
Stage 1€6.33m
Stage 2€2.00m
Stage 3€446k

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 IDBalanceDays past duePD ratioStageTrigger

95 more loans are in the download.

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.