Been struggling with this excel assignment for about an hour. Keep thinking I am correctly inputting the values but whenever I check the numbers the website says my response is wrong. Need some assistance.

Apply Excel (Part 2) 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. Estimated Percent Accounts Age Group Not yet due 1-30 days past due 31-60 days past due 61-90 days past due Over 90 days past due Receivable Uncollectible 78,000 5% 10% 20% 40% 80% 34,000 16,000 10,000 12,000 $150,000 Allowance for Uncollectible Accounts 1,500 Credit After reviewing the data, you note the 'not yet due' category is overstated by 20%, while the 'Over 90 days' category is understated by 20%, (this error also caused the AR balance on the schedule to not equal the amount of Accounts Receivable on the balance sheet). 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? Answer is not complete. Accounts Receivable Allowance for Uncollectible Accounts 2. Prepare the journal entry to adjust the Allowance for Uncollectible Accounts, using your corrected data. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) Answer is not complete. General Journal Transaction No Debit Credit Bad Debt Expense Allowance for Uncollectible Accounts 1 1