NPV
Use this function to calculate the net present value of future cash flows. For each period, net inflow equals inflow minus outflow (outflow is expected to be a positive value). NPV must be used with BY dimension. The symbols in the BY dimension hold the series of values. The result of NPV is stored in the first symbol in the range of symbols in the BY dimension as specified in the calculation block.
Note: To specify the range of symbols in the BY dimension, enter the first and last symbols in the range, separated by a colon. For example, A0601:A0612.
Syntax:
NPV (InflowSymName,Rate[, OutflowSymName])
where:
- InflowSymName is a symbol that contains the cash flows (+ and -).
- Rate is the interest rate to discount the cash flows at.
- OutflowSymName is an optional symbol that contains expenditures.
Syntax example:
CalculationBlock(Accounts;TimePeriods A0101:A0112)
BY TimePeriods
target = NPV (Chi1,0.12,Chi2
End CalculationBlock