Share
Explore BrainMass

ROI and Residual Income on Excel Worksheet

Calculate on Excel worksheet

NP7.2 ROI and Residual Income

Suppose that a division of a company is treated as an investment center. Its manager is currently obtaining an ROI of 15% from existing assets of $1 million. The cost of capital (corporate discount rate) is 10%. The division manager has the option of choosing among the following projects which are independent of existing operations and the other alternative projects.

PROJECT INVESTMENT ROI
A $100,000 14%
B $400,000 20
C $200,000 14
D $300,000 12
E $500,000 8

A Given the current investment in existing assets in which additional projects should the division manager invest if the objective is to maximize ROI.

Solution Preview

ROI and Residual Income

Suppose that a division of a company is treated as an investment center. Its manager is currently obtaining an ROI of 15% from existing assets of $1 million. The cost of capital (corporate discount rate) is 10%. The division manager has the option ...

Solution Summary

This solution is comprised of a detailed explanation to answer which additional projects should the division manager invest if the objective is to maximize ROI.

$2.19