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
| Input | Value |
|---|---|
| Opening trade payables | 100 |
| Closing trade payables | 140 |
| Period credit purchases | 1,200 |
| Days in period | 365 |
| Result | Value |
|---|---|
| Days payable outstanding | 36.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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening trade payables | 100 | 110 | Days payable outstanding | 36.5 days | 38.020833 days |
| Closing trade payables | 140 | 154 | Days payable outstanding | 36.5 days | 38.629167 days |
| Period credit purchases | 1,200 | 1,320 | Days payable outstanding | 36.5 days | 33.181818 days |
| Days in period | 365 | 402 | Days payable outstanding | 36.5 days | 40.2 days |
