A new is project has been proposed that is expected to produce not only cost saving but also an increase in revenue, The initial costs to establish the system are estimated to be $500,000. The remaining cash flow data is presented in the following table.

All amounts are in bund reds of thousands.

a. Using a spreadsheet program, calculate the return on investment (ROI) for this project.

Assume that the cost of capital is 7 percent.

b. How would the rate of return change if the project delivered $50,000 in additional revenue and generated cost savings of $25,000 in the first year?

Transcribed Image Text:

Increased revenue Cost savings Depreciation Initial expense Year 1 Year 2 Year 3 $0 $100 $150 $0 $50 $50 $0 $75 $75 $500 Year 4 Year 5 $200 $250 $50 $50 $75 $75 Increased revenue Cost savings Depreciation Initial expense Year 1 Year 2 Year 3 $0 $100 $150 $0 $50 $50 $0 $75 $75 $500 Year 4 Year 5 $200 $250 $50 $50 $75 $75

Answer rating: 100% (QA)

Estimating Return of Investment The situation is that a new IS project is proposed to produced cost ... View the full answer