Accounts Payable Days Formula
The accounts payable days formula measures the number of days that a company takes to pay its suppliers. If the number of days increases from one period to the next, this indicates that the company is paying its suppliers more slowly, and may be an indicator of worsening financial condition. A change in the number of payable days can also indicate altered payment terms with suppliers, though this rarely has more than a slight impact on the total number of days, since the terms must be altered for many suppliers to alter the ratio to a meaningful extent.
If a company is paying its suppliers very quickly, it may mean that the suppliers are demanding fast payment terms, either because short terms are part of their business models or because they feel the company is too high a credit risk to allow longer payment terms.
To calculate accounts payable days, summarize all purchases from suppliers during the measurement period, and divide by the average amount of accounts payable during that period. The formula is:
Total supplier purchases
(Beginning accounts payable + Ending accounts payable) / 2
This formula reveals the total accounts payable turnover. Then divide the resulting turnover figure into 365 days to arrive at the number of accounts payable days.
The formula can be modified to exclude cash payments to suppliers, since the numerator should include only purchases on credit from suppliers. Otherwise, the number of payable days will appear to be too low. However, the amount of up-front cash payments to suppliers is normally so small that this modification is not necessary.
As an example, the controller of ABC Company wants to determine the company's accounts payable days for the past year. In the beginning of this period, the beginning accounts payable balance was $800,000, and the ending balance was $884,000. Purchases for the last 12 months were $7,500,000. Based on this information, the controller calculates the accounts payable turnover as:
($800,000 Beginning payables + $884,000 Ending payables) / 2
$842,000 Average accounts payable
= 8.9 Accounts payable turnover
Thus, ABC's accounts payable turned over 8.9 times during the past year. To calculate the accounts payable turnover in days, the controller divides the 8.9 turns into 365 days, which yields:
365 Days / 8.9 Turns = 41 Days
There are some issues to be aware of when using this calculation. Companies sometimes measure accounts payable days by only using the cost of goods sold in the numerator. This is incorrect, since there may be a large amount of selling and administrative expenses that should also be included in the numerator. If a company only uses the cost of goods sold in the numerator, this results in an excessively small number of payable days.