Wall Street Prep

Accounts Payable Turnover

Understand the Accounts Payable Turnover Concept

Learn Online Now

Accounts Payable Turnover

In This Article
  • What does the accounts payable turnover ratio measure?
  • What formula calculates the accounts payable turnover ratio?
  • How are the accounts payable turnover and days payable outstanding (DPO) metrics related?
  • Is a higher or lower accounts payable turnover better?

How to Calculate Accounts Payable Turnover

As part of the normal course of business, companies are often provided short-term lines of credit from creditors, namely suppliers.

The accounts payable turnover, or “payables turnover”, is a ratio used to evaluate how quickly a company repaid those that offered them a line of credit, i.e. the frequency at which a company pays off its accounts payable balance.

Calculating the accounts payable ratio consists of dividing a company’s total supplier credit purchases by its average accounts payable balance.

The “Supplier Credit Purchases” refers to the total amount spent ordering from suppliers.

The total supplier purchase amount should ideally only consist of credit purchases, but the gross purchases from suppliers can be used if the full payment details are not readily available.

Moreover, the “Average Accounts Payable” equals the sum of the beginning of period and end of period carrying balances, divided by two.

  • Average Accounts Payable = (Ending AP + Beginning AP) / 2

Accounts Payable Turnover Formula

The formula for calculating the accounts payable turnover is as follows.

Payables Turnover Ratio Formula
  • Accounts Payable Turnover = Supplier Credit Purchases / Average Accounts Payable

In short, the A/P turnover answers:

  • “How often does the company pay off its invoices per year on average?”

For example, if a company’s A/P turnover is 2.0x, then this means it pays off all of its outstanding invoices every six months on average, i.e. twice per year.

So the higher the ratio, the more frequently a company’s invoices owed to suppliers are fulfilled.

Accounts Payable Turnover to Days Payable Outstanding (DPO)

The days payable outstanding (DPO) metric is closely related to the accounts payable turnover ratio.

DPO counts the average number of days it takes a company to pay off its outstanding supplier invoices for purchases made on credit.

The more a supplier relies on a customer, the more negotiating leverage the buyer holds – which is reflected by a higher DPO and lower A/P turnover.

The A/P turnover ratio and the DPO are often a proxy for determining the bargaining power of a specific company (i.e. their relationship with their suppliers).

  • High A/P Turnover and Low DPO ➝ Low Bargaining Leverage and Less Free Cash Flow (FCF)
  • Low A/P Turnover and High DPO ➝ High Bargaining Leverage and More Free Cash Flow (FCF)

Companies like Amazon and Walmart extend their payables outstanding for that reason, i.e. their branding, reputation, and order volume (and size) can all be leveraged to defer supplier payments.

From the date when the credit purchase was made to the date that the company actually paid the supplier in cash, the cash remains in the possession of the buyer, who has the discretion to spend that cash in the meantime (e.g. to reinvest into operations, for capital expenditures).

Interpreting the Payables Turnover – Higher or Lower Ratio?

The rules for interpreting the accounts payable turnover ratio are less straightforward.

For instance, if a company’s accounts receivable turnover is far above that of its peers, there could be a reasonable explanation – however, it is rarely a positive sign, i.e. it typically implies the company is inefficient in its ability to collect cash payments from customers.

But in the case of the A/P turnover, whether a company’s high or low turnover ratio should be interpreted positively or negatively depends entirely on the underlying cause.

  • Positive Scenario: If a company’s A/P turnover is on the lower end because of its buyer power, i.e. the ability of a customer to reduce prices and negotiate favorable terms, which is delaying how quickly suppliers must be repaid in this case.
  • Negative Scenario: Conversely, a company’s A/P turnover could also be low not because of its negotiating leverage but from its inability to repay suppliers even if they wanted to.

In the latter scenario, the company is facing a shortage in liquidity (i.e. low cash on hand), a red flag that could potentially result in the company being in urgent need of restructuring or filing for bankruptcy protection.

Accounts Payable Turnover Excel Calculator

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl
Submitting ...

Payables Turnover Example Calculation

Suppose a company spent $1,000,000 on orders from suppliers in the most recent period (Year 1).

If the company’s accounts payable balance in the prior year was $225,000 and then $275,000 at the end of Year 1, we can calculate the average accounts payable balance as $250,000.

Using those assumptions, we can calculate the accounts payable turnover by dividing the Year 1 supplier purchases amount by the average accounts payable balance.

  • Accounts Payable Turnover = $1,000,000 ÷ $250,000 = 4.0x

The company’s A/P turned four times in Year 1, meaning that its suppliers were repaid each quarter on average.

Accounts Payable Turnover in Days Calculation

Given the A/P turnover ratio of 4.0x, we will now calculate the days payable outstanding (DPO) – or “accounts payable turnover in days” – from that starting point.

If we divide the number of days in a year by the number of turns (4.0x), we arrive at ~91 days.

The 91 days represents the approximate number of days on average that a company’s invoices remain outstanding before being paid in full.

  • Days Payable Outstanding (DPO) = 365 / 4.0x = 91 Days

Accounts Payable Turnover Calculator

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
guest
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.