Friday, April 21, 2006

Amortization in Google

If you didn't know this...the Google search bar is also a calculator...and pretty good one I might add.

Here's an example amortization formula you can cut & paste into Google's search bar to obtain the loan's monthly payment amount:
20000 * ((6 / (12 * 100) / (1 - (1 + (6 / (12 * 100))) ^ -(5*12))))This will return a monthly payment of 386.656031 that corresponds to a $20,000.00 loan at 6% interest for 5 years in length.

To get a better understanding of the loan amortization payment formula...see below:
i = interest rate ex. 6 for 6%
n = number of years ex. 5 for 5 years
p = loan amount ex. 20000 for a $20,000 car loan
m = monthly payment
m = p * ((i / (12 * 100) / (1 - (1 + (i / (12 * 100))) ^ -(n*12))))

A big thanks to Hugh Chou for kindly supplying the amortization formula on his site. Please check out his site for further information regarding amortization formulas.

MT

No comments: