In: Accounting
1. The operating income and the amount of invested assets in each division of Conley Industries are as follows:
Operating Income | Invested Assets | |||
Retail Division | $159,600 | $840,000 | ||
Commercial Division | 86,100 | 410,000 | ||
Internet Division | 42,000 | 300,000 |
a. Compute the return on investment for each division. (Round to the nearest whole percentage.)
Division | Percent |
Retail Division | % |
Commercial Division | % |
Internet Division | % |
2. The operating income and the amount of invested assets in each division of Conley Industries are as follows:
Operating income | Invested Assets | |||
Retail Division | $86,000 | $430,000 | ||
Commercial Division | 74,800 | 440,000 | ||
Internet Division | 91,200 | 380,000 |
Assume that management has established a 12% minimum acceptable return for invested assets.
a. Determine the residual income for each division.
Retail Division | Commercial Division | Internet Division | |||||||
Operating income | $86,000 | $74,800 | $91,200 | ||||||
Minimum acceptable operating income as a percent of invested assets | |||||||||
Residual income | $ | $ | $ |
3. Briggs Company has operating income of $19,266, invested assets of $169,000, and sales of $321,100. Use the DuPont formula to compute the return on investment. If required, round your answers to two decimal places.
a. Profit margin | % | |
b. Investment turnover | ||
c. Return on investment | % |
4. The Commercial Division of Galena Company has operating income of $59,470 and assets of $159,000. The minimum acceptable return on assets is 11%.
What is the residual income for the division?
$
Question 1 | A | B | C=A/B |
Particulars | Operating Income | Invested Assets | ROI |
Retail Division | $ 1,59,600.00 | $ 8,40,000.00 | 19.00% |
Commercial Division | $ 86,100.00 | $ 4,10,000.00 | 21.00% |
Internet Division | $ 42,000.00 | $ 3,00,000.00 | 14.00% |
Question 2 | A | B | C | D =BxC | E=A-D |
Particulars | Operating Income | Invested Assets | Min Acceptable return % | Min Acceptable return | Residual Income |
Retail Division | $ 86,000.00 | $ 4,30,000.00 | 12% | $ 51,600.00 | $ 34,400.00 |
Commercial Division | $ 74,800.00 | $ 4,40,000.00 | 12% | $ 52,800.00 | $ 22,000.00 |
Internet Division | $ 91,200.00 | $ 3,80,000.00 | 12% | $ 45,600.00 | $ 45,600.00 |
Question 3
a. Profit Margin = Operating Income / Sales = $19,266 / $321,100 = 6.00%
b.Investment turnover = Net Sales / Total Assets = $321,100/$169,000 = 1.90
c. Return on investment = Operating Income / Total Assets = $19,266 / $169,000 = 11.40%
Dupont analysis ROI = Profit margin x Investment turnover
11.40% = 6.00% x 1.90 = 11.40%
Question 4
Residual Income = Operating Income - (Total assets x min. acceptable return %) = $59,470 - ($159,000 x 11%) = $41,980