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
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.