Spread Formula Reference
Formula Functions / Functions M to Q / NPV
In This Topic
    NPV
    In This Topic

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

    Syntax

    NPV(discount,value1,value2,...)

    Arguments

    This function has these arguments:

    Argument Description
    discount Rate of discount for one period
    value1,... Values for money paid out (as for a payment) are negative numbers; values for money you receive (as for income) are positive numbers

    The function includes in calculations arguments that are numbers, empty cells, logical values, or text representations of numbers; the function ignores arguments that are error values or text that cannot be translated into numbers. If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored. This function can have up to 255 arguments.

    Remarks

    The payments and income must be equally spaced in time and occur at the end of each period. The function uses the order of the values to interpret the order of cash flows. Be sure to enter your payment and income values in the correct sequence.

    The investment begins one period before the date of the value1 cash flow and ends with the last cash flow in the list. The calculation is based on future cash flows. If your first cash flow occurs at the beginning of the first period, the first value must be added to the result, not included in the value arguments.

    This function is similar to the PV function (present value). Use PV to work with cash flows that begin at the beginning or the end of the period; this function allows cash flows only at the end of the period. Unlike the variable cash flow values of this function, PV cash flows must be constant throughout the investment.

    This is also related to the IRR function (internal rate of return). IRR is equivalent to this function when the rate argument for net present value equals zero: NPV(IRR(...),...) = 0.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    NPV(0.065,D12:D19)

    NPV(R1C1,R12C4:R19C4)

    NPV(6.5%, -10000, 3000, 3400, 7700) gives the result $2,055.38

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    IRR | PV | Financial Functions