PDA

View Full Version : FORMULA for a LOAN



OneStiffRod
03-21-2003, 08:25 PM
I need to know how to calculate loan payments...

like if i borrow $100,000 at 6.5% APR for 15years- what is my per month charge? - I need to know the math formula or just some code since I need to do this via PHP or Javascript...

It seems like a simple problem but I get stuck on this... I've seen some payment forms in javascript and they use loops that are complicated to understand...

I need to know how much I will pay in total after 15years or whatever payment period lasts and I need to know the monthly bill...

Remember, I think that the APR is calculated on the principal owed so as you pay the principal is reduced and tapers off --

I don't want 100,000 * (1.065^15), that's not how loans work...

alpha
03-21-2003, 11:35 PM
the formula for monthly payments is:


A
-------------------
(1 - (1 + I) ^ -N
-------------------
I

the numerator is A, and the denominator is below everything below A.

or


A / ((1 - (1 + I) ^ ( -N)) / I)
This is coming from my calculator, so readability is a bit tedious.

A is the loan amount.
I is the interest rate in decimal form divided by 12 (for monthly), i.e. .065 / 12 for 6.5%.
N is the number of months, i.e. 360 months for 30 yrs.

and yes, that is a negative N, just incase it is a bit small to read.

for total amount including interest, just multiply monthly payments by number of months.

edited for correctness of I.

OneStiffRod
03-22-2003, 01:40 AM
Thank you very much sir!!!

alpha
03-22-2003, 10:14 AM
You're welcome.