How to calculate DPO
Calculating DPO can help you measure the efficiency of your company.
There are two formulas you can use to calculate DPO:
DPO = Average accounts payable x Number of days / COGS
DPO = Average accounts payable / (COGS / Number of days)
You'll need to know three factors to perform the calculation:
- Average accounts payable. This represents the amount your company owes to your suppliers. Average accounts payable can be found as a line item on your balance sheet.
- Number of days. The number of days in a period is often 365 for a full year, 90 days per quarter, or 30 days for a month.
- Cost of goods sold (COGS). This represents the cost of acquiring or manufacturing the products your company sells over a period of time. Examples of COGS include the materials and labour required to make a product or perform a service, and overhead costs such as electricity.
You can use the following formula to calculate COGS:
Cost of goods sold (COGS) = Beginning inventory + Purchases - Ending inventory
Suppose your company, Amazing Goods, has an average accounts payable of $100,000 and a COGS of $1,000,000. We want to calculate the DPO for a year (365 days):
Average accounts payable x Number of days / COGS = DPO
$100,000 x 365 / $1,000,000 = 36.5 days
The company takes an average of 37 days to pay back its accounts payable.