NPV function

This article describes the formula syntax and usage of the NPVfunction in Microsoft Excel.

Description

Determines the net present value of a financial investment by using a discount rate and a series of future payments (unfavorable worths) and earnings (positive worths).

Syntax

NPV(rate, value1, [value2], …)

The NPV function syntax has the following arguments:

• RateRequired. The rate of discount rate over the length of one duration.

• Value1, value2, …Value1 is required, subsequent values are optional. 1 to 254 arguments representing the payments and earnings.

  • Value1, value2, … need to be equally spaced in time and happen at the end of each period.

  • NPV uses the order of value1, value2, … to analyze the order of cash flows. Make certain to enter your payment and income worths in the proper series.

  • Arguments that are empty cells, sensible worths, or text representations of numbers, mistake worths, or text that can not be equated into numbers are overlooked.

  • If an argument is a selection or reference, only numbers in that selection or recommendation are counted. Empty cells, rational values, text, or mistake worths in the variety or recommendation are ignored.

Remarks

• The NPV investment starts one period before the date of the value1 cash flow and ends with the last cash flow in the list. The NPV estimation is based on future capital. If your very first capital happens at the beginning of the very first period, the first worth must be added to the NPV result, not included in the worths arguments. For additional information, see the examples listed below.

• If n is the number of money flows in the list of values, the formula for NPV is:

• NPV resembles the PV function (present value). The main distinction between PV and NPV is that PV allows capital to start either at the end or at the start of the duration. Unlike the variable NPV capital values, PV cash flows need to be constant throughout the financial investment. For details about annuities and monetary functions, see PV.

• NPV is likewise related to the IRR function (internal rate of return). IRR is the rate for which NPV equates to zero: NPV(IRR(…), …) = 0.

Example

Copy the example information in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to reveal outcomes, pick them, press F2, and after that press Enter. If you require to, you can adjust the column widths to see all the data.

Example 2

Top of Page

Calculates the net present worth of a financial investment by utilizing a discount rate and a series of future payments (unfavorable worths) and income (favorable worths).