please answer 9-12!
9 Applying Excel 7: Round function #1 5.5 points Assuming the value in cell A9 is 15,842.0304, which of the following formulas would return a value of 15,842.03? eBook Multiple Choice Print References -ROUND(A9,-2) ROUND-A9,2) =ROUND(2.49) =ROUND(A9.2) 10 55 points Applying Excel 12: Sales dollars to achieve target pretax income Which of the following formulas in cell D13 correctly calculates the dollar amount of sales required to achieve the targeted pretax income? Hint: Remember that Excel uses the order of operations. PARENTHESES then EXPONENTS then MULTIPLICATION and DIVISION then ADDITION and SUBTRACTION. Use parentheses around any calculations in either the numerator or denominator, Reference D $700,000 B 1 Target pretax income 2 3 Units $ per unit 4 Sales 2,000 $500 5 Variable costs 2,000 $300 6 Contribution margin 7 Fixed costs 8 Pretax income 9 10 1) Compute the number of break-even units 11 2) Compute the break-even point in sales dollars 12 3) Sales (units) to achieve targeted pretax income of $700,000 134) Sales (dollars) to achieve targeted pretax income of $700,000 14 Total $1,000,000 600,000 400,000 210,000 $190,000 1,050 $210.000 4,550 $2,275,000 10 14 5.5 points Multiple Choice eBook Print =(+D7+D1)(C4-C5/C4) References (407+01/04-C5C4 D7 D7(C4 C5/C4) +(+D74DMC4-C5)/C4) 11 Applying Excel 13: Operating Income 5.5 points Which of the following formulas in cell C20 yields the correct result when copied to cell E20? E eBook Print 1 2 3 4 References 5 B D Productive Capacity 50,000 units Fixed Budget For the year ended December 31, 2020 Per Unit Total Sales $250 $9,375,000 Variable costs 180 6,750,000 Contribution margin $70 2,625,000 Fixed Expenses 2,500,000 Operating Income $125,000 6 7 8 9 10 11 12 13 Flexible Budget For the year ended December 31, 2020 % of productive capacity 70% Units produced and sold 35,000 14 75% 37500 80% 40,000 15 16 17 18 19 20 Sales Variable costs Contribution margin Fixed expenses Operating income $8 750.000 6300,000 2,450,000 2,500,000 ($50,000 $9375,000 6750,000 2.625,000 2500 000 $125.000 $10,000,000 7200.000 2.800.000 2,500,000 $300,000 11 20 21 Operating income 1550.0001 $125.000 400.000 5.5 points Multiple Choice eBook Print +C$18-C$19 References ***C18 $C$19 +$C$18-$C$19 ++$C$18-019 12 Which of the following formulas correctly calculates the acid-test ratio for 2022? Hint Remember that Excel uses the order of operations PARENTHESES then EXPONENTS thon MULTIPLICATION and DIVISION then ADDITION and SUBTRACTION. Use parentheses around any calculations in either the numerator or denominator 5.5 DO E 000 D 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 2020 $174,000 149,000 25.000 11.000 $14,000 1 2 3 4 Net sales 5 Cost of goods sold 6 Gross margin 7 Operating expenses 8 Net income 9 10 11 12 13 Cash 14 Accounts receivable, net 15 Merchandise inventory 16 Plant assets, net 17 Total assets 18 19 Current liabilities 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 $43.000 $76,000 $48.000 $45.000 12 20 Long-term liabilities 21 Common stock 22 Retained earnings 23 Total liabilities and equity 24 100,000 30,000 138,000 $311,000 110,000 30.000 77,000 $293,000 100.000 30,000 61,000 $239.000 120.000 30,000 14,000 $209.000 5.5 points eBook Print Multiple Choice Reference O 034/C19 -C13 C14/C19 15 -19
