Printable Amortization Table and Calculator

Use the tool below to generate a printable amortization schedule for your home or auto loan. Simply enter the principal (amount borrowed), the length of the loan in months (number of years times 12), the interest rate as a decimal (percent divided by 100), then hit the "Create Table" button. A new window will appear with a printable amortization table that also includes the amount of your monthly payments.



Principal = $
Number of Months = 
Interest Rate (Decimal) = 
  


Example:

Sam borrows $120,000 for 20 years at an annual rate of 5.5%.

In the form above, he enters 120000 for the principal. Since 20 times 12 = 240, he enters 240 as the number of months. And since 5.5 divided by 100 = 0.055, he enters 0.055 as the interest rate.

When he hits the "Create Table" button, he can see that his montly payments are $687.89, as well as the full amortization schedule which breaks down each monthly payment into principal and interest. The last column shows the remaining principal balance due after each month.

At the beginning of the lending period, a larger portion of Sam's monthly payment goes toward the interest due on the loan rather than the principal. In this example, Sam will still owe half of the principal balance (about $60,000) after 128 months.



© Had2Know 2010

What is Amortization?

How to Calculate the Remaining Balance on a Home Mortgage

How Long Will It Take to Pay Off a Loan?

How Much Can I Afford to Borrow?

How Much Will I Save by Refinancing?

When will I have paid or owe $X on my mortgage?

What loan period length will minimize the total interest paid?