Assume that you have to select between two projects for your organization. You need to find out which project is going to bring better financial benefits to the organization in five years. With your team you obtained the information below. Create an Excel Worksheet for calculating the NPV for the two project and upload it back to this question.

The discount rate is 11%.

Project 1 Costs Benefits

Year 1 $6000 $0

Year 2 $1000 $2000

Year 3 $500 $5000

Year 4 $500 $5000

Year 5 $500 $5000

Project 2 Costs Benefits

Year 1 $10000 $500

Year 2 $2000 $3000

Year 3 $1000 $5000

Year 4 $1000 $5000

Year 5 $1000 $5000