Correct answer a. $282,132
To calculate the present value of the project we will be using the NPV function in excel
The NPV function in excel calculated the present value by discounting the series of cash flows at the specified discount rate
=NPV (discount rate, series of cash flow)
As seen in the working below, the NPV is 382,132. We have made an initial investment of 100000 we thus have to deduct the same to get the final NPV
Net present value = 3,82,132 – 100,000
Net present value = 2,82,132
Get Answers For Free
Most questions answered within 1 hours.