How to Calculate Loan Amortization
Learn how loan amortization works, how to build an amortization schedule, and how extra payments accelerate your payoff. Covers mortgages, auto loans, and personal loans.
What Is Loan Amortization?
Amortization is the process of paying off a loan through regular installments over a set period, where each payment covers both interest and principal. The word comes from the Latin "amortire," meaning "to kill," because each payment kills off a portion of the debt. An amortization schedule is a table showing every payment over the life of the loan, breaking down exactly how much goes to interest and how much goes to principal reduction. Understanding amortization reveals why loans are structured the way they are and why early payments are disproportionately interest-heavy. It also explains why making extra principal payments is so effective at reducing total interest costs and shortening the loan term.
How to Calculate the Monthly Payment
The fixed monthly payment for an amortizing loan is calculated using the formula M = P[r(1+r)^n] / [(1+r)^n - 1], where P is the loan principal, r is the monthly interest rate (annual rate divided by 12), and n is the total number of monthly payments. For a $25,000 auto loan at 5.5% APR over 60 months, the monthly rate is 0.055/12 = 0.004583, and the payment is $25,000 * [0.004583 * (1.004583)^60] / [(1.004583)^60 - 1] = approximately $477. This single fixed payment remains constant for the entire loan term. What changes each month is the split between how much of that $477 goes to interest and how much reduces the principal balance. In the first month, interest is $25,000 * 0.004583 = $114.58, so $362.42 goes to principal. Each subsequent month, the interest portion shrinks and the principal portion grows.
Building an Amortization Schedule Step by Step
To build an amortization schedule, start with four columns: Payment Number, Interest Payment, Principal Payment, and Remaining Balance. For each row, first calculate the interest by multiplying the remaining balance by the monthly interest rate. Then subtract that interest from the fixed monthly payment to get the principal portion. Finally, subtract the principal portion from the remaining balance to get the new balance. Repeat for every payment until the balance reaches zero. Using the auto loan example: Month 1 starts with a $25,000 balance, $114.58 in interest, $362.42 in principal, leaving a balance of $24,637.58. Month 2 starts with $24,637.58, interest is $112.92, principal is $364.08, leaving $24,273.50. By the final month (60), the balance is small enough that nearly the entire $477 payment goes to principal. Building this schedule by hand for even a few months gives you an intuitive understanding of how your loan actually works.
Why Loans Are Front-Loaded with Interest
The front-loading of interest in an amortizing loan is not a trick by lenders; it is simply a consequence of how interest is calculated. Interest is always charged on the outstanding balance. In the early months, the balance is large, so the interest charge is large, leaving less room in the fixed payment for principal reduction. As you pay down the balance, less interest accrues each month, so more of your payment goes toward principal. On a 30-year $300,000 mortgage at 6.5%, you pay approximately $382,000 in total interest over the life of the loan. After 10 years of payments (one-third of the loan term), you have paid roughly $228,000 in total payments, but only $41,000 has gone to principal. You still owe about $259,000. It is not until around year 20 that the principal-to-interest ratio in each payment flips to favor principal. This front-loading effect is much less dramatic on shorter-term loans like 5-year auto loans.
The Impact of Extra Payments on Amortization
Extra payments directed toward principal alter the amortization schedule dramatically. When you make an extra principal payment, you skip ahead in the schedule because the balance drops to a level that was not supposed to be reached for months or years. Every dollar of extra principal eliminates all the future interest that dollar would have generated. On a $300,000 mortgage at 6.5%, making a one-time extra payment of $10,000 in year one saves approximately $30,000 in interest and shortens the loan by about 14 months. The same $10,000 extra payment in year 15 saves only about $12,000 in interest and shortens the loan by 10 months. This diminishing return illustrates why early extra payments are the most valuable. Some borrowers make one extra monthly payment per year, which on a typical 30-year mortgage cuts approximately 4-5 years off the term.
Amortization Across Different Loan Types
While the amortization principle is the same, different loan types produce very different schedules. A 30-year mortgage has the most extreme front-loading of interest because the term is so long. A 15-year mortgage has less front-loading and builds equity much faster. A 5-year auto loan amortizes relatively quickly, with the principal-to-interest crossover happening within the first year or two. Student loans with 10-year terms fall in between. Some loans, like interest-only mortgages, do not amortize at all during the interest-only period; your balance stays flat while you pay only interest, and then payments spike when the amortization period begins. Understanding the amortization profile of each loan you carry helps you make informed decisions about which debts to pay extra on and which to let ride on their standard schedules.
Negative Amortization: When Your Balance Grows
Negative amortization occurs when your monthly payment is not enough to cover the interest charge, causing unpaid interest to be added to your principal balance. Your loan balance actually increases over time instead of decreasing. This situation arises with certain adjustable-rate mortgages (ARMs) that have payment caps, some income-driven student loan repayment plans, and any loan where the minimum payment is set below the interest-only amount. For example, if your monthly interest charge is $1,500 but your payment is capped at $1,200, the unpaid $300 is added to your balance each month. After a year, you owe $3,600 more than when you started. Negative amortization is particularly dangerous because borrowers can end up owing far more than they originally borrowed. If you are in a negative amortization situation, the priority should be increasing your payments to at least cover the monthly interest.
Using Amortization Tables for Financial Planning
An amortization schedule is more than a curiosity; it is a practical planning tool. Use it to determine exactly how much equity you will have in your home at any future date, which matters for refinancing decisions and home equity line of credit planning. Use it to compare the total interest cost of different loan offers: a lower monthly payment does not always mean a better deal if the total interest paid over the life of the loan is significantly higher. Use it to plan extra payment strategies by seeing exactly how specific extra amounts change the payoff date and total interest. Run scenarios like "What if I put my annual bonus toward the mortgage each year?" or "What if I refinance to a 15-year term?" The concrete numbers in an amortization schedule make abstract financial decisions tangible and help you commit to a strategy with confidence.
Try These Calculators
Put what you learned into practice with these free calculators.
Related Guides
How to Calculate Mortgage Payments
Learn how to calculate mortgage payments step by step. Understand the mortgage payment formula, principal vs. interest breakdown, escrow, PMI, and how to use amortization schedules.
Understanding Compound Interest
Learn how compound interest works and why it is the most powerful force in personal finance. Covers the compound interest formula, compounding frequency, the Rule of 72, and real-world applications.
How to Calculate Car Loan Payments
Learn how to calculate car loan payments, understand total loan cost, compare financing options, and avoid common auto financing mistakes that cost you thousands.
Guide to Debt Snowball vs. Debt Avalanche
Compare the debt snowball and debt avalanche methods for paying off debt. Learn how each strategy works, which saves more money, and which is better for your situation.