Finance guide · 8 min read

What is an amortization schedule? Meaning and example

An amortization schedule is a table that shows how each loan payment is split between principal and interest. It also shows the remaining balance after every payment, which makes it easier to understand the real path from borrowing money to paying the loan off.

Updated June 25, 2026. Written by Kodotools. Examples are educational estimates for standard fixed-rate loans; actual lender schedules can differ because of fees, dates, rounding, and repayment rules.

Amortization schedule meaning in simple words

An amortization schedule, sometimes called an amortization table, is a payment-by-payment roadmap for a loan. Each row usually includes the payment number, payment date, scheduled payment, principal paid, interest paid, extra payment, and ending balance.

For a standard fixed-rate, fully amortizing loan, the payment is designed to reduce the balance to zero by the end of the term. The total payment may stay steady, but the principal and interest split changes over time.

Free calculator

Generate an amortization schedule

Enter loan amount, rate, term, and extra payments to create a monthly amortization table with a yearly summary and export options.

Open the schedule calculator ->

What information does an amortization table show?

Column	What it tells you
Payment number	Where you are in the repayment schedule.
Payment	The scheduled payment for that period, plus any extra principal if included.
Principal	The amount that reduces the outstanding loan balance.
Interest	The borrowing cost for that period, usually based on the remaining balance.
Balance	The unpaid amount left after the payment is applied.

Amortization schedule example

Suppose you borrow $250,000 at a fixed nominal annual rate of 6.5% for 30 years. The estimated monthly principal-and-interest payment is about $1,580.17.

Payment point	Interest	Principal	Balance after payment
Month 1	$1,354.17	$226.00	$249,774.00
Month 180	$985.79	$594.38	$181,397.85
Month 360	$8.51	$1,571.66	$0.00

The exact cents may vary by lender rounding, but the pattern is the important part: interest is heavier early, principal grows later.

Amortization schedule formula

A common fixed-payment loan formula is:

Payment = P x r x (1 + r)ⁿ / ((1 + r)ⁿ - 1)

P is the loan principal.
r is the monthly interest rate.
n is the number of monthly payments.

After the payment is estimated, each row calculates interest for the period, applies the remaining payment to principal, and updates the balance.

Why do early payments mostly go to interest?

Interest is usually calculated from the remaining balance. At the beginning of the loan, the balance is highest, so the interest portion is larger. As the balance falls, the interest charge becomes smaller and more of each payment can go toward principal.

This is why long loans can feel slow at first. A borrower may make years of payments and still see a large balance, especially on a mortgage amortization schedule.

How extra payments affect an amortization schedule

Extra payments can reduce principal faster. A lower principal balance usually means less future interest and an earlier payoff date, as long as the lender applies extra money to principal.

Before sending extra money, check the loan agreement for allocation rules and possible prepayment charges. The Consumer Financial Protection Bureau explains prepayment penalties for borrowers in the United States.

Monthly schedule vs annual schedule

A monthly amortization schedule is best when you need exact details for every payment. It shows the complete principal and interest schedule from the first month to final payoff.

An annual schedule groups those rows by year. It is easier to scan when you want to compare year 1, year 10, or year 30 without reading hundreds of rows.

Common amortization schedule mistakes

Ignoring taxes and insurance: a mortgage amortization schedule may show principal and interest only, not the full housing payment.
Assuming every lender rounds the same way: official schedules can differ by cents because of dates and rounding.
Treating extra payments as automatic principal: confirm lender instructions before relying on payoff savings.
Only checking the monthly payment: a longer term can lower the payment while raising total interest.

Related calculators

Amortization schedule calculatorMonthly table, yearly summary, and Excel export. Loan payoff calculatorExtra payments, lump sums, and payoff savings. Mortgage calculatorTaxes, insurance, PMI, HOA, and amortization. EMI calculatorFlat and reducing-balance installment comparison.

Frequently asked questions

Is an amortization schedule the same as a payment schedule?

A loan payment schedule may list due dates and payment amounts. An amortization schedule adds the principal, interest, and remaining balance breakdown.

Does every loan have an amortization schedule?

Many installment loans do, especially fixed-rate loans. Credit cards, interest-only loans, variable-rate loans, or revolving debt can work differently.

Why is my lender schedule different from a calculator?

Differences can come from exact payment dates, compounding, APR rules, fees, rounding, escrow items, or lender-specific calculation methods.

Can I make my own amortization schedule in Excel?

Yes. You can build formulas for payment, interest, principal, and balance, or use the Kodotools amortization schedule calculator to export a ready schedule.

Does amortization include property tax or insurance?

A loan amortization schedule usually covers principal and interest. Mortgage taxes, insurance, PMI, and HOA fees are separate housing costs unless a tool specifically includes them.

EMI · 9 min read