XFA Specification
Chapter 23, FormCalc Specification
Financial Built-in Functions
860
NPV()
This function returns the net present value of an investment based on a discount rate, and a series of
periodic future cash flows.
Syntax
NPV(n1, n2 [, ...])
Parameters
n1
is the discount rate over one period.
n2, ...
are the cash flow values which must be equally spaced in time and occur at the end of each
period.
Returns
The net present value rate or null if any of its parameters are null.
The function uses the order of the values n2, ... to interpret the order of the cash flows. Ensure payments
and incomes are specified in the correct sequence.
If n1 is non-positive, the function generates an error exception.
Examples
NPV(0.15, 100000, 120000, 130000, 140000, 50000)
returns 368075.16
*
which is the net present value of an investment projected to generate $100,000,
$120,000, $130,000, $140,000 and $50,000 over each of the next five years and the rate is 15% per annum.
NPV(0.10, -10000, 3000, 4200, 6800)
returns 1188.44
*
.
NPV(0.08, 8000, 9200, 10000, 12000, 14500)
returns 41922.06
*
.