At this time I have created a solution that uses the bisection method to calculate the EARP of a loan.

This method takes about 35 iterations to come up with an answer.

So I would like to do these calculations using either the Newton / Raphes method or one of the Quasi Newton methods.

I believe those methods use around 5 iterations to come up with a fairly accurate solution.

Is there anyone here that has done this in Filemaker or that could show me how it's done?

Also, how can I prevent the calculation from not converging?

Kind regards

Hans

Recursive custom function will do it.

Doesn't financial functions give you enough calculations for loan?