Which of the following formulas correctly calculates the acid-test ratio for 20227 Hint: Remember that Excel uses the order of operatio numerator or denominator points eBook Comparative Income Statements For Years Ended December 31, 2023-2020 2023 2022 2021 $318.000 $284.000 3247.000 143.000 254.000 161.000 175,000 30,000 86,000 114,000 14,000 39,000 $61,000 $16,000 $47.000 4 Net sales 5 Cost of goods sold 6 Gross margin 7 Operating expenses 8 Net Income 2020 $174.000 149,000 25,000 11,000 $14.000 Print References 10 13 Cash 14 Accounts receivable, net 15 Merchandise Inventory 16 Plant assets, net 17 Total assets Comparative Balance Sheets For Years Ended December 31, 2023-2020 2023 2022 2021 $56,000 $4,000 $30,000 89,000 80,000 69.000 36.000 89.000 40.000 130,000 120.000 100.000 $311,000 $293.000 $239.000 2020 $18,000 49,000 52.000 90.000 $209,000 18 19 Current liabilities 20 Long-term liabilities 21 Common stock 22 Retained earnings 23 Total abilities and equity $43.000 100,000 30,000 138,000 $311,000 $76,000 110,000 30.000 77.000 $293.000 $48.000 100,000 30,000 61.000 $239,000 $45,000 120,000 30,000 14.000 $209.000 Multiple Choice O +813-B14C19 O -C3C4C19 O =4613-C14+C157019 O =4613-C14/C19