Instructions 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: Net credit sales, Dec. 31, 2019 Net accounts receivable, Dec. 31, 2018 Net accounts receivable, Dec. 31, 2019 Company A $540,000 Company B $620,000 $120,000 $180,000 $145,000 $175,000 Number of days' sales in receivables ratio, 2018 103 days $250,000 110 days $350,000 Net income, Dec. 31, 2018 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 answers to nearest whole number). 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. C. Submit your assignment by clicking the "Start Assignment" link on the top right-hand side of the page. In the text box, indicate to me that your assignment is ready to be reviewed. Upload your Excel file ending in .xls or .xlsx. Extra Credit (Optional) You may earn up to 25 extra credit points on the final project by also submitting your answers above as a narrated presentation in PowerPoint. Please view one of the narrated PowerPoint videos that I recorded during the semester for homework reviews/solutions to get an idea of the overall feel of what I am looking for. A separate rubric will be added for the extra credit component; As well, the extra credit component will have a separate submission link.