Days Payable Outstanding DPO Formula Example Calculation

Therefore, days payable outstanding measures what is days payable outstanding how well a company is managing its accounts payable. A DPO of 20 means that, on average, it takes a company 20 days to pay back its suppliers. A low DPO indicates that a company is paying its bills to suppliers quickly, which may suggest that the company is managing its cash flow effectively. A low DPO is considered to be a positive sign for a company’s financial health, as it shows that the company is able to pay its bills in a timely manner. However, higher values of DPO may not always be a positive for the business. The company may also be losing out on any discounts on timely payments, if available, and it may be paying more than necessary.

Days Payable Outstanding Calculation Example (DPO)

It ensures businesses not only understand the metrics but also leverage them strategically for sustained growth. A fashion retailer using supplier financing can pay invoices in 90 days while suppliers receive their payments within 10 days, creating a win-win scenario. While smaller companies may lack the same leverage, they can still negotiate favorable terms by demonstrating reliability and maintaining strong relationships with suppliers. Creditors and investors often analyze DPO alongside other metrics like Days Sales Outstanding (DSO) and Days Inventory Outstanding (DIO) to understand the company’s cash conversion cycle (CCC). One of the key drawbacks is that it does not provide insight into the broader picture of a company’s financial health.

One of the most effective ways a company can do this is by using the days payable outstanding formula. Keep reading to learn everything you need to know, including the definition, formula, limitations, and more. If a company wants to decrease its DPO, it can regularly monitor its accounts payable to identify and resolve any issues that may be delaying payment to suppliers. A company can also more quickly resolve supplier payment problems if it has accurate and up-to-date records.

Another simple but effective way to reduce DSO is to offer multiple payment options. If your customers have to jump through hoops to pay you, they’ll procrastinate. Accepting instant bank transfers, same-day ACH, and credit card payments gives them no excuse for delay. Forwardly supports all of these options, making it frictionless for customers to settle their invoices.

For example, Wal-Mart has historically had DPO as high as days, but with the increase in competition (especially from the online retails) it has been forced to ease the terms with its suppliers. So, while DPO focuses on the company’s payment to vendors, DSO is about collecting money from customers. Therefore, most companies strive to increase their days payable outstanding (DPO) over time.

  • For example, if your payment terms call for net 30 payments but you regularly pay within 20 days, stretch those payments out to the full 30 days.
  • A high DPO can improve liquidity, while a low DPO may build supplier goodwill.
  • For example, a retail company might have a DPO of 45 days, meaning it takes 45 days on average to pay its suppliers.
  • Having a DPO higher than the industry average implies more favourable credit terms compared to competitors.

Negotiation Power

DPO measures a company’s average days to settle its bills and invoices. Essentially, the metric reflects the company’s ability to manage its payables. On the other hand, DSO calculates the average number of days it takes for a company to collect payments after making a sale, indicating the efficiency of its receivables collection. Days Payable Outstanding (DPO) shows how long a company usually takes to pay its suppliers. It’s an important metric in working capital management because it reflects a company’s ability to efficiently manage its accounts payable without jeopardizing supplier relationships. The timeframe within which accounts payable are settled is arguably as important as the repayment itself, making DPO a crucial metric for giving businesses insights.

Struggling to Modernize AP? This Guide Helps You Choose the Right Solution

It includes all direct costs related to the production of goods sold, such as raw materials and labor. It’s important to keep all of these things in mind when analyzing the days outstanding payable ratio. Ultimately, the DPO may depend on the contract between the vendor and the company. In that case, the company will have to weigh the option of holding on the cash versus availing the discount.

How to calculate DPO

  • Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis.
  • Essentially, longer payment terms provide greater financial flexibility, allowing the company to optimize its cash management strategy.
  • Paying early may also allow you to capture early pay discounts, which saves your business money.
  • When you automate AP processes, you digitize all invoice data in one place.
  • The longer an invoice remains unpaid, the higher the risk that it will eventually become uncollectible.
  • When handled well, they support stronger cash flow and healthier vendor relationships.

Companies should benchmark their DPO against industry averages to assess their financial efficiency and maintain competitive supplier terms. By comparing DPO against industry peers, a company can assess its financial efficiency. A significantly higher or lower DPO than competitors might signal operational inefficiencies.

Lack of VisibilityWithout a clear view of outstanding payables, finance teams may struggle to make informed spending decisions. MineralTree, for example, not only allows you to increase efficiency, but also completely control outgoing cash flow by setting instructions for exactly when and how to pay each vendor. Depending on the type of industry the company operates in can have a large impact on DPO. Read how adopting automated cash application systems can enhance business operations.

From 2017 to 2019, Apple’s DPO has been in excess of 100 days, which is beneficial to its short-term liquidity. But the reason some companies can extend their payables, while others cannot, is tied to the concept of buyer power, as referenced earlier. This allows you to look at an industry average and see how a company measures up to the broader industry. To determine the cost of goods sold, you add the beginning inventory to the purchases, then subtract the ending inventory.

Number of days – this is the actual number of days that the account payable and cost of sales in based (for example 365 days). Cost of Sales – this is the total cost incurred by the company in manufacturing the product or bringing the product to a level at which it can be sold to the customer. It includes all direct costs such as raw material, utilities, transportation cost, and rent directly applicable to manufacturing. As mentioned in an earlier section, accounts payable (A/P) can alternatively be projected using a percentage of revenue. In reality, the DPO of companies tends to gradually increase as the company gains more credibility with its suppliers, grows in scale, and builds closer relationships with its suppliers.

Until the payment is made, the amount appears under accounts payable on the balance sheet and must be managed to avoid delays or penalties. When managed well and paid on time, trade payables help your business preserve cash, maintain operational continuity, and strengthen negotiating power with suppliers. But when ignored or poorly managed, they can lead to late fees, broken trust, and missed financial reporting deadlines.

DPO has significant implications for cash flow, operational efficiency, and supplier management. A higher DPO indicates that the company is taking longer to pay its suppliers, which may improve short-term cash flow. However, delaying payments too much could strain supplier relationships. Conversely, a lower DPO might indicate prompt payments, which can enhance supplier trust but may limit the company’s cash flexibility.

If your business shows misalignment between these metrics, you can identify specific areas to strengthen your collection practices. Once the hours are logged, the agency sends an invoice payable in 30 days. Vendor relationships have become more important for organizations looking to scale their services. In fact, 71% of companies noted that their supplier relationships became more strategic over the past year. DPO is just one of many metrics that AP departments may choose to track in order to optimize their cash flow and efficiency. Even a high DPO won’t benefit a company if cash flow isn’t managed effectively.

We can assume the company had $300mm of revenues in 2020, which will grow at 10% each year, in line with our COGS assumption. For example, we divide 110 by $365 and then multiply by $110mm in revenue to get $33mm for the A/P balance in 2021. But note that the COGS is directly related to revenue, thereby revenue indirectly drives the A/P forecast.

After adopting MineralTree, the company gained visibility and control that put their finance team back in the driver’s seat. Now they can adjust their DPO to be more strategic instead of reactive, thus optimizing cash flow. Whether you’re trying to shrink your DPO or otherwise optimize it to balance cash flow and vendor relationships, consider switching to an AP automation solution. These solutions can significantly reduce the burden of manual tasks, streamline AP processes, and avoid errors and late payments. Additionally, your team will have more control and insight into when payment is actually executed.