Every payment · Interest and principal · The rows you delete
A mortgage schedule is 360 rows of the same quiet arithmetic. Add an extra payment and the rows change: interest falls, principal climbs, and the last rows stop existing. This ledger opens the whole table, year by year, and counts what those deleted rows were going to cost you.
The ledger correction
Enter your loan to build the schedule, then add an extra payment to see which rows disappear.
Your plan deletes 67 payments: #294 through #360 never happen, and $111,892 of interest dies with them. The rows you still pay stay top-heavy, though: interest does not drop below principal until payment #166. Name the month you want to be done.
Want a different ending? The debt-free-by-date calculator works backwards from the month you pick, and the payoff calculator prices lump sums against this same schedule. Your loan and your extra payment carry over.
All the math runs in your browser; nothing you enter is stored or sent anywhere. Last updated July 2026.
Open any year to read its payments one by one. Interest is what the loan costs you that month; principal is what actually comes off the balance.
| Year | When | Interest | Principal | Extra | Balance left |
|---|
One honest note: these rows are principal and interest only. Property tax, insurance, HOA dues, and PMI ride along in your real payment, and they do not change the payoff math on this page.
Dollar figures use the example: a $400,000 loan at 6.5% over 30 years, first payment August 2026. Run your own numbers above.
Payment #1 and payment #360 are the same $2,528.27. That is where the likeness ends. On the first one, $2,166.67 goes to the bank as interest: 85.7% of the payment, and you keep none of it. On the last one, interest is $13.62 and $2,514.65 lands on the loan. Every row between them is that same trade, moving one notch at a time.
Somewhere in the table, principal finally beats interest. On the example loan it is payment #233, December 2045: nineteen years into a thirty-year loan. The balance does not fall to half until payment #257, later still. Extra principal drags that turning point forward. $200 a month moves it to #166, five years and seven months earlier, because a dollar sent today shrinks the interest line of every row that follows it.
An extra payment does two things, and the loud one is the smaller one. It deletes rows off the end: $200 a month stops the example schedule at payment #293, so #294 through #360 never happen. The interest inside those deleted rows is $27,652. But the habit saves $111,892. The other $84,240 comes from the rows you still pay, each one carrying a slightly smaller interest line than it would have. The end of the table is the headline. The middle is where the money is.
Every tool inherits what you type here. Nothing to re-enter, nothing stored. Dollar figures are the example loan: $400,000 at 6.5% over 30 years.
Make your plan
Payoff calculator
Add $200 a month and watch $111,892 of interest die. Lump sums and milestones too.
Amortization scheduleYou are here
Every payment, split into interest and principal. $200 a month deletes 67 rows.
Debt-free by date
Pick the month; it finds the smallest extra that gets there. Twenty years costs $454.03 a month.
Before retirement
Paid off at 65 instead of 71 costs $221.89 a month. Priced in birthdays, not dates.
Weigh your options
Prepay vs invest
The market has to beat your mortgage rate after tax. Both roads run to the cent.
Bi-weekly payments
Half-payments every two weeks finish 5 years 10 months sooner. The paid programs get priced too.
Recast
A $50,000 lump can cut the payment $319.60 a month. The lower payment’s price: $137,661.
Refinance
The advertised break-even says 25 payments. The honest ledger says 20. You see both.
Today’s numbers
Payoff amount
The statement says $395,529.10. The check that clears the loan says $396,515.26.
PMI removal
Asking at 80% instead of waiting for 78% keeps $2,805. Both dates, dated.
It is the whole life of the loan, one row per payment. Each row says how much of that payment is interest, how much comes off the balance, and what is left afterward. On a $400,000 loan at 6.5% over 30 years the table runs 360 rows and adds up to $910,178 paid on $400,000 borrowed. The rows are not equal: the split inside each one moves a little every month.
Because interest is charged on what you still owe, and at the start you owe all of it. Month one on the example loan: $400,000 times 6.5% divided by 12 is $2,166.67 of interest, which is 85.7% of the $2,528.27 payment. The share falls every month as the balance falls, but slowly. It takes until payment #233 for principal to finally win the row.
Two ways at once. They delete rows off the end, and they shrink the interest line of every row that survives. On the example loan, $200 a month ends the table at payment #293: rows #294 through #360 never happen, and the $27,652 of interest inside them is never billed. That habit saves $111,892 in total, so the other $84,240 comes from the surviving rows being cheaper than they would have been. Most people expect the opposite split.
The first row where more of your money lands on the loan than on interest. On the example loan that is payment #233, December 2045. It is a useful milestone because everything before it is a slow climb and everything after it accelerates. Extra principal pulls it closer: $200 a month moves the crossover to payment #166, and $500 a month moves it to #106.
Not this table. A monthly schedule assumes each payment posts on its due date, which is how your servicer builds the quote too. Paying a few days early does not rewrite the row, though it can shave interest on loans that accrue daily. The one place the calendar really bites is a full payoff: the check has to carry interest for every day since the last due date. The payoff amount calculator prices that per day.
Yes to both. The CSV button hands you every payment as its own row, ready for a spreadsheet, and the print button produces a clean report with the whole table opened. Both are built in your browser from the numbers on screen. Nothing you type is uploaded, stored, or sent anywhere.