Overview
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!
Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
REIT Financial Model Template
169
0
This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will…
Energy Industry Comps Template Energy Industry Comps Template
1,035
62
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
1,634
72
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
1,341
0
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
1,468
107
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
1,234
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
See All