⚡ Quick answer
Calculate Days Payable Outstanding (DPO) using the formula: DPO = (Accounts Payable ÷ COGS) × 365 to understand how long your company takes to pay suppliers.
Days Payable Outstanding
Average days to pay suppliers from payables and COGS.
📖 What it is
Days Payable Outstanding (DPO) is a critical financial metric that measures the average number of days a company takes to pay its suppliers. This calculation helps businesses assess their cash flow and supplier relationships.
To calculate DPO, you need two key inputs: accounts payable (AP) and cost of goods sold (COGS). The output is the average number of days it takes to settle supplier invoices, which can inform payment strategies and liquidity management.
Assumptions in this calculation include that the COGS is annualized and that accounts payable reflects only trade payables. It's important to avoid seasonal fluctuations that might skew results, especially if your COGS varies significantly throughout the year.
How to use
- Identify your total accounts payable.
- Determine your annual Cost of Goods Sold (COGS).
- Apply the formula: DPO = (Accounts Payable ÷ COGS) × 365.
- Interpret the result to assess payment timing.
- Adjust payment strategies based on DPO insights.
📐 Formulas
- Days Payable Outstanding (DPO)—(Accounts Payable ÷ COGS) × 365
- Annual COGS—Total COGS for the year
- Average Accounts Payable—Total outstanding payables
💡 Example
Given accounts payable of $90,000 and annual COGS of $1,200,000:
1. Calculate DPO:
DPO = ($90,000 ÷ $1,200,000) × 365 ≈ 27.4 days.
This indicates that the company takes approximately 27.4 days to pay its suppliers.
Real-life examples
Example 1
A company with accounts payable of $90,000 and annual COGS of $1,200,000 has a DPO of approximately 27.4 days.
Example 2
Another firm with accounts payable of $150,000 and COGS of $1,500,000 calculates a DPO of 36.5 days.
Scenario comparison
- Low DPO—Indicates prompt payments, potentially strengthening supplier relationships but may impact cash flow.
- High DPO—Suggests extended payment periods, which can improve cash flow but may strain supplier relations.
Common use cases
- Evaluate supplier payment strategies.
- Analyze cash flow management.
- Benchmark against industry standards.
- Optimize supplier negotiation terms.
- Assess financial health of the business.
- Make informed decisions on working capital.
- Adjust inventory purchasing policies.
- Plan for cash reserves and liquidity.
How it works
This tool calculates the Days Payable Outstanding (DPO) by taking the total accounts payable and dividing it by the annual cost of goods sold, then multiplying by 365. This formula provides insights into the company's payment practices.
What it checks
This tool checks the average days it takes for a business to pay its suppliers based on accounts payable and COGS data.
Signals & criteria
- Accounts Payable (AP)
- Cost of Goods Sold (COGS)
- Payment Practices
Typical errors to avoid
- Accrual timing mismatch.
- Including non-trade payables.
- Seasonal COGS fluctuations.
Decision guidance
Trust workflow
Recommended steps after getting a result:
- Gather accurate accounts payable data.
- Ensure COGS is annualized and reflects the relevant period.
- Calculate DPO and interpret the results in the context of your cash flow management.
FAQ
FAQ
Purchases vs COGS?
Alternate formulas use purchases; this uses COGS as a common shortcut.