Banking / Loans

  1. Home
  2. Business & Finance
  3. Banking / Loans
Loan Amortization Calculator
A Loan Amortization Calculator For Any Purpose

The loan amortization calculator is intended to show you how your loan will work month-by-month. You'll get an idea of how much interest you pay over the years, and how much of your balance is paid off at any given time.

The loan amortization calculator includes an amortization table for your reference. After filling in information related to your loan, click the Calculate button. A table will appear in the textbox below the loan amortization calculator.

You may want to plug the loan amortization calculator's output into Excel so that you can work with the numbers even further. The best way to do this is to select the data starting outside (above, for example) of the table.

The loan amortization calculator can be used for your auto loans, home loans, or any other straight-line amortized loans.


Loan Amount: $

Interest Rate(.00 format, .0625 = 6.25%):
Length of loan, in years:
Start Date of Loan (month number "MM" and year "YYYY")
Loan Amount $
Down Payment $
Monthly Payment $
# of years
Month/Year Interest Principal Remaining Bal


Are you borrowing too much?

Thanks to javascript.internet.com for providing sample templates for the loan amortization calculator. Note that the final payment period may not add up properly due to rounding.

Explore Banking / Loans

About.com Special Features

Banking / Loans

  1. Home
  2. Business & Finance
  3. Banking / Loans

©2009 About.com, a part of The New York Times Company.

All rights reserved.