Question

In: Accounting

Exercise 11-13 Effects of Changes in Sales, Expenses, and Assets on ROI [LO11-1] [The following information...

Exercise 11-13 Effects of Changes in Sales, Expenses, and Assets on ROI [LO11-1]

[The following information applies to the questions displayed below.]

CommercialServices.com Corporation provides business-to-business services on the Internet. Data concerning the most recent year appear below:

Sales $ 3,900,000
Net operating income $ 273,000
Average operating assets $ 780,000

1. Compute the company's return on investment (ROI). (Do not round intermediate calculations. Round your answer to 2 decimal places.)

2. The entrepreneur who founded the company is convinced that sales will increase next year by 60% and that net operating income will increase by 100%, with no increase in average operating assets. What would be the company’s ROI? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

3. The Chief Financial Officer of the company believes a more realistic scenario would be a $1,150,000 increase in sales, requiring a $230,000 increase in average operating assets, with a resulting $105,750 increase in net operating income. What would be the company’s ROI in this scenario? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Solutions

Expert Solution

  1. Compute company’s Return on Investment(ROI)

Sales

$

3,900,000

Net Operating Income

$

273,000

Average Operating Assets

$

780,000

Return on Investment(ROI)= (Net Operating Income/ Average Operating Assets)*100

= (273,000/ 780,000)*100

= 35.00%

2. Compute company’s Return on Investment(ROI)

Increase in sales = 60%

Increase in Net Operating Income= 100%

Amount($)

Change($)

Revised amount($)

1

2

3=1+2

Sales

3,900,000

3,900,000*60%= 2,340,000

6,240,000

Net Operating Income

273,000

273,000*100%= 273,000

546,000

Average Operating Assets

780,000

NIL

780,000

Return on Investment(ROI)= (Net Operating Income/ Average Operating Assets)*100

= (546,000/ 780,000)*100

= 70.00%

3. Compute company’s Return on Investment(ROI)

Increase in sales = $1,150,000

Increase in Net Operating Income= $105,750

Increase in Average operating assets = $230,000

Amount($)

Change($)

Revised amount($)

1

2

3=1+2

Sales

3,900,000

1,150,000

5,050,000

Net Operating Income

273,000

105,750

378,750

Average Operating Assets

780,000

230,000

1,010,000

Return on Investment(ROI)= (Net Operating Income/ Average Operating Assets)*100

= (378,750/ 1,010,000)*100

= 37.50%


Related Solutions

Exercise 10-13 Effects of Changes in Sales, Expenses, and Assets on ROI [LO10-1] [The following information...
Exercise 10-13 Effects of Changes in Sales, Expenses, and Assets on ROI [LO10-1] [The following information applies to the questions displayed below.] CommercialServices.com Corporation provides business-to-business services on the Internet. Data concerning the most recent year appear below: Sales $ 3,000,000 Net operating income $ 150,000 Average operating assets $ 750,000 1. Compute the company's return on investment (ROI). 2. The entrepreneur who founded the company is convinced that sales will increase next year by 50% and that net operating...
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 10-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO10-1] [The...
Exercise 10-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO10-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 $ 1,400,000 Net operating income $ 70,000 Average operating assets $ 350,000...
Exercise 9-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO9-1] [The...
Exercise 9-11 Effects of Changes in Profits and Assets on Return on Investment (ROI) [LO9-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...
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,640,000 $ 35,800,000 $ 20,640,000 Average operating assets $ 3,160,000 $ 7,160,000 $ 5,160,000 Net operating income $ 606,720 $ 608,600 $ 577,920 Minimum required rate of return 10.00 % 10.50 % 11.20 % Required: 1. Compute the return on...
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-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 $ 134,000 $ 135,000 Accounts receivable 340,000 490,000 Inventory 572,000 481,000 Plant and equipment, net 874,000 854,000 Investment in Buisson, S.A. 394,000 428,000 Land (undeveloped) 252,000 245,000 Total assets $ 2,566,000 $ 2,633,000 Liabilities and Stockholders' Equity Accounts payable $ 371,000 $ 349,000 Long-term debt 1,032,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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT