Question: ONLY ON EXCEL SHEET; PLEASE ASSIST THIS URGENT , ON EXCEL SHEET.,..ON EXCEL SHEET , PLEASE ITS URGENT Consider a five-year investment project that requires

ONLY ON EXCEL SHEET; PLEASE ASSIST THIS URGENT , ON EXCEL SHEET.,..ON EXCEL SHEET , PLEASE ITS URGENT

ONLY ON EXCEL SHEET; PLEASE ASSIST THIS URGENT , ON EXCEL SHEET.,..ON

Consider a five-year investment project that requires an initial investment of R.120 000 and will pay out the following at the end of each of the five years. Model the project in a spreadsheet and use the spreadsheet to answer the following questions: a. Give the net present value (NPV) and the profitability index (PI) of the project assuming a discount rate of 8% per annum. b. Would you regard the investment as a good investment? Motivate your answer. c. How would your answers to question a and b change if the discount rate is assumed to be 11% ? d. Suppose that possible discount rates are 9%,10%,11%,12%,13%,14%. Perform a sensitivity analysis on the NPV and PI of the project for this range of discount rates. Between which two discount rates does the project change from profitable to unprofitable? Give the NPV and PI values at these two discount rates

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!