An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
a.
Customer Due Date
Color World Industries March 13
Hawks Company June 29
Osler Inc. July 8
Sather Sales Company September 6
Wisdom Company August 25
b.
Not Past Over
Customer Balance Due 1 – 30 31 – 60 61 – 90 90
Allied Industries Inc. 3,000$ 3,000$
Archer Company 4,500 4,500$
Zussman Company 5,000 5,000
Subtotals 750,000$ 480,000$ 160,000$ 75,000$ 28,000$ 7,000$
Color World Industries 33,000
Hawks Company 15,000
Osler Inc. 21,000
Sather Sales Company 8,000
Wisdom Company 6,500
Totals 833,500$
0%
[Key code here]
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
Aging of Receivables Schedule
August 31
Days Past Due
Number of Days
Past Due
Name:
Student
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
a.
Customer Due Date
Color World Industries March 13 171
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
Name:
Solution
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
Number of Days
Past Due