The Net Present Value (NPV) function calculates the net present value of an investment by using a discount rate, a series of future payments and an income.
NPV(Rate, Cashflow [,Level])
Rate → The rate of the discount over the time of the period
Cashflow → Series of payments or incomes (negative values represents outgoing payments and positive values represent incoming payments)
Level → [Optional] The period of time or a sequence over which the calculation is going to be made. If the level is not provided, the lowest time level from cashflow is selected
The 'Cashflow' node is the leading input node.
Rate values are percentages and must be entered/returned as decimals. e.g. 10% → 0.1
If a level is entered, it should be a level of the cashflow node
The levels from the rate input node need to be available in the cashflow input node
Any level that is in the same dimension as the selected level from the cashflow node, cannot be available in the rate input node. That also counts for all linked levels in this dimension
With the given cashflow and rate nodes, using the function NPV('Rate', ‘Cashflow') (or NPV('Rate', ‘Cashflow', “Year“)) would give the following result. In this example, the NPV has been aggregated over the years.