Question

In: Accounting

Problem 10-17 Comparison of Performance Using Return on Investment (ROI) [LO10-1] Comparative data on three companies...

Problem 10-17 Comparison of Performance Using Return on Investment (ROI) [LO10-1]

Comparative data on three companies in the same service industry are given below:

Required:

2. Fill in the missing information.

Company
A B C
Sales $4,554,000 $1,435,000
Net operating income $637,560 $186,550
Average operating assets $2,070,000 $3,080,000
Margin % % 7 %
Turnover 1.90
Return on investment (ROI) % 6.50 % %

Solutions

Expert Solution

Particular A B C
(a) sales $4554000 $1435000

$5852000

(Note 9 below)

b)net operating income $637560 $186550

$409640

(Note 8 below)

c)average operating assets $2070000

$2870000

(Note 6 below)

$3080000
d) margin

14%

(Note 1 below)

13%

(Note 4 below)

7%
e) turnover

2.2

(Note 2 below)

0.5

( Note 5 below)

1.90
f) return on investment

30.8%

(Note 3 below)

6.50%

13.3%

(Note 7 below)

Note 1 = margin = net operating income/sales×100

= $637560/$4554000×100= 14%

Note 2 = turnover = sales/average operating assets

= $4554000/$2070000 = 2.2

Note 3 return on investment = margin ×turnover

= 14× 2.2 = 30.8%

Note 4 = Margin of B = $186550/$1435000×100 = 13%

Note 5 =turnover = return on investment/margin

= 6.50/13 = 0.5

Note 6 = average operating assets = sales/turnover

=$1435000/0.5 = $2870000

Note 7 = return on investment = margin × turnover

= 7×1.90 = 13.3%

Note 8 = net operating income = average operating assets × return on investment

= $3080000×13.3% = $409640

Note 9 = sales = net operating income ×1/Margin

= $409640×100/7= $5852000

ALL THE BEST

PLEASE DO SUPPORT US

ANY DOUBT PLEASE COMMENT BELOW

THANK YOU


Related Solutions

Exercise 10-12 Evaluating New Investments Using Return on Investment (ROI) and Residual Income [LO10-1, LO10-2] Selected...
Exercise 10-12 Evaluating New Investments Using Return on Investment (ROI) and Residual Income [LO10-1, LO10-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,000,000 $ 14,000,000 $ 25,000,000 Average operating assets $ 3,000,000 $ 7,000,000 $ 5,000,000 Net operating income $ 600,000 $ 560,000 $ 800,000 Minimum required rate of return 14 % 10 % 16 % Required: 1. Compute the return on...
Exercise 10-12 Evaluating New Investments Using Return on Investment (ROI) and Residual Income [LO10-1, LO10-2] Selected...
Exercise 10-12 Evaluating New Investments Using Return on Investment (ROI) and Residual Income [LO10-1, LO10-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 $ 6,400,000 $ 10,400,000 $ 9,500,000 Average operating assets $ 1,600,000 $ 5,200,000 $ 2,375,000 Net operating income $ 352,000 $ 988,000 $ 261,250 Minimum required rate of return 18.00 % 19.00 % 15.00 % Required: 1. Compute the return on...
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...
Exercise 10-8 Computing and Interpreting Return on Investment (ROI) [LO10-1] Selected operating data for two divisions...
Exercise 10-8 Computing and Interpreting Return on Investment (ROI) [LO10-1] Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below: Division Queensland New South Wales Sales $ 1,539,000 $ 2,346,000 Average operating assets $ 570,000 $ 510,000 Net operating income $ 138,510 $ 140,760 Property, plant, and equipment (net) $ 257,000 $ 207,000 Required: 1. Compute the rate of return for each division using the return on investment (ROI) formula stated in terms of margin...
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...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an investment center should be evaluated based on revenues, costs, and investments. An evaluation based on net income ignores the amount of investment the investment center required. One way to measure operating profit in relation to investment is a calculation called the return on investment. One formula for calculating return on investment is: Operating income Invested Assets ROI is effective because it takes into consideration...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an investment center should be evaluated based on revenues, costs, and investments. An evaluation based on net income ignores the amount of investment the investment center required. One way to measure operating profit in relation to investment is a calculation called the return on investment. One formula for calculating return on investment is: Operating income Invested Assets ROI is effective because it takes into consideration...
please show me step by step this problem? Problem 10-18 Return on Investment (ROI) and Residual...
please show me step by step this problem? Problem 10-18 Return on Investment (ROI) and Residual Income [LO10-1, LO10-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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT