The quarter the ECL jumped
IFRS 9 staging at a quarter end: Stage 3 (credit-impaired) if DaysPastDue is above 90 or CurrentRating is 10; otherwise Stage 2 if DaysPastDue is above 30 or the CurrentRating is 3 or more notches worse (higher) than the loan's OriginationRating; otherwise Stage 1. ECL = OutstandingBalance x PD x LGDPct, where PD is PD12mPct in Stage 1, PDLifetimePct in Stage 2 and 100% in Stage 3 (percentages divided by 100). Work out the total ECL at every quarter end. Between which two consecutive quarter ends did it rise the most? Give the later quarter end as yyyymm.
- Expected
- One month as yyyymm · Line chart of ECL by stage and quarter
- Tables
-
FactLoanSnapshot, DimLoan, DimDate · columns