21 Problem 11-20 Return on Investment (ROI) Analysis [LO11-1] The contribution f

Question

21 Problem 11-20 Return on Investment (ROI) Analysis [LO11-1] The contribution format income statement for Huerra Company for last year is given below 10 points Total Unit Sales Variable expenses Contribution margin Fixed expenses Net operating income Income taxes @ 48% Net income S1,884,888 $ 58.28 38.12 28.e8 401,600 17,688 84,888 eBook 4.28 68 $ se,aees 2.52 Print The company had average operating assets of $498.000 during the year Required: ·1. Compute the company's return on investment (ROI) for the period using the ROI formula stated in terms of margin and turnover For each of the following questions, indicate whether the margin and turnover will increase. decrease, or remain unchanged as a result of the events described, and then compute the new ROl figure. Consider each question separately, starting in each case from the data used to compute the original ROI in (1) above. 2 Using Lean Production, the company is able to reduce the average level of inventory by $97000. (The released funds are used to pay off short-term creditors.) 3. The company achieves a cost savings of $12.000 per year by using less costly materials 4. The company issues bonds and uses the proceeds to purchase machinery and equipment that increases average operating assets by $125,000. Interest on the bonds is $11,000 per year. Sales remain unchanged. The new, more efficient equipment reduces production costs by $5,000 per year 5. Sales are increased by 20%; operating assets remain unchanged. 6. At the beginning of the year, obsolete inventory carried on the books at a cost of $17,000 is scrapped and written off as a loss. 7. At the beginning of the year, the company uses $184.000 of cash (received on accounts receivable) to repurchase and retire some of its common stock. Complete this question by entering your answers in the tabs below. Required 1Required 2 Required 3 Required Required Required Required 7 At the beginning of the year, the company uses $184,000 of cash (received on accounts receivable) to repurchase and retire some of its common stock. (Round your answers to 2 decimal places.) Margin Turnover ROI 96 Required7

Explanation / Answer

Req 1: PRESENT Sales Revenue 1,004,000 Net operating income after tax 50,400 Operating Assets 498,000 Margin%(Net Operating Income/Sales*100) 5.02% Turnover(Sales/ Operating assets) 2.02 ROI(margin%*Turnover) 10.14% Req 2: Average level of inventory reduced by $97,000 Operating assets revised to (498,000-97,000) $ 401,000 Therefore, REVISED Sales Revenue 1,004,000 Net operating income after tax 50,400 Operating Assets 401,000 Margin%(Net Operating Income/Sales*100) 5.02% Turnover(Sales/ Operating assets) 2.5 ROI(margin%*Turnover) 12.55% Req 3: Direct material decrease by $ 12,000 Contribution and net operating income before tax increase by $ 12,000 Net Operating income increase by (12000-tax rate i.e. 40%)   $ 7,200 Revised Operating income after tax (50400+7200) $ 57,600 Therefore, REVISED Sales Revenue 1,004,000 Net operating income after tax 57,600 Operating Assets 498,000 Margin%(Net Operating Income/Sales*100) 5.74% Turnover(Sales/ Operating assets) 2.02 ROI(margin%*Turnover) 11.59% Req 4: Net Operating assets increased by $ 125,000 Revised Operating assets (498,000+125,000) = $ 623,000 Net Operating income decrease by(11000-5000) $ 6000 Net operating income after tax decrease by (6000-40%) $ 3600 Revised Net operating income after tax(50400-3600) = $ 46,800 Therefore, REVISED Sales Revenue 1,004,000 Net operating income after tax 46,800 Operating Assets 623,000 Margin%(Net Operating Income/Sales*100) 4.66% Turnover(Sales/ Operating assets) 1.61 ROI(margin%*Turnover) 7.50%

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.