fnCALC_TAUX ( ValeurActuelle ; NombreMensualites ; Mensualite ; 0,10 )

Returns the interest rate per period of an annuity. RATE is calculated by iteration

Average rating: 4.7 (3 votes) Log in to vote

louis - Show more from this author
none
http://none

Sample input:

fnCALC_TAUX ( 150000; 240; 1000 ; 0.10)

Sample output:

0,4267...

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

/*

***** This is a recursive function *****

Simplified version of the "Rate()" function of Excel.
https://support.office.com/en-us/article/RATE-function-9f665657-4a7e-4bb7-a030-83fc59e748ce

v1.0 - louis - 2017, April

*/


Definir ( [
	vA = pValeurActuelle/pMensualite;

	vP = vA*pTauxInitial*((1+pTauxInitial)^pNombreMensualite) - ((1+pTauxInitial)^pNombreMensualite) + 1;
	vDP = vA*((1+pTauxInitial)^pNombreMensualite) + vA*pNombreMensualite*pTauxInitial*((1+ pTauxInitial)^(pNombreMensualite-1)) - pNombreMensualite*((1+ pTauxInitial)^(pNombreMensualite-1));

	vNouveauTaux = (pTauxInitial - (vP/vDP));
	vEcart = (pTauxInitial - vNouveauTaux)
	];
	Si (	vEcart > 0 ;
		fnCALC_TAUX ( pValeurActuelle; pNombreMensualite; pMensualite; vNouveauTaux);
		vNouveauTaux*100
		)
	)

Same as RATE() function in Excel with only required parameters.

• Total number of payment periods in an annuity.
• The payment made each period.
• The present value.
• The fourth parameter (0.10 aka 10%) in the exemple above is just an initial rate.

Comments

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

fnCALC_TAUX ( ValeurActuelle ; NombreMensualites ; Mensualite ; 0,10 )

Comments

Support this website.

Support this website.