Loan Amortization Explained: How Payments Are Split Over Time

What is amortization?

Amortization is the process of paying off a loan with regular payments over time, so that the amount you owe decreases with each payment. It's built into many fixed-rate loans, including mortgages, auto loans, personal loans, and student loans. In a fixed-rate loan, the combined principal and interest payment does not change over the life of the loan, but the amounts going to principal and interest do change.

Lenders use a standard formula to calculate a payment that ensures the loan is fully paid off at the end of the term. The formula accounts for the loan amount (the principal), the monthly interest rate (annual rate divided by 12), and the total number of payments. Because the payment is set at a level that covers both interest and some principal from the start, the loan balance declines predictably over time.

Not all loans follow an amortization schedule. Interest-only loans, balloon loans, adjustable-rate mortgages, and credit cards are common examples of non-amortizing or differently-structured debt. Credit cards, for instance, typically require a minimum payment that may only cover interest, so balances can persist for years.

Sources: Consumer Financial Protection Bureau, Calculator.net, Rocket Mortgage

How an amortization schedule works

An amortization schedule is a table that details each periodic payment, showing the split between interest and principal and the remaining balance after each payment. A typical schedule includes columns for the payment number, the payment amount, the interest portion, the principal portion, and the ending balance. Some schedules also show the cumulative interest paid.

For a fixed-rate loan, the payment stays the same each period. But because interest is calculated on the current balance, the interest portion is highest in the first payment and decreases over time. As the balance drops, the principal portion grows, so the loan is paid off faster in the later years.

The fixed monthly payment is calculated using the formula M = P * [r(1+r)^n] / [(1+r)^n - 1], where P is the principal, r is the monthly interest rate (annual rate divided by 12), and n is the total number of payments. To create a schedule, you compute the interest for each period by multiplying the remaining balance by the monthly rate, subtract that interest from the fixed payment to get the principal portion, and then subtract the principal portion from the balance.

• Payment number or date
• Beginning balance
• Scheduled payment amount
• Interest payment portion
• Principal payment portion
• Ending balance
• Cumulative interest (in some schedules)

Sources: TransUnion, Calculator.net, Bankrate

Sample amortization table

To see how a schedule works in practice, consider a $300,000 loan at 6.5% interest over 30 years. Over the life of the loan, the interest portion declines and the principal portion rises. The table below shows the first three payments and the final payment.

Note that the payment amount includes only principal and interest. Many mortgage payments also include property taxes and insurance, which are separate and not part of the amortization schedule.

Sources: TransUnion

Why early payments are interest-heavy

Early in a loan term, a larger portion of each payment goes toward interest because the outstanding balance is high. Interest is calculated on the remaining principal, so the interest charge is greatest at the start. Over time, as the balance decreases, the interest portion shrinks and more of each payment goes toward principal.

This is a natural effect of amortization, not a penalty. It means that building equity in the early years is slow, but the pace accelerates as the balance drops. For a 30-year fixed-rate mortgage, the principal repayment pattern is front-loaded with interest, and the loan is designed to be fully paid off by the final payment.

Sources: Wells Fargo, Calculator.net, Bankrate

How extra payments affect your amortization

Another approach is the bi-weekly payment plan, which involves making 26 half-payments per year. That effectively makes one extra monthly payment per year, which can pay off the loan early, but it may involve fees. Check with your lender for availability and any charges.

Sources: Consumer Financial Protection Bureau, Wells Fargo, Total Mortgage

How to create your own schedule

You can create your own amortization schedule in a spreadsheet if you know the loan amount, interest rate, and term. The key steps are: calculate the monthly interest rate by dividing the annual rate by 12; determine the fixed monthly payment using the formula or a built-in function; then, for each period, compute the interest by multiplying the current balance by the monthly rate, subtract that from the payment to get the principal, and update the balance. Repeat until the balance reaches zero.

To set up a spreadsheet, create columns for Payment Number, Beginning Balance, Payment, Interest, Principal, and Ending Balance. Use the PMT function to calculate the payment. For each row, calculate the interest with the formula: Interest = Beginning Balance * (Annual Interest Rate / 12). Then, principal = Payment - Interest, and ending balance = Beginning Balance - Principal. Copy the formulas down for the number of payments.

• Step 1: Set up columns for payment number, beginning balance, payment, interest, principal, and ending balance.
• Step 2: Enter the fixed monthly payment using the PMT function or the formula.
• Step 3: For each row, calculate interest = beginning balance * (annual rate / 12), principal = payment - interest, and ending balance = beginning balance - principal.
• Step 4: Copy the formulas down for the full loan term.

Sources: Bankrate, Calculator.net, Wells Fargo

Amortization for different loan types

Standard amortization is common for fixed-rate mortgages, auto loans, personal loans, and student loans. These loans typically use a monthly compounding fixed rate, which means the interest is calculated each month on the outstanding balance, and the payment is set to repay the loan over the term.

Not all loans follow this pattern. Interest-only loans, for example, allow you to pay only interest for a set period, so the balance does not decrease during that phase. Balloon loans have a standard payment for a short term, but a large balloon payment is due at the end. For a $100,000 loan at 4% over 30 years, the monthly principal and interest payment is $477; a 5-year balloon loan with the same interest rate would have a monthly payment of $477 but a balloon payment of $90,448 at the end. Adjustable-rate mortgages can also have schedules that change when the rate adjusts, and they are not considered standard amortized loans.

Credit cards and home equity lines of credit (HELOCs) are not amortized loans. They typically require a minimum payment that may only cover interest, so the balance can persist or even grow if only minimums are paid. Negative amortization occurs when the payment is less than the interest due, causing the loan balance to grow. This can happen with certain loan products, such as some option ARM plans, and it is something to watch for in loan agreements.

Sources: Rocket Mortgage, Calculator.net, Consumer Financial Protection Bureau