Loan Amortization Explained: How to Read and Create a Schedule

What Is Loan Amortization?

Loan amortization is the process of paying off a loan through regular payments that cover both principal and interest. In an amortizing loan, each payment is split between the two: a greater portion goes toward interest early in the loan term, and a greater portion goes toward principal later. This means the principal balance decreases slowly at first, then more quickly as the loan matures.

For a typical fixed-rate loan, the combined principal-and-interest payment stays the same for the entire loan term. What changes is the allocation: as the balance shrinks, the interest charged each month drops, leaving more of your payment to reduce the principal.

This structure is common for mortgages and auto loans, among other installment loans. Understanding amortization helps you see how much of each payment actually builds equity or ownership in what you financed.

Sources: Consumer Financial Protection Bureau

How to Read an Amortization Schedule

An amortization schedule is a table that shows each payment's allocation to principal and interest, along with the remaining loan balance over time. It typically lists the payment number, the payment amount, the interest portion, the principal portion, and the outstanding balance after each payment.

By scanning a schedule, you can see how much interest you'll pay in total, when the principal portion starts to exceed the interest portion, and how the balance declines month by month.

For example, on a $250,000 30-year mortgage at 5% annual interest, the first payment of $1,342.05 consists of $1,041.67 in interest and $300.38 in principal, leaving a balance of $249,699.62. Over time, the interest amount falls and the principal amount rises, but the total payment stays fixed.

Sources: LiteCalc, GraphCalc

Step-by-Step Example: Building an Amortization Table

You can build an amortization table by hand if you know the loan amount, interest rate, and term. Here's a simple process for a fixed-rate loan with monthly payments.

1. Determine the loan principal (PV), annual interest rate, and total number of payments (n). For a 30-year loan with monthly payments, n = 30 × 12 = 360.
2. Convert the annual interest rate to a monthly rate (r) by dividing by 12. For a 5% annual rate, r = 0.05 / 12 = 0.0041667.
3. Calculate the monthly payment (P) using the formula: P = [r * PV] / [1 - (1 + r)^-n]. For a $250,000 loan at 5% over 30 years, P = [0.0041667 * 250000] / [1 - (1.0041667)^-360] ≈ $1,342.05.
4. For each period, calculate the interest portion as the current balance times the monthly rate.
5. Subtract the interest from the payment to find the principal portion. In the first payment, principal = $1,342.05 − $1,041.67 = $300.38.
6. Subtract the principal portion from the current balance to get the new balance. After the first payment, the balance is $250,000 − $300.38 = $249,699.62.
7. Repeat the interest, principal, and balance calculations for each subsequent payment until the balance reaches zero.

Sources: LiteCalc, GraphCalc

How Extra Payments Change the Schedule

Making extra principal payments can reduce the total interest you pay and shorten the loan term. When you pay extra toward the principal, the loan balance drops faster, which means less interest is charged in subsequent months.

The effect is especially noticeable in the early years of a loan, when interest makes up a large portion of each payment. By reducing the principal sooner, you cut the interest that would have accrued on that amount for the rest of the loan.

You can see the impact by recalculating the schedule with a lower starting balance or by adding a one-time extra payment in the table.

Sources: GraphCalc, TransUnion

Interest Calculation Methods and Your Loan

The standard amortization formula and examples in this guide assume interest is calculated on the current principal balance each month, which is the common method for fixed-rate loans. However, some loans may calculate interest differently. For example, simple-interest loans may accrue interest daily on the unpaid principal, which can affect the payment allocation if you pay early or late.

Because interest calculation methods can vary, it is important to confirm with your lender how interest is calculated for your specific loan. Your lender can also provide an amortization schedule that reflects your loan's terms and interest method.

Sources: Consumer Financial Protection Bureau

Special Cases: Balloon Loans and Negative Amortization

Not all loans follow standard amortization. A balloon loan has a shorter term, but the monthly payments are calculated as if the loan would last longer, resulting in a large final payment of the remaining balance. This final balloon payment can be much larger than the regular payments.

Negative amortization occurs when a borrower makes payments that do not cover the interest due. The unpaid interest is added to the principal balance, increasing the amount owed instead of decreasing it. This can happen with certain payment-option loans or when payments are capped at a level below the full interest amount.

Both types of loans carry risks. Balloon loans require you to pay off or refinance the large balance at the end, and negative amortization can leave you owing more than you borrowed. Always check the loan terms carefully.

Sources: Consumer Financial Protection Bureau