What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    How is the mortgage calculation formulated?

    Asked by capitalresorts on March 06, 2015 at 08:16 PM
    can you share the formula used to calculate this? I need to create a calculator in a form that populates the information based on other fields. If you could share a screenshot that shows how I would enter the calculation into the standard "Form Calculation" widget, that would be a HUGE help!
  • Profile Image

    Answered by Ben on March 07, 2015 at 04:44 AM

    Yes, we can share the calculation - The secret code behind this calculation is this:

    {amountBorrowed} * ( ( {annualInterest} / 1200 * pow(1+{annualInterest} / 1200, {loadDuration} * 12 ) ) / ( pow(1+ {annualInterest} / 1200, {loadDuration} * 12) - 1 ))

    You can see more about pow() function here: Form Calculation - Math Function Reference

    Do let us know however if you have any questions and we would be happy to answer them :)

  • Profile Image

    Answered by capitalresorts on March 07, 2015 at 03:13 PM

    Hi Ben, that was exactly what I was looking for. Unfortunately, it did not work for me. I tried in both Chrome and Firefox (mac) and it gave an error and the calculation would not work. In fact, when I went back to the wizard to check the formula, it was gone completely. Did this about half a dozen times with the same result each time. See below screenshot I took before failing on the last attempt:

    Thanks again for providing, I'm confident we can get it working!

  • Profile Image

    Answered by raul on March 07, 2015 at 04:42 PM

    Did you try using the template provided there?
    I did a test now and the form worked fine on my side.

    Could you please try to clone this form: http://form.jotformpro.com/form/50656672155964? I made the changes in it to make it look like the one you have in your account.

    Give it a try and let us know if the issue persists.

  • Profile Image

    Answered by capitalresorts on March 07, 2015 at 05:53 PM

    Oh that worked great, thanks! I didn't realize the original mortgage calculator was a template - thought it was a widget so I didn't even try it. I should have just done that from the beginning, thanks!