Yes, free mortgage amortization tables are widely available online and in spreadsheet software, and you can also build one yourself with a simple formula. These tables show each monthly payment split into interest and principal, plus the remaining balance after every payment, for the full life of the loan. Below is a calculator that generates the key numbers, followed by a full explanation of how amortization works, how to read a table, and where to find free versions.
Formula
The monthly payment for a fixed-rate mortgage is calculated with the standard amortization formula:
M = P × [ r(1 + r)^n ] / [ (1 + r)^n – 1 ]
- M = monthly payment (in dollars)
- P = principal loan amount (in dollars)
- r = monthly interest rate = annual rate (APR) divided by 12, expressed as a decimal (e.g., 8% APR → 0.08/12 = 0.0066667)
- n = total number of payments = loan term in years × 12
For each payment period, the interest portion is interest = current balance × r. The principal portion is principal = M – interest. The new balance is balance = previous balance – principal. Repeating this for every period produces the full amortization table.
Worked Example
Using the calculator defaults: loan amount $20,000, APR 8%, term 5 years.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Total payments: n = 5 × 12 = 60
- Compute (1 + r)^n = (1.0066667)^60 ≈ 1.4898457
- Monthly payment: M = 20000 × [0.0066667 × 1.4898457] / [1.4898457 – 1] = 20000 × 0.0099336 / 0.4898457 ≈ 405.53
- Total paid: 405.53 × 60 = $24,331.80
- Total interest: 24,331.80 – 20,000 = $4,331.80
The calculator shows a monthly payment of $405.53 and total interest of $4,331.80, matching the manual calculation.
Assumptions
- Fixed interest rate for the entire term.
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at APR / 12.
- No fees, taxes, insurance, PMI, or escrow are included.
- The payment is rounded to the cent, and the total interest uses that rounded payment.
What an Amortization Table Shows
A full amortization table is a row-by-row breakdown of every payment. Each row typically contains:
- Payment number (1 to n)
- Payment amount (constant for a fixed-rate loan)
- Interest portion (largest in early months, decreasing over time)
- Principal portion (smallest in early months, increasing over time)
- Remaining balance after that payment
For example, in the first month of the $20,000 loan at 8% for 5 years, the interest is 20000 × 0.0066667 = $133.33, so the principal portion is 405.53 – 133.33 = $272.20, leaving a balance of $19,727.80. By the 60th payment, the interest is only about $2.68 and the principal is $402.85, paying off the loan completely.
Where to Find Free Amortization Tables
You don’t need to buy software or pay for a website. Several reliable free sources exist:
- Spreadsheet templates – Excel, Google Sheets, and LibreOffice have built-in amortization templates. You can also create one using the PMT function (e.g.,
=PMT(rate, nper, pv)) and then fill down the interest and principal formulas. - Online calculators – Many finance websites offer free amortization calculators that display a full schedule. Look for ones that let you download or print the table.
- Bank and credit union websites – Many lenders provide free amortization calculators, even for non-customers. (We do not endorse any specific institution.)
- Government and non-profit sites – Some consumer education sites offer printable amortization schedules.
When using any free tool, verify that it uses the standard formula and that the payment matches your own calculation (as in the worked example).
How to Build Your Own Table
If you prefer to create your own table, follow these steps in any spreadsheet:
- Enter loan amount, APR, and term in separate cells.
- Calculate monthly rate = APR/12 and number of payments = term × 12.
- Use the PMT function to get the monthly payment (or type the formula manually).
- Create columns: Payment #, Payment, Interest, Principal, Balance.
- For each row: Interest = previous balance × monthly rate; Principal = payment – interest; New balance = previous balance – principal.
- Copy the formulas down for all n rows.
This method gives you full control and lets you add extra columns for extra payments or a payoff date.
Common Mistakes and Misconceptions
- Using the annual rate instead of monthly – Always divide APR by 12. Using 8% instead of 0.6667% will massively overstate the payment.
- Ignoring rounding – The payment is rounded to cents; the final balance may be a few cents off if you don’t adjust the last payment.
- Thinking the interest is simple interest – Mortgage amortization uses compound interest monthly, not simple interest on the original principal.
- Believing the payment is half interest, half principal – Early payments are mostly interest; the split changes over time.
- Confusing APR with the note rate – APR includes some fees, but the amortization table typically uses the note rate for the payment calculation.
How to Use an Amortization Table
An amortization table helps you see the real cost of a loan and plan ahead. You can use it to:
- See how much interest you pay each month and over the life of the loan.
- Determine your remaining balance at any point (useful if you plan to sell or refinance).
- Calculate the effect of extra payments – any extra amount goes directly to principal, reducing the balance faster and shortening the term.
- Compare different loan terms (e.g., 15-year vs. 30-year) by looking at total interest.
For example, if you pay an extra $50 per month on the $20,000 loan, the table would show the loan paid off in about 55 months instead of 60, saving roughly $300 in interest.
Limitations of Amortization Tables
Standard amortization tables assume a fixed rate and constant payments. They do not account for:
- Adjustable rates (ARM) – payments change when the rate changes.
- Biweekly payments – these effectively make an extra payment per year.
- Fees, taxes, insurance, or PMI – these are not part of the principal and interest.
- Prepayment penalties – some loans charge a fee for paying off early.
- Interest rate changes due to a rate cap or index.
If your loan has any of these features, the table will not be perfectly accurate, but it still gives a useful baseline.
Frequently Asked Questions
Can I get a free amortization table without downloading anything?
Yes, many websites offer free amortization calculators that display a full schedule right in your browser. You can also use Google Sheets’ built-in templates without installing software.
How do I calculate the total interest from an amortization table?
Add up all the interest column entries, or simply multiply the monthly payment by the number of payments and subtract the principal. For example, $405.53 × 60 = $24,331.80, minus $20,000 = $4,331.80.
Why is the interest portion so high in the first payment?
Because the balance is largest at the start. Interest is calculated on the current balance, so early payments have high interest and low principal. As the balance decreases, the interest portion shrinks.
Do amortization tables work for adjustable-rate mortgages?
No, not directly. An ARM has a rate that changes, so the payment changes. You would need to recalculate the table each time the rate adjusts, using the new rate and remaining balance.
Can I use an amortization table to plan extra payments?
Yes. If you add an extra amount to your payment, mark it as principal. The balance drops faster, and you can see how many payments you skip at the end. Many online calculators let you input extra payments and show the updated schedule.
Is the amortization table the same as the lender’s statement?
Generally yes, if the loan is fixed-rate and you make payments on time. However, the lender may include escrow (taxes and insurance) in your actual payment, which is not shown in the table. Also, rounding differences can cause a few cents of variance.
Remember, any amortization table is an estimate based on the inputs you provide. Your lender’s official disclosure will show the exact figures for your specific loan.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- JS Bank Credit Card: Features & How to Apply$405.53
- JD Gift Card Balance: How to Check It$60.00
- JD Bank Credit Card: How It Works & What to Know$405.53
- In-N-Out Gift Card Balance: Check & Use Guide$30.00
- JCPenney Credit Card Balance: How to Check It27 months
- Houston Metro Q Card Balance: Check & Add Funds$35.00