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

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

## More From Corporate Finance Institute®

Browse our top rated business templates. See All
Restructuring Financial Model Template
232
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
355
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
Bank Financial Model Template
326
0
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Option Profit/Loss Graph Maker
922
240
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…