NPV function in Excel

Use

NPV function calculates the net present value of an investment by using a discount rate and a series of future payments.

Syntax

=NPV(rate,value1,[value2],…) – Investment value

rate – The discount rate for over one period.

value1,[value2],… – The numeric values representing series of regular payments and income where in payments are in negative and income in positive.

Example

Formula:

Result:

 

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved