npv Function

Description:
The net present value for a series of periodic cash flows at a fixed interest rate.
Returns:
Number
Parameters:
Parameter
Data Type
Description
1
Number
The interest rate.
2
Number*
The list of cash flows.
Example:
When using functions inside a field, remember the field brackets:
{npv(BaseRate, CashFlowList)}
Expression
Result
npv( 0.1, List(-12000, 3300, 4800, 6700) )
0.68

Related content