Wall Street Prep

Average Payment Period

Guide to Understanding the Average Payment Period

Learn Online Now

Average Payment Period

How to Calculate the Average Payment Period

The average payment period refers to the number of days on average that it takes a company to pay off its outstanding supplier or vendor invoices.

For accounts payable to be recognized on the balance sheet, the product or service was delivered to the company as part of the agreement with the supplier, however, the company has yet to pay the related invoice.

Until the company pays the supplier in cash, the outstanding balance sits as accounts payable on its balance sheet.

While the supplier or vendor delivered the purchased good or service, the company placed the order using credit as the form of payment (and the related invoice has not yet been processed in cash).

Calculating the average payment period can be broken into a three-step process:

  • Step 1 → The first step is to calculate the average accounts payable by adding the end of period and beginning of period accounts payable balances and then dividing by two.
      • Average Accounts Payable = (Beginning and Ending Accounts Payable) ÷ 2
  • Step 2 → The next step is to divide the dollar amount of credit purchases made by the company (i.e. orders placed using credit) and the number of days in the period (i.e. annual = 365 days).
  • Step 3 → In the final step, the average accounts payable balance is divided by the resulting figure from step 2 (i.e. credit purchases divided by the number of days in the period) to calculate the implied average payment period.

Average Payment Period Formula

The formula for calculating the average payment period is as follows.

Average Payment Period Formula
  • Average Payment Period = Average Accounts Payable ÷ (Credit Purchases ÷ Number of Days in Period)

The three inputs necessary to calculate the average payment period are explained in more detail below:

  1. Accounts Payable → The accounts payable line item appears on the balance sheet as a current liability and represents the accumulated balance of unpaid invoices.
  2. Number of Days in Period → The number of days in the chosen accounting period, e.g. an annual calculation would use 365 days.
  3. Credit Purchases → The total value of orders placed by the company that was made on credit, as opposed to cash.

Interpreting the Average Payment Period

In general, the more a supplier relies on a customer, the more negotiating leverage is possessed by the buyer when it comes to payment periods.

The time between the initial purchase date and the date of actual cash payment (and receipt by the supplier) is oftentimes used as a proxy for a buyer’s bargaining power, i.e. the capability of a company to exert pressure when negotiating terms with its suppliers to receive favorable terms such as price reductions and extensions of payment due dates.

  • Short Average Payment Period ➝ Low Bargaining Leverage (and Less Free Cash Flow)
  • Long Average Payment Period ➝ High Bargaining Leverage (and More Free Cash Flow)

Companies with more buying power and negotiating leverage typically have the following characteristics:

  • Significant Order Size (or Volume)
  • High Frequency of Orders
  • Long-Term Relationship with Supplier
  • Customer Concentration Risk
  • Niche Technical Materials (i.e. Limited Number of Potential Customers)

Average Payment Period Calculator – Excel Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

Submitting ...

Average Payment Period Calculation Example

Suppose we’re tasked with calculating the average payment period of a company that had an ending accounts payable balance of $20k and $25k in 2020 and 2021, respectively.

Given those two values, the average accounts payable is roughly $23k.

  • Average Accounts Payable = ($25k + $20k) ÷ 2 = $23k

We’ll assume that our company made a total of $100k in credit purchases in 2021.

  • Credit Purchases = $100k

Since all of our figures so far are on an annual basis, the correct number of days in the accounting period to use in our calculation is 365 days.

  • Number of Days in Period = 365 Days

In closing, the average payment period for our hypothetical company is approximately 82 days, which we calculated using the formula below.

  • Average Payment Period = $23k ÷ ($100k ÷ 365) = 82 Days

Average Payment Period Calculator

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
guest
0 Comments
Inline Feedbacks
View all comments
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.