If undrawn limits were fully drawn
Append FactExposureLatest to FactExposure first. EAD = DrawnBalance + 50% of UndrawnLimit for a "Revolving credit line" (credit conversion factor); other products: DrawnBalance. Stage 3: DaysPastDue above 90 or CurrentRating 10. Stage 2 (not Stage 3): DaysPastDue above 30, or CurrentRating 3 or more notches worse (higher) than OriginationRating, or CurrentRating 8 or worse (the watch list). Otherwise Stage 1. PD: Stage 3 = 100%. Otherwise take CumulativePDPct from FactPDTermStructure for the CurrentRating at Year 1 (Stage 1) or at the remaining term (Stage 2: years to MaturityDate rounded up, between 1 and 10; credit lines always 3). Then weight the scenarios of the ScenarioSet in force (latest ValidFrom on or before the month end): PD = sum over scenarios of Weight x min(100, CumulativePDPct x PDMultiplier). LGD: collateral value CV = sum over the facility's collateral of MarketValue x (1 - HaircutPct/100), each item at its latest ValuationDate on or before the month end (0 if none); LGD% = max(10, 65 x max(0, EAD - CV) / EAD). ECL = EAD x PD% x LGD%. By how much would the total ECL at the latest month end in the data (30 September 2026) rise if the credit conversion factor were 100% instead of 50%, in AED?
- Expected
- One amount in AED, 2 decimals · KPI card
- Tables
-
FactExposure, FactExposureLatest, DimFacility, FactCollateral +2 · columns
- Topics
- Risk & Controls Data Modelling