Calculations for amortization

[G]

I am setting up a database for loans. Does anyone know
where I can find the calculations for loan amortization to
use in my coding?

Thank you,

G

 

[Van T. Dinh]

P = A * (1+r/12)^n * (r/12) / ((1+r/12)r^n-1)

P=monthly payment,
A=Loan Amount,
r=annual interest rate (as a decimal),
n=number of payments to pay off the loan.

 

[Tom Wickerath]

Have you tried googling for amortization formulas?

http://www.google.com/search?hl=en&lr=&ie=UTF-8&q=amortization+formulas


Tom
____________________________________________


I am setting up a database for loans. Does anyone know
where I can find the calculations for loan amortization to
use in my coding?

Thank you,

G

 

[G]

Thank you Van. I appreciate your assistance greatly!

G

 

[G]

Tom,
I searched but didn't find what I needed. I kept finding
calculators, but not calculations.
Thank you for the url.

G

 

[Tom Wickerath]

Well, the 2nd hit in this search leads to a Quicken page, where they show an amortization
formula:

http://www.intuit.com/support/quicken/2004/win/1133.html

Similarly, the 6th link titled "3.6 Amortization Tables"
(http://gs.fanshawec.ca/tlc/math270/3_6_amortization_schedules.htm) includes a formula to
calculate the monthly payment amount on a loan. Have you checked out the Help file in Excel? I
believe they pretty much show all the formulas for the built-in functions, including financial
calculations.

I can find all kinds of pages that offer calculations for loan amortization using this google
search, including:
http://www.calcexpress.com/how_to_create_a_mortgage_calculator.html


I'm not sure why you could only find calculators....


Tom
______________________________________________


Tom,
I searched but didn't find what I needed. I kept finding calculators, but not calculations.

Thank you for the url.

G

______________________________________________



Have you tried googling for amortization formulas?

http://www.google.com/search?hl=en&lr=&ie=UTF-8&q=amortization+formulas


Tom
____________________________________________


I am setting up a database for loans. Does anyone know where I can find the calculations for loan
amortization to use in my coding?

Thank you,

G