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
You use the Math.pow method for the exponentiation of a number.
How to do (not so simple) form calculations by Thom Parker.