Corporate Finance & Valuation Working Capital & Operating Cash Cycle FASB ASU 2022-04 (supplier finance disclosure)

Days Payable Outstanding (DPO) Calculator

Days payable outstanding tells you how many days of cost of sales you are currently financing with supplier credit rather than cash. Enter your opening and closing accounts payable, the cost base for the period and the number of days it covers, and this calculator returns DPO, payables turnover, the cost of sales per day, and the one-off cash swing that moving to a different payment period would produce. It is the payables leg of the cash conversion cycle, and the only leg where a longer number is usually the better one.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Opening accounts payableTrade payables on the balance sheet at the start of the period, before accruals and non-trade liabilities.480000 $
Closing accounts payableTrade payables at the end of the same period, taken from the same balance sheet line as the opening figure.520000 $
Average the opening and closing balancesTick to divide by the average of the two balances; untick to use the closing balance alone, which is the convention in most screening databases.Yes
Cost of goods sold or credit purchasesThe denominator, for the same period as the payables balances: COGS from the income statement, or credit purchases (COGS + closing inventory - opening inventory) if you can build it.6200000 $
Days in the periodThe number of days the cost base covers. Use the same period the payables balances bracket.365 - full year
Target payment periodThe payment period you want to model; the calculator reports the one-off change in the payables balance needed to reach it.45 days

It returns

  • Days payable outstanding — The average number of days of cost of sales sitting unpaid in accounts payable.
  • Payables turnover — How many times the payables balance is settled and rebuilt over the period.
  • Payables balance used — The supplier credit currently funding your operations.
  • Cost of sales per day
  • Cash effect of reaching the target — One-off change in the payables balance, and therefore in cash, if the payment period moved to the target.

The formula

DPO=AP¯COGSD
Turnover=COGSAP¯=DDPO
ΔCash=(DPOtargetCOGSD)AP¯

In plain text: DPO = (average accounts payable / cost of goods sold) x days in period

  • DPODays payable outstanding - the average payment period (days)
  • AP̄Average trade accounts payable over the period, or the closing balance if you use that convention ($)
  • COGSCost of goods sold for the period, or credit purchases if you can build them ($)
  • DDays the cost base covers - 365 for a year, 91 for a quarter (days)

The ratio is dimensionally a stock divided by a flow per day. Dividing COGS by D first gives the cost of sales per day; payables divided by that daily cost is the number of days of purchases you have not yet paid for.

Updated Category Working Capital & Operating Cash Cycle Verified against published test cases Reading time 12 min

What days payable outstanding actually measures

Days payable outstanding converts your accounts payable balance into a length of time. If your cost of sales runs at $16,986 a day and you owe suppliers $500,000, you are carrying just under thirty days of purchases you have received but not yet paid for. That is what DPO reports: the average age of the money you owe trade suppliers, expressed in days.

The number matters because supplier credit is free financing. Every day you hold a payable is a day you do not need a bank line, a day of interest you do not pay, and a day the cash sits in your account rather than theirs. Stretch the payment period from 30 days to 45 and the payables balance grows by fifteen days of purchases, and that growth arrives in your bank account exactly once. Working capital metrics reward this: DPO is the only term in the cash conversion cycle that is subtracted, so a longer DPO shortens the cycle while a longer DIO or DSO lengthens it.

The number also has a ceiling that is not financial. Suppliers notice. Past the terms you actually agreed, a rising DPO stops being treasury skill and becomes either a negotiated concession you paid for elsewhere in the price, or a signal that you cannot pay. Both show up in DPO identically, which is why the ratio is read alongside the terms on your purchase orders rather than on its own.

The formula, and why the denominator is the hard part

You divide the payables balance by the cost that generated it, then multiply by the number of days that cost covers. The multiplication by days is what turns a pure ratio into a period. Written the other way round, the cost base divided by days gives cost of sales per day, and payables divided by that daily cost is a count of days directly.

Payables turnover is the same information inverted: cost base divided by payables, telling you how many times over the period the payables balance is emptied and refilled. The two are locked together by turnover = D / DPO, so a 90-day payment period on a 360-day year is exactly 4.0 turns. Report whichever your audience reads; do not treat them as two independent findings.

Average or closing payables

The averaging choice changes the answer whenever the balance moves. Averaging opening and closing balances matches the flow in the numerator to a balance that is representative of the whole period, which is the theoretically better construction and the one textbooks teach. Closing-balance DPO is what most screening databases publish, because they only reliably have one balance sheet per filing. Neither is wrong. What is wrong is comparing your average-basis DPO against a peer's closing-basis DPO and calling the gap a difference in payment behaviour.

COGS or credit purchases

Payables are created by purchases, not by cost of sales. In a period where inventory grows, you bought more than you sold, so COGS understates purchases and DPO comes out too high. Credit purchases reconstruct the right denominator: purchases = COGS + closing inventory − opening inventory, restricted to what was bought on credit. Use it when you have the inventory numbers and inventory moved materially. Use COGS when you are comparing against published peer figures, because published figures are almost always on a COGS basis.

One denominator problem has no clean fix. A service business, a software business or any firm whose payables are dominated by payroll, rent and marketing has a cost of sales line that has almost nothing to do with what it owes. DPO computed on COGS for such a firm is a large, stable, meaningless number. Substituting total operating expenses less depreciation is a defensible workaround, provided you say that is what you did.

Worked example: a distributor with $6.2 million of cost of sales

A distributor opens the year with $480,000 of trade payables and closes at $520,000. Cost of goods sold for the year is $6,200,000. Management wants to know where it stands and what moving to 45-day payment would be worth.

  1. Average the payables. (480,000 + 520,000) ÷ 2 = $500,000.
  2. Find the daily cost base. 6,200,000 ÷ 365 = $16,986.30 per day.
  3. Divide. 500,000 ÷ 16,986.30 = 29.44 days. Equivalently, 500,000 ÷ 6,200,000 = 0.080645, and 0.080645 × 365 = 29.44.
  4. Check with turnover. 6,200,000 ÷ 500,000 = 12.40 turns, and 365 ÷ 12.40 = 29.44 days. The two routes agree, as they must.
  5. Price the target. At 45 days the payables balance would be 45 × 16,986.30 = $764,384. Against today's $500,000 that is a one-off increase of $264,384.

Read that last figure carefully. The $264,384 arrives once, over the transition, as invoices that would have been paid in the old window are held into the new one. From the following year onward, cash paid out again equals cost of sales incurred, because the payables balance is simply sitting higher. Treating it as a recurring $264,384 a year of savings is the single most common error made with this calculation.

What is recurring is the interest you no longer pay on the borrowing that $264,384 displaces. At a 7% revolver rate that is about $18,500 a year — real money, but an order of magnitude smaller than the headline, and it disappears if the supplier prices the longer terms into the invoice.

How to read the number you get

Start with your own contracted terms, not with an industry benchmark. If your standard purchase order says net 30 and DPO reads 29.4, you are paying on time and there is nothing to find. If it says net 30 and DPO reads 52, either you are late — which is a supplier-relationship problem and often a price problem at the next negotiation — or the payables balance contains something that is not trade credit.

Then decompose the gap. A DPO well above terms usually resolves into one of four things: genuine slow payment; accruals and other non-trade liabilities parked in the same balance sheet caption; a supplier finance or reverse-factoring programme, where a bank pays your supplier early and you settle with the bank later; or year-end timing, where a heavy December purchasing month inflates the closing balance that a closing-basis calculation then annualises.

A DPO far below terms is usually deliberate and worth checking against the discount arithmetic in the table below. Paying at day 10 to capture a 2% discount on net 30 terms is a return of roughly 37% a year on the cash you advanced. Almost no company can borrow at 37%, so taking the discount is normally correct even when it drags DPO down. A low DPO with no discount attached to it is the version worth investigating: you are financing suppliers for nothing.

Finally, do not read DPO alone. A firm with a 60-day DPO, a 90-day inventory period and a 45-day collection period still has a 75-day cash cycle to fund. The payables leg only tells you how much of that funding your suppliers are providing, which is why it belongs in the working capital picture rather than on its own dashboard tile.

What early-payment discounts are worth, and the DPO they imply

Annualised cost of passing up a discount, computed as d ÷ (100 − d) × 365 ÷ (net days − discount days). Terms of 2/10 net 30 mean 2% off if you pay within 10 days, otherwise the full amount at day 30.
TermsDPO if you take the discountDPO if you pay at netAnnualised cost of forgoing it
3/10 net 3010 days30 days56.4%
2/10 net 3010 days30 days37.2%
2/15 net 4515 days45 days24.8%
2/10 net 4510 days45 days21.3%
1/10 net 3010 days30 days18.4%
2/15 net 6015 days60 days16.6%
2/10 net 6010 days60 days14.9%
1/15 net 4515 days45 days12.3%
1/10 net 6010 days60 days7.4%

Worked for the first row: 3 ÷ 97 = 0.030928, and 365 ÷ 20 = 18.25, so 0.030928 × 18.25 = 0.5644, or 56.4% a year. Compare each figure against your own marginal borrowing rate: above it, take the discount and accept the lower DPO; below it, hold the cash to the net date.

Supplier finance programmes now have to be disclosed

Reverse factoring lets a bank pay your suppliers early while you settle with the bank on a longer clock. Economically that is borrowing; presented as trade payables, it lengthens DPO without any change in your relationship with the supplier. FASB Accounting Standards Update 2022-04, Liabilities — Supplier Finance Programs (Subtopic 405-50), requires a buyer to disclose the key terms of such programmes and the amount of obligations outstanding under them. When you benchmark a competitor's DPO, read that disclosure before concluding they negotiate better than you do — and when you report your own, say which part of the balance is programme obligations.

Mistakes that make a DPO figure wrong

  • Mismatching the periods. A quarterly payables balance divided by an annual cost base, then multiplied by 365, gives a number roughly four times too large. The balance, the cost base and the day count must all describe the same window.
  • Including non-trade liabilities. Accrued payroll, accrued interest, deferred revenue and income taxes payable often sit inside the same balance sheet caption. Strip them out or say that you did not.
  • Using COGS where inventory moved a lot. If you built inventory during the period, purchases exceeded COGS and DPO is overstated. Rebuild the denominator as COGS plus the inventory increase.
  • Treating the target cash effect as annual. Extending terms releases cash once. Only the avoided interest on that cash recurs, and only until the supplier reprices.
  • Comparing an average-basis figure with a closing-basis one. The two conventions can differ by several days on the same company in the same year. Fix the convention before you rank anyone.
  • Reading a rising DPO as unambiguously good. Below your contracted terms it is treasury discipline; above them it can be distress, and the ratio does not distinguish the two.

Where DPO sits among the working capital metrics

DPO is one third of the cash conversion cycle: CCC = DIO + DSO − DPO. The three are measured the same way — a balance sheet stock divided by the income statement flow that drives it, scaled to days — and they are usually improved in the wrong order. Management stretches payables first because it needs no operational change, then discovers that the supplier repriced, and only afterwards attacks the inventory turns that produce a durable improvement.

For credit analysis the useful move is to read DPO against liquidity. A company whose current ratio is falling while DPO climbs is funding itself from suppliers because other funding is unavailable, and the payables balance is a short-dated, unsecured, and highly nervous liability. A company whose DPO climbs while cash also climbs is more likely to be exercising negotiating power.

If you want the same measurement on the sales side, use the days sales outstanding calculator; for the denominator itself, the cost of goods sold calculator builds COGS from opening inventory, purchases and closing inventory, which is also the identity you invert to get credit purchases.

Key terms

Trade payables
Amounts owed to suppliers for goods and services already received and invoiced. Distinct from accruals, which are amounts owed for goods and services received but not yet invoiced.
Credit purchases
Goods and services bought on account during the period. Reconstructed as cost of goods sold plus the increase in inventory, since anything bought and not sold ends the period in inventory.
Reverse factoring
A supplier finance arrangement in which a bank pays your supplier early at a discount and you repay the bank on the original or a longer schedule. Disclosure of the outstanding balance is required under FASB ASU 2022-04.
Payables turnover
Cost base divided by average payables. The reciprocal of DPO scaled by the day count: turnover multiplied by DPO always equals the days in the period.

Frequently asked questions

Is a high DPO good or bad?

A high DPO is favourable up to your contracted terms and ambiguous beyond them. Inside your terms it means you are using free supplier credit fully, which shortens the cash conversion cycle and reduces borrowing. Beyond your terms it means you are paying late, and late payment costs you at the next price negotiation, in priority during shortages, and sometimes in interest under contract. The ratio itself cannot tell the two apart, so always read it against the terms on your purchase orders.

Should I use COGS or credit purchases in the denominator?

Use credit purchases when you have them and inventory moved materially; use COGS when you are comparing against published figures. Payables are created by purchases, so purchases are the theoretically correct flow. Build them as cost of goods sold plus closing inventory minus opening inventory. If inventory was roughly flat the two denominators give almost the same answer, and COGS has the advantage that every peer figure you will find is computed that way.

What is the difference between DPO and payables turnover?

They are the same measurement in different units. Payables turnover is the cost base divided by payables; DPO is the days in the period divided by that turnover. A turnover of 12.4 on a 365-day year is a 29.4-day payment period. Use turnover when comparing against other turnover ratios such as inventory or asset turnover, and DPO when you want a figure a supplier or a treasurer will recognise immediately.

How much cash does extending payment terms actually release?

One-off, it releases the extra days multiplied by your cost of sales per day. Moving from 30 to 45 days on a $6.2 million cost base releases 15 x $16,986 = about $255,000, and it arrives once during the transition. After that, cash paid out again equals cost incurred; the payables balance simply sits higher. The recurring benefit is only the interest you avoid on the borrowing that released cash displaces.

Why is my DPO enormous when the business seems to pay on time?

Almost always the payables caption contains something that is not trade credit, or the denominator is wrong for the business model. Check for accrued payroll, accrued interest, taxes payable and deferred revenue inside the same line. Then check whether cost of goods sold is a meaningful proxy for what you buy: a services or software business with a small COGS line and large payroll and marketing payables will produce a huge DPO that means nothing.

Which convention do stock screeners use, average or closing payables?

Most screeners use the closing balance, because they hold one balance sheet per filing. That makes their figures sensitive to year-end purchasing patterns: a heavy final quarter inflates the closing balance and therefore the reported payment period. Untick the averaging box in this calculator to reproduce the screener convention, and make sure both sides of any comparison use the same one before you draw a conclusion from the gap.

Can DPO be negative or zero?

Zero happens when the payables balance is zero, which means you pay on delivery and finance the whole purchasing cycle yourself. Negative is not a meaningful result: it only appears if you enter a negative payables balance, which usually means you have picked up a debit balance caused by supplier prepayments or overpayments sitting in the payables ledger. Reclassify those to other receivables and recompute.

How does a supplier finance programme change the number?

It lengthens DPO without lengthening the time your supplier waits, because a bank bridges the gap. The supplier is paid early at a discount, you pay the bank later, and the obligation often stays classified as trade payables. FASB ASU 2022-04 requires buyers to disclose the terms and the outstanding amount of such programmes, so check that disclosure before crediting a peer's long payment period to negotiating strength.

What target payment period should I enter?

Enter the weighted average of the terms you have actually agreed with your suppliers, not an industry figure. If most of your spend is net 30 and a large contract is net 60, weight them by spend. The calculator then shows the gap between where you are and where your own contracts say you should be, which is the only comparison that supports a decision without renegotiating anything.

References