How this instrument works
A mortgage amortization schedule tracks two figures that move in opposite directions every month: how much of the original loan is gone (principal paid) and how much has been handed to the lender for the use of the money (interest paid). This instrument reconstructs both for any single month you name, not only the first payment or the last, by first solving for the fixed monthly payment and then compounding the loan balance forward to that specific point in the schedule.
The number matters most to someone sizing up real equity before a sale or a refinance, an executor settling an estate against a mortgaged house, or a couple splitting home equity in a separation — cases where the loan's true payoff figure is needed now, not in year thirty. The mistake this corrects is assuming payments made equal principal paid: five years into a $300,000, 6%, 30-year mortgage, a borrower has sent 60 of 360 payments, one-sixth of the term, yet the balance has fallen by less than 7%, because most of those early dollars covered interest, not principal.
The balance this returns assumes every payment landed on schedule at the exact computed amount, with no extra principal, no skipped month, and no mid-term rate change — a fixed-rate schedule only. It says nothing about property taxes, homeowners insurance, or mortgage insurance a servicer might collect alongside principal and interest, and it stops at the loan's own arithmetic rather than the home's market value, which a refinance or sale decision also depends on.
- Enter the amount financed under Loan amount, $ and the note rate under Annual interest rate, %.
- Set the full repayment length under Loan term, years.
- Enter the point in the schedule you want to inspect under Month number to check progress at — 12 for one year in, 60 for five years in, and so on.
- Read Monthly payment for the fixed installment, and Balance remaining at that month for what the loan still owes then.
- Compare Cumulative principal paid against Cumulative interest paid to see exactly how that month's total was split.
Worked example — five years into a $300,000 mortgage
Borrow $300,000 at 6% annual interest over a 30-year term — Loan amount, $ set to 300000, Annual interest rate, % set to 6, and Loan term, years set to 30. The payment formula returns Monthly payment = $1,798.65, fixed for all 360 months regardless of how each installment splits between principal and interest.
Set Month number to check progress at to 60 — five years of on-time payments. Balance remaining at that month reads $279,163.07, so Cumulative principal paid comes to $20,836.93 and Cumulative interest paid comes to $87,082.16. Of the $107,919.09 sent over those five years, roughly 81 cents of every dollar went to interest and only 19 cents retired the loan itself — the front-loaded pattern that makes a mortgage's early years so slow to build equity.
Questions
Why is the principal paid so much less than the payment count would suggest?
Interest is charged each month on whatever balance is still outstanding, and that balance sits at its highest point on day one. Sixty payments into the $300,000 example above, one-sixth of the term has elapsed but the balance has fallen only 6.9%, because roughly 81% of every early dollar was interest — a ratio that shifts gradually as the balance shrinks, not something a payment count alone reveals.
How is this different from a plain mortgage payment calculator?
A payment calculator stops at the fixed monthly figure or, at best, a full year-by-year table. This instrument answers a narrower question — what has actually been paid off by one specific month you choose — and splits that month's cumulative total into principal and interest directly, instead of making you scan a table row by row to find it.
Does Month number to check progress at count calendar months or payments made?
It counts payments actually posted, numbered from the start of the loan, not a calendar date. Enter 0 for the day the loan closes, before any payment, and both cumulative figures return zero; enter 360 on a 30-year loan for the final scheduled payment, where the balance should land at essentially zero too.
What happens if I make extra principal payments in real life?
This schedule assumes every payment equals the computed Monthly payment exactly, with nothing extra. Real overpayments shrink the balance faster than shown here, which pulls every later month's split toward more principal and less interest than this instrument reports — a difference the arithmetic cannot see, since it only knows the scheduled amount, not what was actually sent.
Why check progress mid-loan instead of reading a full amortization table?
A full table suits scanning a trend, but most real decisions hinge on one date — a refinance quote, a sale closing, a divorce settlement, an estate valuation — and only need that month's numbers, not all 360 rows. Naming the exact month gets the answer directly instead of counting down a table by hand.
Does the balance include property taxes or homeowners insurance?
No. This tracks only the principal and interest a mortgage note itself accrues and repays; taxes, homeowners insurance, and any mortgage insurance a servicer collects in escrow are billed and tracked separately and do not change the loan's own principal-and-interest arithmetic shown here.
References
- Consumer Financial Protection Bureau — Mortgages
- Federal Reserve — Consumer Credit statistical release (G.19)
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.