The accounts payable turnover ratio, sometimes called creditor’s turnover ratio or payable turnover, measures how many times a company pays its creditors over an accounting period. It is a ratio that measures short-term liquidity, with a higher ratio being more favorable to a lower ratio. Calculating the turnover ratio is of particular interest for creditors as they measure a company's ability to meet their obligations. The formula for calculating the ratio is as follows: Accounts Payable Turnover Ratio = Net Credit Purchases / Average Accounts Payable Sometimes, cost of goods sold (COGS) is used in the numerator instead of net credit purchases.

How to Use the Excel Template

This model is for beginners who are looking to learn more about the A/P turnover ratio, and who want to teach themselves based on an example. It is a simple tool which requires the user to input the following information:
  • Annual sales on credit
  • Amount of product returns
  • Accounts payable, beginning of year
  • Accounts payable, end of year
Once these are all entered into the model, it will generate the payable turnover ratio and payable turnover in days based on the inputs.

Learn More About A/P Turnover Ratio

Read CFI's comprehension guide to learn more about the formula, use, and examples of the ratio!
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
restructuring financial model template preview 1 Restructuring Financial Model Template
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…