Question

In: Accounting

Days Past Due Customer Balance Not Past Due 1-30 31-60 61-90 91-120 over 120 Subtotals 553,900...

Days Past Due
Customer Balance Not Past Due 1-30 31-60 61-90 91-120 over 120
Subtotals 553,900 307,500 132,900 60,900 20,500 18,300 13,800

The following accounts were unintentionally omitted from the aging schedule:

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

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

Age Class Percent Uncollectible
Not past due 2 %
1-30 days past due 4
31-60 days past due 12
61-90 days past due 18
91-120 days past due 40
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

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
Total
Percent uncollectible 2% 4% 12% 18% 40% 85%
Estimate of uncollectible accounts

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

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

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 owner’s capital account would be   by   because bad debt expense would be   and net income   by   on the income statement.

Solutions

Expert Solution



Related Solutions

Number of Days Unpaid   Customer Total 0-30 31-60 61-90 Over 90     Aerosmith $ 2,000 $ 1,000...
Number of Days Unpaid   Customer Total 0-30 31-60 61-90 Over 90     Aerosmith $ 2,000 $ 1,000 $ 1,000     Biggie Small 2,000 $ 1,000 $ 1,000       Others (not shown to save space) 100,200 39,300 42,300 9,300 9,300       ZZ Top 7,300 7,300   Total Accounts Receivable $ 111,500 $ 47,600 $ 43,300 $ 10,300   $ 10,300     Estimated uncollectible (%) 5% 15% 25% 40% Elite Events Corporation has provided event planning services for several years. The company uses the percentage of credit sales method...
Sales (on credit terms) A/R Balance Current 31-60 61-90 90+ Jan 3390 6,200 3,345 1795 1000...
Sales (on credit terms) A/R Balance Current 31-60 61-90 90+ Jan 3390 6,200 3,345 1795 1000 60 Feb 3,610 6,000 3,560 1,550 825 65 Mar 3890 6,340 3,590 1800 900 50 Total 10,890 using the sample ATB above, compute the collection effectiveness index of the company (10Items must show solutions). Then provide analysis of the effect of the result when it will decrease and when it will increase?
Age of A/R Total Balance as of 3/31 Estimated Percentage Uncollectable 1-30 Days $77,300 3% 31-60...
Age of A/R Total Balance as of 3/31 Estimated Percentage Uncollectable 1-30 Days $77,300 3% 31-60 Days $22,900 5% 61-90 Days $9,400 24% 91+ Days $7,200 54% Total Balance $116,800 1) Prepare the journal entry for bad debt expense on 3/31, assuming a credit (positive) balance of $1,400 in the Allowance for Doubtful Accounts before adjustment. 2) Prepare the journal entry for bad debt expense on March 31st, assuming instead that the company has a debit (negative) balance of $1,400...
You owe suppliers balances at 90 days + past due for contract work. -What is the...
You owe suppliers balances at 90 days + past due for contract work. -What is the purpose of a Mechanics Lien for vendors demanding payment?
What are some good first 30-60-90 days plan example for an Account Manager (with half a...
What are some good first 30-60-90 days plan example for an Account Manager (with half a year training)?  
Daley Company prepared the following aging of receivables analysis at December 31. Days Past Due Total...
Daley Company prepared the following aging of receivables analysis at December 31. Days Past Due Total 0 1 to 30 31 to 60 61 to 90 Over 90 Accounts receivable $ 590,000 $ 400,000 $ 94,000 $ 40,000 $ 22,000 $ 34,000 Percent uncollectible 2 % 3 % 6 % 8 % 11 % Exercise 7-8 Aging of receivables method LO P3 a. Complete the below table to calculate the estimated balance of Allowance for Doubtful Accounts using aging of...
Daley Company prepared the following aging of receivables analysis at December 31. Days Past Due Total...
Daley Company prepared the following aging of receivables analysis at December 31. Days Past Due Total 0 1 to 30 31 to 60 61 to 90 Over 90 Accounts receivable $ 580,000 $ 398,000 $ 92,000 $ 38,000 $ 20,000 $ 32,000 Percent uncollectible 3 % 4 % 7 % 9 % 12 % a. Complete a table to calculate the estimated balance of Allowance for Doubtful Accounts using aging of accounts receivable. b. Prepare the adjusting entry to record...
3. Using the information below, perform the following tasks: Account Receivables Not Past Due 0-31 days...
3. Using the information below, perform the following tasks: Account Receivables Not Past Due 0-31 days Past Due 31-60 days Past Due 61-90 days Past Due + 90 days Past Due 350,000 175,000 83,000 38,000 12,000 Percentage of not collecting 2% 8% 22% 58% 78% Calculate the estimated amount of receivables that might not be collected Perform the adjustment(debit/credit) using the allowance method.
QuickE Lube has been monitoring its customer service times over the past 5 days. Each day...
QuickE Lube has been monitoring its customer service times over the past 5 days. Each day they took a sample of 10 customers and recorded the actual service times for those customers. The table below shows the sample mean and sample range for each of the 5 past samples. Excel access Sample 1 2 3 4 5 Mean 22 19 19.4 22.0 21.8 Range 4.4 5.1 3.2 2.9 1.0 What is the three-sigma upper control limits (UCL Only)the company should...
31. Problem 1 : Linden Company will receive 200,000 Canadian dollars (C$) in 90 days and...
31. Problem 1 : Linden Company will receive 200,000 Canadian dollars (C$) in 90 days and is trying to determine whether or not to hedge this position. Linden has developed the following probability distribution for the Canadian dollar: Possible Value of Canadian Dollar in 90 Days Probability $0.54 $0.55 15% 15% $ 0.57 20% $ 0.58 25% $ 0.59 25% The 90-day forward rate of the Canadian dollar is $0.575. Call options on the Canadian dollar are available with a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT