This amortization schedule calculator generates a complete month-by-month payment table showing exactly how much of each payment goes to principal and interest — and your remaining balance after every payment — using the standard fixed amortization formula. To see how extra payments change this schedule, visit our Mortgage Payoff Calculator.
| Month | Principal | Interest | Total Payment | Remaining Balance |
|---|
What Your Amortization Schedule Reveals That Your Monthly Payment Does Not
In year 1 of a $350,000 mortgage at 7% over 30 years, approximately 83% of every monthly payment goes to interest and only 17% reduces your actual balance. Most borrowers know their monthly payment down to the dollar but have never seen this breakdown laid out month by month. The amortization schedule is the document that makes this visible — showing you exactly how much equity you build each month versus how much you send to your lender as interest.
The front-loading of interest in standard amortization is not hidden — it is mathematically built into the formula. Because your balance is largest at the beginning of the loan, the interest charge on that large balance consumes most of each early payment. As payments continue and the balance slowly declines, the interest portion of each payment shrinks and the principal portion grows. By year 25 of a 30-year loan, the split reverses — most of each payment is now principal. But most homeowners refinance, sell, or pay off their loan long before year 25, meaning the majority of the interest they pay accumulates in the early years they are most likely to actually occupy the loan.
The amortization schedule calculator produces this full table instantly — all 360 rows for a 30-year loan, or the exact number of periods for any term you enter. You can see not just what year 1 looks like but what year 5 looks like when you plan to refinance, what year 7 looks like when you plan to sell, and what your balance will be at any future date you care about.
Principal vs Interest Breakdown by Month — On a $300,000 loan at 6.75%, your first monthly payment of $1,945 splits into $1,688 in interest and $257 in principal. By month 120 — year 10 — the same payment splits into $1,490 in interest and $455 in principal. By month 240 — year 20 — it is $1,049 in interest and $896 in principal. The schedule shows this progression for every single payment.
Remaining Balance at Any Point in the Loan — After 5 years of payments on a $350,000 loan at 7%, your remaining balance is approximately $326,000 — you have reduced the principal by only $24,000 despite paying over $130,000 in total payments during that period. Seeing this number before selling or refinancing helps you understand exactly what your loan payoff requirement will be.
Total Interest Paid to Any Date — The amortization schedule cumulates your total interest paid from month 1 to any payment you choose. A homeowner who sells in year 7 can see exactly how much total interest they paid during their ownership — typically $140,000 to $180,000 on a $350,000 loan at current rates — which factors into the real cost of ownership calculation.
Effect of Extra Payments on the Schedule — Adding a $200 monthly extra payment to a $300,000 loan at 6.75% removes approximately 56 rows from the bottom of the schedule — the loan ends in month 304 instead of month 360. The schedule shows exactly which month the loan pays off and what the final partial payment amount is.
Tax Planning with Interest Data — Homeowners who itemize deductions can use the annual interest totals from the amortization schedule to verify or project their mortgage interest deduction. In year 1 of a $350,000 loan at 7%, total annual interest is approximately $24,250 — a significant deduction for taxpayers in the 22% or higher bracket.
Drawbacks of Standard Amortization Schedules
An amortization schedule based on your original loan terms becomes inaccurate the moment you make any payment that differs from the scheduled amount — an extra payment, a late payment, or a partial payment. Most online amortization calculators assume every payment is made on the exact due date for the exact scheduled amount. Your actual remaining balance may differ from the schedule’s projection if your payment history deviates from this assumption.
The schedule also becomes outdated after a refinance. When you refinance, your original amortization schedule is replaced by an entirely new one based on the refinanced balance, rate, and term. Borrowers who refinance multiple times accumulate significant total interest that no single amortization schedule captures — you need a separate schedule for each loan period to see the complete picture of your lifetime mortgage interest cost.
Standard amortization schedules do not account for property taxes, insurance, or PMI — costs that are part of your actual monthly housing payment but are not part of the loan’s amortization structure. Your escrow payment can add $400 to $800 per month to the base principal and interest payment shown in any amortization table, making the schedule an incomplete picture of your true monthly housing cost. For a projection of how extra payments would change your payoff date and total interest, visit the Mortgage Payoff Calculator.
Standard Fixed Amortization Formula Method
The amortization schedule calculator uses the standard fixed amortization formula to generate every row of the payment table. The monthly payment is calculated once using the formula: payment equals loan amount multiplied by the monthly rate divided by one minus one plus the monthly rate to the negative power of the total number of payments. This payment amount stays constant for every row in the schedule. For each row, the interest component equals the previous month’s ending balance multiplied by the monthly rate. The principal component equals the fixed payment minus that month’s interest. The ending balance equals the previous balance minus the principal component. The calculator assumes a fixed interest rate throughout the entire term, payments made on the exact due date each month, and no prepayment of any amount at any point.
Rule of 78s Method
The Rule of 78s is an alternative amortization method used by some consumer lenders — particularly for short-term personal loans and older auto loan products. It front-loads interest even more aggressively than standard amortization by assigning a larger share of total interest to early payments using a sum-of-digits weighting. On a 12-month loan, the first month’s interest equals 12/78 of the total interest, the second month equals 11/78, and so on down to 1/78 in the final month.
The Rule of 78s is less common today and is prohibited for loans longer than 61 months in the United States under the Truth in Lending Act. It suits short-term lenders who want to ensure they collect the majority of their interest return early in the loan life. Standard amortization suits virtually all long-term mortgage and installment loan products and is far more transparent about the true cost of early payoff. If you have a consumer loan that uses the Rule of 78s, your actual payoff amount may be higher than a standard amortization schedule would suggest — always request a payoff quote directly from your lender before assuming the schedule matches.
Tips for Using Your Amortization Schedule
Print or save your schedule at origination and keep it with your loan documents — Most lenders provide an amortization schedule at closing, but borrowers rarely keep it. Having the original schedule lets you verify that your lender is applying payments correctly and track your balance against the projected figures without relying on your servicer’s online portal.
Look at year 10 of the schedule before you look at year 1 — Most borrowers focus on the early rows where the interest split is most painful. The more useful exercise is finding the row that corresponds to when you plan to sell or refinance — whether that is year 5, year 7, or year 10 — and reading your remaining balance directly from the schedule. That number is your loan payoff requirement at that future date.
Use the schedule to verify your servicer’s balance statements — If your servicer’s monthly statement shows a remaining balance that does not match your amortization schedule, the discrepancy may indicate a payment application error, a rate adjustment you were not notified of, or an escrow shortage rolled into the principal. Your schedule gives you an independent baseline to identify errors early.
Run the schedule with your actual loan start date, not a rounded date — Amortization schedules are sensitive to the exact origination date because interest accrues daily. A loan that closes on March 15 has a different first payment amount than one that closes on March 1 due to the prepaid interest collected at closing. Entering your exact closing date produces a schedule that matches your actual payment history more precisely.
Check the cumulative interest column at the year mark you plan to sell — The schedule’s cumulative interest column shows you exactly how much total interest you will have paid from origination to any specific payment. If you plan to sell in year 7, the cumulative interest at payment 84 tells you the total cost of your borrowing during your ownership — a number that factors directly into your true cost of homeownership calculation alongside appreciation, maintenance, and transaction costs.
Dealing with an Amortization Schedule That Does Not Match Your Servicer’s Records
Request a complete payment history from your servicer and compare it row by row against your schedule — Servicers are required to provide a payment history upon request under the Real Estate Settlement Procedures Act. Comparing each payment date, amount applied to principal, amount applied to interest, and ending balance against your original schedule identifies exactly where any discrepancy began — which is the starting point for any correction request.
Identify whether extra payments were applied to principal or to the next scheduled payment — The most common reason a servicer’s balance differs from your schedule is that extra payments were applied to advance your next payment due date rather than reduce the principal balance. If your balance is higher than your schedule projects, check whether your extra payment history shows credits to “next payment” rather than “principal reduction.” Correcting the application method going forward and requesting retroactive correction for past misapplied payments closes the gap.
Generate a new amortization schedule from your current actual balance if you have made extra payments — If you have made extra payments that were correctly applied to principal, your current balance is lower than your original schedule shows — meaning the original schedule is now incorrect. Run the amortization schedule calculator using your current remaining balance, your current rate, and the number of payments remaining as your new inputs. The new schedule from this point forward accurately reflects your accelerated payoff trajectory. Use the Adjustable-Rate Mortgage Calculator to confirm your new projected payoff date based on the corrected starting balance.
Escalate to your state’s banking regulator if your servicer cannot explain a balance discrepancy — Servicers are regulated at both the federal and state level. If your servicer cannot reconcile the balance discrepancy with documentation and a corrected payment history, filing a complaint with your state’s department of financial institutions or the Consumer Financial Protection Bureau typically produces a formal investigation and a written response within 30 to 60 days. Keep copies of all correspondence and your original amortization schedule as documentation.
Related: Mortgage Payoff Calculator | Mortgage Calculator