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
-
Financial Functions
Format:
Article,
1 min read