Preparing an Aging Schedule to Estimate Allowance for Doubtful Accounts A review of open invoices of Sketchers Inc. results in the following report. Date (Each from this Invoice Amount year) #496 $305.65 5-Dec #495 457.18 2-Dec #427 182.77 5-Nov #100 72.71 28-Jun #300 494.29 3-Oct #410 446.84 31-Oct #204 41.80 25-Aug #498 507.23 28-Dec #499 184.10 28-Dec #487 498.19 28-Nov #310 138.43 8-Oct # 178 428.81 7-Aug #497 223.36 5-Dec #488 #105 95.27 29-Nov 12.49 $4,089.12 5-Jul Required a. Organize the list of open invoices as of December 31 into a table with the following aging categories across the top: (1) less than 31 days, (2) 31-60 days, (3) 61-90 days, and (4) greater than 90 days. b. Assume that the company estimates the allowance for doubtful accounts based on the following percentages applied to the appropriate aging categories: (1) 1% for less than 31 days, (2) 5% for 31-60 days, (3) 30% for 61-90 days, and (4) 60% for greater than 90 days. What is the ending balance of the allowance for doubtful accounts as estimated by the company? Complete the following table to complete requirements of parts a and b. Note: For each of the dollar amounts that you enter into the table below, round to two digits after the decimal; for example, enter 1.42 for 1.424, or 1.43 for 1.425. Less than Greater than 31 days 31-60 Days 61-90 Days 90 Days Total Total Receivables $ 0 $ 0 $ 0 $ 0 $ 0 Percentage 0% 0% 0% 0% Estimated Uncollectibles $ 0 $ 0 $ 0 $ 0 $ 0

! Required information [The following information applies to the questions displayed below.] Daley Company prepared the following aging of receivables analysis at December 31. Accounts receivable. Percent uncollectible Req A Req B and C Complete this question by entering your answers in the tabs below. Accounts Receivable X Total $575,000 X a. Complete the table below 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,700 credit. XX c. 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 $200 debit. Not due: 1 to 30: 31 to 60: 61 to 90: Over 90: Estimated balance of allowance for uncollectibles X X Percent Uncollectible (%) 0 $397,000 Complete the table below…

Estimates of doubtful debts is 10% of Accounts Receivable as at 30 Sept. Record the adjusting entry for the allowance for doubtful debts account at 30 Sept.

Calculate the required Allowance for Doubtful Accounts under the Accounts Receivable Aging Method using the following information: Age Group 0-30 days past due 31-60 days past due 61-120 days past due 121-180 days past due Over 180 days past due 10,000 $2,650 $3,650 5,000 Balance $100,000 $20,000 $10,000 $5,000 $5,000 Probability of Non- collection 1% 2% 5% 10% 25%