Loan Ageing — Excel Course

Turn due dates and payment information into ageing buckets. Learn it step by step with guided practice on Excelquro.

Understand

Loan ageing converts due-date and payment information into DPD values and business buckets. The buckets should be mutually understandable and consistently applied.

Worked example

Follow along
  1. Confirm due and payment dates.
  2. Calculate DPD using the agreed business rule.
  3. Map DPD into 0, 1–30, 31–60, 61–90 and larger buckets.
  4. Summarize accounts and POS by bucket.
  5. Review boundary cases such as exactly 30 or 31 DPD.
Interactive practice runs in your browser.