Hello, I’m trying to build a savings goal calculator to figure out how much you need to put away each month to reach your savings goal. I would like the calculator to take into accoung interest rate and copound frequency of the account where the money will be saved.
The formula of the calculator is :
Monthly savings = (Goal amount * Interest rate / Compound frequency) / (1 – (1 + Interest rate / Compound frequency) ^ (-Term in months))
So in the plugin, I tried to start the formula this way : “(fieldname15-fieldname13)/(1+fieldname2)” but I do not manage to do the rest. Could you tell me what is the right formula to add ?
Thanks a lot
