Please answer 1-4

Applying Excel 8: Calculating internal rate of return Which of the following formulas correctly calculates the internal rate of return of this $200,000 investment in cell B11? Data Re File Home Insert Page Layout Formulas Xcut Arial 12 - AA Copy Paste SIV a.A Format Painter Clipboard Font - A Year B Cash Inflows (Outflows) 1 2 3 1 4 2 5 3 6 4 7 5 8 9 Annual discount rate 10 Net present value 11 Internal rate of return ($200,000) $40,000 $80,000 $38,000 $50,000 $58,000 8.00% $12,015 09 10.23% Multiple Choice =IRR(B3:37) =IRR(B9,B2:B7) =IRR(B2:37) =IRR(B2:39) Applying Excel 11: Return on total assets Which of the following formulas correctly calculates return on total assets for 2022? 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 ces B 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 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 2020 $18,000 49.000 52.000 90.000 2 A B E 1 5.5 points 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 BO Pint References 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 20 Long-term liabilities 21 Common stock 22 Retained earnings 23 Total liabilities and equity 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 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 =+C8/AVERAGE(C17:017) =+C8/SUM(C17:017) =AVERAGE(C17:017Y+C8 **C4/AVERAGE(C17:017) 3 Applying Excel 12: Break-even units 5.5 points Which of the following formulas correctly calculates the number of break-even units in cell D10? 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 BO $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 101) 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 13 4) 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 Multiple Choice =+D7/(C5-C4) O =(+D7/C4)-C5 =+D7/(C4-C5) O =+D7/C4-C5 4 Applying Excel 14: Budgeted direct labor cost Which of the following formulas in cell D26 would yield the correct answer when copied to cells E26 and F26? 5.5 points 3 4 5 eBook Print 6 7 8 References March $200 19,000 20,000 21,000 20% 40% 2.400 6,048 1 20 $6.00 20 $18.00 Budget Assumptions For the months of January February, and March January February Selling price per unit $200 $200 Budgeted sales (units) 12,000 15,000 Budgeted sales (units) April Budgeted production (units) April Ratio of ending finished goods inventory to next month's sales Ratio of ending raw materials inventory to next month's requirements Number of units in finished goods inventory, January 1 Number of pounds in raw materials inventory, January 1 Number of pounds of raw materials required per unit Cost per pound of raw materials Number of direct labor hours required per unit Rate per direct labor hour Direct Labor Budget For the months of January February and March January February Budgeted units to produce 12 600 15,800 Direct labor requirements (hours) per unit 2.00 200 Total direct labor hours needed 25 200 31 600 Direct labor rate (per hour) $18.00 $18.00 Total budgeted direct labor cost $453 600 $568 800 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 March 19,200 200 38.400 $18.00 $691,200 Multiple Choice +$D$21'022"D25 E21022D25 -D21022"025 - +$D$23.025