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

Sample input:

NPVV ( "-500000¶200000¶300000¶200000" ; .1 )
NPVV ( List ( -2000 ; 600 ; 300 ; 500 ; 700 ; 400 ) ; .05 )
NPVV ( List ( -5000 ; 10000 ; 0 ; 10000 ; 10000 ) ; .1 )

Sample output:

80025.0262960180315552
164.7584131734254368
18434.1916535755754388

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( 
cfct = ValueCount ( cashFlowsList ) ;

GetValue ( cashFlowsList;  cfct ) / ( 1 + interestRate ) ^ ( cfct - 1 ) + If ( cfct > 0 ; NPVV ( LeftValues ( cashFlowsList ; cfct - 1 ) ; interestRate ); 0 )

)

/*
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.

*/

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.

NPVV ( cashFlowsList ; interestRate )

Comments

Support this website.

Support this website.