A. Use a snipping tool to copy and paste the table below into a Excel spreadsheet. Review the financial data and additional information for the two companies that you are considering investing in, Company A and B: Company A Company B Net credit sales, Dec. 31, 2019 Net accounts receivable, Dec. 31, 2018 Net accounts receivable, Dec. 31, 2019 $540,000 $620,000 $120,000 $180,000 $145,000 $175,000 Number of days' sales in receivables ratio, 2018 103 days 110 days Net income, Dec. 31, 2018 $250,000 $350,000 Additional Information: Company A: Bad debt estimation percentage using the income statement method is 6%, and the balance sheet method is 10%. The $230,000 in Other Expenses includes all company expenses except Bad Debt Expense. Company B: Bad debt estimation percentage using the income statement method is 6.5%, and the balance sheet method is 8%. The $140,000 in Other Expenses includes all company expenses except Bad Debt Expense. B. On an Excel spreadsheet, answer the following questions below: 1. Compute the number of days' sales in receivables ratio for each company for 2019 and interpret the results (round answer to nearest whole number) point). 2. If Company A changed from the income statement method to the balance sheet method for recognizing bad debt estimation, how would that change net income in 2019? Explain (show calculations as formulas in the cells). 3. If Company B changed from the balance sheet method to the income statement method for recognizing bad debt estimation, how would that change net income in 2019? Explain (show calculations as formulas in the cells). 4. What benefits do each company gain by changing their method of bad debt estimation? 5. Which company would you invest in and why? Provide supporting details.