An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
1.
Customer Due Date
Adams Sports and Flies May 22, 2015
Blue Dun Files Oct. 10, 2015
Cicada Fish Co. Sept. 29, 2015
Deschutes Sports Oct. 20, 2015
Green River Sports Nov. 7, 2015
Smith River Co. Nov. 28, 2015
Western Trout Company Dec. 7, 2015
Wolfe Sports Jan. 20, 2016
2., 3.
Not Past Over
Customer Balance Due 1 – 30 31 – 60 61 – 90 91 – 120 120
AAA Outfitters 20,000$ 20,000$
Brown Trout Fly Shop 7,500 7,500$
Zigs Fish Adventures 4,000 4,000
Subtotals 1,300,000$ 750,000$ 290,000$ 120,000$ 40,000$ 20,000$ 80,000$
Adams Sports and Flies 5,000
Blue Dun Files 4,900
Cicada Fish Co. 8,400
Deschutes Sports 7,000
Green River Sports 3,500
Smith River Co. 2,400
Western Trout Company 6,800
Wolfe Sports 4,400
Totals 1,342,400$
Percent uncollectible
Estimate of
uncollectible accounts
4.
5.
On the balance sheet, the omission would cause:
assets to be by
owner’s capital to be by
On the income statement, the omission would cause:
expenses to be by
net income to be by
Cells with non-gray backgrounds are protected and cannot be edited.
0%
[Key code here]
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
Days Past Due
December 31, 2015
Aging of Receivables Schedule
Problem 9-2A
Name:
Section:
Number of Days
Past Due
An asterisk (*) will appear to the right of an incorrect entry. For correct grading, enter a zero in cells you would otherwise leave blank.
otherwise leave blank.
1.
Customer Due Date
Adams Sports and Flies May 22, 2015 223
Blue Dun Files Oct. 10, 2015 82
Cicada Fish Co. Sept. 29, 2015 93
2., 3.
Not Past Over
Customer Balance Due 1 – 30 31 – 60 61 – 90 91 – 120 120
Zigs Fish Adventures 4,000 4,000
Subtotals 1,300,000$ 750,000$ 290,000$ 120,000$ 40,000$ 20,000$ 80,000$
Adams Sports and Flies 5,000 – – – – – 5,000
Blue Dun Files 4,900 – – – 4,900 – –
Cicada Fish Co. 8,400 – – – – 8,400 –
Deschutes Sports 7,000 – – – 7,000 – –
Totals 1,342,400$ 754,400$ 296,800$ 125,900$ 51,900$ 28,400$ 85,000$
4.
124,600
5.
On the balance sheet, the omission would cause:
assets to be overstated by 124,600$
Problem 9-2A
Name:
Solution
Section:
Aging of Receivables Schedule
December 31, 2015
Days Past Due
Bad Debt Expense
Number of Days
Past Due
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
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.
1.
Customer Due Date
Arcade Beauty August 17, 2015
Creative Images October 30, 2015
Excel Hair Products July 3, 2015
First Class Hair Care September 8, 2015
Golden Images November 23, 2015
Oh That Hair November 29, 2015
One Stop Hair Designs December 7, 2015
Visions Hair & Nail January 11, 2016
2., 3.
Not Past Over
Customer Balance Due 1 – 30 31 – 60 61 – 90 91 – 120 120
ABC Beauty 15,000$ 15,000$
Angel Wigs 8,000 8,000$
Zodiac Beauty 3,000 3,000
Subtotals 875,000$ 415,000$ 210,000$ 112,000$ 55,000$ 18,000$ 65,000$
Arcade Beauty 10,000
Creative Images 8,500
Excel Hair Products 7,500
First Class Hair Care 6,600
Golden Images 3,600
Oh That Hair 1,400
One Stop Hair Designs 4,000
Visions Hair & Nail 9,000
Totals 925,600$
Percent uncollectible
Estimate of
uncollectible accounts
4.
5.
On the balance sheet, the omission would cause:
assets to be by
owner’s capital to be by
On the income statement, the omission would cause:
expenses to be by
net income to be by
Cells with non-gray backgrounds are protected and cannot be edited.
0%
[Key code here]
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
Days Past Due
Problem 9-2B
Name:
Section:
December 31, 2015
Aging of Receivables Schedule
Number of Days
Past Due
An asterisk (*) will appear to the right of an incorrect entry. For correct grading, enter a zero in cells you would otherwise leave blank.
otherwise leave blank.
1.
Customer Due Date
Arcade Beauty August 17, 2015 136
Creative Images October 30, 2015 62
Excel Hair Products July 3, 2015 181
2., 3.
Not Past Over
Customer Balance Due 1 – 30 31 – 60 61 – 90 91 – 120 120
ABC Beauty 15,000$ 15,000$
Zodiac Beauty 3,000 3,000
Subtotals 875,000$ 415,000$ 210,000$ 112,000$ 55,000$ 18,000$ 65,000$
Arcade Beauty 10,000 – – – – – 10,000
Creative Images 8,500 – – – 8,500 – –
Excel Hair Products 7,500 – – – – – 7,500
First Class Hair Care 6,600 – – – – 6,600 –
4.
115,860
5.
On the balance sheet, the omission would cause:
assets to be overstated by 115,860$
Problem 9-2B
Name:
Solution
Section:
Aging of Receivables Schedule
December 31, 2015
Days Past Due
Bad Debt Expense
Number of Days
Past Due
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
Cells with non-gray backgrounds are protected and cannot be edited.