How do you calculate and interpret accounts payable turnover and days payable outstanding?

Accounts payable turnover measures how quickly a company pays its suppliers. Days payable outstanding (DPO) converts this into the average number of days it takes to pay.

Formulas

Payable Turnover = Purchases (or COGS) / Average Accounts Payable

DPO = 365 / Payable Turnover

Note: Ideally, use total purchases in the numerator. Since purchases are not always disclosed, COGS is a common proxy.

Example: Foxdale Manufacturing reports:

• COGS: $2,400,000
• Beginning A/P: $180,000
• Ending A/P: $220,000

Average A/P = ($180,000 + $220,000) / 2 = $200,000

Payable Turnover = $2,400,000 / $200,000 = 12.0x

DPO = 365 / 12.0 = 30.4 days

Foxdale takes about 30 days to pay its suppliers on average.

Interpretation: Is Higher or Lower Better?

It depends on context:

• High turnover (low DPO): The company pays suppliers quickly. This may indicate strong cash position and good supplier relationships, or it could mean the company lacks bargaining power and cannot negotiate extended terms.
• Low turnover (high DPO): The company delays payments. This preserves cash and may reflect strong negotiating leverage (e.g., large retailers dictating terms). However, excessively long DPO may signal liquidity problems or strained supplier relationships.

Connection to Cash Conversion Cycle (CCC)

CCC = Days Inventory Outstanding + Days Sales Outstanding - Days Payable Outstanding

A longer DPO reduces the CCC, meaning the company finances itself through suppliers for a longer period. This is generally favorable if the company is not abusing suppliers.

Example:

• DSO: 45 days
• DIO: 60 days
• DPO: 30 days
• CCC = 45 + 60 - 30 = 75 days

If Foxdale negotiates 60-day payment terms (DPO rises to 60):

• CCC = 45 + 60 - 60 = 45 days (significant improvement)

Trend Analysis

Compare DPO over time and against industry peers. A sudden increase in DPO without a corresponding change in payment terms may signal cash flow difficulties. A declining DPO when competitors maintain stable levels could indicate the company is losing supplier leverage.

Exam Tip: Always check whether the question provides purchases or COGS. Use purchases when available; default to COGS when it is not. The CFA exam frequently tests DPO as part of the full cash conversion cycle calculation.

For more ratio analysis practice, explore our CFA Level I question bank.