Question: Please make an excel table for this question, you can upload a screen shot! Using the NPV and Payback models as a selection criterion for
Please make an excel table for this question, you can upload a screen shot!

Using the NPV and Payback models as a selection criterion for project selection your role as a project manager is to report to senior management which of the three projects listed below is the most beneficial project to be approved. Project A initial investment of $1,256,000 with a projected cash inflows of $170,000 for 5 years. The rate of return is 25%. Project B initial investment of $716,000 with a projected cash inflows of $310,000 for 5 years. The rate of return is 25%. Project C initial investment of $435,000 with a projected cash inflows of $180,500 for 5 years. The rate of return is 25%. Question 1: What is the NPV for each of the three projects and which project would you select as the most beneficial project to approve. (4 Marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
