CH 11 - EXCEL ANALYTICS 11-1 i 5 Part 5 of 10 Saved Excel Analytics 11-1 (Static) Return on Investment (ROI) [LO11-1] [The following information applies to the questions displayed below.] Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance 2.5 points 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 eBook Liabilities & Stockholders' Equity Accounts payable Bonds payable Print References Common stock Retained earnings Total liabilities & stockholders' equity 70,000 80,000 550,000 550,000 410,000 410,000 292,800 360,000 $1,322,800 $1,400,000 Sales Variable expenses: Cost of goods sold This Year $2,500,000 1,600,000 240,000 Variable selling expense 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 Tax expense (30%) Net income 96,000 28,800 $ 67,200