How to use the accounts payable days calculator
Prepare the values for this calculation
Estimate days payable outstanding from average accounts payable and COGS. Use the formula below to check that it answers your question. Read the input units before transferring figures from a statement, measurement or dataset.
Enter and check each input
- Average accounts payable: enter a value at least 0. Use the unit named in the label or selected above. Do not leave this required field blank.
- COGS for period: enter a value at least 1e-06. Use the unit named in the label or selected above. Do not leave this required field blank.
- Days in period: enter a value at least 1. Use the unit named in the label or selected above. Do not leave this required field blank.
The input table gives a complete example. Keep units and time periods consistent across related fields.
Calculate and resolve any input error
Choose Calculate after entering the values. Changes also update the answer after a short pause. If an error appears, follow its message, correct the field and calculate again. Reset restores the example values.
Interpret the answer
Check Days payable outstanding first. With the unchanged example inputs, it is 48.6666666667. Interpret it using the formula and assumptions on this page.
Compare and keep a useful result
For a controlled comparison, keep every other example input unchanged and change Average accounts payable from 120000 to 132000. The resulting Days payable outstanding is 53.5333333333. This illustrates the equation’s response to that input, rather than a forecast of real events.
Read the chart’s axis labels and data table. A scenario curve changes one stated input while holding the others fixed; it does not add external observations. Use Download graph to save an available chart as a PNG.
Use Copy result or Download CSV to keep the answer. Share tool shares the page address without placing your input values in the URL. Recheck inputs and assumptions before using the result for a decision.
Accounts Payable Days Calculator formula
DPO = average accounts payable ÷ COGS × days in period.
Inputs and units
| Input | Format / range | Example |
|---|---|---|
| Average accounts payable | minimum 0 | 120000 |
| COGS for period | minimum 1e-06 | 900000 |
| Days in period | minimum 1 | 365 |
Worked example
Using the example inputs above, the days payable outstanding is 48.6666666667.
- Days payable outstanding
- 48.6666666667
Results and assumptions
The output uses the days payable outstanding convention and formula shown above. Match the entered units and source assumptions when comparing results.
Rates, fees and tax assumptions are entered values. This calculation does not quote a lender, determine a tax liability or guarantee an investment return.
Fix an input or unexpected result
Average accounts payable is required. Enter average accounts payable using the format and bounds in the input table. Zero and an empty field are different: use zero only if it is allowed and represents your data.
If your answer differs from the example, choose Reset and compare every field, including selected units and options. Check percentage versus decimal entry and whether values describe the same period. Round only the final displayed answer when reproducing the formula.
If a discrepancy remains, report the calculator issue with the page address, non-sensitive example inputs, actual result, expected result and a reference for your calculation.