Loans, Savings & Interest · Loans & Interest
How to Read an Amortization Schedule
A monthly payment stays the same while its contents change. Read the schedule to see how much of each payment is interest, how fast the balance falls, and what an extra payment really saves.
An amortization schedule turns one monthly payment into a story about a balance. The payment is level, but the interest behind it is not: it is charged on whatever principal remains, so the split changes every month. Reading the schedule lets you check a lender's numbers, compare terms, and see what an extra payment actually does.
The Loan Payment Calculator generates this schedule from the amount, rate, and term you enter. This guide explains how to read it and how to audit a row without repeating the page's instructions.
What the schedule shows
Each row is one payment. It contains the payment amount, the interest charged for that month, the principal repaid, and the balance left afterwards. The opening example is $25,000 at 6.5% for 60 months, so there are 60 scheduled rows.
month 1: payment $489.15 = interest $135.42 + principal $353.74
balance after month 1: $25,000.00 - $353.74 = $24,646.26
The payment is the same in month 2. The interest is lower, because the balance is lower, so more of the payment goes to principal. That is the whole mechanism.
The three lines in every month
For a fixed-rate loan with monthly payments, the monthly rate is the annual rate divided by 12. At 6.5%, that is 0.065 ÷ 12 = 0.005416667. Each row follows the same order:
interest = previous balance × 0.005416667
principal = payment - interest
balance = previous balance - principal
| Month | Payment | Interest | Principal | Balance after |
|---|---|---|---|---|
| 1 | $489.15 | $135.42 | $353.74 | $24,646.26 |
| 2 | $489.15 | $133.50 | $355.65 | $24,290.61 |
| 3 | $489.15 | $131.57 | $357.58 | $23,933.03 |
Interest falls by about $1.92 between month 1 and month 2 in this example. That fall is the monthly rate applied to the $353.74 of principal repaid in month 1.
Why interest is front-loaded
Interest is a percentage of the balance, not a percentage of the payment. The balance is largest at the start, so the interest is largest at the start. On the $25,000 loan, the first year charges $1,496.23 in interest, while the fifth year charges $201.55. The payment did not change; the balance did.
The same effect explains why a longer term lowers the payment but raises total interest. Stretching the loan keeps a larger balance outstanding for longer, so more interest is charged before the principal is repaid. A shorter term does the opposite: a higher payment, less total interest, and less flexibility if income changes.
What an extra payment changes
An extra payment is applied after the month's interest, so the full extra amount reduces principal. On the same $25,000 loan, adding $100 every month produces these results:
| Measure | Scheduled | With $100 extra |
|---|---|---|
| Monthly outlay | $489.15 | $589.15 |
| Payments made | 60 | 49 |
| Total interest | $4,349.22 | $3,483.78 |
| Payoff | 5 years | 4 years 1 month |
The last payment with the extra amount is $204.41, not $589.15, because the balance runs out mid-payment. Total interest falls by $865.44, and the loan ends 11 months early. The extra payments add up to about $4,900, but that total is not the saving: most of it is principal the schedule would have repaid later anyway. The saving is the interest those earlier principal payments prevented.
Timing matters. An extra payment in month 2 prevents interest on that principal for 58 months; the same payment in month 58 prevents almost nothing. That is why a monthly extra amount and a single lump sum are not interchangeable even when the total cash is the same.
Five checks that catch a bad schedule
- First interest. Multiply the original balance by the monthly rate: $25,000 × 0.005416667 = $135.42. If the first interest line does not match, the rate or the balance is different from what you think.
- Roll-forward. Subtract the principal from the previous balance and compare it with the balance in the same row. Do this for a few rows, including the last one.
- Interest total. Add the interest column. It must equal total interest, and principal plus interest must equal total paid. A schedule whose printed totals do not match its own rows cannot be audited.
- Final row. The final balance should be zero, and the final payment may be smaller than the others. A final balance of a few cents usually means the payment was rounded; a large residual means the term or payment is wrong.
- Annual grouping. If the schedule also shows yearly rows, each annual interest figure should equal the sum of the twelve monthly interest figures. A partial final year should contain only the months that were actually paid.
These checks do not require a spreadsheet. They require the rate, the balance, and one row at a time.
Annual summary versus monthly detail
An annual table is easier to scan: it shows how much interest was paid in each loan year and how the balance fell. A monthly table is what you use to audit a specific payment or to see the last payment. Some lenders print only the annual summary; others provide the full monthly schedule.
The calculator shows the annual table on the page and offers the monthly rows as a CSV download. The CSV has one row per payment with the payment, interest, principal, and remaining balance. It is generated in the browser from the same schedule used for the on-page totals, so the two should agree.
Displayed cents can differ from a hand calculation by a few cents. The schedule keeps the unrounded payment internally and rounds only for display. If you add the printed payment 60 times, you can be a few cents away from the printed total; that is a display effect, not an error in the loan.
What the schedule leaves out
The schedule covers principal and interest on a fixed-rate loan with level monthly payments. It does not include property taxes, homeowners insurance, mortgage insurance, HOA dues, closing costs, or any other escrow item. It also does not model a variable rate, an interest-only period, a balloon payment, a biweekly plan, a one-time lump sum, a prepayment penalty, or income-driven repayment.
A lender's payoff quote can differ from the schedule's remaining balance because it includes per-diem interest to the payoff date, fees, and the date the payment is received. The schedule is a planning and verification tool, not a payoff quote.
FAQs
Why does the last payment differ from the others?
The balance is rarely an exact multiple of the monthly payment. The last payment is capped at the remaining balance plus that month's interest, so it is usually smaller. The schedule's final balance should still be zero.
Is paying extra always better than investing the difference?
That is a comparison of a known interest saving against an uncertain return, and it depends on the rate, the time horizon, taxes, liquidity, and the terms of the loan. The schedule can show the interest saved by an extra payment; it cannot decide whether that is the right use of the money.
Why is my lender's payoff amount higher than the schedule balance?
A payoff quote adds interest through the payoff date and may include fees or daily interest. The schedule's balance is as of the last payment date, not the date you request the quote.
Can I use this to check a biweekly payment plan?
Not directly. A biweekly plan makes 26 half-payments a year, which is equivalent to 13 monthly payments. The extra payment field can approximate the effect of paying more each month, but it will not reproduce the exact dates and per-diem interest of a biweekly schedule.
Does a longer term always cost more in total?
For the same rate and amount, a longer term normally means a lower monthly payment and more total interest. The schedule shows why: the balance stays outstanding longer. Confirm with the actual rate and term rather than assuming the difference.