--- title: Accounts Payable Turnover Ratio | Formula, Example, Analysis, Calculator description: Accounts payable turnover ratio is the average number of times it takes for a company to pay its suppliers in one year. Click to know more. --- [![Carbon collective](https://www.carboncollectiveinvesting.com/hubfs/raw_assets/public/CarbonCollective_August2021%20copy/images/carbon-collective-green-investing-logo-white.4f6047d4.svg "Carbon collective")](https://www.carboncollectiveinvesting.com/) - About - Employers - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - [401(k) Comparison Tool](https://www.carboncollectiveinvesting.com/401k/plan-comparison-tool) - Individuals - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [ETF](https://www.carboncollectivefunds.com/) - Learn - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Blog](https://blog.carboncollective.co/) - [Tools](https://tools.carboncollective.co/calculator/) - Log in - [Carbon Collective](https://app.carboncollective.co) - [Altruist](https://app.altruist.com) [Talk to a human](https://ask.carboncollective.co/f4o5dylkg) [Sign up](https://app.carboncollective.co/sign-up) [Log In](http://app.carboncollective.co/) [![Carbon collective](https://www.carboncollectiveinvesting.com/hubfs/raw_assets/public/CarbonCollective_August2021%20copy/images/carbon-collective-green-investing-logo.53b28bee.svg "Carbon collective")](https://www.carboncollectiveinvesting.com/) - About - Employers - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - [401(k) Comparison Tool](https://www.carboncollectiveinvesting.com/401k/plan-comparison-tool) - Individuals - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [ETF](https://www.carboncollectivefunds.com/) - Learn - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Blog](https://blog.carboncollective.co/) - [Tools](https://tools.carboncollective.co/calculator/) - Log in - [Carbon Collective](https://app.carboncollective.co) - [Altruist](https://app.altruist.com) [Talk to a human](https://ask.carboncollective.co/f4o5dylkg) [Sign up](https://app.carboncollective.co/sign-up) [Log In](http://app.carboncollective.co/) **[Home](https://www.carboncollectiveinvesting.com/) > [Sustainable Investing](https://www.carboncollectiveinvesting.com/sustainable-investing) >** Accounts Payable Turnover Ratio # Accounts Payable Turnover Ratio ![](https://www.carboncollectiveinvesting.com/hubfs/Brooke%20Tomasetti.png) Written by Brooke Tomasetti | Reviewed by [Subject Matter Experts](https://www.carboncollectiveinvesting.com/subject-matter-experts) Updated on October 1, 2024 Fact Checked Why Trust Carbon Collective? ### Table of Contents Accounts payable turnover ratio (APTR) is a financial ratio of the net credit purchases of a business to its average accounts payable for one year. Accounts payable turnover is simply the number of times a company pays its suppliers in one year. It can also be used to evaluate how fast or slow a company is paying off its suppliers. Accounts payable turnover is sometimes referred to as the creditor’s velocity or creditor’s turnover ratio. The amounts from average accounts payable and the number of times suppliers are paid a good measure of the short term liquidity of a business. Accounts payable turnover is expressed in terms of times, and it shows how many times accounts payable are paid over a given period. These average accounts payable a company has in a typical period of one year. Depending on the cash situation of the company, suppliers can either receive their pay faster or slow. Accounts payable turnover, therefore, can be used to judge the company’s financial status as well as the creditworthiness of a company. Also, we can accounts payable turnover ratio as an indicator of efficient delivery of supplier’s short term debts. A high accounts payable turnover shows that the company has a desirable policy in its dealings and is probably not taking advantage of its suppliers while a low payable turnover is an indicator of financial distress and it signals that the company has a cash flow problem such that it is not able to pay its bills. Accounts payable turnover also varies across different companies and industries. To compute accounts payable turnover in days you can use [days payable outstanding](https://www.carboncollectiveinvesting.com/sustainable-investing/days-payable-outstanding/). ## Accounts Payable Turnover Ratio Formula ![](https://www.carboncollectiveinvesting.com/hubfs/image-png-May-13-2022-05-47-22-33-PM.png) The figure for net credit purchases is often not very easy to discover because such information is not always available in the [financial statements](https://www.carboncollectiveinvesting.com/sustainable-investing/basic-financial-statements/). You should be able to find it in the annual reports of the company. But if the figure for net purchase is missing, the total net purchase can be used instead of credit purchases assuming that for that given period, the company purchased everything on credit. Different authors have stated that the cost of goods sold can as well be used, but how? The cost of goods sold can be used to arrive at net purchases for a company by adjusting it using the begging and ending inventories. ![6-Apr-23-2022-02-58-57-58-AM](https://www.carboncollectiveinvesting.com/hs-fs/hubfs/6-Apr-23-2022-02-58-57-58-AM.png?width=1457&name=6-Apr-23-2022-02-58-57-58-AM.png) Average accounts payable is found by summing the beginning and ending accounts payable figures, then divide by two. When the opening stock is not given, then only the closing accounts. Notes payable are considered as part of accounts payable, so any time the average of the two is being computed, notes payable are always added to them. ![](https://www.carboncollectiveinvesting.com/hubfs/image-png-May-13-2022-05-47-54-69-PM.png) A high APTR shows that the company has a desirable policy in its dealings and is probably not taking advantage of its suppliers, and it is also working so hard to take advantage of the discounts suppliers offer for early payments. A low payable turnover is an indicator of financial distress, and it signals that the company has a cash flow problem such that it is not able to pay its bills. The accounts payable turnover ratio should only be compared with others in the same industry. ## Accounts Payable Turnover Ratio Example Sarah works for a company in Italy. They published a total of $187,000 as annual credit purchases. They had returns of inventory worth $27,000 for the 2018 fiscal year. Accounts payable for the beginning and end of the year were $30,000 and $ 50,000, respectively. What is the company’s accounts payable turnover ratio? Now let’s break it down and identify the values of different variables in the problem. - Net credit purchases = $160,000 - Average Accounts Payable = Unknown - Though missing, we can calculate the average accounts payable from what we learned above. Upon combining the starting and ending accounts payable, we can divide it by two. - So, the average accounts payable would be $40,000. Finally, we can use our formula: ![](https://www.carboncollectiveinvesting.com/hubfs/image-png-May-13-2022-05-48-11-76-PM.png) The company was paying its suppliers 4 times annually. From the examples above, XYZ company has a APTR of 4. If a competitor, ABC Company has APTR of 17, then the one with 17 is said to be paying its suppliers well as compared to the other one with APTR of 4. ## Accounts Payable Turnover Excel Template This [accounts payable turnover Excel template](https://www.carboncollectiveinvesting.com/sustainable-investing/accounts-payable-turnover-excel-template/) lets you quickly calculate the accounts payable turnover ratio and measure the number of times a company pays its suppliers in one year. Accounts payable turnover ratio is a financial ratio of the net credit purchases of a business to its average accounts payable for one year. Accounts payable turnover is simply the number of times a company pays its suppliers in one year. It can also be used to evaluate how fast or slow a company is paying off its suppliers. Accounts payable turnover is sometimes referred to as the creditor’s velocity or creditor’s turnover ratio. The amounts from average accounts payable and the number of times suppliers are paid a good measure of the short term liquidity of a business. ### How to Use the Excel Spreadsheet This is a model for beginners to learn how the A/P turnover ratio works. Simply input the following information: - The net credit sales for the period - The amount of product returns for the period - Accounts payable at the beginning of the period - Accounts payable at the end of the period - The number of days in a period (usually 365) The template will then calculate the accounts payable turnover ratio and show you the payable turnover in days value as well. ## Accounts Payable Turnover Ratio Analysis   The accounts payable turnover ratio indicates how fast or slows a company pays off its creditors within a specified period. It helps in assessing the creditworthiness of a company. The accounts payable turnover ratio measures how a company is effectively managing its supplier’s bills. For instance, APTR of 20 means the company has managed to pay its suppliers 20 times in one year. A solid understanding of APTR is of utmost importance, and the need for it is universal for any business person who wants to prosper in dealings with the suppliers. Apart from the conventionally accepted net credit purchases, some analysts have used several assumptions depending on the information available to use different figures such as the cost of goods sold, total purchases, among others in the numerator of the formula as a proxy to net credit purchases to compute the APTR. This direction is incorrect as several things may be omitted, such as administrative expenses, which also be included; hence this leads to a high turnover ratio. Different analysts explain a low accounts payable turnover differently, arguing that maybe XYZ Company has a high bargaining power to successfully negotiate for better payment terms with their suppliers, which allows them to make payments less frequently, without any penalty. Therefore, we can assume that XYZ Company is taking advantage of the favorable credit terms extended them by suppliers. This might help them maintain a comfortable cash flow position. Similarly, high APTR shown by it’s competitor, ABC Company, could mean they’re not reinvesting their earnings into the business to take advantage of the opportunity to increase their growth for future cash flows. In other words, a high or low ratio shouldn’t be taken on face value. Instead, lead investors to investigate further as to the reason for the high or low ratio. ## Accounts Payable Turnover Ratio Conclusion - Accounts payable turnover ratio is the average number of times it takes for a company to pay its suppliers in one year. - A high result can indicate that the company is paying its suppliers fast and vice versa - If a company has high bargaining power, then chances of having low result are very high. - It is important to realize that a financial ratio will vary between industries. You should be comparing to your ratio to the ratios of companies within its industry. - This formula requires two variables: Net credit purchase and Average accounts payable. ## Accounts Payable Turnover Ratio Calculator You can use the accounts payable turnover ratio calculator below to quickly calculate the number of times in a year a company able to pay its creditors/suppliers by entering the required numbers.   Average Accounts Payable Net Credit Purchases Accounts Payable Turnover Ratio ## FAQs ### 1. What is accounts payable turnover ratio? The accounts payable turnover ratio indicates how fast or slow a company pays off its creditors within a specified period. It helps in assessing the creditworthiness of a company. The accounts payable turnover ratio measures how a company is effectively managing its supplier’s bills. ### 2. How do you calculate the accounts payable turnover ratio? The accounts payable turnover ratio is calculated by dividing the net credit purchase (cost of goods sold) by the average accounts payable. ### 3. What is an ideal accounts payable turnover ratio? There is no industry-specific answer to this question since the ideal accounts payable turnover ratio varies depending on the type of business. However, a general rule of thumb is that a higher number is better as it indicates that the company is paying its suppliers quickly. ### 4. Is higher accounts payable turnover better? There is no definite answer as to whether a high or low accounts payable turnover ratio is better. However, it is generally agreed that a higher number is preferable as it indicates that the company is paying its suppliers quickly. ### 5. How can you analyze your accounts payable turnover ratio? The accounts payable turnover ratio should be analyzed in comparison to the ratios of other companies in the same industry. Additionally, it is important to investigate the reasons behind any abnormally high or low ratios in order to determine whether they are indicative of a problem. ### Related Topics - [Sustainable 401(k) Plan](https://www.carboncollective.co/401k) - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing/) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Retirement Glossary](https://www.carboncollective.co/sustainable-investing/retirement-planning-glossary) - [Best Retirement Plans](https://www.carboncollective.co/sustainable-investing/the-10-best-retirement-plans) - [Wealth Manager Vs Financial Advisor](https://www.carboncollective.co/sustainable-investing/wealth-manager-vs.-financial-advisor) ![Attend Our Next Webinar](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-webinar.12af7b6e.svg) ### Attend Our Next Webinar Join our next Sustainable Investing 101 webinar, get our favorite DIY options, and walk through how we build our portfolios. [Watch Now](https://www.carboncollective.co/sustainable-investing-webinar-green-retirement-month) ![Get Our Newsletter](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-demo.6ed28722.svg) ### Get Our Newsletter Go a level deeper with us and investigate the potential impacts of climate change on investments like your retirement account. Join Newsletter ![close-typeform](data:image/gif;base64,R0lGODlhEQARAIAAAODn7P///yH5BAEHAAEALAAAAAARABEAAAIqBIKpab3v3EMyVHWtWZluf0za0XFNKDJfCq5i5JpomdUxqKLQVmInqyoAADs=) ![Talk To A Human](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-chat.49d48c5b.svg) ### Talk To A Human Joining a new investment service can be intimidating. We’re here for you. Click below to email us a question or book a quick call. [Ask a Question](https://ask.carboncollective.co/f70pooobq) Topics ## Sustainable Investing Topics View our list of some topics below. See More - Portfolios - [Performance](https://www.carboncollectiveinvesting.com/returns) - About - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - Learn - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - Contact - [Contact us](mailto:hello@carboncollective.co) - [Legal](https://www.carboncollective.co/legal) - [Privacy Policy](https://www.carboncollectiveinvesting.com/hubfs/2022-11%20Carbon%20Collective%20Privacy%20Policy.pdf) - [Back to top](https://www.carboncollectiveinvesting.com/sustainable-investing/accounts-payable-turnover-ratio#top-of-page) DISCLAIMERS: Advisory services provided by Carbon Collective Investment LLC (“Carbon Collective"), an SEC-registered investment adviser. A copy of Carbon Collective's current written disclosure statement discussing Carbon Collective’s business operations, services, and fees is available at the SEC’s investment adviser public information website – [www.adviserinfo.sec.gov](https://adviserinfo.sec.gov/firm/summary/310129) or [our legal documents here](https://blog.carboncollective.co/legal-documents/). The articles and research support materials available on this site are educational and are not intended to be investment or tax advice. Carbon Collective does not make any representations or warranties as to the accuracy, timeliness, suitability, completeness, or relevance of any information prepared by any unaffiliated third party, whether linked to Carbon Collective’s web site or incorporated herein, and takes no responsibility therefor. All such information is provided solely for convenience purposes only and all users thereof should be guided accordingly. Investments in securities: Not FDIC Insured • No Bank Guarantee • May Lose Value. Investing in securities involves risks, and there is always the potential of losing money when you invest in securities. Before investing, consider your investment objectives and Carbon Collective's charges and expenses. Carbon Collective's internet-based advisory services are designed to assist clients in achieving discrete financial goals. They are not intended to provide comprehensive tax advice or financial planning with respect to every aspect of a client's financial situation and do not incorporate specific investments that clients hold elsewhere. For more details, see our Form CRS, Form ADV Part 2 and other disclosures. Past performance does not guarantee future results, and the likelihood of investment outcomes are hypothetical in nature. Not an offer, solicitation of an offer, or advice to buy or sell securities in jurisdictions where Carbon Collective is not registered. © 2026 Carbon Collective Corporation. All rights reserved. × #### Fact Checked Carbon Collective partners with financial and climate experts to ensure the accuracy of our content. Our team of reviewers are established professionals with years of experience in areas of personal finance and climate. They have contributed to top tier financial publications, such as Reuters, Axios, Ag Funder News, Bloomberg, Marketwatch, Yahoo! Finance, and many others. This team of experts helps Carbon Collective maintain the highest level of accuracy and professionalism possible. × #### Why Trust Carbon Collective Carbon Collective is the first online investment advisor 100% focused on solving climate change. We believe that sustainable investing is not just an important climate solution, but a smart way to invest. We follow ethical journalism practices, which includes presenting unbiased information and citing reliable, attributed resources. Much of our research comes from leading organizations in the climate space, such as Project Drawdown and the International Energy Agency (IEA). Our goal is to deliver the most understandable and comprehensive explanations of climate and finance topics. Our writing and editorial staff are a team of experts holding advanced financial designations and have written for most major financial media publications. Our work has been directly cited by organizations including MarketWatch, Bloomberg, Axios, TechCrunch, Forbes, NerdWallet, GreenBiz, Reuters, and many others. We strive to empower readers with the most factual and reliable climate finance information possible to help them make informed decisions. } ```json { "@context" : "https://schema.org", "@type" : "Organization", "alternateName" : "Carbon Collective", "contactPoint" : { "@type" : "ContactPoint", "areaServed" : "US", "availableLanguage" : "en", "contactType" : "customer service", "telephone" : "(650) 868-2697" }, "logo" : "https://www.carboncollective.co/hubfs/CarbonCollectiveLogo.png", "name" : "Carbon Collective Investing LLC", "sameAs" : [ "https://www.facebook.com/carboncollectiveinvesting/", "https://twitter.com/carbncollective", "https://www.instagram.com/carbon.collective/", "https://www.youtube.com/channel/UC769Y-F-L_B37kyQfdpvyXA", "https://www.linkedin.com/company/carbon-collective/", "https://www.crunchbase.com/organization/carbon-collective", "https://adviserinfo.sec.gov/firm/summary/310129", "https://www.wikidata.org/wiki/Q110243690" ], "url" : "https://www.carboncollective.co/" } ``` ```json { "@context" : "https://schema.org", "@type" : "FAQPage", "mainEntity" : [ { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "The accounts payable turnover ratio indicates how fast or slow a company pays off its creditors within a specified period. It helps in assessing the creditworthiness of a company. The accounts payable turnover ratio measures how a company is effectively managing its supplier’s bills." }, "name" : "What is accounts payable turnover ratio?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "The accounts payable turnover ratio is calculated by dividing the net credit purchase (cost of goods sold) by the average accounts payable." }, "name" : "How do you calculate the accounts payable turnover ratio?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "There is no industry-specific answer to this question since the ideal accounts payable turnover ratio varies depending on the type of business. However, a general rule of thumb is that a higher number is better as it indicates that the company is paying its suppliers quickly." }, "name" : "What is an ideal accounts payable turnover ratio?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "There is no definite answer as to whether a high or low accounts payable turnover ratio is better. However, it is generally agreed that a higher number is preferable as it indicates that the company is paying its suppliers quickly." }, "name" : "Is higher accounts payable turnover better?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "The accounts payable turnover ratio should be analyzed in comparison to the ratios of other companies in the same industry. Additionally, it is important to investigate the reasons behind any abnormally high or low ratios in order to determine whether they are indicative of a problem." }, "name" : "How can you analyze your accounts payable turnover ratio?" } ] } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "https://20345524.fs1.hubspotusercontent-na1.net/hubfs/20345524/Brooke%20Tomasetti.png", "url" : "https://www.carboncollectiveinvesting.com/sustainable-investing/author/brooke-tomasetti" }, "dateModified" : "2024-10-01", "datePublished" : "2021-03-24", "description" : "Accounts payable turnover ratio is the average number of times it takes for a company to pay its suppliers in one year. Click to know more.", "headline" : "Accounts Payable Turnover Ratio | Formula, Example, Analysis, Calculator", "image" : "", "mainEntityOfPage" : { "@id" : "https://www.carboncollectiveinvesting.com/sustainable-investing/accounts-payable-turnover-ratio", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.carboncollective.co/hubfs/CarbonCollectiveLogo.png" }, "name" : "Carbon Collective" } } ```