1. Money
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, including information about:

  • Your monthly payment
  • How much of your loan gets paid off each month
  • How much of your monthly payment goes to interest each month
  • How much you'll owe on your loan at any point in time
The loan amortization calculator includes an amortization table for your reference.

For more details on the results of your calculation, read How Amortization Works. If you want to dig into the numbers even more deeply, find out Calculate Loans on Your Own.

Instructions

Fill in the required information related to your loan, and click the Calculate button. A table will appear below the loan amortization calculator with the information described above.

You may want to plug the loan amortization calculator's output into Excel or another spreadsheet program so that you can work with the numbers even further (for example, you might calculate how much interest you'll pay over the first 10 months of your loan). The best way to do this is to select the data starting outside (above, for example) of the table. Or, use a pre-built Excel loan calculator template.

The loan amortization calculator can be used for your auto loans, home loans, or any other straight-line amortized loans. It does not work with credit card loans or other revolving loans.


Loan Amount: $

Interest Rate in decimal format (6.25% = .0625. See How to Convert Percentages):
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.
You can opt-out at any time. Please refer to our privacy policy for contact information.

©2014 About.com. All rights reserved.