Open calculator ↗

Days payable outstanding · Calculation guide

Average opening and closing trade payables. Use credit purchases over the matching period; substituting cost of sales may distort the measure when inventory changes.

Calculation guide

Days payable outstanding = (Opening trade payables + Closing trade payables) / 2 / Period credit purchases × Days in period

Inputs

Opening trade payables

Example entry 100 (in the selected currency).

Closing trade payables

Example entry 140 (in the selected currency).

Period credit purchases

Example entry 1200 (in the selected currency).

Days in period

Example entry 365. Use whole numbers.

Worked example

InputValue
Opening trade payables100
Closing trade payables140
Period credit purchases1,200
Days in period365
ResultValue
Days payable outstanding36.5 days

Calculation steps

Days payable outstanding = ((((Opening trade payables + Closing trade payables) ÷ 2) ÷ Period credit purchases) × Days in period)

((((100 + 140) ÷ 2) ÷ 1,200) × 365) = 36.5 days

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening trade payables100110Days payable outstanding36.5 days38.020833 days
Closing trade payables140154Days payable outstanding36.5 days38.629167 days
Period credit purchases1,2001,320Days payable outstanding36.5 days33.181818 days
Days in period365402Days payable outstanding36.5 days40.2 days
Days payable outstanding →

Sources