Amortization Rate Table: Payments and Loan Balance

An amortization rate table shows how each scheduled loan payment is divided between interest and principal, and how the balance changes over time. Use this calculator to estimate a fixed-rate loan’s monthly payment and total interest from its amount, APR, and term; the table itself is then built by applying the monthly interest and payment to each period.

Formula

For a fixed-rate loan with equal monthly payments, the payment is calculated using the standard level-payment formula:

Payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the starting principal, in dollars.
• r is the monthly interest rate as a decimal: annual APR ÷ 1200. For an 8% APR, r = 8 ÷ 1200.
• n is the number of monthly payments: loan term in years × 12.

Total interest in this calculator is monthly payment × n − P. The block displays both money results to two decimal places. Its total-interest calculation uses the displayed, cent-rounded payment, so it may differ slightly from a calculation using an unrounded payment.

Worked Example

Using the calculator’s defaults—$20,000 principal, 8% APR, and a 5-year term:

1. Convert the APR to a monthly rate: r = 8 ÷ 1200 = 0.0066666667.
2. Find the number of payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: $20,000 × 0.0066666667 ÷ [1 − (1 + 0.0066666667)⁻⁶⁰] ≈ $405.53 per month.
4. Calculate total interest using the rounded payment: ($405.53 × 60) − $20,000 = $4,331.80.

These are estimates based on the stated assumptions. A lender’s schedule may differ if its payment dates, rate calculation, fees, or rounding conventions differ.

Assumptions

• The interest rate remains fixed for the full term.
• Payments are equal, made monthly, and are assumed to occur at the end of each period.
• Interest compounds monthly using APR ÷ 12.
• The calculation excludes fees, taxes, insurance, PMI, and escrow.

How to Read an Amortization Rate Table

A full amortization table usually has one row for each payment period. Common columns include the payment number or date, opening balance, scheduled payment, interest portion, principal portion, and closing balance. For each row, interest is generally computed on the opening balance for that period; principal is the payment minus that interest. The closing balance is the opening balance minus principal paid.

For the example, the first month’s estimated interest is $20,000 × 0.0066666667, or about $133.33. Subtracting that from the $405.53 payment leaves about $272.20 toward principal, producing an estimated balance of $19,727.80 after the first payment. Values shown in a lender’s table can differ by a cent because calculations may use more precise amounts internally or use specific dates.

As the balance falls, the interest charged in later periods generally falls too, while a larger share of a level payment goes toward principal. That shift is the defining pattern of a standard amortizing loan. The final payment may be adjusted slightly to clear the remaining balance rather than leave a small rounding difference.

When to Use the Calculator

Use this estimate when you want to understand the basic payment and interest pattern for a loan with a fixed APR and regular monthly payments. Enter the principal being financed, the quoted annual APR, and the term in years. Use the lender’s actual figures where available; a hypothetical APR is only an illustration, not a forecast of what a lender may offer.

The calculator gives a payment and total interest, not a row-by-row table. To construct a table, repeat these steps for each month, using the previous month’s closing balance as the next opening balance:

1. Calculate that month’s interest as opening balance × monthly rate.
2. Subtract interest from the scheduled payment to find principal repaid.
3. Subtract principal repaid from the opening balance to get the closing balance.

Extra payments, skipped payments, variable rates, irregular dates, and payment changes alter this sequence. They require a calculation that models those events rather than the fixed-payment formula shown here.

Common Misreadings and Limits

• APR is not the monthly rate. For this formula, convert an annual percentage rate to a monthly decimal by dividing the percentage value by 1200. Do not enter 8% as 0.08 in the APR field; enter 8.
• Term and payment count are different units. The term field is in years, while the formula uses months, calculated as years × 12.
• Principal is not always the purchase price. The loan amount is the amount being amortized. A down payment, trade-in, or separately financed charges can make it different from an asset’s price.
• Total interest is not the full cost of borrowing. This estimate excludes any charges not represented in the loan amount or APR calculation, along with taxes, insurance, and other costs.
• Rounding matters over many payments. Small differences in monthly rounding can accumulate. A lender’s contractual schedule is the reference for its payment amounts and payoff balance.

This formula does not model variable-rate changes, interest-only periods, daily-interest methods, deferred payments, fees added during repayment, or a different payment frequency. A rate table is useful for understanding a standard schedule, but it cannot determine a lender’s exact figures without the loan’s terms and calculation rules.

Frequently Asked Questions

What does an amortization rate table show?
It shows each scheduled payment’s interest and principal portions and the remaining balance after that payment, usually period by period.

Why does more of a payment go to interest at the beginning?
Interest is calculated on the outstanding balance. The balance is largest at the start, so interest generally takes a larger share of a fixed payment in early periods.

Is an amortization table the same as an interest rate table?
No. An interest rate table compares rates or rate periods. An amortization table tracks payments, interest, principal, and balance over a loan’s repayment schedule.

Does this calculator create a full amortization schedule?
No. It calculates the estimated monthly payment and total interest. A full schedule requires a separate row for each period, using the changing balance.

Why might my lender’s payment or balance differ?
Differences can come from the actual APR and principal, payment dates, fees, compounding or day-count conventions, extra payments, and rounding. Check the loan disclosure for the governing figures.

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

Related

• SC Qualified Retirement Income Deduction: Rules and Limits
• Section 8 Qualifying Income Level Explained
• Qualifying Income Trust: Meaning and Tax Basics

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