Accounts Payable (AP) is generated when a company purchases goods or services from its suppliers on credit. Accounts payable is expected to be paid off within a year’s time or within one operating cycle (whichever is shorter). AP is considered one of the most current forms of the current liabilities on the balance sheet.
Accounts Payable Turnover
Accounts payables turnover is a key metric used in calculating the liquidity of a company, as well as in analyzing and planning its cash cycle. A related metric is AP days (accounts payable days). This is the number of days it takes a company, on average, to pay off their AP balance.
The cash cycle (or cash conversion cycle) is the amount of time a company requires to convert inventory into cash. It is tied to the operating cycle, which is the total of accounts receivable days and inventory days. The cash cycle, then, is the operating cycle minus AP days.
Reducing Accounts Payables
AP is an accumulation of the company’s current obligations to suppliers and service providers. As such, accounts payables are reduced when a company pays off the obligation. Using double-entry accounting, cash is reduced alongside AP. As such, the asset side is reduced an equal amount as compared to the liability side.
How to Calculate Accounts Payable in Financial Modeling
In financial modeling, it’s important to be able to calculate the average number of days it takes for a company to pay its bills.
The formula for calculating AP days is:
AP Days = (Accounts Payable Value / Cost of Goods Sold) x 365
The formula for calculating AP value is:
AP Value = (Accounts Payable Days x Cost of Good Sold) / 365
Note: The above examples are based on a full year 365-day period.
Download the Free Template
Enter your name and email in the form below and download the free template now!
Balance Sheet (Accounts Payable) Template
Download the free Excel template now to advance your finance knowledge!
Impact of AP on Cash Balance
Since AP represents the unpaid expenses of a company, as accounts payable increases, so does the cash balance (all else being equal).
When AP is paid down and reduced, the cash balance of a company is also reduced a corresponding amount.
This is a very important concept to understand when performing financial analysis of a company.
Learn more about Balance Sheet reporting standards at FASB.
Learn accounting fundamentals and how to read financial statements with CFI’s free online accounting classes.
These courses will give the confidence you need to perform world-class financial analyst work. Start now!
Building confidence in your accounting skills is easy with CFI courses! Enroll now for FREE to start advancing your career!
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.