Skip to main content
DD-ECL-002-Q025 Medium Time series

KSA at its fiscal year end

Days past due (DPD) = the SnapshotDate minus the DueDate in days. Buckets: Current (DPD 0 or less), 1-30, 31-60, 61-90, 91-180, 180+ (over 180). The allowance policy at a month end: a customer whose CreditImpairedDate is on or before it is provided at OpenAmount x (100 - ExpectedRecoveryPct)% - the specific allowance. Every other open item: OpenAmount x LossRatePct% x FLI - the collective allowance - where LossRatePct comes from its entity's MatrixVersion in force (latest EffectiveFrom on or before the date) for the customer's Segment and the item's Bucket, and FLI is the forward-looking factor of the customer's Segment: the sum of Weight x Multiplier over the scenarios of its entity's ScenarioSet in force (latest ValidFrom on or before the date). The KSA company's fiscal year ends on 31 March. What was its total allowance at 31 March 2026, in SAR?
Expected
One amount in SAR, 2 decimals · KPI card
Tables
FactOpenItems, FactOpenItemsLatest, DimCustomer, FactLossRates +1 · columns
  • FactOpenItems
  • FactOpenItemsLatest
  • DimCustomer
  • FactLossRates
  • FactMacroScenarios
  • OpenAmount
  • DueDate
  • LossRatePct
  • Weight
  • Multiplier
  • CreditImpairedDate
  • ExpectedRecoveryPct

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