How to Read a Loan Amortization Table

Photo Courtesy: Ariel Skelley/Getty Images

If you want to keep up with loan payments, particularly when it comes to a fixed-interest loan, using an amortization table can be incredibly helpful. Not only can a loan amortization table help you keep up with your monthly payments, but it’s also great for understanding your interest costs as the loan balance decreases. Not familiar with how an amortization table works? Don’t worry — we’ll walk you through how to make, read, and use one.

What Is an Amortized Loan?

An amortized loan is a type of loan with scheduled payments that go toward paying off both the loan’s principal amount and interest. Most types of loans that you pay back on a monthly basis tend to be amortized loans — think auto, home equity, and personal loans. Another great example of this type of loan structure is a fixed-rate mortgage.

Photo Courtesy: krisanapong detraphiphat/Getty Images

When you make monthly payments on an amortized loan, part of your payment goes to paying off interest, while the rest goes towards paying off your principal. An amortization table is a handy way to calculate how much of your monthly payment is going to each category, especially since this ratio will change as your total balance decreases.

The average amortization table calculates several things, including:

  • Monthly Balance: This column keeps a record of your total remaining balance.
  • Monthly Payment: If you have a fixed-rate loan, this column will likely include the same payment amount each month. Once you make your payment, you’ll be able to subtract it from the monthly balance.
  • Interest Paid: This is where you’ll see how much of your monthly payment is going toward the interest. In order to find this figure, multiply your remaining loan balance by your monthly interest rate.
  • Principle Paid: Once you figure out how much of your payment went toward paying off interest, subtract that number from the entire payment you made. The remaining money will be the amount that went toward your principal.
  • Remaining Balance: This is the new monthly balance you’ll start with for the next month’s payment. In other words, subtract your payment from the old monthly balance to find the new remaining balance.

When you first start making payments, you’ll notice that your interest costs are at their highest. As you make more payments, however, there will be less and less principal to charge interest on. In turn, you’ll notice that a little more of your payment will go toward paying off your principal.

How Do You Make a Loan Amortization Table?

Making your own amortization chart using Microsoft Excel, or even using an Excel loan payment template, can be a great, firsthand way to see how it all works. There’s even a free website called that’s able to do the math for you, so long as you input your loan type, amount, interest rate, and term.

Photo Courtesy: Maggie Winslow/Getty Images

In addition to helping you look ahead to future payments, an amortization chart can come in handy before you even take out a loan. For example, while it may initially seem like making the lowest possible payment every month is the way to go, a loan amortization calculator may tell a different story. That is, in some cases, by paying less each month — or selecting a longer repayment term — you may end up paying far more interest in the long run.

So, before settling on repayment terms, try running a couple of options through an amortization table to see what will yield the best rate overall. This strategy can also help you decide whether refinancing a loan or, if possible, paying it off early is the way to go.

Loans That Do and Don’t Work With an Amortization Chart

As helpful as an amortization loan chart can be, it can not be used in conjunction with every type of loan. That is, these tables only work when forecasting installment loans or fixed-rate loans that allow you to pay down the balance over time.

Photo Courtesy: seksan Mongkhonkhamsao/Getty Images

Loans that will not fit into an amortization table include the following:

Interest-Only Loans: Most mortgages are amortized loans, but others work in different ways. Interest-only loans, for instance, only require you to pay the interest on the loan for a certain amount of time. This is great during the initial period when just the interest is due, as it results in much lower payments. What you have to keep in mind, however, is that you’re not paying off your principal at all during that time. Eventually, the interest-only period will come to an end and you’ll be expected to either pay off the loan completely or start making much higher payments that cover both the principal and interest.

Balloon Loans: Balloon loans are similar to interest-only loans in that they’re fun while they last. This is the kind of loan you’ll only want to take out if you’re expecting a huge payment at some point in the future. The monthly payments for balloon loans start out pretty small, but then, at some point, you’ll be expected to either pay off the loan completely in a lump sum or refinance it, which isn’t always a stable option. For example, many people lost their homes in the mortgage crisis of 2008 by counting on the refinancing option.

Revolving Debt: Revolving debt is the type you go into when you use credit cards. Because you get to choose how much you borrow and pay back each month, the principal isn’t always likely to stay the same, even if the interest rate does. The only time you’d be able to use an amortization table to pay off this type of debt would be if you decided to no longer use the credit card anymore and dedicated yourself to just paying it off. Even then, however, it would only work if your interest rate never changed.