What Days Payable Outstanding Measures (and Why It Matters for Cash Flow)
Days Payable Outstanding tracks how long a business holds cash before paying its suppliers. At its core, it’s a working-capital efficiency metric—one that tells you whether a company is preserving liquidity or rushing payments out the door.
For investors, DPO surfaces in diligence across multiple dimensions. It sheds light on liquidity cushions, vendor concentration, and payment-term leverage. A rising DPO might signal tighter negotiations with suppliers or intentional cash preservation. A falling DPO can indicate a shift toward early-pay discounts or pressure to accelerate payments.
Ultimately, DPO helps you assess how effectively management balances short-term cash needs with supplier relationships.
Days Payable Outstanding Formula (AP, COGS, and Days in Period)
The most common formula is straightforward:
DPO = (Accounts Payable × Days) ÷ COGS
Here, Accounts Payable reflects what the company owes suppliers at a point in time. COGS (cost of goods sold, or cost of sales) represents the expenses incurred to produce or acquire inventory. Days refers to the period you’re analyzing—365 for annual, roughly 90 for quarterly, or 30 for monthly.
One key decision is whether to use ending AP or average AP. Ending AP offers a snapshot but can be skewed by quarter-end timing or large one-time purchases. Average AP—typically the mean of beginning and ending balances—smooths out those swings and is preferred for modeling and peer comparisons.
Similarly, if you’re calculating DPO for a quarter, use ~90 days (or the exact number of days in that quarter). For a trailing-twelve-month view, stick with 365.
How to Calculate Days Payable Outstanding (Step-by-Step)
1) Gather inputs and align periods
Pull Accounts Payable from the balance sheet and COGS from the income statement. Make sure both figures cover the same period. If you’re using average AP, grab the opening and closing balances for that window.
2) Choose AP method (ending vs. average) and compute
Decide whether ending AP or average AP fits your use case. Then plug your numbers into the formula. For example, if average AP is $500,000, COGS is $3,650,000, and you’re analyzing a full year (365 days):
DPO = (500,000 × 365) ÷ 3,650,000 = 50 days
3) Sanity-check for seasonality and one-time items
Review for large prepayments, year-end accruals, or seasonal spikes in inventory purchases. If COGS includes unusual charges (restructuring costs, write-downs), consider normalizing the denominator to avoid distortion.
Worked Example (Quick Days Payable Outstanding Calculation)
Assume a company reports:
- Ending Accounts Payable: $600,000
- COGS for the year: $4,380,000
- Period: 365 days
DPO = (600,000 × 365) ÷ 4,380,000 ? 50.0 days
Now suppose you have beginning AP of $400,000. Average AP becomes (400,000 + 600,000) ÷ 2 = $500,000.
DPO = (500,000 × 365) ÷ 4,380,000 ? 41.6 days
The difference—8.4 days—illustrates why the choice between ending and average AP matters. If AP grew sharply during the period, ending AP will inflate DPO relative to the underlying payment pattern.
How to Interpret Days Payable Outstanding: High vs. Low, "Good" DPO, and Benchmarks
From an investor lens, a higher DPO means the company retains cash longer, boosting near-term liquidity and reducing working-capital needs. But stretch too far and you risk supplier pushback, late fees, or forfeited early-payment discounts.
A lower DPO can signal strong supplier relationships, access to attractive discounts, or simply shorter standard payment terms. It may also point to weaker negotiating leverage or management prioritizing vendor goodwill over cash optimization.
There’s no universal "good" DPO. Instead, benchmark against close industry peers. A software company with minimal inventory will have a different profile than a retailer managing vast supplier networks. Track trends quarter over quarter and year over year to spot shifts in payment behavior.
DPO also connects directly to the Cash Conversion Cycle (CCC), which combines Days Inventory Outstanding (DIO), Days Sales Outstanding (DSO), and DPO:
CCC = DIO + DSO ? DPO
All else equal, raising DPO shortens the cash conversion cycle, meaning the business recovers cash faster. But remember to assess DIO and DSO in tandem—optimizing one metric in isolation can mask underlying working-capital stress.
How to Optimize Days Payable Outstanding Without Breaking Vendor Relationships
The most direct lever is renegotiating payment terms. Instead of net-30, push for net-45 or net-60 where feasible. Larger buyers often have room to extend terms without damaging supplier trust.
Improving internal AP workflow can also help. Faster invoice approval and centralized payment scheduling let you time outflows intentionally rather than scrambling at month-end.
When suppliers offer early-payment discounts—say, 2/10 net-30 (2% discount if paid within 10 days)—compare the implied annualized return to your cost of capital. A 2% discount over 20 days works out to roughly 36% annualized, often worth capturing.
In diligence, watch for red flags: stretched payables that balloon relative to COGS, rising disputes or chargebacks, and commentary in supplier earnings calls about payment delays. These can signal supply disruption risk or deteriorating relationships that may not yet show up in financial statements.
FAQ: Days Payable Outstanding (DPO)
What is Days Payable Outstanding (DPO)?
DPO measures the average number of days a company takes to pay suppliers (accounts payable), indicating working-capital efficiency and short-term liquidity.
How do you calculate DPO?
Common approach: DPO = (Accounts Payable × Days in Period) ÷ COGS. Many analysts use average AP for the period and 365 (annual) or ~90 (quarterly) days.
Should I use ending accounts payable or average accounts payable?
Average AP is typically more stable for modeling and comparisons; ending AP can be distorted by seasonality, large one-time purchases, or quarter-end payment timing.
What is a "good" DPO?
There’s no universal target. "Good" depends on industry norms, supplier leverage, payment terms, and discount programs—benchmark against close peers and track trends over time.
Is a higher DPO better or worse?
Higher DPO can improve near-term cash flow (cash retained longer) and reduce the cash conversion cycle, but may increase supplier risk, late fees, or lost early-pay discounts if pushed too far.
How does DPO relate to the Cash Conversion Cycle (CCC)?
CCC is commonly expressed as CCC = DIO + DSO ? DPO. Holding DIO and DSO constant, a higher DPO reduces CCC (faster cash recovery).
How can a company improve DPO without harming supplier relationships?
Typical levers include renegotiating terms, improving invoice approval timing, using scheduled payments, and selectively taking (or skipping) early-payment discounts based on the implied return.
How is DPO used in financial modeling and underwriting?
Analysts often project payables from COGS using a DPO assumption to estimate working-capital needs and cash flow—especially when stress-testing liquidity, covenants, and deal structure.
What are common pitfalls when using DPO?
Mixing COGS vs. total operating expenses, ignoring seasonality, comparing across incompatible industries, and interpreting a spike in DPO as "good" when it may signal supplier strain or payment distress.
