Question: How are the various payment statistics calculated?
Answer: The following tables display sample calculations.
Invoice Number |
Invoice Amount |
Paid Amount |
Invoice Date |
Due Date |
Paid Date |
Paid Date Minus Invoice Date |
1 |
$100 |
$100 |
10/06/2020 |
11/06/2020 |
11/30/2020 |
55 |
2 |
$500 |
$50 |
10/06/2020 |
11/06/2020 |
Not fully paid |
|
3 |
$200 |
$200 |
10/06/2020 |
11/06/2020 |
12/01/2020 |
56 |
4 |
$50 |
$50 |
10/06/2020 |
11/06/2020 |
12/04/2020 |
59 |
5 |
$1,000 |
$1,000 |
10/06/2020 |
11/06/2020 |
01/01/2021 |
87 |
Totals |
$1,850 |
$1,350 |
|
|
|
257 |
|
|
|
Divide by number of fully paid invoices |
4 |
||
|
|
|
|
|
ADTP |
64 |
Invoice Number |
Invoice Amount |
Paid Amount |
Invoice Date |
Due Date |
Paid Date |
Paid Date minus Invoice Date |
Paid Amt times Days to Pay |
1 |
$100 |
$100 |
10/06/2020 |
11/06/2020 |
11/30/2020 |
55 |
5,500 |
2 |
$500 |
$50 |
10/06/2020 |
11/06/2020 |
Not fully paid |
|
|
3 |
$200 |
$200 |
10/06/2020 |
11/06/2020 |
12/01/2020 |
56 |
11,200 |
4 |
$50 |
$50 |
10/06/2020 |
11/06/2020 |
12/04/2020 |
59 |
2,950 |
5 |
$1,000 |
$1,000 |
10/06/2020 |
11/06/2020 |
01/01/2021 |
87 |
87,000 |
Totals |
$1,850 |
$1,350 |
|
|
|
257 |
106,650 |
|
|
|
|
Divided by total paid amount |
1,350 |
||
|
|
|
|
|
|
WADTP |
79 |
Invoice Number |
Invoice Amount |
Paid Amount |
Invoice Date |
Due Date |
Paid Date |
Paid Date minus Due Date |
1 |
$100 |
$100 |
10/06/2020 |
11/06/2020 |
11/30/2020 |
24 |
2 |
$500 |
$50 |
10/06/2020 |
11/06/2020 |
Not fully paid |
|
3 |
$200 |
$200 |
10/06/2020 |
11/06/2020 |
12/01/2020 |
25 |
4 |
$50 |
$50 |
10/06/2020 |
11/06/2020 |
12/04/2020 |
28 |
5 |
$1,000 |
$1,000 |
10/06/2020 |
11/06/2020 |
01/01/2021 |
56 |
Totals |
$1,850 |
$1,350 |
|
|
|
133 |
|
|
|
Divide by number of fully paid invoices |
4 |
||
|
|
|
|
|
ADPD |
33 |
Invoice Number |
Invoice Amount |
Paid Amount |
Invoice Date |
Due Date |
Paid Date |
Paid Date minus Due Date |
Paid Amt times Days Past Due |
1 |
$100 |
$100 |
10/06/2020 |
11/06/2020 |
11/30/2020 |
24 |
2,400 |
2 |
$500 |
$50 |
10/06/2020 |
11/06/2020 |
Not fully paid |
|
|
3 |
$200 |
$200 |
10/06/2020 |
11/06/2020 |
12/01/2020 |
25 |
5,000 |
4 |
$50 |
$50 |
10/06/2020 |
11/06/2020 |
12/04/2020 |
28 |
1,400 |
5 |
$1,000 |
$1,000 |
10/06/2020 |
11/06/2020 |
01/01/2021 |
56 |
56,000 |
Totals |
$1,850 |
$1,350 |
|
|
|
133 |
64,800 |
|
|
|
|
Divided by total paid amount |
1,350 |
||
|
|
|
|
|
|
WADPD |
48 |
Invoice Number |
Invoice Amount |
Paid Amount |
Invoice Date |
Due Date |
Paid Date |
Open Amt |
1 |
$100 |
$100 |
10/06/2020 |
11/06/2020 |
11/30/2020 |
0 |
2 |
$500 |
$50 |
10/06/2020 |
11/06/2020 |
Not fully paid |
450 |
3 |
$200 |
$200 |
10/06/2020 |
11/06/2020 |
12/01/2020 |
0 |
4 |
$50 |
$50 |
10/06/2020 |
11/06/2020 |
12/04/2020 |
0 |
5 |
$1,000 |
$1,000 |
10/06/2020 |
11/06/2020 |
01/01/2021 |
0 |
Totals |
$1,850 |
$1,350 |
|
|
|
450 |
|
90 |
Days |
Divide by average daily sales |
$20.56 |
||
|
$20.56 |
Average Daily Sales |
DSO |
22 |