12/21/2020 D 1 Instructions: Doofenshmirtz Evil Inc. recorded sales of $400,000 in 2020. The unpaid invoices in Accounts Receivable are listed below. Doofenshmirtz uses an 2 accounts receivable aging schedule to measure the allowance for doubtful accounts. The beginning balance in the allowance for doubtful accounts was $7,000. 3 Doofenshmirtz wrote off $5,000 worth of accounts receivable during the year. Complete the tables below. Hint: The Aging Schedule computation of Bad Debt 4 expense is similar to the Percantage of Receivables method. S 6 Part 1: Calculate the days unpaid for the following open invoices using the DAYS() function 7 Customer Invoice Amount 8 O.W.C.A. $ 3,500 Candace Flynn $ 20,500 Invoice Date 6/17/2020 12/21/2020 10 Jeremy Johnson $ 1,200 10/12/2020 11 Isabelle Garcia-Shapiro $ 5,000 12/5/2020 12 Lawrence Fletcher $ 54,000 11/29/2020 13 Karl $ 200 14 Phineas Flynn $ 15 Total Unpaid Invoices $ 6,700 91,100 11/20/2020 10/4/2020 16 Current Date Number of Days Unpaid 12/31/2020 12/31/2020 12/31/2020 12/31/2020 12/31/2020 12/31/2020 12/31/2020 18 19 Days overdue 17 Part 2: Calculate the ending balance of the Allowance for Doubtful Accounts by completing the Aging Schedule Amount in Category estimated uncollectible Estimated Amount Uncollectible 200-15 21 15-30 1% 2% 22 30-60 33.en.on 1999 5% Income Stat & Balance Sheet Accounts Receivable Investory & COGS Depreciation Notes F Meaty