Days Payable Outstanding Calculator: AP, COGS & Days

Is a days payable outstanding of 30.00 days healthy?

On the defaults — $150,000.00 of accounts payable and $1,825,000.00 of cost of goods sold over 365 days — the days payable outstanding is 30.00 days, the accounts payable needed for a 30-day DPO is $150,000.00, and the cost of goods sold needed for a 30-day DPO is $1,825,000.00. The days payable outstanding — accounts payable divided by cost of goods sold, times the days in the period — is the payables test: how many days, on average, you take to pay your suppliers. A DPO under 30 days is generally strong for supplier relationships; 30–45 days is typical for many businesses; over 60 days usually means you are stretching suppliers, which can cost you early-payment discounts and goodwill. Retail businesses often run a low DPO because suppliers demand fast payment; manufacturers often run 40–50 days; construction can run 60 days or more because invoices are large and payment terms are long. The same DPO can mean different things by industry — a retailer and a construction firm do not pay the same way — so compare within an industry, not across them.

Four things about the model are worth stating plainly. First, the days payable outstanding is the accounts payable divided by the cost of goods sold, times the days in the period — $150,000.00 ÷ $1,825,000.00 × 365 = 30.00 days. Second, the accounts payable needed at the target is the cost of goods sold times the target DPO, divided by the days in the period — $1,825,000.00 × 30 ÷ 365 = $150,000.00. Third, the cost of goods sold needed at the target is the accounts payable times the days in the period, divided by the target DPO — $150,000.00 × 365 ÷ 30 = $1,825,000.00. And fourth, the DPO is the mirror of days sales outstanding — DSO plus days inventory outstanding minus DPO is the cash conversion cycle — and using average accounts payable — (opening + closing) ÷ 2 — gives a steadier figure than a single end-of-period snapshot; all listed in Accuracy & limitations.

The worked example, line by line

Setup: $150,000.00 of accounts payable, $1,825,000.00 of cost of goods sold, 365 days in the period, target DPO 30 days.

Line 1 — the days payable outstanding. The days payable outstanding is $150,000.00 ÷ $1,825,000.00 × 365 = 30.00 days.

Line 2 — the accounts payable needed. The accounts payable needed for a 30-day DPO is $1,825,000.00 × 30 ÷ 365 = $150,000.00.

Line 3 — the cost of goods sold needed. The cost of goods sold needed for a 30-day DPO is $150,000.00 × 365 ÷ 30 = $1,825,000.00.

Line 4 — the check. $150,000.00 ÷ $1,825,000.00 × 365 = 30.00 days, the target; and $150,000.00 ÷ $1,825,000.00 × 365 = 30.00 days, the target again.

Every branch, checked

Accounts payable $75,000: Days payable outstanding 15.00 days; accounts payable needed for the 15-day target $75,000.00; cost of goods sold needed for the 15-day target $1,825,000.00 — With accounts payable of $75,000.00 the DPO falls to 15.00 days — suppliers paid twice as fast, in the strong band.

Cost of goods sold $912,500: Days payable outstanding 60.00 days; accounts payable needed for the 60-day target $150,000.00; cost of goods sold needed for the 60-day target $912,500.00 — With cost of goods sold of $912,500.00 the DPO rises to 60.00 days — the slow band: you are stretching suppliers, which can cost you early-payment discounts and goodwill.

Accounts payable $225,000: Days payable outstanding 45.00 days; accounts payable needed for the 45-day target $225,000.00; cost of goods sold needed for the 45-day target $1,825,000.00 — With accounts payable of $225,000.00 the DPO is 45.00 days — the top of the typical 30–45 day band.

Days in period 90: Days payable outstanding 7.40 days; accounts payable needed for the 7.4-day target $150,055.56; cost of goods sold needed for the 7.4-day target $1,824,324.32 — Over a 90-day quarter the same payables and costs give a DPO of 7.40 days — the same money, measured over a shorter window.

Accounts payable $37,500: Days payable outstanding 7.50 days; accounts payable needed for the 7.5-day target $37,500.00; cost of goods sold needed for the 7.5-day target $1,825,000.00 — With accounts payable of $37,500.00 the DPO falls to 7.50 days — cash leaves fast.

Cost of goods sold $3,650,000: Days payable outstanding 15.00 days; accounts payable needed for the 15-day target $150,000.00; cost of goods sold needed for the 15-day target $3,650,000.00 — With cost of goods sold of $3,650,000.00 the DPO falls to 15.00 days — near the retail pace.

Accounts payable $0: Days payable outstanding 0.00 days; accounts payable needed for the 30-day target $150,000.00; cost of goods sold needed for the 30-day target $0.00 — With no accounts payable the DPO is 0.00 days — nothing owed.

The reverses, worked backwards

Largest whole-dollar accounts payable for the DPO to STAY at or below 30 days: At the displayed $150,000 the figures are Days payable outstanding 30.00 days; accounts payable needed for the 30-day target $150,000.00; cost of goods sold needed for the 30-day target $1,825,000.00. At the displayed $150,000 the days payable outstanding is 30.00 days. At $150,001 the payables are $1 over the $150,000 allowed — and the unrounded DPO is 30.000200 days, which displays as 30.00 days after rounding, so $150,000 is the largest whole-dollar accounts payable for the DPO to stay at or below 30 days.

Smallest whole-dollar cost of goods sold for the DPO to stay at or below 25 days: At the displayed $2,190,000 the figures are Days payable outstanding 25.00 days; accounts payable needed for the 25-day target $150,000.00; cost of goods sold needed for the 25-day target $2,190,000.00. At the displayed $2,190,000 the days payable outstanding is 25.00 days. At $2,189,999 the costs are $1 short of the $2,190,000 needed — and the unrounded DPO is 25.000011 days, which displays as 25.00 days after rounding, so $2,190,000 is the smallest whole-dollar cost of goods sold for the DPO to stay at or below 25 days.

Largest whole-dollar accounts payable for the DPO to STAY at or below 45 days: At the displayed $225,000 the figures are Days payable outstanding 45.00 days; accounts payable needed for the 45-day target $225,000.00; cost of goods sold needed for the 45-day target $1,825,000.00. At the displayed $225,000 the days payable outstanding is 45.00 days. At $225,001 the payables are $1 over the $225,000 allowed — and the unrounded DPO is 45.000200 days, which displays as 45.00 days after rounding, so $225,000 is the largest whole-dollar accounts payable for the DPO to stay at or below 45 days.

Smallest whole-dollar cost of goods sold for the DPO to stay at or below 20 days: At the displayed $2,737,500 the figures are Days payable outstanding 20.00 days; accounts payable needed for the 20-day target $150,000.00; cost of goods sold needed for the 20-day target $2,737,500.00. At the displayed $2,737,500 the days payable outstanding is 20.00 days. At $2,737,499 the costs are $1 short of the $2,737,500 needed — and the unrounded DPO is 20.000007 days, which displays as 20.00 days after rounding, so $2,737,500 is the smallest whole-dollar cost of goods sold for the DPO to stay at or below 20 days.

Smallest whole-dollar accounts payable for the DPO to reach 40 days: At the displayed $200,000 the figures are Days payable outstanding 40.00 days; accounts payable needed for the 40-day target $200,000.00; cost of goods sold needed for the 40-day target $1,825,000.00. At the displayed $200,000 the days payable outstanding is 40.00 days. At $199,999 the payables are $1 short of the $200,000 needed — and the unrounded DPO is 39.999800 days, which displays as 40.00 days after rounding, so $200,000 is the smallest whole-dollar accounts payable for the DPO to reach 40 days.

Largest whole-dollar accounts payable for the DPO to STAY at or below 15 days: At the displayed $75,000 the figures are Days payable outstanding 15.00 days; accounts payable needed for the 15-day target $75,000.00; cost of goods sold needed for the 15-day target $1,825,000.00. At the displayed $75,000 the days payable outstanding is 15.00 days. At $75,001 the payables are $1 over the $75,000 allowed — and the unrounded DPO is 15.000200 days, which displays as 15.00 days after rounding, so $75,000 is the largest whole-dollar accounts payable for the DPO to stay at or below 15 days.

A warning about the neighbours: every neighbour above shows as the target when rounded to two decimals, but its unrounded DPO is a hair above or below the target. A supplier underwriting on the unrounded DPO would still say no where the unrounded figure misses the line. The page prints the unrounded neighbour value in full so the rounding does not mislead you: 30.000200, 25.000011, 45.000200, 20.000007, 39.999800 and 15.000200 days.

What the defaults assume

The defaults are $150,000.00 of accounts payable, $1,825,000.00 of cost of goods sold, 365 days in the period and a target DPO of 30 days — Days payable outstanding 30.00 days; accounts payable needed for the 30-day target $150,000.00; cost of goods sold needed for the 30-day target $1,825,000.00. With Accounts payable $75,000, Days payable outstanding 15.00 days; accounts payable needed for the 15-day target $75,000.00; cost of goods sold needed for the 15-day target $1,825,000.00. With Cost of goods sold $912,500, Days payable outstanding 60.00 days; accounts payable needed for the 60-day target $150,000.00; cost of goods sold needed for the 60-day target $912,500.00. With Accounts payable $225,000, Days payable outstanding 45.00 days; accounts payable needed for the 45-day target $225,000.00; cost of goods sold needed for the 45-day target $1,825,000.00. With Days in period 90, Days payable outstanding 7.40 days; accounts payable needed for the 7.4-day target $150,055.56; cost of goods sold needed for the 7.4-day target $1,824,324.32. With Accounts payable $37,500, Days payable outstanding 7.50 days; accounts payable needed for the 7.5-day target $37,500.00; cost of goods sold needed for the 7.5-day target $1,825,000.00. With Cost of goods sold $3,650,000, Days payable outstanding 15.00 days; accounts payable needed for the 15-day target $150,000.00; cost of goods sold needed for the 15-day target $3,650,000.00. With Accounts payable $0, Days payable outstanding 0.00 days; accounts payable needed for the 30-day target $150,000.00; cost of goods sold needed for the 30-day target $0.00. With Cost of goods sold $0, Days payable outstanding — (undefined: no cost of goods sold to divide by); accounts payable needed for the 30-day target $0.00; cost of goods sold needed for the 30-day target $1,825,000.00. With Accounts payable $0, Days payable outstanding 0.00 days; accounts payable needed for the 30-day target $150,000.00; cost of goods sold needed for the 30-day target $0.00. With Accounts payable $98,765, cost of goods sold $1,234,567, Days payable outstanding 29.20 days; accounts payable needed for the 30-day target $101,471.26; cost of goods sold needed for the 30-day target $1,201,640.83. With Accounts payable $500,000, Days payable outstanding 100.00 days; accounts payable needed for the 30-day target $150,000.00; cost of goods sold needed for the 30-day target $6,083,333.33. With Cost of goods sold $1,000,000, Days payable outstanding 54.75 days; accounts payable needed for the 30-day target $82,191.78; cost of goods sold needed for the 30-day target $1,825,000.00. With Accounts payable $150,001, Days payable outstanding 30.00 days; accounts payable needed for the 30-day target $150,000.00; cost of goods sold needed for the 30-day target $1,825,012.17. With Target bars — accounts payable $150,000, cost of goods sold $1,825,000, accounts payable needed at the 20-day target $100,000.00; at the 45-day target $225,000.00; cost of goods sold needed at the 20-day target $2,737,500.00; at the 45-day target $1,216,666.67.

A note on the rounding: with accounts payable of $98,765 and cost of goods sold of $1,234,567 the unrounded days payable outstanding is 29.199894 days, which rounds half-up to 29.20 days — the page prints the unrounded value so the rounding does not mislead you. With accounts payable of $150,001 and cost of goods sold of $1,825,000 the unrounded days payable outstanding is 30.000200 days, which rounds to 30.00 days. With accounts payable of $500,000 the DPO is 100.00 days, and with cost of goods sold of $1,000,000 the DPO is 54.75 days.

Output · formula · meaning

Who uses this

• The small-business owner checking the year: they learn $150,000.00 of accounts payable on $1,825,000.00 of cost of goods sold gives a DPO of 30.00 days — and they check the $150,000 reverse to see the largest payables that still stay at or below 30 days.
• The finance manager stretching cash: they learn a DPO under 30 days is generally strong for supplier relationships and over 60 days usually means stretching suppliers — and they check the $2,190,000 reverse to see the smallest cost of goods sold that stays at or below a 25-day DPO.
• The manufacturer whose DPO slipped to 45.00 days: they learn the business sits at the top of the typical 30–45 day band — and they check the $225,000 reverse to see the largest payables that stay at or below 45 days.
• The retailer paying in about 15 days: they learn a low DPO is normal for retail because suppliers demand fast payment — and they check the $2,737,500 reverse to see the smallest cost of goods sold that stays at or below a 20-day DPO.

Accuracy & limitations

The math is first-principles: the days payable outstanding is the accounts payable divided by the cost of goods sold, times the days in the period, rounded to two decimals half-up; the accounts payable needed at the target is the cost of goods sold times the target DPO, divided by the days in the period; the cost of goods sold needed at the target is the accounts payable times the days in the period, divided by the target DPO. The reverses are judged on the UNROUNDED DPO: a neighbour one dollar short or over shows as the target when rounded to two decimals, but its unrounded DPO is above or below the target, so it does not meet the bar — the page prints the unrounded neighbour value in full. What the model cannot do is judge the business: only CREDIT purchases count — cash purchases are excluded, because cash is already paid; the average accounts payable is (opening + closing) ÷ 2, a simple average that hides swings inside the period; with cost of goods sold of $0 the DPO is undefined — the calculator shows “—” with a note, never Infinity or NaN; with accounts payable of $0 the DPO is 0.00 days — nothing owed; a high DPO means cash stays in your business longer but can strain relationships and lose you discounts; a low DPO means suppliers are happy and discounts are captured, but cash leaves fast; and the same DPO means different things by industry, so compare within an industry, not across them. DPO differs from days sales outstanding, which tests how fast your customers pay you, and from the cash conversion cycle, which combines receivables, inventory and payables. Use it to see how fast you pay your suppliers — then read the rest of the statements.

Frequently asked questions