keyboard_backspace

Payable turnover ratio

share close
Bookmark Posts
check_circle

Bookmark Successfully Added

error_outline

Bookmark Successfully Removed

You can view all your Bookmarks from "My Bookmarks" section

What is Payable turnover ratio ?

As part of financial ratio analysis, activity ratios play an important role. These ratios help in understanding the efficiency at which the company utilizes the resources.

Similarly, another important activity ratio is the Payable turnover ratio.

Let us understand about this turnover ratio in-depth.

Payable turnover ratio meaning

As part of business operations, companies make credit purchases from various vendors.

The amount payable to such vendors is called as Accounts Payable.

Now, the Payable turnover ratio basically indicates the frequency at which the company makes payment to its Account Payable.

It helps in understanding if the company makes the payment to vendors too often or it generally lags the payment due to such vendors.

Hence, understanding the this turnover ratio helps in assessing the overall liquidity position of the company as well. 

Payable turnover ratio formula

payable turnover ratio formula

The formula for the payable turnover ratio is quite logical.

We take Credit Purchases in the numerator and Average accounts payable in the denominator.

Credit purchase refers to the purchase made by the company from various vendors in which payment for such purchases are not made in cash immediately, but after some period.

Now, such amount outstanding towards the vendors is recorded in the Balance Sheet as Accounts Payable.

Hence, Average Accounts Payable is nothing but a simple average of Accounts payable balance as at current period-end and previous-period end.

Below are the important aspects which are relevant while calculating numerator and denominator. 

Credit Purchases

  • Only Credit Purchase has to be taken in the numerator. At times, it is difficult to identify exact credit purchase. Hence, Analysts generally use the Cost of Goods Sold (COGS) as a proxy.
  • Only Credit Purchase has to be considered i.e, any purchases made on cash basis is not to be considered.

Average Accounts Payable

  • The average of both periods accounts payable has to be considered, and not mere closing accounts payable.

Let us calculate the ratio using a hypothetical example

[yuzo id=1213 ]

Payable turnover ratio example

Let us look at our 1st example.

We take Company A and Company B for calculating PTR.

Values given in the examples below are in $ millions.

Consider the below-given income statement for both the companies.

Payable turnover ratio example

To calculate Payable turnover ratio, we need

  • Credit Purchases
  • Average Accounts Payable

It is important to note that only credit purchases need to be considered and not total purchases.

Because in the case of cash purchase, the company will always make the payment for the goods or services it receives. Hence, the question of Accounts Payable balance does not arise.

Credit Purchase value for both the companies can be obtained from the income statement.

  • Company A = $ 500
  • Company B = $800

Now, let us also take a look at total assets for both the companies.

accounts payable turnover ratio example

Average Accounts payable for both the companies can be obtained from the current liability section of the Balance Sheet.

Also, we should not take a mere closing balance of Accounts Payable.

Instead, an average of the past 2 year-end balance has to be taken.

But, in our example, we are given only one-period data.

Hence, given Accounts Payable balance will only be Average Accounts payable.

  • Company A = $300
  • Company B = $400

Now that we know all the values, let us calculate the ratio for both the companies.

Payable turnover ratio = Credit Purchases / Average Accounts Payable

  • Company A = $500/$300 = 1.6 x
  • Company B = $800/$400 = 2 x

What this means is that Company A pays its Average Accounts Payable only 1.6 times during a year.

On the contrary, Company B pays its Average Accounts Payable twice a year.

Keeping other things constant, compared to Company  B, Company A is more efficient since it makes the payment less frequently.

Payable turnover ratio for Walmart

In our next example, let us calculate the Payable turnover ratio using excel.

You can download the turnover ratio template using below option.

Payable Turnover Ratio Template

grade grade grade grade grade

2516

46

FREE

Consider the below-shown Consolidated Income Statement of Walmart.

payable turnover ratio cost of goods sold

 

Credit Purchases

In the case of public companies, it is generally difficult to segregate Credit Purchases from the cost of goods sold since the figure is not directly reported in the Income Statement.

Hence, for the sake of convenience, analysts generally use the Cost of Sales or  Cost of Goods Sold(COGS) as a proxy for Credit Purchases

COGS = $385,301

Also, consider the below-given Balance Sheet extract of Walmart.

 

accounts payable walmart

Average Accounts Payable

  • Accounts Payable 2018= $46,092
  • Accounts Payable 2019= $47,060
  • Average Accounts Payable = ($46,092 + $47,060)/2
  • Average Accounts Payable = $46,576

Now that we know all the values, let us calculate the PTR for Walmart.

 

payable turnover ratio interpretation

 

Payable turnover ratio = COGS / Average Accounts Payable

  • $385,301/$46,576 = 8.3 x

As clearly evident, Payable turnover ratio for Walmart is 8.3 times.

What this means is that Walmart pays its Average Account Payable balance around 8 times during a year.

Now whether the ratio is good or bad depends upon the fact that how is the company’s performance relative to the industry standard.

Payable turnover ratio interpretation

As we have already understood, PTR indicates how frequently the company makes payment towards its account payables.

High payable turnover ratio

  • High payable turnover ratio indicates the company is making the payment more frequently.
  • This indicates that the company has sufficient cash balance to make the payment.
  • It also indicates that the company is inefficiently managing its liquidity position.
  • If the turnover ratio is high, the company’s funds are utilized more frequently which otherwise could have been re-deployed in other profitable projects

Low payable turnover ratio

  • Low payable turnover ratio indicates the company is paying off its accounts payable balance less frequently.
  • This may be an indication that the company is running out of cash or it has insufficient cash.
  • Companies, at times deliberately make less frequent payment towards Account Payable balance.
  • Hence, the company can make better use of cash available. This, in turn, increases the company’s liquidity position.
  • But this strategy may even backfire if the vendors top supplying the goods or services.
  • Hence, management has to be cautious while dealing low payable turnover ratio.

Trend Analysis

As already highlighted, any financial ratios will not give any clear picture when analyzed on a standalone basis.

How the ratio has more historically has to be analyzed.  This is performed as part of Trend Analysis.

Let us look at how PTR has moved historically in case of Facebook- The Social Media Gaint.

Payable turnover ratio facebook

Source

As evident, the Payable turnover ratio for Facebook is  8.7 times. 

This indicates that the company makes the payment towards its Accounts Payable almost 9 times a year.

This ratio, back in 2015 was as low as 5.7 times.

While the company’s cost of sales increased, its Accounts Payable balance did not increase at the same place. Hence, the ratio for Facebook started increasing. 

So, performing trend analysis helps in identifying any unusual pattern. Depending upon the importance of that particular ratio, analysts perform even more in-depth analysis.

Comparison with similar companies

Similar to trend analysis, it is also important to understand the ratio profile of various companies under different sectors as well.

This helps in understanding the cross-sectional industry dynamics.

Walmart vs Home Depot

Payable turnover ratio Walmart, Home Depot, Amazon and ExxonMobil

As you can see companies in the retail sector like Walmart and Home Depot have a Payable Turnover ratio which is in the range of 8 to 10 times. 

This indicates that the vendor from whom these companies make purchases typically provide a similar credit period.

Hence, the ratio for both the company are almost similar for the past 5 years.

Amazon Inc

Amazon Inc is into e-commerce, cloud computing, digital streaming, and artificial  intelligence and other similar business.

Compared to Walmart or Home Depot, Amazon has a relatively lower turnover ratio.

Also, it is very interesting to note that the payable turnover ratio for Amazon has been stagnant for past 5 years in the range of 3.6 times to 3.8 times.

This indicates the efforts of the company in managing its Accounts Payables.

This, in turn, helps the company in boosting its liquidity position.

ExxonMobil

ExxonMobil is a US-based multinational oil and gas company.

Generally, oil and gas companies are into highly capital intensive business.

The payable turnover ratio for ExxonMobil is 9 times.

The growth of Account Payable balance outpaced the growth of the cost of goods sold. Hence there is was a decrease in PTR.

Facebook vs Google vs Microsoft

Payable turnover ratio apple facebook google and microsoft

When you calculate the ratio for tech-based companies like Apple, Facebook, Google (Alphabet) and Microsoft, you will observe that the ratio varies from company to company.

Apple

The Payable turnover ratio for Apple is 3 times.

The company is able to maintain this steady-state ratio for past 5 years.

This shows the ability of the company in managing its Account Payable more efficiently.

Facebook

As already highlighted as part of Trend Analysis, the payable turnover ratio for Facebook is 8.7 times.

The ratio was as low as 5.7 times but subsequently it increased gradually to current 8.7 x.

This indicates that the company was making the payment towards accounts payable more frequently.

Microsoft

Similar to Apple, even Microsoft was able to maintain a steady turnover ratio.

Currently, Payable turnover ratio for Microsoft is 4.7 x

Google

Interestingly, the Payable turnover ratio for Google is 15.8 times.

This is relatively high among other tech-based companies.

The company maintains a very moderate Accounts Payable balance compared to its Cost of Sales.

Hence, the ratio for Google is relatively high.

Important considerations

Below are few important aspects one must consider while analyzing any company using Payable turnover ratio.

Credit Purchase vs COGS

As already highlighted, depending upon the availability of information analysts generally use COGS as a proxy to credit purchase in the numerator.

Average Accounts Payable

Also, it is important to take Average Accounts Payable balance and not mere closing Accounts Payable balance in the denominator.

Next reading

Scroll through below recommended resources or learn other important activity ratios

Share on facebook
Facebook
Share on linkedin
LinkedIn
Share on twitter
Twitter
Share on pinterest
Pinterest
Share on whatsapp
WhatsApp
Share on email
Email

Payable Turnover Ratio Template

grade grade grade grade grade

2516

46

FREE