Ever wonder how to calculate a monthly payment without using a spreadsheet software such as MS Excel?

Well below is the formula:

• P = principal, the initial amount of the loan
• I = the annual interest rate (from 1 to 100 percent)
• L = length, the length (in years) of the loan, or at least the length over which the loan is amortized.

The following assumes a typical conventional loan where the interest is compounded monthly. First I will define two more variables to make the calculations easier:

• J = monthly interest in decimal form = I / (12 x 100)
• N = number of months over which loan is amortized = L x 12

Okay now for the big monthly payment (M) formula, it is:

`                              J         M  =  P  x ------------------------                      1  - ( 1 + J ) ^ -N   where 1 is the number one (it does not appear too clearly on some browsers)`

Pretty complicated huh?

Well I whipped up a little webpage script to do it all for you if you enter in your 3 main variables (Amount, Years financed, and Interest Rate). I wanted it to use for my blackberry, so it is very mobile-focused. (Read as nothing fancy, but it is fast loading)

Monthly Payment Calculator

Thanks goes to Karl for the above formula.

Technorati Tags: , , , , ,