How to Calculate an Amortization Schedule: Complete Guide
Learn how loan amortization works, how to build an amortization table step by step, and how extra payments can save you tens of thousands in interest on your mortgage or loan.
What Is Amortization and Why It Matters
Amortization is the process of spreading a loan into a series of fixed payments over time. Each payment covers both interest and principal, but the ratio between them shifts dramatically over the life of the loan. In the early years, most of your payment goes to interest; in the later years, most goes to principal. This front-loaded interest structure is why lenders profit most from loans held to full term, and why paying off a loan early saves a disproportionately large amount of money. The word amortization comes from the Latin 'amortire,' meaning 'to kill' — you are literally killing the debt over time. Amortization applies to any installment loan with a fixed end date: mortgages, auto loans, personal loans, and student loans. Credit cards and HELOCs are typically not amortized because they are revolving credit without a fixed payoff timeline. Understanding your amortization schedule gives you a complete picture of where every dollar of every payment goes. It reveals the true cost of borrowing, shows exactly when you will reach key milestones (like 20% equity for PMI removal), and helps you evaluate whether refinancing or making extra payments makes financial sense. An amortization schedule is simply a table listing every payment from the first to the last, showing the date, payment amount, interest portion, principal portion, and remaining balance.
The Amortization Formula Step by Step
Building an amortization schedule requires two formulas. First, calculate the fixed monthly payment using 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 payments. For a $250,000 mortgage at 7% for 30 years: r = 0.07/12 = 0.005833, n = 360. M = 250,000 × [0.005833 × (1.005833)^360] / [(1.005833)^360 - 1] = 250,000 × [0.005833 × 8.1165] / [8.1165 - 1] = 250,000 × 0.04735 / 7.1165 = 250,000 × 0.006653 = $1,663.26 per month. Second, for each month, calculate: Interest = Remaining Balance × Monthly Rate, Principal = Monthly Payment - Interest, New Balance = Old Balance - Principal. Month 1: Interest = $250,000 × 0.005833 = $1,458.33, Principal = $1,663.26 - $1,458.33 = $204.93, New Balance = $249,795.07. Month 2: Interest = $249,795.07 × 0.005833 = $1,457.14, Principal = $206.12, New Balance = $249,588.95. Notice how the principal portion grows each month as the balance shrinks and less interest accrues. By month 180 (halfway), your payment split is roughly 60% interest and 40% principal. By month 300, it flips to about 30% interest and 70% principal.
Reading an Amortization Table
An amortization table has five core columns: Payment Number, Payment Amount, Interest Paid, Principal Paid, and Remaining Balance. Some tables also include a Cumulative Interest column showing total interest paid to date. Here is what to look for in your table. The crossover point is the month where principal exceeds interest for the first time. On a 30-year mortgage at 7%, this happens around month 215 out of 360 — meaning for the first 18 years, more than half of each payment is interest. The total interest line at the bottom reveals the true cost of borrowing. That $250,000 mortgage at 7% for 30 years has total payments of $598,772 — meaning you pay $348,772 in interest, or 139% of the original loan amount. The equity buildup curve shows how slowly equity grows at first. After 5 years (60 payments) of $1,663/month, you have paid $99,796 total but only $15,663 went to principal. Your remaining balance is still $234,337 — you have only paid off 6.3% of the loan despite making 16.7% of total payments. After 10 years, you have paid off about 14% of principal. After 20 years, about 40%. The final 10 years account for 60% of principal reduction. This exponential curve is the fundamental reason why holding a mortgage for 30 years is extraordinarily expensive and why even small extra payments early on have an outsized impact.
How Extra Payments Impact Your Amortization
Extra payments go entirely toward principal, which recalculates the interest for every future month. The earlier you make extra payments, the more you save because you eliminate compounding interest on that principal for the remaining loan term. On our $250,000 mortgage at 7% for 30 years ($1,663.26/month), adding $200 extra per month from the start produces dramatic results: the loan is paid off in 22.3 years instead of 30, saving 92 months of payments. Total interest drops from $348,772 to $240,188 — a savings of $108,584. The total extra you paid is only $200 × 268 months = $53,600, yet you saved over $108,000. That is a return of roughly $2 saved for every $1 of extra payment. Even one extra payment per year (paying $1,663 once extra annually) cuts 4.5 years off a 30-year mortgage and saves about $63,000 in interest. The bi-weekly payment strategy (paying half the monthly amount every two weeks) achieves a similar effect because 26 half-payments equal 13 full monthly payments per year. Lump sum payments also help enormously. A $10,000 lump sum applied in year 2 of our example mortgage saves approximately $28,000 in interest over the remaining loan life. The same $10,000 applied in year 20 saves only about $3,500. Timing matters because early principal reduction prevents years of compounding interest.
Amortization for Different Loan Types
While the basic math is the same, amortization works differently across loan types. Fixed-rate mortgages have the simplest amortization: payment stays the same for 15 or 30 years, and the schedule is fully predictable from day one. Adjustable-rate mortgages (ARMs) have an initial fixed period (typically 5, 7, or 10 years) followed by annual rate adjustments. The amortization schedule changes at every rate reset, which can significantly increase or decrease your payment. A 5/1 ARM at 5.5% on $250,000 starts at $1,419/month, but if rates rise to 8.5% at year 6, the payment jumps to approximately $1,805 — a $386 monthly increase. Auto loans are typically 36-72 months and fully amortized. A $35,000 car loan at 6.5% for 60 months has a payment of $685. Total interest is $6,100. Because auto loans are shorter, the interest-to-principal ratio is less extreme than mortgages. Student loans offer multiple repayment plans. Standard 10-year repayment is fully amortized. Income-driven plans (IBR, PAYE, REPAYE) may result in negative amortization where payments do not cover the interest and the balance actually grows. A $50,000 student loan at 6% on a standard 10-year plan costs $555/month and $16,600 in interest. On income-driven repayment at $200/month, the balance might grow to $58,000 before the 20-25 year forgiveness kicks in. Understanding your specific amortization schedule is essential for making informed financial decisions about refinancing, extra payments, and loan selection.
Related Free Tools
Frequently Asked Questions
What is the difference between amortization and depreciation?
Amortization and depreciation both spread costs over time, but they apply to different things. Amortization refers to paying off a loan in installments (or spreading the cost of an intangible asset in accounting). Depreciation refers to the declining value of tangible physical assets like cars, equipment, or buildings. In personal finance, amortization almost always means the loan payoff schedule.
Why do I pay so much interest at the start of a mortgage?
Interest is calculated on the outstanding balance each month. At the start, your balance is at its highest, so the interest charge is largest. On a $300,000 loan at 7%, month one interest is $1,750 out of a $1,996 payment — only $246 reduces the principal. As you pay down the balance over years, less interest accrues each month, and more of your fixed payment goes to principal.
Can I get an amortization schedule from my lender?
Yes, most lenders provide an amortization schedule at closing and on request. It is also included in the Loan Estimate and Closing Disclosure documents for mortgages. Many lenders offer it through their online portal. However, you can easily calculate your own using our free amortization calculator, which also lets you model extra payments and see how they change the schedule.