Amortization Distribution Table: How to Read It

An amortization distribution table—usually called an amortization schedule or table—shows how each loan payment is divided between interest and principal, and how the balance changes over time. Use this calculator to enter a loan amount, annual APR, and term; it estimates the monthly payment and total interest, while the table’s underlying pattern can be understood from the formula and example below.

Formula

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

PMT = round[P × r ÷ (1 − (1 + r)⁻ⁿ), 2]

• P is the starting principal, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
• n is the number of monthly payments, calculated as years × 12.
• PMT is the monthly payment in dollars, rounded to the nearest cent.

Total interest in this calculator is PMT × n − P, in dollars. Because the payment is rounded to cents first, the total follows that rounded payment rather than an unrounded theoretical amount. An actual lender’s final payment or disclosed total can differ because of payment dates, rounding conventions, fees, or other contract details.

Worked Example

With the calculator’s default inputs, the principal is $20,000, APR is 8%, and the term is 5 years.

1. Convert APR to a monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
2. Convert the term to payments: 5 × 12 = 60 months.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53 after rounding to cents.
4. Calculate interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The headline result is an estimated monthly payment of $405.53; estimated total interest is $4,331.80.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest accrues monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.

What an Amortization Distribution Table Shows

The table lays out the loan one payment period at a time. Each row commonly includes the payment number or date, beginning balance, scheduled payment, interest charged, principal repaid, and ending balance. “Distribution” refers to the split of a payment; it does not mean the borrower receives separate payments or that the debt is divided among people.

For a standard fixed-rate loan, interest for a period is based on the balance at the start of that period. The payment first covers that interest; the remainder reduces principal. As the balance declines, the interest portion generally falls and the principal portion rises, even though the scheduled payment remains level. The precise schedule depends on the contract’s rate, dates, and calculation method.

For the example above, the first month’s approximate interest is $20,000 × 0.08 ÷ 12 = $133.33. From the $405.53 payment, about $272.20 therefore goes to principal, leaving a balance near $19,727.80. Subsequent rows calculate interest from the new balance. Small differences can arise from rounding displayed row values.

How to Read or Build the Schedule

For a basic monthly schedule, repeat these calculations for each payment:

1. Multiply the opening balance by the monthly rate to find that period’s interest.
2. Subtract the interest from the scheduled payment to find principal repaid.
3. Subtract principal repaid from the opening balance to get the closing balance.
4. Use that closing balance as the next period’s opening balance.

In symbols, for payment period k, interest is opening balance × r; principal is payment − interest; and closing balance is opening balance − principal. A complete schedule has one row per payment. The calculator here gives the payment and total interest, not a row-by-row downloadable table, so the calculations above explain how to construct the distribution.

When the Estimate May Differ

This calculation is appropriate for understanding a fixed-rate, fully amortizing loan with regular monthly payments. It is not a universal schedule formula. A variable rate can change the interest allocation or payment; an interest-only period does not reduce principal in the usual way; and a balloon payment leaves some balance due at the end. Irregular payment intervals and daily interest calculations also require different timing assumptions.

• APR versus the rate used for accrual: The calculator treats the entered APR as a nominal annual rate divided by 12. A loan’s disclosure may use different conventions or include costs in a disclosed APR.
• Fees and financed charges: If charges are added to the loan balance, the actual principal may exceed the amount received. They are not modeled here.
• Extra or missed payments: Additional principal can change later interest and payoff timing. A missed or late payment can also change the actual schedule.
• Rounding: The displayed monthly payment is rounded to cents. A lender may adjust the final payment to clear a small remaining balance.

Use the loan documents or lender-provided schedule for contractual dates and amounts. Enter the actual principal, rate, and term shown in the disclosure when using this estimate; do not treat a sample default as a current rate or offer.

Frequently Asked Questions

Is an amortization distribution table the same as an amortization schedule?
Usually, yes. “Amortization schedule” is the more common name for a period-by-period table showing payment allocation and the remaining balance.

Why does more of the payment go to interest at the beginning?
Interest is calculated on the outstanding balance. The balance is largest at the start, so interest takes a larger share of a level payment; as principal falls, the interest amount generally falls too.

Does the monthly payment include taxes and insurance?
Not in this calculator. It estimates principal and interest only. Any taxes, insurance, escrow, or other charges must be checked separately in the relevant loan documents.

Does paying extra reduce total interest?
When an extra amount is applied to principal, it can reduce the balance on which later interest is calculated. The impact depends on timing and the loan’s terms; this calculator does not model extra payments or their treatment.

Why might my lender’s table show different amounts?
Possible reasons include a different starting balance, payment date, day-count method, rate convention, fees, rounding, or a final-payment adjustment. The lender’s disclosure reflects the specific contract.

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

Related

• Social Security Qualifying Income: What Counts?
• SC Qualified Retirement Income Deduction: Rules and Limits
• Section 8 Qualifying Income Level Explained

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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2