its all one question, its just a long question. I really really need help with it; please & thank you!!

4. The financial statements of Smith 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 piaces. X.XX.) (2) = 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: Aug average, ST- short-term, and Cash = cash and cash equivalents. Round the ratios to two decimal places, XXX.) (3) (4) (5) (6) Acid-test ratio 2018 2017 c. Inventory tumover 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, Xxx.) (7) (8) - Inventory turnover 2018 2017 a 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, XX.) (10) Days' inventory outstanding (DIO) 2018 2017 (9) d. Accounts receivable tumover. 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 tumover 2018 2017 o. 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. Round your final answers to one decimal place, X.X.) (13) (14) Days' sales outstanding (DSO) 2018 2017 1. 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, XXX.) (15) (16) Accounts payable tumover 2018 2017 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 decimal place, X.X) (17) (18) Days' payable outstanding (DPO) 2018 a 2017 (19) 9. Cash conversion cycle (in days) (Enter formula ratios and final answers to one decimal place. XXAbbreviations used: Avg average and ST short-term.) (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? Ratio Improved or Deteriorated a. Current ratio (22) b. Quick (acid test) rato (23) c. Inventory turnover and days' inventory outstanding (D10) (24) d. Accounts receivable turnover (25) e. Days' sales in average receivables or days' sales outstanding (DSO) Accounts payable tumover and days' payable outstanding (DPO) (27) 9. Cash conversion cycle (in days) (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 (26) 2018 2017 2016 $ 20.000 67.000 Balance sheet: Cash Short-term investments Not receivables Inventory Prepaid expenses Total current assets Accounts payable Total current liabilities Income statement: Net credit sales Cost of goods sold 77,000 $ 9,000 81,000 93,000 4,000 264,000 55,000 138,000 103.000 22.000 84.000 79.000 5.000 293.000 60,000 99,000 10.000 $ 501,000 $ 274,000 513,000 287,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 tumover and days' inventory outstanding (DID) d. Accounts receivable turnover e Days' sales in average receivables or days' sales outstanding (DSO) 1. Accounts payable turnover and days' payable outstanding (DPO) Use cost of goods sold in the formula for accounts payable turnover 9. Cash conversion cycle (in days) (When calculating days, round your answer to the nearest whole number) 2. Evaluate the company's liquidity and current debi-paying ability for 2018. Has it improved or deteriorated trom 2017? 3. As a manager of this company, what would you try to improve next year? (1) Cash Inventory Total assets Average daily sales Cost of goods sold Net credit sales Total abilities Average inventory Current assets Net receivables Average net receivables Current liabilities Short-term investments (2) Cash Inventory Total assets Average daily sales Cost of goods sold Net credit sales Total liabilities Average inventory Current assets Net receivables Average net receivables Current liabilities Short-term investments (3) O Cash Inventory Total assets Average daily sales Cost of goods sold Net credit sales o Total liabilities Average inventory Current assets ONet receivables Avg net receivables Current liabilities ST investments OOO 0 000 (4) OOOO Cash Inventory Average daily sales Cost of goods sold Net credit sales Average inventory Current assets Net receivables Avg net receivables Current liabilities ST investments Total assets Total liabilities 5} (5) 0 000 Average daily sales Average inventory Avg net receivables Cash Cost of goods sold Current assets Current liabilities Inventory Total assets Net credit sales o Total liabilities Net receivables ST investments (6) O Cash Average daily sales Cost of goods sold Average inventory Current assets Avg net receivables Current liabilities Inventory Total assets Net credit sales Total liabilities Net receivables OST investments Total assets Total liabilities Total assets Total liabilities OOOO (7) Cash Inventory Average daily sales Cost of goods sold Net credit sales Average inventory Current assets Net receivables Average net receivables Current liabilities Short-term investments (8) O Cash Inventory Average daily sales Cost of goods sold Net credit sales Average inventory Current assets Net receivables Average net receivables Current liabilities Short-term investments (9) Average net receivables Current liabilities Accounts payable turnover Cash Days in year Average daily sales Cost of goods sold Inventory Average inventory Current assets Inventory turnover Net credit sales Total liabilities Net receivables Short-term investments Total assets (10) Average net receivables Current liabilities Accounts payable turnover Cash Days in year Average daily sales Cost of goods sold Inventory Average inventory Current assets Inventory turnover Net credit sales Total liabilities Net receivables Short-term investments Total assets Cash Inventory Average daily sales Cost of goods sold Net credit sales Average inventory Current assets Net receivables Average net receivables Current liabilities Short-term investments OOOO (11) Total assets Totat labilities OOOO 200 (12) Cash Inventory Total assets Average daily sales Cost of goods sold Net credit sales Total liabilities Average inventory Current assets Net receivables Average not receivables Current liabilities Short-term investments (13) Cost of goods sold Inventory Accounts receivable turnover Current assets Net credit sales Average inventory Current liabilities Net receivables Cash Days in year Short-term investments Total assets Total liabilities (14) Cost of goods sold Inventory Accounts receivable turnover Current assets Net credit sales Average inventory Current liabilities Net receivables Cash Days in year Short-term investments Total assets Total liabilities (15) Average net receivables Current liabilities O Average accounts payable Cash Inventory Average daily sales Cost of goods sold Net credit sales Average inventory Current assets Net receivables Short-term investments Total assets Total liabilities 00 Current liabilities Inventory Net credit sales Net receivables (16) Average net receivables Average accounts payable Cash Average daily sales Cost of goods sold Average inventory Current assets Short-term investments Total assets Total liabilities (17) Average net receivables Accounts payable tumover Cash Average daily sales Cost of goods sold Average inventory Current assets Net credit sales Total liabilities Net receivables Short-term investments Total assets Current liabilities Days in year Inventory Inventory turnover (18) Average net receivables Accounts payable turnover Cash Average daily sales Cost of goods sold Average inventory Current assets Net credit sales Total liabilities Net receivables Short-term investments Total assets Current liabilities Days in year Inventory Inventory turnover 0 000 (19) Cash Days in year Inventory turnover Avg daily sales O Cost of goods sold ODIO Net credit sales Avg inventory Current assets ODPO Net receivables Avg net receivables Current liabilities DSO ST investments Total assets Total liabilities (20) Cash Days in year Inventory turnover Avg daily sales Cost of goods sold ODIO Net credit sales Avg inventory Current assets DPO Net receivables Avg net receivables Current liabilities DSO ST investments Total assets Total liabilities (21) Cash Days in year Inventory turnover Avg daily sales Cost of goods sold ODIO Net credit sales Avg inventory Current assets ODPO Net receivables Avg net receivables Current liabilities OSO OST investments Total assets Total liabilities OOOO (22) ( (23) (24) (25) Improved Deteriorated 000 Improved Deteriorated Improved Deteriorated (26) 127) (28) 29) Improved Deteriorated cost of goods sold inventory turnover short term investments Improved O Deteriorated Improved Deteriorated Improved Deteriorated (30) cash collections prepaid expenses total current assets (31) fewer more (32) O less more (33) make more short-term investments. prepay more expenses. tighten collection policies