Calculations for amortization

G

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
 
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
 
T

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
 
Top