s The financial staterments of Harris News, Inc., include the following iterris: (Click the icon to view the financial statements.) Data Table Read the recuirements. Requirement 1. Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest whole number a. Current ratio. Select the formula and then enter the amounts to calculate the current ratio. (Round the ratios to two decimal places, X.xx) 2018 2017 2016 Balance sheet: 53,000 S 89,000 25,000 80,000 69.000 7,000 270,000 55.000 90,000 - Current ratio Shorl -terrn investments 16,000 77,000 93,000 6,000 245,000 75,000 131,000 2018 45,000 Inventory Prepaid expenses Total current assets 2017 65,000 Requirements able 50,000 Total curment liabilities Income statement: 1. Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest whole number Net credit sales S 498,000 S 514,000 Cost of gcods sold 273,000 277,000 b. Quick (acid-test) ratio c. Inventory turnover and days inventory outstanding (DIO) d. Accounts receivable tunover e. Days' sales in average receivables or days' sales outstanding (DSO) f. Accounts payable tumover and days' payable outstanding (DPO). Use Print Done cost of goods sold in the formula for accounts payable turnover Cash conversion cycle (in days) (When calculating days, round your answer to the nearest whole number.) 2. Evaluate the company's liquicity and current debt-paying ablity for 2018. Has Choose from any list or enter any number in the input f it improved or deteriorated from 2017? 3. 10 Pearmaining Check Answer As a manager of this company, what would you try to improve next year