Question

In: Accounting

Problem 11-20 Return on Investment (ROI) Analysis [LO11-1] The contribution format income statement for Huerra Company...

Problem 11-20 Return on Investment (ROI) Analysis [LO11-1] The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 998,000 $ 49.90 Variable expenses 598,800 29.94 Contribution margin 399,200 19.96 Fixed expenses 317,200 15.86 Net operating income 82,000 4.10 Income taxes @ 40% 32,800 1.64 Net income $ 49,200 $ 2.46 The company had average operating assets of $493,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. (Round your intermediate calculations and final answer to 2 decimal places.) 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 ROI 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 $102,000. (The released funds are used to pay off short-term creditors.) (Round your answers to 2 decimal places.) 3. The company achieves a cost savings of $12,000 per year by using less costly materials. (Round your answers to 2 decimal places.) 4. The company issues bonds and uses the proceeds to purchase $129,000 in machinery and equipment at the beginning of the period. Interest on the bonds is $19,000 per year. Sales remain unchanged. The new, more efficient equipment reduces production costs by $7,000 per year. (Round your answers to 2 decimal places.) 5. Sales are increased by 15%; operating assets remain unchanged. (Round your answers to 2 decimal places.) 6. Obsolete inventory carried on the books at a cost of $15,000 is scrapped and written off as a loss. (Round your answers to 2 decimal places.) 7. The company uses $176,000 of cash (received on accounts receivable) to repurchase and retire some of its common stock. (Round your answers to 2 decimal places.)

Solutions

Expert Solution

As per policy only first four questions will be answered

Part 1

Margin = net operating income / sales = 82000/998000 = 8.22%

Turnover = sales / Average operating assets = 998000 / 493000 = 2.02

ROI = margin * turnover = 8.22%* 2.02 = 16.60%

Part 2

Margin = net operating income / sales = 82000/998000 = 8.22% Unchanged

Turnover = sales / Average operating assets = 998000 / (493000-102000) = 998000 / 391000 = 2.55 increase

ROI = margin * turnover = 8.22% * 2.55 = 20.96% increase

Part 3

Margin = net operating income / sales = (82000+12000)/998000 = 94000/998000 = 9.42% increase

Turnover = sales / Average operating assets = 998000 / 493000 = 2.02 unchanged

ROI = margin * turnover = 9.42% * 2.02 = 19.31% increase

Part 4

Margin = net operating income / sales = (82000+7000) / 493000 = 89000 / 998000 = 8.92% increase

Turnover = sales / Average operating assets = 998000 / (493000+129000) = 998000 / 622000 = 1.51 decrease

ROI = margin of * turnover = 8.92% * 1.51 = 13.47% decrease


Related Solutions

Problem 11-20 Return on Investment (ROI) Analysis [LO11-1] The contribution format income statement for Huerra Company...
Problem 11-20 Return on Investment (ROI) Analysis [LO11-1] The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 992,000 $ 49.60 Variable expenses 595,200 29.76 Contribution margin 396,800 19.84 Fixed expenses 316,800 15.84 Net operating income 80,000 4.00 Income taxes @ 40% 32,000 1.60 Net income $ 48,000 $ 2.40 The company had average operating assets of $508,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the...
Problem 11-20 (Algo) Return on Investment (ROI) Analysis [LO11-1] The contribution format income statement for Huerra...
Problem 11-20 (Algo) Return on Investment (ROI) Analysis [LO11-1] The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 996,000 $ 49.80 Variable expenses 597,600 29.88 Contribution margin 398,400 19.92 Fixed expenses 316,400 15.82 Net operating income 82,000 4.10 Income taxes @ 40% 32,800 1.64 Net income $ 49,200 $ 2.46 The company had average operating assets of $496,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for...
Problem 10-20 Return on Investment (ROI) Analysis [LO10-1] The contribution format income statement for Huerra Company...
Problem 10-20 Return on Investment (ROI) Analysis [LO10-1] The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 992,000 $ 49.60 Variable expenses 595,200 29.76 Contribution margin 396,800 19.84 Fixed expenses 318,800 15.94 Net operating income 78,000 3.90 Income taxes @ 40% 31,200 1.56 Net income $ 46,800 $ 2.34 The company had average operating assets of $491,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the...
Problem 10-20 Return on Investment (ROI) Analysis [LO10-1] The contribution format income statement for Huerra Company...
Problem 10-20 Return on Investment (ROI) Analysis [LO10-1] The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 1,006,000 $ 50.30 Variable expenses 603,600 30.18 Contribution margin 402,400 20.12 Fixed expenses 326,400 16.32 Net operating income 76,000 3.80 Income taxes @ 40% 30,400 1.52 Net income $ 45,600 $ 2.28 The company had average operating assets of $506,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the...
Problem 10-20 Return on Investment (ROI) Analysis [LO10-1] The contribution format income statement for Huerra Company...
Problem 10-20 Return on Investment (ROI) Analysis [LO10-1] The contribution format income statement for Huerra Company for last year is given below: Total Unit Sales $ 992,000 $ 49.60 Variable expenses 595,200 29.76 Contribution margin 396,800 19.84 Fixed expenses 314,800 15.74 Net operating income 82,000 4.10 Income taxes @ 40% 32,800 1.64 Net income $ 49,200 $ 2.46 The company had average operating assets of $503,000 during the year. Required: 1. Compute the company’s return on investment (ROI) for the...
Problem 11-15 Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] Financial data for Joel de...
Problem 11-15 Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] Financial data for Joel de Paris, Inc., for last year follow: Joel de Paris, Inc. Balance Sheet Beginning Balance Ending Balance Assets Cash $ 133,000 $ 134,000 Accounts receivable 337,000 475,000 Inventory 572,000 472,000 Plant and equipment, net 858,000 859,000 Investment in Buisson, S.A. 393,000 426,000 Land (undeveloped) 246,000 253,000 Total assets $ 2,539,000 $ 2,619,000 Liabilities and Stockholders' Equity Accounts payable $ 374,000 $ 342,000 Long-term debt 1,035,000...
Problem 11-18 Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] “I know headquarters wants us...
Problem 11-18 Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] “I know headquarters wants us to add that new product line,” said Dell Havasi, manager of Billings Company’s Office Products Division. “But I want to see the numbers before I make any move. Our division’s return on investment (ROI) has led the company for three years, and I don’t want any letdown.” Billings Company is a decentralized wholesaler with five autonomous divisions. The divisions are evaluated on the basis...
Problem 11-18 Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] “I know headquarters wants us...
Problem 11-18 Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] “I know headquarters wants us to add that new product line,” said Dell Havasi, manager of Billings Company’s Office Products Division. “But I want to see the numbers before I make any move. Our division’s return on investment (ROI) has led the company for three years, and I don’t want any letdown.”      Billings Company is a decentralized wholesaler with five autonomous divisions. The divisions are evaluated on the basis...
Exercise 11-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO11-1] [The...
Exercise 11-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO11-1] [The following information applies to the questions displayed below.] Fitness Fanatics is a regional chain of health clubs. The managers of the clubs, who have authority to make investments as needed, are evaluated based largely on return on investment (ROI). The company's Springfield Club reported the following results for the past year: Sales $ 820,000 Net operating income $ 22,140 Average operating assets $ 100,000...
Exercise 11-12 Evaluating New Investments Using Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] Selected...
Exercise 11-12 Evaluating New Investments Using Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 12,840,000 $ 28,840,000 $ 26,050,000 Average operating assets $ 3,210,000 $ 7,210,000 $ 5,210,000 Net operating income $ 564,960 $ 346,080 $ 755,450 Minimum required rate of return 6.00 % 6.50 % 14.50 % Required: 1. Compute the return on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT