Question

In: Accounting

Selected sales and operating data for three divisions of different structural engineering firms are given as...

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,600,000 $ 35,750,000 $ 20,600,000
Average operating assets $ 3,150,000 $ 7,150,000 $ 5,150,000
Net operating income $ 516,600 $ 572,000 $ 597,400
Minimum required rate of return 9.00 % 9.50 % 11.60 %

Required:

1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover.

2. Compute the residual income (loss) for each division.

1
Margin Turnover ROI
Division A    % %
Division B % %
Division C    % %
2
Division A Division B Division C
Residual income (loss)

Solutions

Expert Solution

Margin
A B C
Net Operating income 5,16,600 5,72,000 5,97,400
Divide: Sales revenue 1,26,00,000 3,57,50,000 2,06,00,000
Margin 4.10% 1.60% 2.90%
Turnover
A B C
Sales revneue 1,26,00,000 3,57,50,000 2,06,00,000
Divide: Average Assets 31,50,000 71,50,000 51,50,000
Turnover 4 5 4
ROI:
A B C
Margin 4.10% 1.60% 2.90%
Multiply: Turnover 4 5 4
ROI 16.40% 8% 11.60%
Residual Income
A B C
Average assets 31,50,000 71,50,000 51,50,000
Multiply: target rate of return 9.00% 9.50% 11.60%
Target return 283500 679250 597400
Actual net income 516600 572000 597400
Residual income 233100 -107250 0
Req 1.
Margin turnover Roi
A 4.10% 4 16.40%
B 1.60% 5 8%
C 2.90% 4 11.60%
Req 2.
A B C
Residual income 2,33,100 -1,07,250 0

Related Solutions

Selected sales and operating data for three divisions of different structural engineering firms are given as...
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 investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 5,100,000 $ 9,100,000 $ 8,200,000 Average operating assets $ 1,020,000 $ 2,275,000 $ 1,640,000 Net operating income $ 214,200 $ 746,200 $ 118,900 Minimum required rate of return 17.00 % 32.80 % 14.00 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
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,280,000 $ 35,350,000 $ 20,280,000 Average operating assets $ 3,070,000 $ 7,070,000 $ 5,070,000 Net operating income $ 601,720 $ 600,950 $ 567,840 Minimum required rate of return 10.00 % 10.50 % 11.20 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
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,360,000 $ 28,360,000 $ 25,450,000 Average operating assets $ 3,090,000 $ 7,090,000 $ 5,090,000 Net operating income $ 494,400 $ 453,760 $ 636,250 Minimum required rate of return 7.00 % 7.50 % 12.50 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
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,120,000 $ 28,120,000 $ 20,120,000 Average operating assets $ 3,030,000 $ 7,030,000 $ 5,030,000 Net operating income $ 496,920 $ 449,920 $ 503,000 Minimum required rate of return 7.00 % 7.50 % 10.00 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 16,000,000 $ 36,000,000 $ 20,800,000 Average operating assets $ 3,200,000 $ 7,200,000 $ 5,200,000 Net operating income $ 752,000 $ 576,000 $ 540,800 Minimum required rate of return 9.00 % 9.50 % 10.40 % Required: 1. Compute the margin, turnover, and return on investment (ROI) for each division. 2. Compute the residual income (loss) for...
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C   Sales $ 5,600,000 $ 9,600,000 $ 8,700,000   Average operating assets $ 1,120,000 $ 3,200,000 $ 1,740,000   Net operating income $ 263,200 $ 835,200 $ 169,650   Minimum required rate of return 16.00 % 26.10 % 13.00 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
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,900,000 $ 10,900,000 $ 10,000,000 Average operating assets $ 1,725,000 $ 5,450,000 $ 2,500,000 Net operating income $ 414,000 $ 1,090,000 $ 325,000 Minimum required rate of return 19.00 % 20.00 % 16.00 %      Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and...
Selected sales and operating data for three divisions of different structural engineering firms are given as...
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 investment (ROI) for each division using the formula stated in terms of margin and turnover.             ANSWER:     Division A margin             =          __________                                    ...
Selected sales and operating data for three divisions of different structural engineering firms are given as...
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,440,000 $ 35,550,000 $ 25,550,000 Average operating assets $ 3,110,000 $ 7,110,000 $ 5,110,000 Net operating income $ 547,360 $ 639,900 $ 740,950 Minimum required rate of return 10.00 % 10.50 % 14.50 % Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover. (Do not...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT