DPO Calculator — Days Payable Outstanding

The DPO calculation relies on three sequential equations to determine your average payment duration. First, the calculator finds your average trade payables by adding your ending payables and beginning payables, then dividing by two: average_trade_payables = (ending_payables + beginning_payables) / 2. Next, it computes total purchases using your inventory changes and cost of goods sold: purchases = ending_inventory - beginning_inventory + cost_of_goods_sold. Finally, it divides average trade payables by purchases, multiplying the result by the total days in your accounting period: days_payable_outstanding = (average_trade_payables / purchases) * days_in_accounting_period.

Imagine a mid-sized retail company analyzing its financial health for a standard 365-day year. The business starts the year with $40,000 in inventory and $25,000 in accounts payable, ending the year with $50,000 in inventory and $35,000 in accounts payable. Its annual cost of goods sold (COGS) totals $300,000. First, we find the average trade payables: ($35,000 + $25,000) / 2 = $30,000. Second, we calculate total purchases: $50,000 - $40,000 + $300,000 = $310,000. Finally, we compute the DPO: ($30,000 / $310,000) * 365 = 35.32 days. This means the company takes roughly 35 days to settle its supplier invoices.

A higher DPO means you hold onto cash longer, which can improve short-term liquidity, but stretching payments too far risks damaging supplier relationships and forfeiting early-payment discounts. Conversely, a very low DPO might indicate you are paying suppliers too quickly and failing to leverage available free credit. Always compare your DPO against industry benchmarks and your company's Days Sales Outstanding (DSO) to ensure a balanced cash conversion cycle.