(A)
45-day collection period implies all receivables outstanding from previous quarter are collected in the current quarter, and (90-45)/90 = 1/2 of current sales are collected.
Particular | Q1 | Q2 | Q3 | Q4 |
Beginning receivables | 300 | 270 | 285 | 315 |
Sales | 540 | 570 | 630 | 780 |
Total | 840 | 840 | 915 | 1095 |
Less: | ||||
Cash Collection | ||||
Previous Period | -300 | -270 | -285 | -315 |
Current Quarter | -270 | -285 | -315 | -390 |
Ending Balnce | 270 | 285 | 315 | 390 |
(B)
60-day collection period implies all receivables outstanding from previous quarter are collected in the current quarter, and (90-60)/90 = 1/3 of current sales are collected
Particular | Q1 | Q2 | Q3 | Q4 |
Beginning receivables | 300 | 360 | 380 | 420 |
Sales | 540 | 570 | 630 | 780 |
Total | 840 | 930 | 1010 | 1200 |
Less: | ||||
Cash Collection | ||||
Previous Period | -300 | -360 | -380 | -420 |
Current Quarter | -180 | -190 | -210 | -260 |
Ending Balnce | 360 | 380 | 420 | 520 |
(C)
30-day collection period implies all receivables outstanding from previous quarter are collected in the current quarter, and (90-30)/90 = 2/3 of current sales are collected
Particular | Q1 | Q2 | Q3 | Q4 |
Beginning receivables | 300 | 180 | 190 | 210 |
Sales | 540 | 570 | 630 | 780 |
Total | 840 | 750 | 820 | 990 |
Less: | ||||
Cash Collection | ||||
Previous Period | -300 | -180 | -190 | -210 |
Current Quarter | -360 | -380 | -420 | -520 |
Ending Balnce | 180 | 190 | 210 | 260 |