Bisbee Aerospace is seeking to undertake a new project to upgrade its ERP system. The project is expected to have a useful life of 5 years. The initial investment (cash outflow) is $1,000,000. The net cash inflow is expected to be $300,000 for each year of the year useful life. Determine the NPV of this project, using Excel, if the discount rate is 12% and inflation is expected to average 2%. Should this project be funded? If yes why, and if no, why not?
This needs to be done in excel