An amortizing loan is repaid in equal payments, but each payment splits differently: early on it is mostly interest, at the end mostly principal. The schedule shows that split for every payment, which is what you need to see how much a loan really costs, what you still owe after any number of years, and what an extra payment does.
How it is calculated
- Monthly payment = P × r ÷ (1 − (1 + r)−n), with P the loan amount, r the monthly rate (APR ÷ 12), n the number of payments.
- Each month: interest = balance × r; principal = payment − interest (+ any extra); new balance = balance − principal.
- Total interest is the sum of the interest column. With extra payments the schedule ends early, and the difference in total interest is the saving.
Example
$300,000 at 6.5% for 30 years: payment $1,896.20. The first payment is $1,625 interest and only $271 principal. Total interest over 30 years is $382,633, more than the amount borrowed. Adding $200 a month pays the loan off in about 23 years and saves roughly $103,000 in interest.
Why extra payments are so effective early
An extra dollar of principal in year one stops interest accruing on it for the remaining 29 years; the same dollar in year 25 saves five years of interest. That is why front-loading extra payments, or a one-off lump sum early in the loan, has an outsized effect. Check that the loan has no prepayment penalty and that extra amounts are applied to principal, not to next month’s payment.
What is not included
Property tax, insurance and HOA fees for a mortgage; these are added to the payment by the lender but do not amortize. Variable-rate loans change the payment when the rate resets; this schedule assumes a fixed rate.
Frequently asked questions
What is amortization?
Paying off a loan in regular equal payments where each payment covers that period’s interest plus some principal. The schedule lists the split for every payment until the balance is zero.
Why is most of my early payment interest?
Because interest is charged on the outstanding balance, which is highest at the start. As the balance falls, the interest part shrinks and the principal part grows, even though the payment stays the same.
How much does an extra $100 a month save?
On a $300,000, 30-year loan at 6.5%, about $61,000 in interest and 4 years off the term. Enter your own figures above; the savings scale with the rate and the remaining term.
Does this work for car loans and personal loans?
Yes. Any fixed-rate loan with equal monthly payments follows the same schedule. Enter the amount, APR and term in years.
Is the payment the same as what the bank charges?
For the principal and interest, yes, to the cent in almost all cases. Mortgages add escrow for taxes and insurance on top; the total may also differ slightly if the lender rounds differently.
Read more
- 15 vs 30-year mortgage: the payment, the interest and the middle pathOn a $320,000 loan at this week's US averages, a 15-year mortgage costs $615.69 a month more than a 30-year one and saves $283,283 of interest. Why the gap is that large, how fast each loan builds equity, and what happens if you take the 30-year loan and pay it like a 15-year one.
- How much is PMI, and when does it end?Private mortgage insurance costs about $30 to $70 a month per $100,000 borrowed. On a $400,000 home with 10% down that is $108 to $252 a month, and at a typical rate it lasts close to ten years unless you ask to drop it sooner. The cost by down payment, the three dates it can stop, and how extra payments bring them forward.
- 60 vs 72 vs 84 month car loan: what the longer term really costsOn $40,000, stretching a 60-month loan to 72 months saves $110 a month and costs $1,613 more interest; 84 months costs $3,260 more, and more again when the rate rises with the term. The numbers side by side, how long each term keeps you underwater, and when a long loan still makes sense.
- What interest rate should you expect on an RV loan?US credit unions published starting rates from 5.74% to 10.24% in September 2026 — a spread wide enough to change the payment by hundreds a month. Here is what every lender published, what actually moves your number, and the term trap underneath it all.
Sources
- CFPB: Understanding your loan estimate and amortization
- Regulation Z, 12 CFR Part 1026 (Truth in Lending) — Defines the annual percentage rate, negative amortization and prepayment penalties.
By Calcelate Team. Formula from the sources above.
- 2026-09-14 · Formula and texts checked