Microsoft Excel Training Home

NPV or Net Present Value in Excel - correction

The initial investment of 120000 units should not have been added to the NPV calculations because we had already accounted for the expenditure details using the PMT function. We had in fact taken a loan of a total of 120000 from a bank and paid it back in 2 years.

         



Reference

NPV or Net Present Value in Excel - correction