1 Reply Latest reply on Nov 5, 2012 9:28 AM by gkaiseril

    Loan Calculator

    TANDOG122

      I need help converting EXCEL to javascript for a form.

       

      In the form you will have one input field.  "The loan amount"

       

      Then you'll have 12 fields that show the pay amounts per month with the interest compounding monthly.

       

      In EXCEL the first of the 12 fields equation is =(C1*(1+0.04)^1)

      In EXCEL the 2nd of the 12 fields equation is =(C1*(1+0.04)^2)

       

      and so on. 

       

      Can anyone help