Aging of Receivables Estimating Allowance for Doubtful Accounts Wig Creations Company supplies wigs and hair care products to beauty salons throughout Texas and the Southwest The accounts receivable clerk for Wig Creations prepared the following partially completed aging of receivables schedule as of the end of business on December 31, 20Y1 Days Past Due Balance Not Past Due 1 30 31 60 61 90 91 120 over 120 554,000 307,400 133,000 60,900 20,500 18,300 13,900 The following accounts were unintentionally omitted from the aging schedule Customer Due Date Balance Arcade Beauty May 28, 20Y1 $2,500 Creative Images Sept 7, 20Y1 5,300 Excel Hair Products Oct 17, 20Y1 700 First Class Hair Care Oct 24, 20Y1 1,800 Golden Images Nov 23, 20Y1 600 Oh The Hair Nov 29, 20Y1 3,100 One Stop Hair Designs Dec 2, 20Y1 2,000 Visions Hair and Nail Jan 5, 20Y2 6,500 Wig Creations has a past history of uncollectible accounts by age category, as follows Age Class Percent Uncollectible Not past due 1 1 30 days past due 3 31 60 days past due 10 61 90 days past due 15 91 120 days past due 35 Over 120 days past due 85 Required 1 Determine the number of days past due for each of the preceding accounts If an account is not past due, enter a zero Customer Due Date Number of Days Past Due Arcade Beauty May 28, 20Y1 days Creative Images Sept 7, 20Y1 days Excel Hair Products Oct 17, 20Y1 days First Class Hair Care Oct 24, 20Y1 days Golden Images Nov 23, 20Y1 days Oh The Hair Nov 29, 20Y1 days One Stop Hair Designs Dec 2, 20Y1 days Visions Hair and Nail Jan 5, 20Y2 days Feedback 2 Complete the aging of receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals If an amount box does not require an entry, leave it blank Wig Creations Company Aging of Receivables Schedule December 31, 20Y1 Customer Balance Not Past Due Days Past Due 1 30 Days Past Due 31 60 Days Past Due 61 90 Days Past Due 91 120 Days Past Due Over 120 Subtotals Arcade Beauty Creative Images Excel Hair Products First Class Hair Care Golden Images Oh The Hair One Stop Hair Designs Visions Hair and Nail Totals Percent uncollectible ( ) 1 3 10 15 35 85 Estimate of uncollectible accounts $ $ $ $ $ $ $ Feedback 3 Estimate the allowance for doubtful accounts, based on the aging of receivables schedule $ Feedback 4 Assume that the allowance for doubtful accounts for Wig Creations has a credit balance of $1,540 before adjustment on December 31, 20Y1 Journalize the adjustment for uncollectible accounts Feedback 5 Assume that the adjusting entry in (4) was inadvertently omitted, how would the omission affect the balance sheet and income statement On the balance sheet, assets would be by because the allowance for doubtful accounts would be by In addition, the owners capital account would be by because bad debt expense would be and net income by on the income statement

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 22, 2024

Aging of Receivables; Estimating Allowance for Doubtful Accounts Wig Creations Company supplies wigs and hair care products to beauty salons throughout Texas and the Southwest.

Aging of Receivables; Estimating Allowance for Doubtful Accounts

Wig Creations Company supplies wigs and hair care products to beauty salons throughout Texas and the Southwest. The accounts receivable clerk for Wig Creations prepared the following partially completed aging of receivables schedule as of the end of business on December 31, 20Y1:

Balance	Not Past Due	1-30	31-60	61-90	91-120	over 120
		Days Past Due
554,000	307,400	133,000	60,900	20,500	18,300	13,900

The following accounts were unintentionally omitted from the aging schedule:

Customer		Balance
Arcade Beauty	May 28, 20Y1	$2,500
Creative Images	Sept. 7, 20Y1	5,300
Excel Hair Products	Oct. 17, 20Y1	700
First Class Hair Care	Oct. 24, 20Y1	1,800
Golden Images	Nov. 23, 20Y1	600
Oh The Hair	Nov. 29, 20Y1	3,100
One Stop Hair Designs	Dec. 2, 20Y1	2,000
Visions Hair and Nail	Jan. 5, 20Y2	6,500

Wig Creations has a past history of uncollectible accounts by age category, as follows:

Age Class	Percent Uncollectible
Not past due	1	%
1-30 days past due	3
31-60 days past due	10
61-90 days past due	15
91-120 days past due	35
Over 120 days past due	85

Required:

1. Determine the number of days past due for each of the preceding accounts. If an account is not past due, enter a zero.

Customer	Due Date	Number of Days Past Due
Arcade Beauty	May 28, 20Y1	days
Creative Images	Sept. 7, 20Y1	days
Excel Hair Products	Oct. 17, 20Y1	days
First Class Hair Care	Oct. 24, 20Y1	days
Golden Images	Nov. 23, 20Y1	days
Oh The Hair	Nov. 29, 20Y1	days
One Stop Hair Designs	Dec. 2, 20Y1	days
Visions Hair and Nail	Jan. 5, 20Y2	days

Feedback

2. Complete the aging of receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals. If an amount box does not require an entry, leave it blank.

Wig Creations Company
Aging of Receivables Schedule
December 31, 20Y1
Customer	Balance	Not Past Due	Days Past Due 1-30	Days Past Due 31-60	Days Past Due 61-90	Days Past Due 91-120	Days Past Due Over 120
Subtotals
Arcade Beauty
Creative Images
Excel Hair Products
First Class Hair Care
Golden Images
Oh The Hair
One Stop Hair Designs
Visions Hair and Nail
Totals
Percent uncollectible (%)		1%	3%	10%	15%	35%	85%
Estimate of uncollectible accounts	$	$	$	$	$	$	$

Feedback

3. Estimate the allowance for doubtful accounts, based on the aging of receivables schedule. $

Feedback

4. Assume that the allowance for doubtful accounts for Wig Creations has a credit balance of $1,540 before adjustment on December 31, 20Y1. Journalize the adjustment for uncollectible accounts.

Feedback

5. Assume that the adjusting entry in (4) was inadvertently omitted, how would the omission affect the balance sheet and income statement?

On the balance sheet, assets would be by because the allowance for doubtful accounts would be by . In addition, the owners capital account would be by because bad debt expense would be and net income by on the income statement.