# 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.

© BrainMass Inc. brainmass.com October 1, 2020, 8:58 pm ad1c9bdddfhttps://brainmass.com/business/accounting/roi-and-residual-income-on-excel-worksheet-159427

#### 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.