WorksheetFunction.Npv (Excel)

Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).

Value1, value2, ... must be equally spaced in time and occur at the end of each period. Npv uses the order of value1, value2, ... to interpret the order of cash flows. Be sure to enter your payment and income values in the correct sequence. Arguments that are numbers, empty cells, logical values, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored. 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. The Npv investment begins one period before the date of the value1 cash flow and ends with the last cash flow in the list. The Npv 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 Npv result, not included in the values arguments. If n is the number of cash flows in the list of values, the formula for Npv is:

Npv (Arg1, Arg2, ..., Arg30)

Dim dblArg1 As Double: dblArg1 = 
Dim dblNpv As Double
dblNpv = WorksheetFunction.Npv(Arg1:=dblArg1, Arg2:=)

Arguments

Arg1 (Double) - Rate - the rate of discount over the length of one period.