DPO Calculator

Purchases, not COGS

DPO asks how long you take to pay for what you bought. So the denominator should be purchases — the value of goods actually acquired from suppliers in the period.

COGS is not that. COGS is the value of goods actually sold. The two differ by whatever happened to the inventory balance:

Purchases = COGS + closing inventory − opening inventory. It is the same identity that appears on the face of a cost-of-goods-sold schedule, rearranged.

A business building stock bought more than it sold, so COGS understates what it owes suppliers for — and dividing by the smaller number makes DPO come out too high. A business running stock down has the opposite problem. Only when inventory is flat are the two denominators the same, and only then does the shortcut cost nothing.

This is not a trivial distinction. It is the reason two competent analysts can look at the same filing and report DPOs several days apart, each correctly, having made different assumptions. The tool above shows both figures and flags the gap when it exceeds three days, because the honest move is to state which denominator you used rather than to argue that one is universally right.

Most published DPO figures use COGS, simply because purchases are not a disclosed line item and have to be derived. That is a defensible reason to use it. It is not a reason to pretend the difference does not exist.

What stretching really costs

Suppose a supplier offers 2/10 net 30: two per cent off if you pay within ten days, otherwise the full amount at thirty.

Skipping the discount is a borrowing decision, and it is worth seeing it as one. You keep 98% of the invoice for an extra twenty days, and you pay 2% of the invoice for the privilege. That is a rate of 2 ÷ 98 = 2.04% for twenty days.

There are roughly 18.25 twenty-day periods in a 365-day year, so the simple annualised cost is 2.04% × 18.25 = 37.2%. Compounded, it is 44.6%. On the 360-day convention that most textbooks use, the same terms give the familiar figure of 36.7%.

Whichever convention you prefer, the conclusion does not move: this is far above what almost any business can borrow at. If you have an overdraft at 9% and a supplier offering 2/10 net 30, the arithmetic says draw on the overdraft and take the discount.

The size surprises people because the discount looks small. Two per cent sounds like nothing. It is nothing — over twenty days. Annualising is what makes it visible, and annualising is the right thing to do, because the choice repeats every time an invoice arrives.

Note what happens when the credit window lengthens. On 2/10 net 60 the same discount buys fifty days rather than twenty, and the annual cost falls to about 14.9%. The discount percentage is only half the story; the number of days it buys is the other half.

Why the cycle rewards it anyway

Here is the tension this page exists for. In the cash conversion cycle, DPO is subtracted. So every extra day of payment delay removes exactly one day of cycle. Not approximately — exactly, as a matter of arithmetic.

That makes DPO the cheapest lever on the whole cycle to pull. Cutting DSO needs a collections function. Cutting DIO needs better forecasting. Extending DPO needs an instruction to accounts payable, and it works this month.

So a business measured on its cash conversion cycle, with no other constraint, will extend payables. The metric improves, the working-capital report looks excellent, and if discounts were being forfeited to achieve it, the margin quietly paid for the whole thing. The cycle got shorter and the company got poorer.

The fix is not to stop measuring the cycle. It is to measure DPO alongside the terms actually on offer, which is what the panel in the tool does: cash freed on one side, discount forgone on the other, both in money rather than in days.

There is also a cost the arithmetic never shows. Suppliers notice. Payment behaviour affects allocation when stock is scarce, willingness to hold safety stock on your behalf, and price at the next negotiation. A reputation as a slow payer is a real cost that does not appear in any ratio on this page.

Supplier finance, and why DPO stopped being simple

Supply-chain finance — also called reverse factoring — lets a company extend its own payment terms while a bank pays the supplier early, for a fee. The buyer pays the bank later than it would have paid the supplier.

This creates a genuine classification question. Is the obligation still a trade payable, or has it become borrowing from a bank? The answer changes both the reported DPO and the reported debt, and for a long time it was not consistently disclosed. Several large corporate failures involved arrangements of this kind, where a balance sheet that looked like ordinary trade credit was in substance short-term debt.

Disclosure requirements around supplier finance programmes have since been tightened, which is a reasonable signal about how material the ambiguity was. For anyone reading someone else’s accounts, the practical advice is short: a DPO that has risen sharply without a corresponding change in stated supplier terms is worth investigating, and the accounting-policy notes are where to look.

For your own business, the arrangement can be entirely sensible — it can genuinely help suppliers get paid sooner. The point is simply that the resulting DPO is no longer measuring what the ratio appears to measure, and reporting it without saying so is misleading.

What DPO cannot tell you

Three limits worth stating.

Higher is not better. This is the reverse of the usual reading. A rising DPO can mean strong negotiating power, or it can mean the company cannot pay its bills. The ratio looks identical either way, and the second is a solvency problem presenting as a working-capital improvement.

It is an average across suppliers on different terms. A DPO of 60 might be every supplier on 60-day terms, or half on 30 who are being paid at 90. The second means relationships are being damaged and the ratio cannot see it. Only an aged creditors report can.

The denominator is ambiguous, and that is not fixable. As above: COGS or purchases, with a real difference whenever inventory moves. Any cross-company comparison needs both firms on the same basis, and that usually cannot be established from published accounts.

Finally, DPO tells you nothing about whether you are buying well. A business with excellent payment terms and terrible purchase prices has a flattering DPO and a poor gross margin. Terms and price are negotiated together, and suppliers routinely trade one against the other.

Sources and methodology

The definitions behind the denominator and the discount arithmetic.

• IRS Form 1125-A, Cost of Goods Sold — the schedule where purchases sit between opening and closing inventory, which is the identity this page derives
• IAS 2 Inventories — the cost basis that makes purchases and COGS differ by the inventory movement
• SEC Regulation S-X §210.5-03 — why purchases are not a disclosed line item and have to be derived
• ACCA Financial Management technical articles — the professional treatment of trade credit and early-settlement discounts
• How we calculate — methodology

Method. Purchases are derived rather than assumed, and a derivation that resolves to zero or less is refused outright instead of producing a meaningless ratio. The discount cost is computed both simply and compounded, and asserted against the conventional results on both day bases — 36.73% on 360 days and 37.24% on 365 for 2/10 net 30 — so the page’s claim about where the familiar textbook figure comes from is checked rather than repeated. The relationship that one extra day of DPO removes exactly one day of cycle is asserted across sixty-one values rather than argued. The engine is verified on every change against 113 assertions shared with the rest of the working-capital cluster. The count and the per-case breakdown are published on the formula verification page.

Related calculators

Where this goes next:

More in Business, or browse all calculators.