Free Printable Amortization Table

Allison Martin
Loan amortization

An amortization table lets you see what your loan payments will be each month for the life of your loan and also gives you a preview of the outstanding loan balance at each point. Use the calculator below to generate a simple amortization table that you can print.

Generating an Amortization Table

Follow the steps listed below to generate a printable amortization table based on details of your loan.

  1. Enter the total amount financed.

  2. Enter the interest rate.

  3. Enter the loan term in years.

  4. Enter the month in which the loan will start. You can input the name or number of the month (i.e. January or "1").

  5. Enter the four-digit year in which the loan will start.

  6. Select calculate.

  7. Print your results.

You will also have the option to reset the contents of the table and enter new values. This is particularly useful if you want to compare loans with different terms.

Interpreting the Outputs

Once the values are entered, the printable amortization table will display the following components:

  • Amount of the monthly payment

  • Total interest you will pay over the life of the loan

  • Total amount paid over the life of the loan.

This table will allow you to plug in an assortment of figures to help identify the best mortgage option for you. If you don't have any firm offers, but are searching for the most feasible loan terms, consider experimenting with the interest rate, payment term or total amount of the loan.

Additional Resources for Amortization Tables

The amortization table provided above is fairly basic, though you can find other tools to use if you are looking for a more sophisticated resource. For example, there are tools available that produce results in Excel or that are designed to create calculations based on things like adjustable rates, balloon notes or payment frequency. Options you may want to consider include:

  • Bankrate.com - This site includes a mortgage calculator that allows you to generate a printable amortization schedule and see the impact of making extra payments.

  • Calculators.org - This straight-forward amortization calculator includes line items for standard loan terms, along with a line to specify the payment frequency (i.e. bi-weekly, monthly, quarterly).

  • MyAmortizationChart.com - This simple site consists of amortization charts. You can get yours by inputting your information in the calculator, and you also have the option to view average interest rates by zip code.

  • RealData.com - This site is operated by a manufacturer of real estate software. It is a very simple three-column table for fixed-rate loans only.

  • MortgageMavin.com - This is one of the few sites that lets you print an amortization table for adjustable rate, graduated or balloon mortgages.

  • Microsoft Office Online - Stick to this site if you're looking to download an amortization table to Excel or another spreadsheet program. This sheet has the formulas already entered, so all you have to do is plug in your numbers and print.

Valuable Loan Information

Whether you're looking to compare loan offers, considering a refinance or have recently gotten a mortgage, you may benefit from reviewing amortization tables. They can help you understand the true cost of a home loan.

Free Printable Amortization Table