Brian Dunning's FileMaker Custom Functions

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   Lewis Lorenz
Lorenz Companies
http://www.LorenzCom.com

Share on Facebook Share on Twitter

  Sample input:
NPVV (
  Sample output:
80025.0262960180315552164.758413173425436818434.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

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.