Data Table 2018 2017 2016 $ Balance sheet: Cash Short term investments Netreceivables 77,000 $ 18.000 81.000 90.000 7,000 The financial statements of Explorer News, Inc., include the following (Click the icon to view the financial statements) Read the requirements Requirement 1. Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest wt a. Current ratio Select the formula and then enter the amounts to calculate the current ratio (Round the ratio to two decimal places, XXX) Current ratio 2018 2017 - b. Quick (acid test ratio Select the formula and then enter the amounts to calculate the acid-test ratio (Abbreviations used Avg average, ST short XXX) Acid-test 2018 / 2017 ) 103.000 20.000 34,000 70 000 6,000 35.000 58.000 270 000 Inventory Prepaid expenses Total current assets Accounts payable Total current liabilities Income statement: Net credit sales Cost of goods sold 40.000 283,000 35.000 97,000 45.000 130,000 $ 493.000 $ 507.000 278,000 280,000 Print Done c. Inventory tumover and days inventory outstanding (10) Choose from any list or enter any number in the input fields and then continue to the next question The financial statements of Explorer News, Inc., include the following terms: mm Click the icon to view the financial statements.) Read the requirements c. Inventory tumover and days' Inventory outstanding (IO) Begin by selecting the formula and then enter the amounts to calculate inventory tumover. (Round the ratios to two decimal places, XXX) Inventory turnover 2018 2017 Now, select the formula and then enter the amounts to calculate days' Inventory outstanding (DIO) (Enter formularation to two decimal places, XXX, and use a 365-day year. Round your final answers to one place, XX) - Days Inventory outstanding (10) 2018 2017 d. Accounts receivable tumover Select the formula and then enter the amounts to calculate accounts receivable tumover (Round the ratios to two decimal places, XXX) Acounts receivable lumover Choose from any list or enter any number in the input fields and then continue to the next question The financial statements of Explorer News, Inc., include the following items: Click the icon to view the financial statements.) Read the requirements e. Days' sales in average receivables or days' sales outstanding (DSO). Select the formula and then enter the amounts to calculate days' sales in average receivables or days' sales outstanding (DSO). (Enter formula ratios to two decimal places, Xxx, and use a 365-day year. Rour final answers to one decimal place, XX) Days' sales outstanding (DSC) 2018 2017 1 f. Accounts payable turnover and days' payable outstanding (DPO) Use cost of goods sold in the formula for accounts payable turnover Begin by selecting the formula and then enter the amounts to calculate accounts payable tumover. (Round the ratios to two decimal places, X.XX.) - Accounts payable turnover 2018 2017 1 Now, select the formula and then enter the amounts to calculate days' payable outstanding (DPO). (Enter formula ratios to two decimal places, Xxx, and use a 365-day year. Round your final answers to one de place, XX Choose from any list or enter any number in the input fields and then continue to the next