The formula to calculate the Average Collection Period (ACP) is:
ACP=AR(SRPt)
Where:
The Average Collection Period is the approximate amount of time that it takes for a business to receive payments owed in terms of accounts receivable.
Let's assume the following values:
Using the formula:
ACP=2000(45800030)
Evaluating:
ACP=0.13 days
The Average Collection Period is 0.13 days.
Accounts Receivable | Sales for Reporting Period | Reporting Period Length (days) | Average Collection Period (days) |
---|---|---|---|
1900 | 450000 | 29 | 0.12 |
1900 | 450000 | 30 | 0.13 |
1900 | 450000 | 31 | 0.13 |
1900 | 455000 | 29 | 0.12 |
1900 | 455000 | 30 | 0.13 |
1900 | 455000 | 31 | 0.13 |
1900 | 460000 | 29 | 0.12 |
1900 | 460000 | 30 | 0.12 |
1900 | 460000 | 31 | 0.13 |
2000 | 450000 | 29 | 0.13 |
2000 | 450000 | 30 | 0.13 |
2000 | 450000 | 31 | 0.14 |
2000 | 455000 | 29 | 0.13 |
2000 | 455000 | 30 | 0.13 |
2000 | 455000 | 31 | 0.14 |
2000 | 460000 | 29 | 0.13 |
2000 | 460000 | 30 | 0.13 |
2000 | 460000 | 31 | 0.13 |
2100 | 450000 | 29 | 0.14 |
2100 | 450000 | 30 | 0.14 |
2100 | 450000 | 31 | 0.14 |
2100 | 455000 | 29 | 0.13 |
2100 | 455000 | 30 | 0.14 |
2100 | 455000 | 31 | 0.14 |
2100 | 460000 | 29 | 0.13 |
2100 | 460000 | 30 | 0.14 |
2100 | 460000 | 31 | 0.14 |