An amortization schedule answers a question that a monthly payment alone cannot: where does the money go? It shows how each loan payment is divided between interest and principal, then tracks the balance that remains. Once you understand those columns, you can compare payoff plans without guessing how much progress a payment makes.
Our mortgage amortization calculator produces a monthly schedule and a downloadable CSV. It also shows a compact first-payment breakdown beneath the calculation button. This guide explains how to read those results for a fixed-rate mortgage with monthly payments. Adjustable rates, interest-only periods, and unusual payment arrangements require a different model.
Identify the starting loan balance
The principal is the amount borrowed. In this calculator, it equals the home price minus the down payment. A $400,000 home with an $80,000 down payment produces a $320,000 starting loan balance. That balance is not the same as the home’s value, and it does not include separately paid closing costs.
If you are evaluating an existing loan, the relevant starting figure may instead be its current principal balance. Be careful with the term: entering a current balance with a fresh 30-year term models repayment over another 30 years. It does not reproduce the remaining schedule of a loan that already has several years of payments behind it.
Read the five schedule columns
Month is the payment number, beginning with one. Payment is the amount applied to principal and interest that month, including the entered extra payment where a balance remains. Principal is the part that reduces the debt. Interest is the modeled borrowing cost for the period. Balance is what remains immediately after that payment.
Property taxes and homeowners insurance are separate housing costs. They appear in the calculator’s monthly housing estimate and compact payment table, but not in the loan amortization rows. Sending money into escrow does not reduce mortgage principal. Keeping those amounts separate avoids overstating how quickly the loan is being repaid.
For each row, principal plus interest should equal payment, apart from small display-rounding differences. The previous balance minus principal should equal the new balance. These two relationships are a useful way to inspect a downloaded schedule without needing to understand every part of the payment formula.
Walk through the first payment
Consider an illustrative $320,000 loan at a fixed annual interest rate of 6.5% over 30 years, with no extra payments. The modeled monthly principal-and-interest payment is approximately $2,022.62. The first month’s interest is $320,000 multiplied by 0.065 and divided by 12, or approximately $1,733.33. About $289.28 goes toward principal, leaving roughly $319,710.72.
The second month begins with that lower balance. With the same rate, the interest portion is slightly smaller and the principal portion slightly larger. The scheduled principal-and-interest payment remains level in this fixed-rate model. The CFPB’s explanation of amortization describes this general repayment pattern.
The displayed first-row amounts may appear to add to a cent less than the displayed payment because the model retains more precision internally than it prints. Do not round every intermediate calculation by hand and expect every later row to match perfectly. A lender’s own rounding and servicing rules can also create small differences.
What changes when you pay extra
In the calculator, an extra payment is applied toward principal each month. This lowers the balance used for future interest calculations. On the illustrative loan above, entering $500 in extra monthly principal raises the initial loan payment to approximately $2,522.62 and shortens the modeled repayment period. The housing estimate also adds your property tax and insurance inputs.
Compare the original and extra-payment schedules at the same payment number. The difference in balances shows the additional progress made by that date. Compare total interest as a second measure. The final payment can be smaller than the regular payment plus extra because the model never requires repayment of more than the remaining debt and accrued interest.
Before using that plan with a real mortgage, check how the servicer handles extra payments and whether your loan has applicable restrictions or charges. Ask how to designate an additional amount for principal and verify the next statement. Our model assumes immediate monthly principal application and no prepayment penalty; it does not inspect your contract.
Use the CSV for a focused comparison
Download the baseline schedule before changing an input. Name the file so that the loan amount, rate, term, and extra-payment assumption are easy to recognize. Download a second file for the revised scenario. Comparing two files with identical names and no saved assumptions invites mistakes, especially if you return to them several weeks later.
In a spreadsheet, locate month 12, month 60, and the final row. Compare the remaining balances and add the interest column for the period that matters to you. Someone expecting to sell in five years may care more about the balance at month 60 than the total interest over 30 years. Sale costs and the future home value still need their own assumptions.
Know what the schedule cannot tell you
A loan balance is only one part of home equity. Equity also depends on the property’s value and other debts secured by it. The calculator does not predict appreciation, selling expenses, repairs, or a lender’s payoff quote. A payoff quote may include interest through a particular date and other applicable amounts, so it need not equal the last balance displayed on an old statement.
Use the interest-rate comparison guide when changing borrowing costs, and the 15-year versus 30-year guide when comparing terms. Review a lender’s Loan Estimate for the actual offer. The schedule is a transparent calculation tool: it helps explain a repayment path, while your loan documents establish the real obligation.