NPVV ( cashFlowsList ; interestRate )
Calculate Net Present Value of a value list (not a repeating field) of cash flows with a specified rate of return.
Average rating: 4.8 (24 votes) Log in to vote
|
Lewis Lorenz - Show more from this author
Lorenz Companies http://www.LorenzCom.com |
NPVV ( List ( -2000 ; 600 ; 300 ; 500 ; 700 ; 400 ) ; .05 )
NPVV ( List ( -5000 ; 10000 ; 0 ; 10000 ; 10000 ) ; .1 )
164.7584131734254368
18434.1916535755754388
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
NPVV ( cashFlowsList ; interestRate )
Created: 4-5-2013
Modified: 1-2-14
Author: Lewis C. Lorenz
Calculate 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. Calculates Net Present Value from a value list instead of a repeating field that FileMaker Pro requires with its NPV function. Provides more flexibility and ease of use than the built-in function, with the same calculation results and similar speeds.
Example:
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.
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.