Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A company is considering an ERP system and has identified the following costs and benefits. The initial investment (year O) for the system is: Software
A company is considering an ERP system and has identified the following costs and benefits. The initial investment (year O) for the system is: Software $2,500,000 Hardware $1,200,000 Consulting $1,900,000 Training $750,000 Internal BPR team $1,000,000 Implementation $300,000 The following costs for the next five years were identified. Software Licenses $200,000 per year (years 1, 2, 3, 4 and 5) Hardware $100,000 during the first year Hardware $30,000 in years 2, 3, 4 and 5 Consulting $300,000 during the first year Consulting $100,000 in years 2, 3, 4 and 5 Training $200,000 during the first year Training $100,000 in years 2 and 3 Internal BPR team $200,000 in years 1, 2 and 3 Implementation $200.000 per year (years 1, 2, 3, 4 and 5) The following financial benefits have been identified for the next five years. Inventory Reduction $3,200,000 in each of years 1 and 2 Inventory Reduction $1,700,000 in year 3 Inventory Reduction $600,000 in year 4 Personnel Reduction $2,500,000 for the second year Personnel Reduction $2,000,000 for each of years 3, 4, and 5 IT Cost Reduction $300,000 for the first year IT Cost Reduction $400,000 for the second year IT Cost Reduction $500,000 for the third year IT Cost Reduction $600,000 for the fourth and fifth years Cash Management $700,000 for each year (1, 2, 3, 4, and 5) Increased sales profits $700,000 for the first year Increased sales profits $320,000 for second year Increased sales profits $900,000 for years 3, 4 and 5 The company uses a 19% discount rate to evaluate projects. What is the Net Present Value (NPV) and Internal Rate of Return (IRR) for the project? What is the payback period for the project? Also, prepare a table that shows the sensitivity of Net Present Value to the discount rate
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started