Skip to main content
DD-BNK-002-Q029 Medium

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
  • FactExposure
  • FactExposureLatest
  • DimFacility
  • FactCollateral
  • FactScenarios
  • FactPDTermStructure
  • UndrawnLimit
  • Product

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