es Revise your worksheet to reflect these updated assumptions then answer the questions that follow. You have been provided with the following Aging Report to use to adjust the Allowance for Uncollectible Accounts for a company at year end. Age Group Not yet due 1 to 30 days past due 31 to 60 days past due 61 to 90 days past due Over 90 days past due Accounts Receivable $96,000 43,000 34,000 28,000 21,000 $222,000 Estimated Percent Uncollectible 5% 10% 20% 40% 80% Allowance for Uncollectible Accounts After reviewing the data, you note the "not yet due" category is overstated and needs to decrease by 20%. Also, the "Over 90 days" category is understated and needs to increase by 20%. 2,400 Credit Also, you note the balance in the Allowance account is actually a debit, rather than a credit. Being that the normal balance for this account is a credit, the accountant hadn't noticed the issue. Required: 1. Use your spreadsheet to recalculate the needed adjustment and account balances. What will be the balance in Accounts Receivable and the Allowance for Uncollectible Accounts based on the above information? ha