A higher DPO keeps cash in the business longer, but paying too slowly can damage supplier relationships or lose early-payment discounts (such as 2/10 net 30).
How to use the DPO Calculator: Days Payable Outstanding
- Beginning accounts payable
- Ending accounts payable
- Cost of goods sold
- Days in the period
Results update as you type, and every field accepts the units shown in its menu.
How it works
Enter beginning and ending accounts payable, cost of goods sold and the number of days.
Inputs explained
| Field | What to enter |
|---|---|
| Beginning accounts payable | Amount in your currency |
| Ending accounts payable | Amount in your currency |
| Cost of goods sold | Amount in your currency |
| Days in the period | A number |
What each result means
- Days payable outstanding = ([Beginning accounts payable] + [Ending accounts payable])÷2÷[Cost of goods sold]×[Days in the period]
- Payables turnover = [Cost of goods sold]÷(([Beginning accounts payable] + [Ending accounts payable])÷2)
Example values
How the main result changes when Beginning accounts payable changes and everything else stays at the example values above:
| Beginning accounts payable | Days payable outstanding (days) |
|---|---|
| 45,000 | 21.8 |
| 67,500 | 24.9 |
| 90,000 | 28.1 |
| 112,500 | 31.2 |
| 135,000 | 34.4 |
| 180,000 | 40.7 |
Formula
DPO = average accounts payable ÷ COGS × days in the period
Payables turnover = COGS ÷ average payables
Worked example
Inputs: Beginning accounts payable: $90,000; Ending accounts payable: $110,000; Cost of goods sold: $1,300,000; Days in the period: 365.
Results: Days payable outstanding = 28.1 days; Payables turnover = 13.
Frequently asked questions
What is a good DPO?
Close to your suppliers' terms: often 30–60 days.
Is a high DPO good?
It helps cash flow, but too high may signal payment difficulties.
How does DPO affect the cash conversion cycle?
A higher DPO shortens it.