Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the armember-membership domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home1/wanrru6iyyto/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the ARMember domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home1/wanrru6iyyto/public_html/wp-includes/functions.php on line 6114

Warning: Cannot modify header information - headers already sent by (output started at /home1/wanrru6iyyto/public_html/wp-includes/functions.php:6114) in /home1/wanrru6iyyto/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/wanrru6iyyto/public_html/wp-includes/functions.php:6114) in /home1/wanrru6iyyto/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/wanrru6iyyto/public_html/wp-includes/functions.php:6114) in /home1/wanrru6iyyto/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/wanrru6iyyto/public_html/wp-includes/functions.php:6114) in /home1/wanrru6iyyto/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/wanrru6iyyto/public_html/wp-includes/functions.php:6114) in /home1/wanrru6iyyto/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/wanrru6iyyto/public_html/wp-includes/functions.php:6114) in /home1/wanrru6iyyto/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/wanrru6iyyto/public_html/wp-includes/functions.php:6114) in /home1/wanrru6iyyto/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/wanrru6iyyto/public_html/wp-includes/functions.php:6114) in /home1/wanrru6iyyto/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893
{"id":5314,"date":"2016-11-04T16:11:58","date_gmt":"2016-11-04T16:11:58","guid":{"rendered":"https:\/\/businessecon.org\/?p=5314"},"modified":"2023-08-11T15:46:19","modified_gmt":"2023-08-11T15:46:19","slug":"accounts-payable-turnover-rate-ratio-2","status":"publish","type":"post","link":"https:\/\/valueinvestingnow.com\/2016\/11\/accounts-payable-turnover-rate-ratio-2","title":{"rendered":"Accounts Payable Turnover Rate (Ratio)"},"content":{"rendered":"

Accounts Payable Turnover Rate (Ratio)<\/span><\/strong><\/span><\/h1>\n

The accounts payable turnover rate is a business activity ratio measuring the frequency of the company’s ability to pay its vendors and suppliers. The numerical value is customarily reported as an annual value. The higher the number, the more often the payables are cleared (paid). A ’12’ would indicate that all payables are paid every month (360 days\/12 = 30 days). Ideal values exceed 20 as this indicates all accounts are paid on average at least every 18 days (360 days\/20 = 18 days).<\/span><\/p>\n

There are several fundamental principles<\/a> involved with this ratio and as a business entrepreneur you should gain a full understanding of the formula. It is easy to manipulate the results and there is proper application of the formula in business. This paper is designed to enlighten the reader to the formula’s benefits and drawbacks.<\/span><\/p>\n

\"\"<\/a>
Key Business Principle<\/span><\/figcaption><\/figure>\n

THE UNDERLYING GOAL OF THE ACCOUNTS PAYABLE TURNOVER RATE IS TO MEASURE THE FREQUENCY (ABILITY) OF THE BUSINESS TO PAY ITS BILLS IN A TIMELY MANNER.<\/strong><\/span><\/p>\n

<\/div>\n

 <\/p>\n

Accounts Payable Turnover Rate Formula<\/span><\/strong><\/h2>\n

Academia instructs students with the following as the accounts payable turnover rate (ratio) formula:<\/span><\/p>\n

Accounts Payable Turnover Rate = Sales\/Average Accounts Payable Balance<\/span><\/p>\n

The rate is annual value and is the average of the twelve months ending balances. Take the sum total of accounts payable and divided by 12 for the average. Below is an illustration.<\/span><\/p>\n

Fenner’s Auto Parts<\/strong>\u00a0<\/em><\/span><\/p>\n

Fenner’s sells auto parts for foreign cars. The following is the store’s accounts payable ending balance for 2015 by month and the final average.<\/span><\/p>\n

Accounts Payable<\/strong><\/span><\/p>\n

Month<\/strong><\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Ending Balance<\/strong><\/span><\/span>
\nJan\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$117,208<\/span>
\nFeb \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a091,616<\/span>
\nMar\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 138,209<\/span>
\nApril\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0127,114<\/span>
\nMay\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 131,292<\/span>
\nJune\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 163,437<\/span>
\nJuly\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0142,101<\/span>
\nAugust\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 139,630<\/span>
\nSept\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 153,006<\/span>
\nOct\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0127,840<\/span>
\nNov\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 144,093<\/span>
\nDec\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0132,787<\/span><\/span>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $1,608,333
\n<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Divide by\u00a0\u00a0\u00a0\u00a0 12
\n<\/span><\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Average Balance $134,028<\/span><\/p>\n

Fenner’s sales for 2015 were $2.6 Million; therefore the accounts payable turnover rate is:<\/span><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$2,600,000\/$134,028
\n<\/span><\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0=\u00a0 19.40<\/span><\/p>\n

19.40 equates to an average cycle of 18.5 days (360 days\/19.4). This is very good. If sales (numerator) increases without a change in accounts payable average then the ratio will also increase. At $3.6 Million in sales without an increase in the average payables balance the rate is 26.9 or a cycle period of 13.4 days. Notice that as the ratio increases, the cycle period decreases.<\/span><\/p>\n

This relationship between sales and the average accounts payable balance determines the ability of the company to pay its bills in a timely fashion. If the average balance increases for payables and there is no change in sales, it symbolizes a slowing down of paying bills in a timely manner, i.e. the rate decreases increasing the average number of days to pay a bill.<\/span><\/p>\n

Remember the key to this ratio is that it is used to ‘Measure the ability to pay bills in a timely manner’. Is it a true and absolute measurement device?\u00a0 Let’s find out.<\/span><\/p>\n

Manipulation<\/span><\/strong><\/h2>\n

One of the basic business principles is called substitution. For this formula it is essentially shifting the financial obligation to another venue. For accounts payable it is a matter of transferring the financial obligation by using a different type of current liability. Look at the following types of current liabilities<\/a>\u00a0:<\/span><\/p>\n

Current Liabilities<\/strong><\/span><\/span>
\nAccounts Payable<\/span>
\nCredit Card Accounts<\/span>
\nAccrued Payroll<\/span>
\nAccrued Expenses<\/span>
\nAccrued Taxes<\/span>
\nLine of Credit<\/span><\/p>\n

A simple draw on a line of credit and then using those proceeds (cash) to pay down accounts payable is effectively shifting the accounts payable to the line of credit. The A\/P average decreases, increasing the turn ratio. An outside reader would be misled as to the true ability of the company to pay its bills in a timely manner.<\/span><\/p>\n

Another aspect of this same principle is using credit cards to purchase necessary materials and supplies for sales. This reduces the average accounts payable and thus increases the turn rate.<\/span><\/p>\n

What is interesting is that there are many different methods to manipulate the results.<\/span><\/p>\n

Substitution is the number one method used to manipulate the formula. In small business, the lack of working capital or the extended working capital cycle<\/a>\u00a0 forces the owner to delay or slow pay accounts payable. After extended periods of time with slow pay and the corresponding stress (vendor phone calls, extra notices, disgruntled suppliers) small business owners shift current liabilities to long-term notes via loans. Initially the shifting is within current liabilities; once the credit is fully utilized, owners shift to longer term types of liabilities freeing up short-term accounts for further use.<\/span><\/p>\n

The above substitution method affects the denominator. Manipulation also occurs with the numerator.<\/span><\/p>\n

The fundamental underlying theory of the accounts payable turnover rate (ratio) is based on an outdated retail model. In that model, accounts payable are used for purchasing products to sell. The customer pays with cash and the formula has a pure relationship. But modern businesses no longer function like this. The more common forms of sales include exit pay (cash, debit\/credit at the register), customer accounts, long-term revolving charge accounts and third-party financing. More importantly, sales in modern times have more service based orientation sources and not product sources. Almost everything sold includes warranties or service contracts. Therefore, the mix of sales is diverse and often not purely related to accounts payable. Look at the following example:<\/span><\/p>\n

Grafton Lawn Equipment<\/strong>\u00a0<\/span><\/p>\n

Grafton sells and services yard equipment including lawn mowers, small tractors, light duty construction equipment and small fuel powered tools. As the customer base broadened over many years the sales mix continuously shifted towards service. The mix is almost 60\/40 with service dominating sales.<\/span><\/p>\n

Accounts payable is strictly used for suppliers of equipment. Over the last four years, the store has averaged $70,000 of accounts payable. The sales mix has changed from product to service per the following schedule:<\/span><\/p>\n

\u00a0YR <\/span>\u00a0 \u00a0 \u00a0 SALES\u00a0<\/span> \u00a0\u00a0SERVICE\/PRODUCT MIX<\/span> \u00a0SERVICE SALES<\/span>\u00a0 PRODUCT SALES<\/span><\/strong><\/span>
\n2012\u00a0 $1,800,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a040\/60\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $720,000 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $1,080,000<\/span>
\n2013\u00a0\u00a0\u00a0 1,963,636\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a045\/55\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 883,636 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1,080,000<\/span>
\n2014\u00a0\u00a0\u00a0 2,250,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a052\/48\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01,170,000 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1,080,000<\/span>
\n2015\u00a0\u00a0\u00a0 2,700,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a060\/40\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01,620,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01,080,000<\/span><\/p>\n

Technically, using the standard formula the turnover rate is continuously improving per this schedule:<\/span><\/p>\n

\u00a0YR<\/span>\u00a0 \u00a0 \u00a0 \u00a0\u00a0SALES<\/span>\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0AVERAGE A\/P<\/span> \u00a0 \u00a0TURNOVER RATE<\/span>
\n<\/strong>2012\u00a0\u00a0\u00a0 $1,800,000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $70,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a025.71<\/span>
\n2013\u00a0\u00a0\u00a0\u00a0\u00a0 1,963,636\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 70,000 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 28.05<\/span>
\n2014\u00a0\u00a0\u00a0\u00a0\u00a0 2,250,000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 70,000 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 32.14<\/span>
\n2015\u00a0\u00a0\u00a0\u00a0\u00a0 2,700,000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 70,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a038.57<\/span><\/p>\n

This would indicate that Grafton is doing extremely well in paying its bills in an expeditious manner. But here is the reality, remember product sales were constant over this time and the payables are strictly related to products purchased for equipment sales.<\/span><\/p>\n

Accounts Payable Turnover Rate\u00a0 =\u00a0 $1,080,000\/$70,000
\n<\/strong><\/span>Accounts Payable Turnover Rate\u00a0 =\u00a0 15.43 for all four years<\/span><\/p>\n

Another key to the numerator is level sales with similar markups throughout the entire year. Many businesses, especially small businesses, concentrate their sales base on seasonal income. Think of the local hardware store (Ace, True Value<\/span><\/strong><\/a> etc.) that depend on sales related to spring items for the home. Other retailers place high reliance on Christmas to bring in the money. How does seasonal sales affect the payables turnover rate?<\/span><\/p>\n

If the relationship is pure (retail and equal markup on all products) as explained earlier, the average payables turnover rate will remain constant. Look at the following schedule and note the seasonal increase in sales in the springtime. This is the monthly turnover rate:<\/span><\/p>\n

MONTH <\/span>\u00a0 \u00a0 \u00a0 \u00a0 SALES<\/span>\u00a0 \u00a0 \u00a0 A\/P AVERAGE<\/span>\u00a0 \u00a0 \u00a0 PAYABLES TURNOVER RATE<\/span><\/strong><\/span>
\n\u00a0Jan\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$100,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0Feb\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0100,000 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0Mar\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 250,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0125,000 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0April\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0350,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0175,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02.0<\/span>
\n\u00a0May\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 300,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0150,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02.0<\/span>
\n\u00a0June\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0100,000 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0July\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0100,000 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0August\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0100,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0Sept\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0100,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0Oct\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0100,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0Nov\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0100,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span>
\n\u00a0Dec\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 200,000<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 100,000<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.0<\/span><\/span>
\n\u00a0Totals\u00a0 \u00a0 \u00a0 \u00a0 $2,700,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$1,350,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02.0\u00a0 <\/span><\/p>\n

In this store’s case the gross margin percentage is most likely 50% (can be different, but to prove the point 50% is the assumed percentage). If seasonal items have a different markup, higher or lower than normal, it can greatly affect the ratio. Assume the same sales, but markup for the marginal seasonal items in March, April and May is double (which cuts in half the marginal increase in the accounts payable average). Look at this comparable schedule:<\/span><\/p>\n

MONTH<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SALES<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 A\/P AVERAGE<\/span> \u00a0 PAYABLES TURNOVER RATE<\/span><\/strong><\/span>
\n\u00a0Jan \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0$100,000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.0<\/span>
\n\u00a0Feb\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0200,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0100,000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.0<\/span>
\n\u00a0March\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0250,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0112,500\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02.22<\/span>
\n\u00a0April\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0350,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0137,500\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02.545<\/span>
\n\u00a0May\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 300,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0125,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02.4<\/span>
\n\u00a0June – Dec\u00a0 \u00a0 \u00a01,400,000<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0700,000<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 2.0<\/span><\/span>
\nTotals \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$2,700,000\u00a0 \u00a0 \u00a0 $1,275,000\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.118\u00a0<\/span><\/p>\n

So seasonal sales can affect the turnover rate if the markup is different which is usually true. Another factor having a bearing on this turnover rate is the lag time between delivery of the retail product and the actual sale of the product.<\/span><\/p>\n

Think about the candy manufacturer\/retailer for chocolates. The company buys the raw chocolate, sugar and cremes well in advance of the respective holiday sales period. The sales for the product are generally intense just prior to the holiday. However the average accounts payable increased significantly several months prior to the sales period. Therefore the average accounts payable (denominator) increases without a corresponding increase in sales. The turnover rate goes down and can be interpreted as a poor indicator of the ability to pay the bills. The exact opposite happens in the month of robust sales and the turnover rate looks great.<\/span><\/p>\n

Based on the above it appears easy to manipulate and misinterpret the payables turnover rate. How does a business entrepreneur properly apply the formula?<\/span><\/p>\n

Proper Application of the Accounts Payable Turnover Rate<\/span><\/strong><\/h2>\n

The first rule of thumb is to only use this formula in business with sales in excess of $10 Million per year. This large sales volume minimizes mix and seasonal effects on the formula. In addition, limit the formula to business operations that have a pure or very strong retail to payables relationship. Service based operations should ignore or not use this particular activity ratio.<\/span><\/p>\n

If it is inadvisable to use this ratio in small business, what can the owner or investor use as a tool to measure the ability of the business to pay its bills on time?<\/span><\/p>\n

There are several alternatives that inform readers of financial information about the ability of a small business to pay its bills. They are as follows:<\/span><\/p>\n

Current Liabilities Turnover Rate<\/span><\/strong><\/h3>\n

This is very similar to the accounts payable turnover rate except now all the current liabilities are included in the average. This eliminates the substitution method (shifting of debt to other current liabilities), sales mix and other manipulation tactics. In addition it is really what an interested party wants to know – how often does the business pay its bills, ALL BILLS<\/strong>.<\/span><\/p>\n

Working Capital Growth Trend Line<\/span><\/h3>\n

The positive difference of current assets over current liabilities is called working capital. Ultimately working capital should increase in incremental steps over time. This is the trend line. If the line is increasing (positive) then in the long run cash is available to pay the bills in a more timely manner.\u00a0 <\/span><\/p>\n

Cash Flow From Operations<\/span><\/strong><\/h3>\n

This is the best indicator of the ability to pay bills in a timely manner. Positive cash flow from operations indicates an increasing cash balance (in most cases); therefore more funds are available to reduce current liabilities. Cash flow from operations<\/a>\u00a0 takes into consideration profit, gross working capital changes and all current liability changes with their respective balances. As cash flow increases the cash balance is available to reduce current liability balances.<\/span><\/p>\n

Good Financial Management<\/span><\/strong><\/h3>\n

Overall, good financial management provides the greatest latitude in addressing consistency in paying all liabilities. Finance managers look at future commitments to deal with solvency<\/span><\/strong><\/a> of the business. Any capital (working capital) outlays for new equipment or to fund growth is dealt with after addressing short-term liabilities. Since most small businesses lack a finance manager, the owner typically assumes this role. Most novice business entrepreneurs focus on funding growth and not the day-to-day operations. This is a mistake. Focus on reducing short-term (current) liabilities first and once working capital is adequate; growth is considered.<\/span><\/p>\n

Summary – Accounts Payable Turnover Rate<\/span><\/strong><\/h2>\n

The accounts payable turnover rate is an activity ratio measuring the ability of a company to pay its bills in a timely manner. The ratio is an indicator of how frequently in one full accounting cycle (fiscal year) the accounts payable balance is paid. The higher the value the more frequently bills are remitted. The formula is:<\/span><\/p>\n

Accounts Payable Turnover Rate (Ratio) =\u00a0 Sales\/Average Accounts Payable Balance<\/span><\/p>\n

The formula is of little value in business operations with less than $10 Million per year in sales. This is because it is easily manipulated with either the numerator or denominator. As volume increases the manipulation factors are mitigated. In small business the best gauges of a company’s ability to pay its bills in a timely manner include cash flow from operations, good finance management and an increasing working capital growth trend line. As a substitute to accounts payable turnover rate use total current liabilities turnover rate. ACT ON KNOWLEDGE<\/strong>.\u00a0<\/span><\/p>\n