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

    sliders with calculated result widget.

    Asked by sixtowns on November 02, 2014 at 06:37 PM

     

    Hi, can anybody help I’m trying to do a loan repayment calculator using the ‘sliders with calculated result’ widget.

     

    Showing the amount customer would like to borrow In £

     

    Monthly Loan repayment £, at an interest rate of 2% per month (APR 26.8)

     

    Over a maximum repayment period of 36 months.

     

    Thanks in advance

     

    Page URL:
    http://form.jotformpro.com/form/43057255607960

    style size font maximum
  • Profile Image
    JotForm Support

    Answered by ashwin_d on November 02, 2014 at 11:04 PM

    Hello sixtowns,

    Please explain the formula to calculate the repayment calculator and we will surely help you.

    We will wait for your response.

    Thank you!

  • Profile Image

    Answered by sixtowns on November 03, 2014 at 07:51 AM

     

    Hi I have produced a repayment calculator which I hope will give you an idea of how our calculations work.

     

    Thanks.

    https://app.box.com/s/zkusunlx46cai2gjt5u9

  • Profile Image
    JotForm Support

    Answered by ashwin_d on November 03, 2014 at 09:03 AM

    Hello sixtowns,

    I was able to figure out the rest of the formula you have added. Can you please explain the formula to calculate the "Monthly Payment" amount value. Please be noted that you need to actually explain the formula instead of excel function.

    We will wait for your response.

    Thank you!

  • Profile Image

    Answered by sixtowns on November 03, 2014 at 11:23 AM

     

    Hi, How does this look?

     

     

     

    P = the amount borrowed

     

    r = the monthly interest rate

     

    n = the number of months of the loan

     

    M = the monthly payment

     

    M = P(1+r)n r / [(1+r)n-1]

     

     

     

    Example 1: Customer borrow £1,000.00 at 18% annually for two years. monthly payment is.

     

     

     

    P= £1,000

     

    r = 1.5% per month

     

    n = 24 months

     

    Thus,

     

    M=1,000(1+.015)24(.015)/[(1+.015)24-1]= £49.92.Per Month


     

  • Profile Image
    JotForm Support

    Answered by ashwin_d on November 03, 2014 at 11:41 AM

    Hello sixtowns,

    This seems to be clear. 

    Let me check if that can be implemented within the form with the set of formula available.

    I will get back to you on this soon.

    Thank you!

  • Profile Image

    Answered by sixtowns on November 10, 2014 at 07:02 AM

    Hi, any updates on this?

  • Profile Image
    JotForm Support

    Answered by ashwin_d on November 10, 2014 at 08:33 AM

    Hello sixtowns,

    I am still trying to create this form but unable to complete the calculation. I am exploring the other possibilities on how to do the interest calculation within the "Form Calculation" widget.

    I will get back to you on this as soon as I am able to complete it.

    Thank you!