I need help

Question 12. Empire Bridal Boutique has a credit balance of $620 in its allowance for bad debts account as of December 31, 2016. An analysis of the accounts receivable of Empire Bridal Boutique as of the same date, reveals the following Age Interval Not due 1-30 days past due 31-60 days past due Over 60 days past due Est. Percentage Uncollectible 2% 5% 11% 40% Balance 63,000 7,100 6,300 2,900 Required: 1 Prepare an aging schedule as of December 31, 2016 2 Prepare the adjusting entry to record the Bad Debt Expense at the end of the year. Age Interval Balance Estimated Percentage Amount Estimated as Not due $63,000 2% 1-30 days past due | 140 days past due | Over 60 days past due! Total 7100|596 6300|1190 2,900|4090 $79,300 Post Ref Debit Credit Description Adjusting Entries Date Dec 31