Bob476 Posted May 14, 2003 Posted May 14, 2003 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 Posted May 14, 2003 Posted May 14, 2003 Take a look at the "financial functions" available when creating a calculation. Pete
Peter Fenner Posted May 14, 2003 Posted May 14, 2003 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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now