Suppliers who let you pay in 30, 45 or 60 days are giving you a loan with no interest. Days payable outstanding, or DPO, shows how much of it you use. This DPO calculator takes your accounts payable, your cost of goods sold, the days in the period and your suppliers’ terms to give the DPO, the payables turnover, the purchases per day and the cash you could free.
How the calculation works
- DPO = accounts payable ÷ cost of goods sold × days in the period. Purchases can replace the cost of goods sold when you know them.
- Payables turnover = cost of goods sold ÷ accounts payable, the number of times payables are paid in the period.
- Purchases per day = cost of goods sold ÷ days.
- Cash you could free = unused days of credit (terms − DPO, not below zero) × purchases per day.
Example
A company owes suppliers $120,000 at year end and has a cost of goods sold of $1,095,000 over 365 days. DPO = 120,000 ÷ 1,095,000 × 365 = 40.0 days, and payables turn over 9.13 times. Suppliers give 45 days, so 5 days of credit go unused. With purchases of $3,000 a day, paying on the due date would keep $15,000 in the bank longer.
Why it matters
Managing payables is one of the cheapest ways to improve cash. A company that pays on day 20 when terms are 45 gives away 25 days of free credit, and for a business with large purchases that is a lot of money. On the other hand, one that regularly pays late damages its relationship with suppliers and its credit standing.
Good to know
A DPO far above the terms warns of cash stress or a disorganized payment process, and a DPO well below suggests that early payment is not being traded for a discount. If a supplier offers a 2 % discount for payment in 10 days instead of 30, taking it is worth far more than the loan, an annual return of more than 36 %. Use the same period for payables and cost of goods sold, and be careful with seasonal businesses where year-end payables are not typical. Compare DPO with companies in the same industry.
Related tools
The cash conversion cycle calculator combines DPO with inventory and receivable days, the asset turnover calculator measures how efficiently assets produce sales and the inventory turnover calculator measures the stock side.