Description
Calculate the net present value of an investment based on a series of periodic cash flows and a discount rate.
Signature
PresentValue_NPV('rate', 'values')
Parameters
| Name | Required | Type | Description |
|---|---|---|---|
| rate | Yes | double | The rate of discount over the length of one period |
| values | Yes | string array double | A series of future payments (negative values) and income (positive values). |
Example 1
PresentValue_NPV(0.1, '100,200,300,400,500') Returns 1065.25