3. The financial statements of Harris News, Inc., include the following items: (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 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.) (1) Current assets (2) Current liabilities - 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-term, and Cash* = cash and cash equivalents. Round the ratios to two decimal places, X.XX.) (3) (5) (6) = Acid-test ratio ( 2018 ( 2017 ( c. Inventory turnover and days' inventory outstanding (DIO). Begin by selecting the formula and then enter the amounts to calculate inventory turnover. (Round the ratios to two decimal places, X.XX.) (7) = Inventory turnover 2018 2017 Now, select the formula and then enter the amounts to calculate days' inventory outstanding (DIO). (Enter formula ratios to two decimal places, X.XX, and use a 365-day year. Round your final answers to one decimal place, X.X.) (10) = Days' inventory outstanding (DIO) 2018 2017 d. Accounts receivable turnover. Print Select the formula and then enter the amounts to calculate accounts receivable turnover. (Round the ratios to two decimal places, X.XX.) (12) = Acounts receivable turnover 2018 2017 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, X.XX, and use a 365-day year. Round your final answers to one decimal place, X.X.) (13) (14 = Days' sales outstanding (DSO) 2018 2017 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 turnover. (Round the ratios to two decimal places, X.XX.) (15) (16) = Accounts payable turnover 2018 2017 Now, select the formula and then enter the amounts to calculate days' payable outstanding (DPO). (Enter formula ratios to two decimal places, X.XX, and use a 365-day year. Round your final answers to one decimal place, X.X.) (18) = Days' payable outstanding (DPO) 2018 2017 g. Cash conversion cycle (in days). (Enter formula ratios and final answers to one decimal place, X.X. Abbreviations used: Avg = average and ST = short-term.) (19) (20) (21) + = Cash conversion cycle + 2018 2017 + Requirement 2. Evaluate the company's liquidity and current debt-paying ability for 2018. Has it improved or deteriorated from 2017? Print Ratio Improved or Deteriorated (22) a. Current ratio (23) (24) (25) b. Quick (acid test) ratio c. Inventory turnover and days' inventory outstanding (DIO) d. Accounts receivable turnover e. Days' sales in average receivables or days' sales outstanding (DSO) f. Accounts payable turnover and days' payable outstanding (DPO) g. Cash conversion cycle (in days) (26) (27) (28) Requirement 3. As a manager of this company, what would you try to improve next year? The factors that need the most improvement are (29) - and (30) .. The company needs to make (31) sales and keep (32) inventory on hand, as well as (33) - 1: Data Table Print 2018 2017 2016 Balance sheet: Cash Short-term investments 77,000 $ 9,000 81,000 103,000 25,000 84,000 75,000 Net receivables 25,000 60,000 Inventory 94,000 Prepaid expenses 6,000 8,000 Total current assets ..... 295,000 267,000 50,000 139,000 25,000 Accounts payable Total current liabilities Income statement: 36,000 92,000 Net credit sales Cost of goods sold 492,000 $ 272,000 513,000 279,000 ........ 2: Requirements 1. Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest whole number. a. Current ratio b. Quick (acid-test) ratio c. Inventory turnover and days' inventory outstanding (DIO) d. Accounts receivable turnover e. Days' sales in average receivables or days' sales outstanding (DSO) f. Accounts payable turnover and days' payable outstanding (DPO). Use cost of goods sold in the formula for accounts payable turnover. g. Cash conversion cycle (in days) (When calculating days, round your answer to the nearest whole number.) 2. Evaluate the company's liquidity and current debt-paying ability for 2018. Has it improved or deteriorated from 2017? 3. As a manager of this company, what would you try to improve next year