How to Read an Amortization Schedule: A Step-by-Step Guide

What Is an Amortization Schedule?

An amortization schedule is a table that shows the amount of each loan payment applied to principal and interest over the life of the loan. For a fixed-rate loan, the monthly payment stays the same, but the portion that goes to interest versus principal changes each month.

In an amortizing loan, the consumer pays a fixed monthly payment, but a greater percentage is applied to interest early in the loan and a greater percentage to principal toward the end. The principal balance decreases slowly at first, then more quickly closer to the end of the loan term. This is why the schedule is a useful tool for understanding how your loan is paid down.

• The schedule lists each payment period, typically monthly.
• It tracks the interest and principal portions of each payment.
• It shows the remaining loan balance after each payment.

Sources: Consumer Financial Protection Bureau, Investopedia

Reading the Columns: Payment, Principal, Interest, Balance

A typical amortization schedule has columns for payment number, payment amount, interest, principal, and remaining balance. Although the exact labels may vary, the information is consistent.

The payment number shows which payment you are making. The payment amount is the total you pay each period, which is fixed for a fixed-rate amortized loan. The interest column shows how much of that payment goes to interest, and the principal column shows how much reduces your loan balance. The balance column shows what you still owe after each payment.

• Payment number: The sequence of payments, starting at 1.
• Payment amount: The total due each period, unchanged for a fixed-rate loan.
• Interest: The cost of borrowing, calculated on your remaining balance.
• Principal: The portion that reduces your balance.
• Balance: The remaining amount you owe after the payment.

Sources: Investopedia, Amortization-calc.com

How Interest and Principal Change Over Time

In a typical fixed-rate mortgage, the combined principal and interest payment does not change over the life of the loan, but the amounts going to principal and interest change over time. The interest portion of each payment is calculated by multiplying the remaining loan balance by the periodic interest rate.

As the loan balance decreases, the interest portion of each payment decreases and the principal portion increases. For example, in the first month, your interest is high because the balance is high; later, the balance is low, so interest is low and more of your payment goes to principal.

• Interest is calculated on the remaining balance, not the original loan amount.
• Early payments are mostly interest; later payments are mostly principal.
• The total payment remains the same for a fixed-rate loan, so the split shifts over time.

Sources: Consumer Financial Protection Bureau, Investopedia

Using the Schedule to Plan Extra Payments

An amortization schedule can help you see the effect of an extra payment. When you make an extra payment, it typically goes directly to the principal, reducing the balance. This can shorten the loan term and reduce total interest paid, as fewer future interest charges accrue.

To plan, look at the balance column for the month you expect to make an extra payment. If you pay an additional amount, your balance will drop by that amount. The next month's interest will be recalculated on the lower balance, and the schedule may be adjusted by the lender.

• Extra payments reduce your principal balance directly.
• A lower balance leads to less interest charged in future periods.
• You can use the schedule to compare total interest with and without extra payments.

Sources: Consumer Financial Protection Bureau, Investopedia

Using the Schedule for Tax and Equity Planning

An amortization schedule shows how much interest you pay each year, which may be relevant for tax planning. However, tax deductibility of mortgage interest varies by jurisdiction and individual circumstances. You should consult a tax professional for advice specific to your situation.

The schedule also helps you track your equity—the portion of your home you own outright. As you make payments, the principal portion reduces your balance, increasing your equity. By looking at the balance column, you can see your remaining debt and estimate your equity if you know your property's value.

• The interest column shows how much interest you pay each period, which can be useful for estimating potential tax effects.
• The principal column tracks how much debt you are paying off, which builds equity.
• This information can help you decide whether to make extra payments to build equity faster.

Sources: Consumer Financial Protection Bureau, Investopedia

Amortization Schedule Examples (15-year vs 30-year)

The length of a loan term has a major effect on the amortization schedule. Longer loan terms result in lower monthly payments but higher total interest paid over the life of the loan. Conversely, shorter terms have higher monthly payments but much lower total interest.

Consider a 30-year fixed-rate mortgage and a 15-year mortgage with the same interest rate and principal. The 30-year loan has a lower monthly payment, but because you pay interest for twice as long, the total interest is significantly higher. The 15-year loan builds equity faster because a larger share of each payment goes to principal.

• 30-year loan: Lower monthly payment, more total interest.
• 15-year loan: Higher monthly payment, less total interest, faster equity growth.
• The balance declines more quickly in a shorter-term loan once the principal portion increases.

Sources: Consumer Financial Protection Bureau

Obtaining Your Schedule from Lenders or Online

Your lender typically provides an amortization schedule when you take out a loan. For an existing loan, you can often request a copy or view it in your online account. Many lenders include the schedule in your monthly statement or provide a portal with your payment breakdown.

There are also many online amortization calculators that can generate a schedule based on your loan amount, interest rate, and term. These tools use the same standard formula to calculate payments and can help you plan for different scenarios.

• Check your lender's online portal or customer service for your schedule.
• Online tools require your loan amount, interest rate, and term to generate a schedule.
• You can also create your own using a spreadsheet and the amortization formula.

Sources: Investopedia, Amortization-calc.com

What Is an Amortization Table?

An amortization table is a detailed version of the schedule, providing the same information in a tabular format. It typically lists each payment row with columns for the payment number, payment amount, interest, principal, and balance.

The terms 'amortization schedule' and 'amortization table' are often used interchangeably. Some sources reserve 'table' for the full list of all payments, while a 'schedule' may refer to the same thing. In practice, both are comprehensive records of how a loan is paid off.

• An amortization table is a row-by-row listing of every payment.
• Each row shows the payment date, interest, principal, and balance.
• Tables are useful for reference and for tracking your loan over time.

Sources: Investopedia, Amortization-calc.com

Key columns

The key columns in an amortization table are payment number, payment amount, interest, principal, and balance. Understanding these columns is essential to using the table effectively.

The payment number is simply the sequential count of payments. The payment amount is the total due for that period, which is fixed for a fixed-rate loan. The interest column shows the interest charged for that period, calculated on the previous balance. The principal column shows how much of the payment reduces the loan balance. The balance column shows the remaining amount owed after that payment.

• Payment Number: Helps you locate a specific month or year.
• Payment Amount: The total payment, including interest and principal.
• Interest: The cost of borrowing for that period.
• Principal: The amount that reduces your debt.
• Balance: The outstanding loan amount after the payment.

Sources: Investopedia, Amortization-calc.com

Sample Amortization Table for a Mortgage

Let's consider a typical 30-year fixed-rate mortgage. The monthly payment is calculated using the standard amortization formula, and the table shows how the payment s split between interest and principal.

Sources: Consumer Financial Protection Bureau, Amortization-calc.com

Sample Amortization Table for an Auto Loan

For an auto loan, the amortization schedule works the same way, but the term is typically shorter.

Sources: Consumer Financial Protection Bureau, Investopedia

Sample Amortization Table for a Personal Loan

Personal loans also use amortization schedules. The schedule follows the same pattern, with early payments mostly interest and later payments mostly principal.

Sources: Investopedia, Amortization-calc.com

How to Create Your Own Amortization Table

You can create an amortization table using a spreadsheet program. The process involves calculating the monthly payment and then, for each period, computing the interest on the current balance, subtracting that from the payment to get the principal, and updating the balance.

To start, you need the loan amount, the annual interest rate, and the loan term. The monthly payment can be computed using the standard formula, then you can fill each row manually or with spreadsheet formulas.

1. Determine the loan principal, annual interest rate, and loan term in months.
2. Calculate the monthly rate by dividing the annual rate by 12.
3. Compute the monthly payment using the formula: M = P × [r(1+r)^n] / [(1+r)^n – 1], where M is the monthly payment, P is the principal, r is the monthly rate, and n is the number of payments.
4. For each payment period, calculate the interest on the current balance: interest = balance × monthly rate.
5. Subtract the interest from the monthly payment to get the principal portion.
6. Subtract the principal portion from the balance to get the new balance.

Sources: Investopedia, Amortization-calc.com

Common Mistakes When Reading Amortization Tables

One common mistake is confusing the nominal interest rate with the annual percentage rate (APR). The APR may include fees and other costs, so it can differ from the rate used to calculate your monthly payment. Always use the actual contract rate for your schedule.

Another mistake is assuming that the interest rate is applied to the original loan amount each month. In fact, interest is calculated on the remaining balance, which is why the interest portion changes over time.

Some borrowers forget to account for taxes and insurance in their total payment. The principal and interest column only covers the loan's amortization; your full payment may be higher if escrow is included.

• Use the correct interest rate (not APR) when reviewing your schedule.
• Remember that interest is on the remaining balance, not the original amount.
• Understand that your total payment may include escrow for taxes and insurance, which is not shown in the principal-and-interest breakdown.

Sources: Investopedia, Amortization-calc.com

Example Loan Parameters

This example is used in the sample mortgage amortization table above to illustrate the breakdown between principal and interest.

• Loan term: 30 years (360 payments)

Sources: Consumer Financial Protection Bureau, Amortization-calc.com

Monthly Payment Calculation

The monthly payment for a fixed-rate amortized loan 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, and n is the number of payments.

Sources: Investopedia, Amortization-calc.com

Full Amortization Schedule Table

A full amortization schedule contains 360 rows for a 30-year loan. It lists every payment from the first to the last, showing how the balance gradually decreases to zero. The table is too long to show entirely here, but the first 12 payments demonstrate the pattern.

Sources: Consumer Financial Protection Bureau, Amortization-calc.com

Explaining the First Few Payments

In the first few payments of any amortized loan, the interest portion is at its highest because the balance is largest.

This pattern continues, with interest decreasing and principal increasing each month.

Sources: Consumer Financial Protection Bureau, Amortization-calc.com

How to Verify a Schedule with a Spreadsheet

If you have created your own amortization schedule or received one from a lender, you can verify it using a spreadsheet. The key is to check that the interest for each period is calculated correctly as the previous balance times the periodic rate, and that the principal is the payment minus interest.

You can also verify that the final balance reaches zero after the last payment. If your spreadsheet uses the correct formula, the numbers will match a trusted schedule.

1. Enter the loan amount, annual interest rate, and term in months.
2. Compute the monthly payment using the amortization formula.
3. For each row, calculate interest = previous balance × monthly rate.
4. Calculate principal = monthly payment – interest.
5. New balance = previous balance – principal.
6. Check that the final balance is zero after the last payment.

Sources: Investopedia, Amortization-calc.com

What Is Principal and Interest?

Principal and interest are the two components of a loan payment. Principal is the original amount borrowed, and interest is the cost of borrowing that money. In an amortizing loan, each payment includes both, but the split changes over time.

Early in the loan, interest is high because the principal balance is high. As you make payments, the balance decreases, so the interest charged each month also decreases. The principal portion increases correspondingly, accelerating the paydown.

Sources: Consumer Financial Protection Bureau, Investopedia

How Interest Is Calculated on Amortized Loans

Interest on an amortized loan is calculated by multiplying the remaining loan balance by the periodic interest rate. For a monthly payment schedule, the periodic rate is the annual rate divided by 12.

Sources: Investopedia, Amortization-calc.com

Amortization Allocation Over the Loan Term

Over the full loan term, the allocation of each payment shifts gradually from mostly interest to mostly principal. In the beginning, a small fraction of the payment goes to principal; by the end, almost all of it does.

This allocation is a direct result of calculating interest on a declining balance. The longer the loan term, the more interest you pay overall, because the balance declines more slowly.

Sources: Consumer Financial Protection Bureau, Investopedia

interest rate and loan term on the split

A higher interest rate increases the interest portion of each payment, especially early in the loan. A longer loan term also means more interest overall, because the balance is outstanding for more periods.

For example, a 30-year mortgage at a higher rate has a larger share of interest in the early payments than a 15-year mortgage at the same rate. The shorter-term loan pays down principal faster, so the split shifts more quickly.

Sources: Consumer Financial Protection Bureau, Investopedia

Example Schedule Showing Principal and Interest

It illustrates how the principal portion increases while the interest portion decreases each month.

Sources: Consumer Financial Protection Bureau, Amortization-calc.com

Why the Split Matters for Equity and Total Interest

The split between principal and interest matters because it determines how quickly you build equity and how much total interest you pay over the life of the loan. When you pay more in principal, you own more of the asset and pay less interest in future periods.

Understanding the split can help you decide whether to make extra payments or refinance to a shorter term. Because interest is calculated on the remaining balance, reducing principal earlier saves you more in interest over the long run.

Sources: Consumer Financial Protection Bureau, Investopedia