Amortization Schedule Calculator

This calculator builds a complete amortization schedule from your loan details. It shows every payment split into interest and principal, the remaining balance after each month, and the month PMI stops. Add an extra monthly payment to see how much interest it removes and how many months it takes off the loan before you commit to the higher payment.

Your loan details

Dollar amounts and percentages only. Every calculation runs in your browser.

Enter a value to see results

Amortization schedule

Every row is one payment. The Payment column is principal and interest, including any extra payment you entered; property tax, insurance and HOA are left out because they are not part of the loan. Switch to the yearly view to see whole years at once.

Monthly breakdown for the first 12 payments
Month Payment Interest Principal Balance PMI
Enter a value to see results
Schedule view

How this is calculated

The loan amount is the home price minus the down payment. The monthly rate is the annual rate divided by 100 and by 12, and the number of payments is the term in years multiplied by 12. The monthly principal and interest payment comes from the standard annuity formula, the same one lenders use for a fixed-rate loan. That payment is kept at full precision for every month of the simulation; only the numbers you see are rounded to the cent.

P = home price - down payment r = annual rate / 100 / 12 n = term in years * 12 payment = P * r * (1 + r)^n / ((1 + r)^n - 1) when r > 0 payment = P / n when r = 0 interest(t) = balance(t-1) * r principal(t) = payment + extra - interest(t) balance(t) = balance(t-1) - principal(t) final month: principal = remaining balance, so balance = 0 PMI stops on the first month where balance / home price <= 0.78

Each month the interest charge is the previous balance times the monthly rate, and the principal reduction is the payment plus any extra payment minus that interest. The balance is then reduced by the principal. In the final month the principal is set to the remaining balance, so the loan closes at exactly zero and the last payment is smaller than the others.

The PMI column follows the balance: it is charged while the balance is above 78 percent of the home price and stops on the first month the ratio is at or below that threshold. Total interest is the payment times the number of payments minus the loan amount, or, when an extra payment is entered, the sum of the monthly interest charges up to payoff. Interest share is total interest divided by everything you pay on the loan.

Assumptions

Frequently asked questions

What is an amortization schedule?

An amortization schedule lists every payment on a loan in order, and splits each one into the interest charge and the principal reduction. The balance line shows what is still owed after that payment. Early payments are mostly interest because the balance is large, so the balance barely moves. Later payments are mostly principal. This calculator builds the schedule from the loan amount, the interest rate and the term, using the same monthly payment for every period except the last one, which is adjusted by a few cents to close the loan exactly.

How does an extra monthly payment change the schedule?

An extra payment goes straight to principal, so it does not reduce this month's interest charge, it reduces every later one. The balance falls faster, more of each following payment is principal, and the loan ends earlier. The schedule rebuilds with the new payoff month, and the results panel shows the interest saved and the months removed compared with the same loan without the extra amount. The last payment is smaller than the regular one whenever the loan closes mid-schedule.

Why does the PMI column stop partway through the schedule?

Private mortgage insurance is normally charged while the loan balance is above 80 percent of the home price, and it is dropped once the balance falls to 78 percent. This schedule simulates the balance month by month, so the PMI column shows the charge for each month it applies and then stops on the month the threshold is crossed. Paying extra principal reaches that threshold sooner, which shortens the PMI period as well as the loan.

Why is the last payment different from the others?

The monthly payment is calculated to full precision, while every row in the table is rounded to the cent for display. Rounding cannot change the real balance, so the final payment absorbs the leftover cents and the balance closes at exactly zero. On a 30 year loan the difference is usually under a dollar. If you add an extra payment, the final payment can be much smaller, because the loan ends in the middle of the original schedule.

Do the payment rows include property tax and insurance?

No. The table tracks the loan only: interest, principal and the remaining balance, plus PMI while it applies. Property tax, homeowners insurance and HOA dues are shown in the results panel as monthly amounts and are included in the first payment figure there, because lenders collect them in the same bill. They are not part of the loan balance and they do not earn interest, so adding them to every row would make the schedule harder to read.

New to the math? Read how mortgage payments are calculated or the guide to PMI.

Estimates only, not financial advice. Results depend on the inputs you enter and on lender-specific fees this tool does not model. See Disclaimer.