In: Accounting
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 | |||||||||||||||||||||||||
|
2 | |||||||||
|
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 | |||