Loan Amortization Explained: How to Build and Use a Schedule

What Is Amortization?

Amortization is the process of paying off a loan through scheduled, regular payments. In a typical amortizing loan, a portion of each payment goes toward the interest that has accrued on the outstanding balance, and the remaining amount reduces the principal. Early in the loan term, a larger share of each payment covers interest, while later payments are mostly principal.

An amortization schedule is a table that shows, for each payment period, the payment amount, the interest portion, the principal portion, and the remaining balance after that payment. Lenders and borrowers use this schedule to track how the loan balance decreases over time.

Sources: Consumer Financial Protection Bureau, TransUnion

The Amortization Formula

For a fixed-rate loan, the monthly payment can be calculated using a standard formula. Let P be the principal (the initial loan amount), r the monthly interest rate (annual rate divided by 12), and n the total number of monthly payments. The monthly payment M is: M = P × [r(1+r)^n] / [(1+r)^n - 1].

For example, a $200,000 loan at 4% annual interest with a 30-year term (360 payments) has a monthly rate of 0.04/12 = 0.003333.

To find the interest for a specific period, multiply the current loan balance by the monthly interest rate. The principal portion of a payment is then the total payment minus the interest for that period.

Sources: TransUnion, Wells Fargo

Reading an Amortization Schedule

An amortization schedule lists every payment in sequence. For each row, you typically see the payment number, the scheduled payment, the interest paid, the principal paid, and the remaining balance after the payment. Early rows show high interest and low principal; later rows reverse that pattern.

For a fixed-rate loan with a constant payment, the monthly payment stays the same, but the interest portion decreases and the principal portion increases as the balance is paid down. The schedule makes it easy to see how much of your payment is really going toward reducing the debt versus covering interest.

Amortization schedules generally work only for fixed-rate loans, not for adjustable-rate mortgages, variable-rate loans, or lines of credit, because those payment amounts can change with rate adjustments.

Sources: Consumer Financial Protection Bureau, TransUnion, Wells Fargo

Creating a Schedule in a Spreadsheet

You can build an amortization schedule in a spreadsheet with just a few formulas. The key is to use functions for the periodic payment, the interest portion, and the principal portion.

In Excel, the PMT function calculates the fixed payment, IPMT returns the interest part of a payment for a given period, and PPMT returns the principal part. You would set up columns for the period, beginning balance, payment, interest, principal, and ending balance, then fill the rows down for each payment period.

• Use PMT(rate, nper, pv) to get the monthly payment, where rate is the monthly interest rate, nper is the total number of payments, and pv is the loan amount.
• Use IPMT(rate, per, nper, pv) to get the interest for a specific period (per).
• Use PPMT(rate, per, nper, pv) to get the principal paid in that period.
• For each period, the ending balance is the beginning balance minus the principal payment.
• You can copy the formulas down for every payment period to generate the full schedule.

Sources: Wells Fargo

Extra Payments on the Schedule

Making an extra payment toward the principal can have a significant effect on your loan. Any extra amount is applied directly to the principal, reducing the balance immediately. That lower balance reduces the interest calculated in future periods, which can save you money and shorten the loan term.

For example, on a $200,000, 30-year mortgage at 4% interest, paying an extra $100 each month could shorten the loan term by more than 4.5 years and reduce total interest paid by more than $26,500.

A biweekly payment plan is another approach. Instead of paying $955 once a month, you pay half of that ($477.50) every two weeks. Over a year, that is 26 half-payments, which equals 13 full monthly payments—one extra payment per year. For the example loan above, this could shorten the term by more than 4 years and reduce interest paid by more than $22,000.

Keep in mind these figures are examples based on specific loan terms; your actual savings depend on your loan balance, interest rate, and how your lender applies extra payments.

Sources: Wells Fargo, TransUnion, Total Mortgage

Using Schedules for Financial Planning

An amortization schedule is a practical planning tool. It shows you exactly when your loan will be paid off, how much interest you will pay over the life of the loan, and how extra payments change that picture.

When you make an extra payment, be sure your lender applies it to the principal, not to prepaid interest or other fees. You can track your progress by updating the schedule with your actual payments.

Sources: Wells Fargo, Total Mortgage, TransUnion

Amortization for Fixed vs. Adjustable Rate Loans

Amortization schedules are designed for fixed-rate loans, where the payment amount stays the same for the entire term. The formula and the schedule are straightforward because the interest rate does not change.

For adjustable-rate mortgages (ARMs) or other variable-rate loans, the monthly payment can change when the interest rate adjusts. The standard amortization schedule no longer applies because future payments depend on future rates, which are unknown. The same is true for lines of credit, where you may be able to borrow again as you pay down the balance.

Sources: TransUnion