The days payable outstanding (dpo) calculator works out average accounts payables, days payable outstanding and purchases from beginning inventory, beginning account payable, cost of goods sold, days in accounting period, ending inventory and ending accounts payable. Enter what you have and the relationship is applied straight away, so you get the answer without working through the algebra yourself.
What Is the Days Payable Outstanding (DPO) Calculator?
The days payable outstanding (dpo) calculator takes beginning inventory, beginning account payable, cost of goods sold, days in accounting period, ending inventory and ending accounts payable and turns them into average accounts payables, days payable outstanding and purchases.
It is the kind of calculation you would otherwise do on the back of an envelope: mechanical, repeatable and easy to get subtly wrong without noticing.
How the Days Payable Outstanding (DPO) Figure Is Built
Each result is calculated from the ones before it, so the working is fully visible. That matters when the answer is going to be quoted to somebody else and you need to be able to explain where it came from.
The figures are exactly as good as the assumptions underneath them. Check the rates, the periods and the tax treatment before you rely on the result.
Reading the Result Sensibly
A small change in an input can move the result by much more than you would expect, particularly where the calculation divides by one of the figures you supplied. That is worth understanding before you rely on a figure.
For anything that will be committed to, write the inputs down beside the result. A number you can reproduce is worth far more than one you cannot explain.
A Worked Example
Working through an example, with beginning inventory set to 10, beginning account payable set to 5, cost of goods sold set to 2, the calculator returns purchases of 2, and average accounts payables of 5, and days payable outstanding of 250. Substitute your own figures and the same steps produce the same kind of answer.
Frequently Asked Questions
What do I need to work out average accounts payables?
Enter beginning inventory, beginning account payable, cost of goods sold, days in accounting period, ending inventory and ending accounts payable. The calculator then works through the relationship and reports average accounts payables, days payable outstanding and purchases.
What does the days payable outstanding (dpo) actually calculate?
It takes beginning inventory, beginning account payable, cost of goods sold, days in accounting period, ending inventory and ending accounts payable and converts them into average accounts payables, days payable outstanding and purchases using the standard relationship for this problem. Each step is applied in turn, so every output is traceable back to the numbers you typed in.
How should I enter beginning inventory?
Use the value you actually have, in the unit shown next to the field. Enter every value in the same unit system. The calculator assumes the figures you supply are consistent, so it cannot correct a mistake that happens before the calculation starts.
Do I have to fill in every field?
Only the fields a particular result depends on. If you leave one blank, the results that need it simply show a note instead of a number, and everything else still works.
Is the answer exact?
It is as exact as the formula and the inputs allow. The method itself is the standard one for this problem, so the only sources of error are the figures you enter and the precision you ask for.