Question

In: Accounting

Below is the “totals” section of XYZ Corporation’s full aging schedule. XYZ will be using this...

  1. Below is the “totals” section of XYZ Corporation’s full aging schedule. XYZ will be using this information to estimate uncollectible accounts receivable at year-end

    Number of Days Outstanding
    Total 0-30 31-60 61-90 91-120 Over 120
    Accounts receivable $ 375,000 $ 220,000 $   90,000 $   30,000 $   20,000 $   15,000
    % uncollectible 1% 4% 5% 9% 20%
    Estimate bad debts

    Instructions:

    1. Calculate the total estimated bad debts based on the above information.
    2. Prepare the year-end adjusting journal entry to record the bad debts using the allowance method and the aged uncollectible accounts receivable determined in (a). Assume the current balance in Allowance for Doubtful Accounts is a $3,000 credit.
    3. Prepare the year-end adjusting journal entry to record the bad debts using the allowance method and the aged uncollectible accounts receivable determined in (a). Assume the current balance in Allowance for Doubtful Accounts is a $500 debit.
    4. Of the above accounts, $1,800 is determined to be specifically uncollectible. Prepare the journal entry to write off the uncollectible accounts
    5. The company subsequently collects $700 on a specific account that had previously been determined to be uncollectible in (d). Prepare the journal entry(ies) necessary to restore the account and record the cash collection.
    6. Explain how establishing an allowance account satisfies the expense recognition principle.

Please list each response separately label them clearly to avoid confusion. thank you.

Solutions

Expert Solution

a)

Age category Amount % uncollectible Estimated Bad debts
0-30 220000 1% 2200
31-60 90000 4% 3600
61-90 30000 5% 1500
91-120 20000 9% 1800
over 120 15000 20% 3000
Total estimated bad debts 12100

b)

Bad debt expense for the year = Total estimated bad debts - current balance in Allowance for Doubtful Accounts

                        = 12100 -3000

                       = 9100

Date Account title Debit credit
Bad debt expense 9100
Allowance for doubtful account 9100

c)

Bad debt expense for the year = Total estimated bad debts - current balance in Allowance for Doubtful Accounts

                        = 12100 -(-500)

                        = 12100+500

                       = 12600

Date Account title Debit credit
Bad debt expense 12600
Allowance for doubtful account 12600

d)

Date Account title Debit credit
Allowance for doubtful account 1800
Accounts receivable 1800

Related Solutions

Below is the “totals” section of XYZ Corporation’s full ageing schedule. XYZ will be using this...
Below is the “totals” section of XYZ Corporation’s full ageing schedule. XYZ will be using this information to estimate uncollectible accounts receivable at year-end. Number of Days Outstanding Total 0-30 31-60 61-90 91-120 Over 120 Accounts receivable $ 375,000 $ 220,000 $   90,000 $   30,000 $   20,000 $   15,000 % uncollectible 1% 4% 5% 9% 20% Estimate bad debts   Instructions (a)   Calculate the total estimated bad debts based on the above information. (b)   Prepare the year-end adjusting journal entry to...
The following selected information is from Imagine Corporation’s partial aging schedule in fiscal year 2015. To...
The following selected information is from Imagine Corporation’s partial aging schedule in fiscal year 2015. To determine the adjusted allowance for doubtful accounts, the company uses each percentage of uncollectible Accounts Receivables based on different classifications of the number of outstanding days. Number of Days Outstanding Accounts Receivable Estimated Percentage Uncollectible 0-30 days $110,000 1% 31-60 days 50,000 5% 61-90 days 20,000 20% Over 90 days 12,500 50% Total $192,500 The unadjusted balance in Allowance for Doubtful Accounts is a...
Question 6: The following selected information is from Imagine Corporation’s partial aging schedule at the end...
Question 6: The following selected information is from Imagine Corporation’s partial aging schedule at the end of August: Number of Days Outstanding:   Accounts Receivable:   Estimated Percentage Uncollectible: Estimated Uncollectible Accounts 0-30 days $280, 000 1% 31-60 days $90,000 3% 61-90 days $45,000 10% Over 90 days $18,000 15% Total: $433,000 The unadjusted balance in Allowance for Doubtful Accounts is a debit of $4,300. Required (a) Complete the aging schedule and calculate the total estimated uncollectible accounts from the above information....
Using the Accounts Receivable Aging Schedule below, answer the following questions related to Christina’s Cookie Company:...
Using the Accounts Receivable Aging Schedule below, answer the following questions related to Christina’s Cookie Company: Customer Current Balance 1-30 days past due 31-60 days past due 61-90 past due +90 days past due Total Smith $100 $200 $300 Jones $300 $800 $1,100 Brown $800 $100 $800 $1,700 Edwards $5,000 $5,000 Totals $900 $400 $800 $1,000 $5,000 $8,100 Estimation of the allowance for doubtful accounts is based on the following rules: Aging Category Probability AR will not be collected Current...
Section B: Using the financial statements of XYZ Furnishings (below), comment on your interpretation of the...
Section B: Using the financial statements of XYZ Furnishings (below), comment on your interpretation of the financial health of the company. There is a maximum of 10 marks available for this section, four marks for your knowledge and understanding of the financial statements, four marks for your analysis and evaluation and 2 marks for your communication. Statement of Financial Position Assets Current Cash and equivalents 220 Trade receivables 8,420 Other receivables 10 Inventories 1,000 ST Investments 160 Non-Current Land and...
Presented below is an aging schedule for the Ivan Company at December 31, 2020: Customer Balance...
Presented below is an aging schedule for the Ivan Company at December 31, 2020: Customer Balance Not Yet Due 1-30 past due 31-60 past due 61-90 past due Over 90 Culberson $24,000 $ 9,000 $15,000 Samsa 30,000 $30,000 Burks 50,000 5,000 5,000 $40,000 Greuel 38,000 $38,000 Others 120,000 72,000 35,000 13,000 $262,000 $107,000 $49,000 $28,000 $40,000 $38.000 % estimated uncollectible 3% 7% 12% 24% 60% Total estimated uncollectible $42,400 $3,210 $3,430 $3,360 $9,600 $22,800 At December 31 2020, the unadjusted...
Presented below is an aging schedule for Pearl Industries at December 31, 2021. Customer Total Not...
Presented below is an aging schedule for Pearl Industries at December 31, 2021. Customer Total Not Yet Due Number of Days Past Due 1–30 31–60 61–90 Over 90 Aneesh $ 22,000 $ 8,200 $13,800 Bird 30,500 $ 30,500 Cope 46,000 5,300 4,500 $36,200 DeSpears 36,200 $36,200 Others 126,000 78,500 34,400 13,100    $260,700 $114,300 $47,100 $26,900 $36,200 $36,200 Estimated percentage uncollectible 3% 7% 13% 26% 62% Total estimated bad debts $ 42,079 $ 3,429 $3,297 $3,497 $ 9,412 $22,444 At...
resented below is an aging schedule for Wildhorse Company on December 31, 2021. Wildhorse sells all...
resented below is an aging schedule for Wildhorse Company on December 31, 2021. Wildhorse sells all of its goods on account with terms n/30. Number of Days Past Due Customer Total Not yet Due 1–30 31–60 61–90 Over 90 Akers $18,800 $8,500 $10,300 Barrett 28,200 $28,200 Corner 47,000 14,100 4,700 $28,200 DeJong 35,700 $35,700 Other 118,400 86,500 14,100 12,200 5,600 $248,100 $128,800 $27,300 $22,500 $28,200 $41,300 Estimated percentage uncollectible 2% 5% 8% 27% 54% At December 31, 2021, the unadjusted...
Using an Aging Schedule to Account for Bad Debts Sparkle Jewels distributes fine stones. It sells...
Using an Aging Schedule to Account for Bad Debts Sparkle Jewels distributes fine stones. It sells on credit to retail jewelry stores and extends terms that require the stores to pay in 60 days. For accounts that are not overdue, Sparkle has found that there is a 90% probability of collection. For accounts up to one month past due, the likelihood of collection decreases to 75%. If accounts are between one and two months past due, the probability of collection...
Using an Aging Schedule to Account for Bad Debts Sparkle Jewels distributes fine stones. It sells...
Using an Aging Schedule to Account for Bad Debts Sparkle Jewels distributes fine stones. It sells on credit to retail jewelry stores and extends terms that require the stores to pay in 60 days. For accounts that are not overdue, Sparkle has found that there is a 90% probability of collection. For accounts up to one month past due, the likelihood of collection decreases to 75%. If accounts are between one and two months past due, the probability of collection...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT