The standard columns, explained
| Column | What it means |
|---|---|
| Payment # | The sequential number of the payment, starting at 1. Payment 12 is the end of your first year; payment 360 is the final payment of a 30-year loan. |
| Date | The calendar date that payment is due, based on your loan's first payment date and monthly interval. |
| Payment | The total amount due that period — for a fixed-rate loan, this stays the same every month (unless you're adding extra payments, which increase the total amount paid that period). |
| Principal | The portion of that payment that reduces your actual loan balance. |
| Interest | The portion of that payment that's the cost of borrowing — calculated as your current remaining balance times your monthly interest rate. |
| Balance | What you still owe after that payment is applied. This starts at your original loan amount and decreases to exactly $0 at the final payment. |
The core relationship to remember: Payment = Principal + Interest for every single row, and each row's Balance = previous row's Balance − that row's Principal (minus any extra payment applied directly to principal, if you're using one).
Reading three sample rows
Here are payments 1, 2, and 3 of a $300,000 loan at 6.5% APR over 30 years (the amortization schedule calculator's own default example):
| # | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | $1,896.20 | $271.20 | $1,625.00 | $299,728.80 |
| 2 | $1,896.20 | $272.67 | $1,623.53 | $299,456.12 |
| 3 | $1,896.20 | $274.15 | $1,622.05 | $299,181.97 |
Notice the Payment column never changes, but Principal grows slightly and Interest shrinks slightly with every row — because Interest is recalculated on the shrinking Balance each time. See how mortgage amortization works for the full mechanism.
Practical uses of a full schedule
- Finding your PMI removal date. If you put down less than 20% on a conventional mortgage, scan the Balance column for the payment number where your balance first drops to 78% (automatic PMI termination) or 80% (borrower-requested cancellation) of your original home value. That payment number tells you roughly when PMI can come off — see PMI explained for the exact legal thresholds and how they work.
- Estimating your loan balance at a future date — useful when considering refinancing, selling, or just tracking your net worth, without needing to log into your loan servicer's portal.
- Comparing "what if I add extra payments" scenarios. Generate a schedule with an extra monthly payment amount and compare the resulting balance and payoff date against the standard schedule — see how extra payments save interest for a worked comparison.
- Understanding your total interest cost before committing to a loan — summing the Interest column (or checking the summary total) shows the real all-in cost of borrowing, which is easy to lose sight of when only looking at the monthly payment.
What an amortization schedule does NOT show
A standard amortization schedule covers principal and interest only. For a mortgage specifically, your actual total monthly payment likely also includes property tax, homeowners insurance, PMI (if applicable), and HOA dues — none of which are part of the amortization schedule itself, since those costs don't reduce your loan balance. Use the mortgage calculator for the full monthly payment including those items, and the amortization schedule calculator specifically for the payment-by-payment principal/interest breakdown.
Frequently asked questions
Why does the Interest column decrease every single row?
Because interest each period is calculated on your current remaining balance, and that balance decreases with every payment. A smaller balance produces a smaller interest charge, which is why the Interest column steadily shrinks (and the Principal column steadily grows) from the first payment to the last.
Can I get a schedule that includes extra payments?
Yes — the amortization schedule calculator has an optional extra-payment field. Adding an extra amount reduces the Balance column faster than the standard schedule and shortens the total number of rows (payments) needed to reach a $0 balance.
Can I download the schedule instead of reading it on screen?
Yes — the amortization schedule calculator includes a "Download CSV" button that exports the complete table as a spreadsheet file you can open in Excel, Google Sheets, or Numbers.
Does the schedule change if my interest rate changes later (like with an ARM)?
A standard amortization schedule assumes a fixed rate for the full term. If you have an adjustable-rate mortgage, your actual future payments and balance will diverge from a fixed-rate schedule at each rate adjustment point — the schedule shown by this or any standard calculator represents what would happen if the rate never changed.