On November 30, 2020, ABC law firm, providing legal consulting services, had the following account receivable...

Transcribed Image Text:

On November 30, 2020, ABC law firm, providing legal consulting services, had the following account receivable amounts due from its customer: Not Yet 1-30 Days 31-60 Days 61-90 Days Customer Due Past Due Past Due Past Due ACCT Tech. $1,400 $300 Over 90 Days Past Due $200 GMA Ltd. 2,700 850 Coogle Inc. 1,500 1,500 $800 $1,000 CY Studio 1,800 Moc Ltd. S&W Corp. 500 350 500 700 250 Based on the firm's past experience, it has established the following percentages for estimating uncollectible accounts: Aging Interval Percent Uncollectible Not yet due 1% 1-30 days past due 3% 31-60 days past due 5% 61-90 days past due 10% Over 90 days past due 25% Requirement: 1. You have been asked to estimate the total amount of uncollectible accounts expense as of November 30, 2020 by completing the excel file. (80%) 2. Using the above Aging Interval and the corresponding dollar amounts as the X-axis and Y- axis, respectively, create a chart and explain what this chart means. (20%) On November 30, 2020, ABC law firm, providing legal consulting services, had the following account receivable amounts due from its customer: Not Yet 1-30 Days 31-60 Days 61-90 Days Customer Due Past Due Past Due Past Due ACCT Tech. $1,400 $300 Over 90 Days Past Due $200 GMA Ltd. 2,700 850 Coogle Inc. 1,500 1,500 $800 $1,000 CY Studio 1,800 Moc Ltd. S&W Corp. 500 350 500 700 250 Based on the firm's past experience, it has established the following percentages for estimating uncollectible accounts: Aging Interval Percent Uncollectible Not yet due 1% 1-30 days past due 3% 31-60 days past due 5% 61-90 days past due 10% Over 90 days past due 25% Requirement: 1. You have been asked to estimate the total amount of uncollectible accounts expense as of November 30, 2020 by completing the excel file. (80%) 2. Using the above Aging Interval and the corresponding dollar amounts as the X-axis and Y- axis, respectively, create a chart and explain what this chart means. (20%)