Question
In: Accounting
For the first company division listed, insert formula commands to calculate ROI and Residual income (assume...
For the first company division listed, insert formula commands to calculate ROI and Residual income (assume the company has a 25% target rate of return). To insert formulas, highlight the cell where you want to place the answer. (Please Provide Excel Formula used)
Use the “Copy” and “Paste” commands to copy the same formulas into the appropriate cell for each division.
Use the “%” on the “Number” section of the menu bar to format the ROI as a percentage. Format the residual income as a dollar amount.
| Americas | Chinas | EMEA | Channel Development | |
| Assets | 3327.20 | 2770.90 | 273.80 | 114.00 |
| Operating Income | 3663.20 | 765.00 | 116.10 | 893.40 |
| Revenue | 15652.70 | 3240.20 | 1013.70 | 2008.60 |
| Division | ROI | Residual Income |
| Americas | ||
| Chinas | ||
| EMEA | ||
| Channel Development |
Solutions
ekkarill92 answered 11 months agoRelated Solutions
ROI and Residual Income: Impact of a New Investment The Mustang Division of Detroit Motors had...
ROI and Residual Income:
Impact of a New Investment
The Mustang Division of Detroit Motors had an operating income of
$900,000 and net assets of $4,000,000. Detroit Motors has a target
rate of return of 16 percent.
(a) Compute the return on investment. (Round your answer to three
decimal places.)
Answer
(b) Compute the residual income.
$Answer
(c) The Mustang Division has an opportunity to increase operating
income by $250,000 with an $750,000 investment in assets.
1. Compute the Mustang...
Residual income, ROI, and EVA The following selected data pertain to Brannard Company's Construction Division for...
Residual income, ROI, and EVA
The following selected data pertain to Brannard Company's
Construction Division for last year.
Sales
$2,380,000
Variable costs
$1,428,000
Traceable fixed costs
$238,000
Average invested capital (assets)
$3,570,000
Current liabilities
$238,000
Required rate of return
15%
Marginal tax rate
36%
Weighted average cost of capital
12%
1. Calculate the residual income. $______
2. Calculate the return on investment. ______%
3. Calculate the economic value added. $______
Residual income, ROI, and EVA The following selected data pertain to Brannard Company's Construction Division for...
Residual income, ROI, and EVA The following selected data
pertain to Brannard Company's Construction Division for last
year.
Sales $2,380,000
Variable costs $1,428,000
Traceable fixed costs $238,000
Average invested capital (assets) $3,570,000
Current liabilities $238,000
Required rate of return 15%
Marginal tax rate 36%
Weighted average cost of capital 12%
QN:
1. Calculate the residual income. $______
2. Calculate the return on investment. ______%
3. Calculate the economic value added. $______
ROI, Residual Income, and EVA with Different Bases Envision Company has a target return on capital...
ROI, Residual Income, and EVA with Different Bases Envision
Company has a target return on capital of 12 percent. The following
financial information is available for October ($ thousands):
Software Division . Consulting Division Venture Capital
Division
(Value Base) (Value Base) (Value Base)
Book Current Book Current Book Current
Sales $100,000 $100,000 $200,000 $200,000 $800,000 $800,000
Income 12,250 11,700 16,400 20,020 56,730 51,920
Assets 70,000 90,000 100,000 110,000 610,000 590,000
Liabilities 10,000 10,000 14,000 14,000 40,000 40,000
Required
a. Compute...
ROI, Residual Income Raddington Industries produces tool and die machinery for manufacturers. The company expanded vertically...
ROI, Residual
Income
Raddington Industries
produces tool and die machinery for manufacturers. The company
expanded vertically in 20x1 by acquiring one of its suppliers of
alloy steel plates, Keimer Steel Company. To manage the two
separate businesses, the operations of Keimer are reported
separately as an investment center.
Raddington monitors
its divisions on the basis of both unit contribution and return on
average investment (ROI), with investment defined as average
operating assets employed. Management bonuses are determined on
ROI. All...
ROI, Residual Income Raddington Industries produces tool and die machinery for manufacturers. The company expanded vertically...
ROI, Residual Income
Raddington Industries produces tool and die machinery for
manufacturers. The company expanded vertically in 20x1 by acquiring
one of its suppliers of alloy steel plates, Keimer Steel Company.
To manage the two separate businesses, the operations of Keimer are
reported separately as an investment center.
Raddington monitors its divisions on the basis of both unit
contribution and return on average investment (ROI), with
investment defined as average operating assets employed. Management
bonuses are determined on ROI. All...
ROI, Residual Income Raddington Industries produces tool and die machinery for manufacturers. The company expanded vertically...
ROI, Residual Income
Raddington Industries produces tool and die machinery for
manufacturers. The company expanded vertically in 20x1 by acquiring
one of its suppliers of alloy steel plates, Keimer Steel Company.
To manage the two separate businesses, the operations of Keimer are
reported separately as an investment center.
Raddington monitors its divisions on the basis of both unit
contribution and return on average investment (ROI), with
investment defined as average operating assets employed. Management
bonuses are determined on ROI. All...
ROI, Residual Income Raddington Industries produces tool and die machinery for manufacturers. The company expanded vertically...
ROI, Residual Income
Raddington Industries produces tool and die machinery for
manufacturers. The company expanded vertically in 20x1 by acquiring
one of its suppliers of alloy steel plates, Keimer Steel Company.
To manage the two separate businesses, the operations of Keimer are
reported separately as an investment center.
Raddington monitors its divisions on the basis of both unit
contribution and return on average investment (ROI), with
investment defined as average operating assets employed. Management
bonuses are determined on ROI. All...
ROI, Residual Income Raddington Industries produces tool and die machinery for manufacturers. The company expanded vertically...
ROI, Residual
Income
Raddington Industries
produces tool and die machinery for manufacturers. The company
expanded vertically in 20x1 by acquiring one of its suppliers of
alloy steel plates, Keimer Steel Company. To manage the two
separate businesses, the operations of Keimer are reported
separately as an investment center.
Raddington monitors
its divisions on the basis of both unit contribution and return on
average investment (ROI), with investment defined as average
operating assets employed. Management bonuses are determined on
ROI. All...
ROI, Residual Income Raddington Industries produces tool and die machinery for manufacturers. The company expanded vertically...
ROI, Residual Income
Raddington Industries produces tool and die machinery for
manufacturers. The company expanded vertically in 20x1 by acquiring
one of its suppliers of alloy steel plates, Keimer Steel Company.
To manage the two separate businesses, the operations of Keimer are
reported separately as an investment center.
Raddington monitors its divisions on the basis of both unit
contribution and return on average investment (ROI), with
investment defined as average operating assets employed. Management
bonuses are determined on ROI. All...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Consider a project generating the following cash flows over six years: Year Cash Flow (R in...
- Please explain why it is important to determine early and late, start and finish schedules?
- 8. if the project duration needs to be reduced then a. the activity with the lost...
- Part 4: CLO 4 Question 1 What are the factors that project manager need to consider...
- I need this in Java please: Behaviors. In the context of OOP, functions are called methods...
- Emotional Intelligence (EI) includes both personal and social competence. In the personal realm, a person with...
- How "democratic" is the U.S. democracy? What is "limited government" and how are the various levels...
ADVERTISEMENT