Skip to main content
DD-BNK-001-Q030 Very Hard Time series

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
  • FactLoanSnapshot
  • DimLoan
  • DimDate
  • OutstandingBalance
  • DaysPastDue
  • CurrentRating
  • OriginationRating
  • PD12mPct
  • PDLifetimePct
  • LGDPct
  • DateKey

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us