Which of the following formulas correctly calculates the return on total assets for 2023? Hint Remember that Excel uses the order numerator or denominator ints eBook Comparative Income Statements For Years Ended December 31, 2023-2020 2023 2022 2021 $318,000 $284,000 $247,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 eferences 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 19 Current liabilities 20 Long-term liabilities 21 Common stock 22 Retained earnings 23 Total liabilities 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 -BB/AVERAGE(017.17) O AVERAGE(817-C17Y+B8 o O +BB/SUM(B17-C17/2 o O -BISUMB17 1/2) Which of the following formulas correctly calculates the debt ratio for 20217 Hint: Remember that Excel uses the order of operat denominator points eBook 4 Net sales 5 Cost of goods sold 6 Gross margin 7 Operating expenses 8 Net Income Comparative Income Statements For Years Ended December 31, 2023-2020 2023 2022 2021 $318,000 $284,000 $247,000 143,000 254,000 161000 175,000 30.000 86.000 114,000 14.000 39.000 $61,000 $16.000 $47.000 2020 $174,000 149,000 25,000 11.000 $14.000 Print References 2023 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 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 19 Current liabilities 20 Long-term liabilities 21 Common stock 22 Retained earnings 23 Total liabilities 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 -017/019-0201 O --01920/017 O -019020/017) O -4019-0207017 Chap 11 - HW Which of the following formulas correctly calculates Inventory turnover for 2023? Hint Remember that Excel usest numerator or denominator. points eBook Comparative Income Statements For Years Ended December 31, 2023-2020 2023 2022 2021 $318,000 $284.000 $247.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 Print 2020 $174,000 149,000 25,000 11,000 $14.000 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 $66.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 19 Current liabilities 20 Long-term liabilities 21 Common stock 22 Retained earnings 23 Total llabilities 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 0 O -AVERAGE(815:C15y85 0 O +B5/SUM(B15.0152 0 +B5/AVERAGE(B15:C15) 0 O =+35/+B15+C15/2
