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.<\/p>\n
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.<\/p>\n
DISCLAIMER:<\/strong> 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.<\/p>\n NOTICE:<\/strong> This is a recursive function. If you change the function name then also change it in the function code.<\/p>\n NPVV code:<\/strong> 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.<\/a><\/p>\n