The data set provided with this chapter includes data for the allowance for doubtful accounts receivable accounts for Chevron, Cisco, Coca-Cola, Dow, Microsoft, and Verizon from 2016 to 2018. The following data includes the following accounts: beginning balance in the allowance for doubtful accounts, bad debt expense, write-offs, amounts charged to other accounts, and ending balance in the allowance for doubtful accounts. William R. Pasewark and Mark E. Riley (Journal of Accountancy, September 2009, pages 40-44) discuss three techniques for analyzing estimates of uncollectible receivables. The provided data visualization dashboard uses the first two techniques to create comparisons. It contains the following charts: 1. Figure 1: Allowance for Doubtful Accounts Changes 2. Figure 2: Compare Bad Debt Expense (BDE) to Write-Off (WO) - 3. Figure 3: Compare Beginning Allowance for Doubtful Accounts (BADA) to write-offs (WO) Analyze the data in these charts and use your findings to answer the questions below. Click here to view the data in Tableau, and here to view it in Power BI. (The Tableau and Power BI files contain the same data; you can use either to answer the questions in this assignment. Your instructor may specify which program they prefer you to use!) How to Access Tableau: You can open the Tableau file in this problem statement with Tableau Desktop software. If you don't have Tableau Desktop, you can download Tableau Reader, a free program that allows you to open Tableau visualizations. To get it, search for "Tableau Reader" in your internet browser, or click here. How to Access Power BI: You can open the Power BI file in this problem statement with Power BI Desktop. If you don't have it already, search for "Power BI download" in your internet browser, or click here for a free download. Which company is showing an increasing trend in the beginning allowance for doubtful accounts, bad debt expense and ending allowance for doubtful accounts? Cisco Microsoft Chevron Coca-Cola Which of the following statements are true? Verizon has the largest amount of bad debt expense Microsoft has decreasing ending allowance for doubtful accounts Coca-Cola has increasing bad debt expense values Cisco has increasing ending allowance for doubtful accounts Based on Pasewark and Riley's technique on evaluating bad debt expense to write-off, what can be concluded from Figure 2? Coca-Cola is estimating its collection problem appropriately Chevron is underestimating its collection problem Verizon is overestimating its collection problem Microsoft is estimating its collection problem appropriately Based on Pasewark and Riley's technique on evaluating beginning allowance for doubtful accounts to write-offs, what can be concluded from Figure 3? Coca-Cola has an inconsistent allowance for doubtful accounts and write-off relationship Chevron has increasing write-off values Chevron has a consistent allowance for doubtful accounts and write-off relationship Verizon is overestimating its allowance for doubtful accounts Allowance for Doubtful Accounts Analysis Figure 1: Allowance for Doubtful Accounts Changes Bad Debt Exp I Figure 2: Compare Bad Debt Expense (BDE) to Write-Offs (WO) Figure 3: Compare Beginning Allowance for Doubtful Accounts (BADA) to Write-Offs (WO)