NPVV ( cashFlowsList , interestRate )
NPVV calculates Net Present Value of a value list of cash flows (cashFlowsList) with a specified rate of return (interestRate). Used to determine the present value of an investment by the discounted sum of all cash flows paid or received.
NPVV calculates Net Present Value from a value list instead of a repeating field that FileMaker Pro requires with its NPV function. This custom function provides more flexibility and ease-of-use than the built-in function, with the same calculation results and similar speeds. A list of 360 cash flows was processed through this custom function with no noticeable speed problem.
- cashFlowsList – Value list of cash flows.
- interestRate – Specified rate of return.
- NPVV ( “-500000¶200000¶300000¶200000”, .1 ) = 80025.0262960180315552
- NPVV ( List ( -2000, 600, 300, 500, 700, 400 ), .05 ) = 164.7584131734254368
- NPVV ( List ( -5000, 10000, 0, 10000, 10000 ), .1 ) = 18434.1916535755754388
DISCLAIMER: Using this NPVV function, several calculations were compared against the results obtained on other NPV calculators and the results matched. However, that does not guarantee a correct result in every operation of this custom function, so you assume this risk when you use it.
NOTICE: This is a recursive function. If you change the function name then also change it in the function code.
NPVV code: Copy the selected code (click on Select All to highlight all the code) to the clipboard and paste it into a newly created Custom Function. Download code as a text file from here.