Loan simulator formula - Little error

Get Help
,
1

Hi guys,

I am Vincent and I am coming from Belgium.
I use Gravity Forms and the Gravity FormsAdvanced Calculations to build my loan simulator.

I use this formula: A = P (r (1+r)^n) / ( (1+r)^n -1 ).

I take a real example.

Correct result:

Amount: 25 000 €
Duration : 60 months
Rate : 8.25%
Monthly payment: 506.35 €

False result with he formula:

Amount: 25 000 €
Duration : 60 months
Rate : 8.25%
Monthly payment: 509.91 €

I know that it’s only a difference of 3 euros but I can’t use the simulator because of this difference.

Can you help me?

2

@user666f1780acbcb745 what’s the exact calculation you have entered into your Gravity Forms Number field?

Presumably you are using merge tags to provide P, r, and n. What if you remove the merge tags and hardcode the values in the Number field calculation? Same result?

3

Hi,

I get the same result with hard code.

In order to get the good result for a rate at 8.25%, I have to put 7.9523 in the hidden field.

That’s really strange.