Question
Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance Assets Cash $
Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance Assets Cash $ 62,800 $ 150,000 Accounts receivable 160,000 180,000 Inventory 230,000 240,000 Property, plant & equipment (net) 833,000 793,000 Other assets 37,000 37,000 Total assets $ 1,322,800 $ 1,400,000 Liabilities & Stockholders Equity Accounts payable $ 70,000 $ 80,000 Bonds payable 550,000 550,000 Common stock 410,000 410,000 Retained earnings 292,800 360,000 Total liabilities & stockholders equity $ 1,322,800 $ 1,400,000 This Year Sales $ 2,500,000 Variable expenses: Cost of goods sold 1,600,000 Variable selling expense 240,000 Total variable expenses 1,840,000 Contribution margin 660,000 Fixed expenses: Fixed selling expenses 220,000 Fixed administrative expenses 300,000 Total fixed expenses 520,000 Net operating income 140,000 Interest expense (8%) 44,000 Net income before tax 96,000 Tax expense (30%) 28,800 Net income $ 67,200 Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a a brief tutorial on Charts in Excel. rev: 05_07_2020_QC_CS-210952, 01_09_2021_QC_CS-246235 8. Refer to the Requirement 8 DuPont Diagram tab within your template. For alternative 3, complete the diagram by using appropriate formulas and reference cells. (In some instances your formulas and reference cells will refer to the Requirement 7 Financials tab.) a. Which choice shows the formula used to compute the return on investment? b. What is this alternatives estimated margin, turnover, and return on investment (ROI)? c. If the company pursues this alternative, would it cause next years ROI to be greater than, less than, or equal to this years ROI (as computed in Requirement 2b)?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started