Question: Submit as an MS Excel sheet. A new inventory management system for ABC Company could be developed at a cost of $260,000. The estimated net

Submit as an MS Excel sheet. A new inventory management system for ABC Company could be developed at a cost of $260,000. The estimated net operating costs adn estimated net benefits over six years of operation would be Estimated Net Operatin9 Cost Cumulative Costs Estimated Net Benefits Cumulative Benefits ear 0 S 260,000.00 1 S 7,000.00 2 S 9,400.00 3 S 11,000.00 4 S 14,000.00 S 15,000.00 6 S 25,000.00 S 42,000.00 S 78,000.00 S 82,000.00 S 115,000.00 S120,000.00 140,000.00 1. What would the payback period be for this investment? 2. What would the ROI ratio be for this investment? 3. Assuming the internal rate of return for this company is less than 5 years, would it be a good or bad investment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
