Amortization Table Definition and How to Read One

An amortization table is a schedule that shows how each loan payment is divided between interest and principal, and how the balance changes over time. This calculator estimates a fixed-rate loan’s monthly payment and total interest from the amount, annual APR, and term; its outputs are useful for checking the payment pattern shown in an amortization table.

Formula

For a fixed-rate loan with monthly payments, the level monthly payment is calculated as:

Payment = P × r / [1 − (1 + r)−n]

Here, P is the starting principal in dollars, r is the monthly interest rate as a decimal (APR ÷ 1200), and n is the number of monthly payments (years × 12). The calculator’s total-interest estimate is monthly payment × n − P. The payment formula assumes the same payment amount each month and does not round each month’s interest separately; real servicing schedules may differ by cents because of rounding and payment dates.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% annual APR, and a five-year term:

• Monthly rate: 8 ÷ 1200 = 0.0066667.
• Number of payments: 5 × 12 = 60.
• Monthly payment: 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53, rounded to cents.
• Total of the rounded payments: $405.53 × 60 = $24,331.80.
• Estimated total interest: $24,331.80 − $20,000 = $4,331.80.

The displayed total interest follows the calculator expression, which uses the rounded monthly payment. It is an estimate: a lender’s schedule can account for exact accrual dates, payment timing, and final-payment adjustments.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are level, made monthly, and treated as occurring at regular intervals.
• Interest compounds monthly using APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, and other charges are not included.

What an Amortization Table Shows

A full amortization table lists each scheduled payment in order, often with columns for the payment number or date, total payment, interest portion, principal portion, and remaining balance. The principal is the amount borrowed; paying principal reduces what remains owed. Interest is the borrowing cost accrued under the loan’s terms. A schedule may also show cumulative principal and cumulative interest.

“Amortization” describes the gradual repayment of debt through scheduled payments. For a standard fixed-rate installment loan, the payment is generally level, but its components change. Early in the schedule, the balance is larger, so interest usually accounts for a greater share. As principal is repaid, less interest accrues for each later period, and more of the same payment goes to principal.

For example, at a monthly rate of 0.5%, a $10,000 balance accrues $50 in interest over one month under a simple monthly calculation. If the scheduled payment is $200, about $50 covers interest and about $150 reduces principal, leaving roughly $9,850. Actual contracts may calculate accrued interest using specific dates or conventions, so a lender’s schedule can differ.

How to Read the Schedule

Read one row at a time. The interest and principal portions should usually add up to the scheduled loan payment, while the ending balance should equal the prior balance minus principal paid, subject to the lender’s calculation and rounding. A quick check is that balances generally decline over time when payments cover both interest and some principal.

• Payment: The amount scheduled for that period, excluding any separately listed charges.
• Interest: The portion applied to interest accrued for the period.
• Principal: The portion that reduces the loan balance.
• Remaining balance: The principal still outstanding after the payment is applied.

Do not assume a scheduled payment equals the total amount withdrawn or billed. An account may collect separate items, such as taxes or insurance, and a statement may display them alongside the loan payment. Those items do not necessarily pay down principal.

What Changes the Payment Pattern

The payment and table depend chiefly on the amount borrowed, rate, term, and payment frequency. Holding the other inputs constant, a larger principal generally raises the payment; a higher rate generally raises it; and a longer term generally lowers the level payment while extending repayment. Since interest accrues over more periods on a longer schedule, the total interest can be higher even when the monthly payment is lower.

This calculator assumes a fixed APR and monthly installments. It does not model variable rates, irregular payment dates, interest-only periods, skipped or late payments, fees added to the balance, or extra principal payments. A changing rate or payment can make the actual schedule diverge from a table based on the original terms.

Common Misunderstandings and Limits

A common misconception is that the interest portion is a fixed percentage of the original loan amount every month. In a typical amortizing schedule, interest is calculated against the outstanding balance according to the contract, so the interest amount tends to fall as that balance declines. Another misconception is that paying the same amount monthly means the same amount of principal is repaid each time; in a standard fixed-rate schedule, the principal portion usually grows over time.

Rounding matters. A schedule may round interest to cents each period and adjust the last payment, while a formula calculator may apply a rounded payment across all periods. A small difference in the displayed total is not necessarily an error. Compare the assumptions and the lender’s official payment schedule rather than expecting every calculator to match to the cent.

For a personal schedule, use the lender’s stated principal, APR, term, and payment frequency. Check whether the quoted rate is the same rate used to calculate periodic interest and whether charges are included. The calculator is a general fixed-rate estimate, not a replacement for a contract or account statement.

Frequently Asked Questions

What does an amortization table mean?
An amortization table is a period-by-period record of scheduled loan payments, showing how much goes to interest and principal and what balance remains.

Why does more of my payment go to interest at first?
Interest is generally calculated on the outstanding balance. That balance is highest near the beginning of a fully amortizing loan, so the interest share is usually larger then.

Does an amortization table include taxes and insurance?
Not necessarily. A principal-and-interest schedule usually shows repayment of the loan itself. Taxes, insurance, and other charges may appear separately, depending on the account and document.

Can an amortization table change?
Yes. A variable rate, payment changes, extra payments, missed payments, fees, or date-based interest calculations can change the actual balance and schedule.

Is the calculator’s total interest exact?
No. It is an estimate based on the entered figures and stated assumptions. The lender’s schedule may use exact payment dates, periodic rounding, and a different final payment.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

• Qualified Income Trust in NJ: Medicaid Explained
• Qualified Income Trust (QIT): What It Is and How It Works
• Qualified Income Trust (Miller Trust): How It Works

in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2