PLEASE HELP WITH C THROUGH G 2 & 3

The financial statements of Big City News, Inc., include the following items: (Click the icon to view the financial statements.) Read the requirements. Data Table Requirement 1. Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest whole number 2018 2017 2016 a. Current ratio Balance sheet: Select the formula and then enter the amounts to calculate the current ratio. (Round the ratios to two decimal places. X.XX.) $ 65,000 $ 13,000 1 ... Current liabilities 137,000 Current assels 254,000 278,000 91,000 24,000 82,000 Cash Short-term investrrierits Net receivables Inventory Current ratio 1.85 3.09 2018 2017 S S 70,000 1 $ 90.000 = 79,000 93,000 4,000 80,000 78,000 3,000 b. Quick (acid-test) ratio. Prepaid expenses Total current assets 254,000 55,000 137,000 278,000 40,000 45,000 Select the formula and then enter the amounts to calculate the acid-test ratio. (Abbreviations used: Avg - average, ST short-term, and Cash + ST investments Net receivables )/ Current liabilities - Acid-test ratio 2018 | 65.000 + $ 13.000 + S 79.000 137,000 1.15 2017 S 91,000 + $ 24.000 + S 82,000 )/S 90,000 2.19 + 90,000 = Accounts payable Total current liabilities Income statement: Net credit sales ......... $ Cost of goods sold ......... 492,000 $ 273,000 514,000 287,000 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.) / Average inventory = Inventory turnover Cost of goods sold 273000 1 2018 2017 287000 / Print Done - Requirements a. C. e. 1. Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest whole number. Current ratio b. Quick (acid-test) ratio Inventory turnover and days' inventory outstanding (DIO) d. Accounts receivable turnover 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