Exercise

The manager asks you to assist her with the data analytics on bad debts expense at year-end. To do this, you access the following Tableau Dashboard for your company.

1. Estimate the balance of the Allowance for Doubtful Accounts using percent of sales method. Assume a $0 existing balance in Allowance for Doubtful Accounts. Hint: Identify the percent of uncollectible for credit sales.

2. Estimate the balance of the Allowance for Doubtful Accounts using percent of receivables method. Assume a $0 existing balance in Allowance for Doubtful Accounts. Hint: Identify the percent of uncollectible for accounts receivable.

3. Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable. Assume a $0 existing balance in Allowance for Doubtful Accounts.