In: Finance
Route Canal Shipping Company has the following schedule for aging of accounts receivable:
Age of Receivables |
|||||
(1) | (2) | (3) | (4) | ||
Month of Sales |
Age of Account |
Amounts |
Percent of Amount Due |
||
April | 0–30 | $ | 189,000 | _______ | |
March | 31–60 | 135,000 | _______ | ||
February | 61–90 | 162,000 | _______ | ||
January | 91–120 | 54,000 | _______ | ||
Total receivables | $ | 540,000 | 100% | ||
a. Calculate the percentage of amount due for
each month.
b. If the firm had $1,620,000 in credit sales
over the four-month period, compute the average collection period.
Average daily credit sales should be based on a 120-day
period.
c. If the firm likes to see its bills collected
in 45 days, should it be satisfied with the average collection
period?
d. Disregarding your answer to part c and
considering the aging schedule for accounts receivable, should the
company be satisfied?