Overview
This Accounts Payable Excel Template, is an educational resource that highlights where you would find the A/P account on a balance sheet. It gives you an example balance sheet with current assets and current liabilities. Accounts payable is a current liability account that records an outstanding balance that the company has with its suppliers and service providers. The account is also known as unpaid expenses and is recorded when a company purchases from its suppliers on credit.  A/P are usually expected to be repaid within either one year or one operating cycle (whichever is longer), and are considered one of the most liquid forms of liabilities of a company. Because A/P represents the unpaid expenses of a company, an increase in A/P will increase the cash balance, all else being equal. When A/P is paid down, the cash balance will also decrease.

Measuring Liquidity

Accounts payable turnover and A/P days are some of the most commonly used metric to assess how liquid a company is and analyze its cash cycle.   A/P Turnover is a liquidity ratio that measures the number of times a company is able to repay its A/P within a specified period and is given in the following formula: A/P Turnover = Cost of Goods Sold / Accounts Payable   A/P Days measures the number of days it takes a company to pay off its A/P balance on average. The formula for calculating the metric is: A/P Days = (Accounts Payable / Cost of Goods Sold) x 365

Learn More About This Topic

Read CFI's guide to review the definition, calculation and examples of A/P!
Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Financial Institution Dividend Discount Model
429
0
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
277
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
339
28
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
338
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
restructuring financial model template preview 1 Restructuring Financial Model Template
566
0
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
744
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…