its all one question, need help asap, please & thankyou!!

4. The financial statements of Smith News, Inc. include the following items Click the icon to view the financial statements.) Read the requirements > Acid-test ratio 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) (2) Curront 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) (5) (6) 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, XXX) (8) 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, XXX, and use a 365-day year. Round your final answers to one decimal place. XX.) (9) (10) Days' inventory outstanding (DIO) 2018 2017 d. Accounts receivable turnover. Select the formula and then enter the amounts to calculate accounts receivable turnover (Round the ratios to two decimal places, X.XX.) (11) (12) Acounts receivable turnover 2018 2017 6. 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 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 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, XXX, and use a 365-day year. Round your final answers to one decimal place, XX) (18) - Days' payable outstanding (DPO) 2018 2017 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? (23) (24) Ratio Improved or Deteriorated a Current ratio (22) b. Quick (acid test) ratio c. Inventory turnover and days'inventory Outstanding (DIO) d. Accounts receivable turnover (25) e Days' sales in average receivables or days' sales outstanding (DSO) (26) 1. Accounts payable turnover and days' payable outstanding (DPO) (27) 9. Cash conversion cycle fin 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) 4: Data Table 2018 2017 2016 77,000 $ 9.000 81.000 20,000 67.000 Balance sheet: Cash Short-term investments Net receivables Inventory Prepaid expenses Total current assets Accounts payable Total current liabilities Income statement Net credit sales Cost of goods sold 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 5: 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 (10) d. Accounts receivable turnover .. Days' sales in average receivables or days' sales outstanding (DSO) 1. Accounts payable tumover and days payable outstanding (DPO). Use 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 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? 0 000 2) (1) O 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 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 Cash Inventory Total assets Average daily sales Cost of goods sold Net credit sales Total liabilities Average inventory Current assets Net receivables Avg net receivables Current liabilities OST Investments OOOO OOOO (3) ) (4) OOOO Total assets Total liabilities Average daily sales Average inventory Avg net receivables Cash Cost of goods sold Current assets Current liabilities Inventory Net credit sales Net receivables ST investments 5) Average daily sales Average inventory Avg net receivables OOOO Cash Cost of goods sold Current assets Current liabilities Inventory Total assets Net credit sales Total liabilities Net receivables ST investments 6 (6) 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 Total liabilities Net receivables ST investments (7) 7 OOOO Cash Average daily sales Cost of goods sold Average inventory Current assets Average net receivables Current liabilities OOOO Inventory Net credit sales Net receivables Short-term investments Total assets Total liabilities 8) OOOO Total assets Total liabilities OOOO 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 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 not 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 Not receivables Short-term investments Total assets OOO (11) Average daily sales Average inventory Average net receivables Cash Cost of goods sold Current assets Current liabilities Total assets Total liabilities OOO Inventory Net credit sales Net receivables Short-term investments (12) Oo oo OOOO () OOOO (15) > 00 OOC 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 (13) Cost of goods sold Inventory Total assets Accounts receivable turnover Current assets Net credit sales Total liabilities Average inventory Current liabilities Net receivables Cash Days in year Short-term investments (14) Cost of goods sold Inventory Total assets Accounts receivable turnover Current assets Net credit sales Total liabilities Average inventory Current liabilities Net receivables Cash Days in year Short-term investments Average net receivables Current liabilities 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 (16) Average net receivables Current liabilities 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 (17) 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 (18) Average net receivables Current liabilities Accounts payable turnover Cash Days in year Average daily sales Cost of goods sold O Inventory Average inventory Current assets Inventory turnover Net credit sales Total liabilities Net receivables Short-term investments Total assets OOOO O OO (19) Avg daily sales Avg inventory Avg net receivables Total assets Total liabilities Cash Days in year Inventory turnover Cost of goods sold ODIO Net credit sales Current assets DPO Net receivables Current liabilities O DSO ST investments OOO (20) 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 O 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 DSO ST investments Total assets Total liabilities (22) 123) (24) ( ) (25) OOO Improved Deteriorated Improved Deteriorated Improved Deteriorated Improved Deteriorated (26) (27) (28) ) Improved Deteriorated Improved Deteriorated Improved Deteriorated (29) O cost of goods sold inventory turnover short term investments OOO (30) (32) ) (33) cash collections prepaid expenses total current assets (31) O fewer more 0 0 less more OO make more short-term investments. prepay more expenses tighten collection policies. 4. The financial statements of Smith News, Inc. include the following items Click the icon to view the financial statements.) Read the requirements > Acid-test ratio 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) (2) Curront 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) (5) (6) 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, XXX) (8) 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, XXX, and use a 365-day year. Round your final answers to one decimal place. XX.) (9) (10) Days' inventory outstanding (DIO) 2018 2017 d. Accounts receivable turnover. Select the formula and then enter the amounts to calculate accounts receivable turnover (Round the ratios to two decimal places, X.XX.) (11) (12) Acounts receivable turnover 2018 2017 6. 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 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 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, XXX, and use a 365-day year. Round your final answers to one decimal place, XX) (18) - Days' payable outstanding (DPO) 2018 2017 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? (23) (24) Ratio Improved or Deteriorated a Current ratio (22) b. Quick (acid test) ratio c. Inventory turnover and days'inventory Outstanding (DIO) d. Accounts receivable turnover (25) e Days' sales in average receivables or days' sales outstanding (DSO) (26) 1. Accounts payable turnover and days' payable outstanding (DPO) (27) 9. Cash conversion cycle fin 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) 4: Data Table 2018 2017 2016 77,000 $ 9.000 81.000 20,000 67.000 Balance sheet: Cash Short-term investments Net receivables Inventory Prepaid expenses Total current assets Accounts payable Total current liabilities Income statement Net credit sales Cost of goods sold 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 5: 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 (10) d. Accounts receivable turnover .. Days' sales in average receivables or days' sales outstanding (DSO) 1. Accounts payable tumover and days payable outstanding (DPO). Use 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 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? 0 000 2) (1) O 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 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 Cash Inventory Total assets Average daily sales Cost of goods sold Net credit sales Total liabilities Average inventory Current assets Net receivables Avg net receivables Current liabilities OST Investments OOOO OOOO (3) ) (4) OOOO Total assets Total liabilities Average daily sales Average inventory Avg net receivables Cash Cost of goods sold Current assets Current liabilities Inventory Net credit sales Net receivables ST investments 5) Average daily sales Average inventory Avg net receivables OOOO Cash Cost of goods sold Current assets Current liabilities Inventory Total assets Net credit sales Total liabilities Net receivables ST investments 6 (6) 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 Total liabilities Net receivables ST investments (7) 7 OOOO Cash Average daily sales Cost of goods sold Average inventory Current assets Average net receivables Current liabilities OOOO Inventory Net credit sales Net receivables Short-term investments Total assets Total liabilities 8) OOOO Total assets Total liabilities OOOO 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 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 not 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 Not receivables Short-term investments Total assets OOO (11) Average daily sales Average inventory Average net receivables Cash Cost of goods sold Current assets Current liabilities Total assets Total liabilities OOO Inventory Net credit sales Net receivables Short-term investments (12) Oo oo OOOO () OOOO (15) > 00 OOC 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 (13) Cost of goods sold Inventory Total assets Accounts receivable turnover Current assets Net credit sales Total liabilities Average inventory Current liabilities Net receivables Cash Days in year Short-term investments (14) Cost of goods sold Inventory Total assets Accounts receivable turnover Current assets Net credit sales Total liabilities Average inventory Current liabilities Net receivables Cash Days in year Short-term investments Average net receivables Current liabilities 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 (16) Average net receivables Current liabilities 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 (17) 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 (18) Average net receivables Current liabilities Accounts payable turnover Cash Days in year Average daily sales Cost of goods sold O Inventory Average inventory Current assets Inventory turnover Net credit sales Total liabilities Net receivables Short-term investments Total assets OOOO O OO (19) Avg daily sales Avg inventory Avg net receivables Total assets Total liabilities Cash Days in year Inventory turnover Cost of goods sold ODIO Net credit sales Current assets DPO Net receivables Current liabilities O DSO ST investments OOO (20) 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 O 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 DSO ST investments Total assets Total liabilities (22) 123) (24) ( ) (25) OOO Improved Deteriorated Improved Deteriorated Improved Deteriorated Improved Deteriorated (26) (27) (28) ) Improved Deteriorated Improved Deteriorated Improved Deteriorated (29) O cost of goods sold inventory turnover short term investments OOO (30) (32) ) (33) cash collections prepaid expenses total current assets (31) O fewer more 0 0 less more OO make more short-term investments. prepay more expenses tighten collection policies