Calculating accruing interest/monthly payment

[Bob476]

OK, not sure how to do this, but here's what I need. I have the following fields:

BALANCE

INTERESTRATE

MONTHSTOPAY

So if I have a balance of 2000, interest rate is 9% and monthstopay is 6, what field calculation do I need in order to calculate the resulting monthly payments and/or the total payment, assuming all payments are made on time?

[Peter Fenner]

Take a look at the "financial functions" available when creating a calculation.

Pete

[Peter Fenner]

Ok, I was being lazy.

The monthly payment is:

PMT (balance, interest rate/12, months to pay)

The total payment is the above result * months to pay.

Pete

[Bob476]

Thanks! That was quick!!