Arundel Company uses aging to estimate uncollectibles. At the end of the fiscal year, December 31, 2018, Accounts Receivable has a balance that consists of:
Dollar Value Age of Account Estimated Collectible
$215,000 < 30 days old 98.0%
60,000 30 to 60 days old 92.0%
25,000 61 to 120 days old 78.5%
13,000 >120 days old 12.0%
The current unadjusted Allowance for Uncollectible Accounts balance is a debit balance of $2,000 and the Bad Debt Expense accounts has an unadjusted balance of zero. After the adjusting entry is made, what will be the dollar balances in the Allowance for Doubtful Accounts? Round to nearest whole dollar.
Answer a. | Date | Account | Debit | Credit |
31-Dec | Bad debts expense | $ 27,915 | ||
Allowance for doubtful accounts | $ 27,915 | |||
(Provision made for Bad debts expenses) | ||||
Answer b. | Balance in allowances for uncollectible | $ 25,915 | ||
Detailed Workings | ||||
Calculation of Provision required for Current year | ||||
Dollar Value | Age of Account | Estimated Collectible | Estimated Uncollectible % | Estimated Uncollectible (Amount) |
a | b | c | d = 100-c | e = a*d |
$215,000 | <30 days old | 98.00% | 2.00% | $4,300 |
60,000 | 30 to 60 days old | 92.00% | 8.00% | $4,800 |
25,000 | 61 to 120 days old | 78.50% | 21.50% | $5,375 |
13,000 | >120 days old | 12.00% | 88.00% | $11,440 |
Total Estimated Amount of Uncollectibles | $25,915 | |||
Allowance for Uncollectible Account (Dr) | 2000 | |||
Bad debt expense for adjusting entry | $27,915 |
Arundel Company uses aging to estimate uncollectibles. At the end of the fiscal year, December 31,...
Baltimore Company uses aging to estimate uncollectibles. At the end of the fiscal year, December 31, 2018, Accounts Receivable has a balance that consists of: Dollar Value Age of Account Estimated Collectible $180,000 < 30 days old 99% 65,000 30 to 60 days old 94% 30,000 61 to 120 days old 78% 13,000 > 120 days old 17% The current unadjusted Allowance for Uncollectible Accounts balance is a debit balance of $2,000 and the Bad Debt Expense accounts has an unadjusted...
Baltimore Company uses aging to estimate uncollectibles. At the end of the fiscal year, December 31, 2018, Accounts Receivable has a balance that consists of: Dollar Value Age of Account Estimated Collectible $155,000 < 30 days old 99% 75,000 30 to 60 days old 93% 25,000 61 to 120 days old 70% 10,000 > 120 days old 19% The current unadjusted Allowance for Uncollectible Accounts balance is a debit balance of $2,000 and the Bad Debt Expense accounts has an unadjusted...
Baltimore Company uses aging to estimate uncollectibles. At the end of the fiscal year, December 31, 2018, Accounts Receivable has a balance that consists of: Dollar Value Age of Account Estimated Collectible $180,000 < 30 days old 99% 60,000 30 to 60 days old 90% 20,000 61 to 120 days old 70% 8,000 > 120 days old 12% The current unadjusted Allowance for Uncollectible Accounts balance is a debit balance of $2,000 and the Bad Debt Expense accounts has an unadjusted...
Arundel Company uses percentage of sales to estimate uncollectibles. At the end of the fiscal year, December 31, 2018, Accounts Receivable has a balance of $78,000 and had a total of $725,000 in credit sales. Arundel assumes that 1.5% of sales will eventually be uncollectible. before adjustment, the Allowance for Uncollectible Accounts had a credit balance of 4,000. What dollar amount should be credited to Allowance for Uncollectible Accounts at year end?
Cindrella uses aging to estimate uncollectibles. Accounts of $150,000 are less than 30 days old (96% collectible), $80,000 are 30 to 60 days old (85% collectible), $35,000 are 61-120 days old (50% collectible), and the remaining $10,000 is 10% collectible. Question 12 options: A) The Allowance for Uncollectibles should have a balance of $6,000. B) The Allowance for Uncollectibles should have a balance of $17,500. C) The Allowance for Uncollectibles should have a balance of $44,500. D) The Allowance for...
Exercise 9-8 Aging of receivables method P3Daley Company prepared the following aging of receivables analysis at December 31. Days Past DueTotal0 1 to 30 31 to 60 61 to 90 Over 90 Accounts receivable$570,000$396,000$90,000$36,000$18,000$30,000Percent uncollectible 1%2%5%7% 10% a. Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable b. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $3,600 credit. c. Prepare the adjusting entry to record bad...
Daley Company prepared the following aging of receivables analysis at December 31.Days Past DueTotal0 1 to 30 31 to 60 61 to 90 Over 90 Accounts receivable$585,000$399,000$93,000$39,000$21,000$33,000Percent uncollectible 1%2%5%7% 10%a. Complete the below table to calculate the estimated balance of Allowance for Doubtful Accounts using aging of accounts receivable. b. Prepare the adjusting entry to record Bad Debts Expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $3,900 credit. c. Prepare the adjusting entry to record bad debts...
Canarie Ltd. prepares an aging schedule for its accounts receivable at the end of each month and records bad debts expense monthly. The following selected information is from Canarie’s partial aging schedule at the end of July: Number of Days Outstanding Accounts Receivable Estimated Percentage Uncollectible 0–30 days $719,000 2% 31–60 days 326,000 6% 61–90 days 121,000 11% Over 90 days 78,000 23% Total $1,244,000 The unadjusted balance in Allowance for Doubtful Accounts is a credit of $13,000. (a) Your...
Daley Company prepared the following aging of receivables analysis at December 31. a. Estimate the balance of the Allowance for Doubtful Accounts assuming the company uses 5% of total accounts receivable to estimate uncollectibles, instead of the aging of receivables method. b. Prepare the adjusting entry to record Bad Debts Expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $12,500 credit. c. Prepare the adjusting entry to record bad debts expense using the estimate...
Daley Company prepared the following aging of receivables analysis at December 31. a. Estimate the balance of the Allowance for Doubtful Accounts assuming the company uses 4.5% of total accounts receivable to estimate uncollectibles, instead of the aging of receivables method. b. Prepare the adjusting entry to record Bad Debts Expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $12,000 credit. c. Prepare the adjusting entry to record bad debts expense using the...