Answer:
The Net Present Value (NPV) of this project is $93,405.59.
Explanation:
Note: Find attached the excel file for the calculation of the NPV of this project.
Net present value (NPV) refers to the present value of cash inflows minus the present value of cash outflows over a specified period of time.
On its own, present value (PV) refers the value that a future sum of money or stream of cash flows has now or currently given a specified rate of return. The formula for calculating the PV is given as follows:
PV = FV / (1 + r)^n
Where,
FV = Future value
r = discount rate. This is given as 10% in this question
n = Relevant period, e.g. year
The above explanation and formula together with other stated formulae in the attached excel file is used in calculating the NPV of this project.