What is Amortization Schedule Calculator?
An amortization schedule is the complete payment-by-payment breakdown of a loan over its entire term. Each row in the schedule represents one payment and shows four key numbers: the payment date, the portion applied to principal, the portion applied to interest, and the remaining loan balance. Understanding your amortization schedule gives you visibility into exactly how your loan balance decreases over time and how much interest you pay at each stage.
The amortization formula distributes payments evenly over the loan term, but the split between principal and interest changes with every payment. In the early years, the outstanding balance is high, so interest charges consume most of each payment. As the balance decreases, interest charges shrink and more of each payment goes toward principal. This front-loaded interest structure is why extra payments in the first half of the loan term produce the largest interest savings.
This calculator generates a full amortization schedule for any fixed-rate loan — mortgage, auto, personal, or student. It supports both year-based and month-based terms, optional start dates, and extra payment modeling. The results include the monthly payment, total interest, total cost, and payoff date, with optional PDF and CSV exports for the complete schedule.
For a broader loan comparison that includes property taxes, insurance, and PMI, see our Loan Calculator. For mortgage-specific analysis with taxes and insurance, see our Mortgage Calculator.
When to Use This Calculator
- Before taking out any loan — see the full payment schedule and total interest cost.
- When comparing loan offers from different lenders — normalize by total cost, not just monthly payment.
- When planning extra payment strategies — see the exact interest savings and payoff acceleration.
- When considering refinancing — check your current balance and interest paid to calculate break-even.
- For annual financial review — verify your loan is amortizing as expected.
- When exporting records for tax or financial planning purposes.
Steps:
- Enter the loan amount (principal) — this is the total amount borrowed.
- Set the annual interest rate as a percentage — check current rates from Bankrate or your lender.
- Choose the loan term in years or months — 30 years and 15 years are the most common mortgage terms.
- Optional: set a start date to see the real-world payment timeline and payoff date.
- Optional: add extra monthly or one-time payments to see how they reduce total interest and shorten the loan term.
Formula
Monthly Payment (M) = P × [r(1+r)^n] / [(1+r)^n − 1]
Where:
P = Principal (loan amount)
r = Monthly interest rate (annual rate ÷ 12)
n = Total number of payments (years × 12 or months)
Interest Portion = Remaining Balance × r
Principal Portion = M − Interest Portion
New Balance = Previous Balance − Principal Portion
Example:
Principal: $200,000
Annual Rate: 6.0%
Term: 30 years (360 payments)
r = 0.06 ÷ 12 = 0.005
n = 360
M = 200,000 × [0.005(1.005)^360] / [(1.005)^360 − 1]
M = $1,199.10/month
Payment 1:
Interest: $200,000 × 0.005 = $1,000.00
Principal: $1,199.10 − $1,000.00 = $199.10
Balance: $200,000 − $199.10 = $199,800.90
Total Interest: ($1,199.10 × 360) − $200,000 = $231,676.00
Use Cases
- Generating a complete payment schedule for any fixed-rate loan before committing to the terms
- Comparing total interest cost between 15-year and 30-year loan terms for the same principal
- Modeling the impact of extra monthly or one-time payments on loan payoff time and interest savings
- Planning when to refinance by seeing how much principal has been paid at any point in the schedule
- Exporting the full schedule to PDF for documentation or to CSV for financial planning in a spreadsheet
- Understanding the front-loaded interest structure of amortizing loans and planning payment strategies accordingly
Key Benefits
- See every payment broken down into principal and interest for the full loan term
- Compare total interest cost with and without extra payments to quantify savings
- Export the complete schedule to PDF for documentation or CSV for spreadsheet analysis
- Model different loan terms, rates, and extra payment strategies side by side
- Understand the exact payoff date including the impact of extra payments
- Plan refinancing decisions by seeing the remaining balance at any point in the schedule
Pro Tips
- Make extra payments as early as possible — each dollar of principal reduced in year 1 eliminates interest for the remaining 29 years
- Specify that extra payments go toward principal, not future payments — most lenders have a checkbox or form for this
- Use the bi-weekly payment strategy: pay half your monthly payment every two weeks for one extra payment per year with no budget change
- If your rate is above current market rates, use the amortization schedule to calculate the break-even point for refinancing
- Export the schedule and review it annually — seeing your balance drop is motivating and helps with financial planning
- Consider rounding up your payment to the nearest $50 or $100 — small increases compound into significant savings over 30 years
Common Mistakes to Avoid
- Focusing only on the monthly payment without considering total interest cost — a 30-year term costs nearly double the loan amount in interest
- Not making extra payments in the first 5 years — the earlier you reduce principal, the more interest you save over the remaining term
- Assuming extra payments reduce the next payment — they reduce the balance, which lowers all future interest charges
- Choosing a longer term for lower payments without calculating the total interest difference — often $100,000+ more
- Ignoring the amortization schedule when considering refinancing — you need to know your current balance and interest paid
- Not verifying that extra payments are applied to principal — some lenders apply them to future payments instead
Key Terms Explained
- Amortization: The process of repaying a loan through regular payments that include both principal and interest over a fixed period
- Principal: The original loan amount borrowed, which decreases with each payment
- Interest: The cost of borrowing money, calculated as a percentage of the remaining principal balance
- Amortization Schedule: A table showing each payment's breakdown into principal and interest, along with the remaining balance
- Extra Payment: An additional amount applied to principal beyond the scheduled payment, reducing the balance faster
- Payoff Date: The date when the loan balance reaches zero — accelerated by extra payments
- Front-Loaded Interest: The characteristic of amortizing loans where early payments are predominantly interest
Related Concepts
- Loan Calculator: For a broader comparison that includes different loan types and payment scenarios, see our Loan Calculator.
- Mortgage Calculator: For mortgage-specific analysis including taxes, insurance, PMI, and HOA fees, see our Mortgage Calculator.
- Compound Interest Calculator: Understanding how interest compounds helps explain why extra payments are so powerful — each dollar of principal reduction eliminates compound interest for the remaining term.
Example
Marcus and Elena have a $320,000 mortgage at 6.75% over 30 years. Their monthly payment is $2,068. Over 30 years, they will pay $424,416 in interest — more than the loan amount itself. They decide to add $400/month in extra payments. The amortization schedule shows their loan pays off in 22.3 years instead of 30, and they save $168,932 in total interest. Their total payment drops from $744,416 to $575,484. They also make a one-time $10,000 extra payment in year 3, which saves an additional $28,400 in interest. The schedule shows exactly how each extra payment shifts the principal/interest split in their favor.
Interpreting Your Results
The monthly payment is your fixed obligation — the amount due each month for the full loan term. This number does not change for a fixed-rate loan. The total interest is the true cost of borrowing — it represents everything you pay above the original loan amount. On a 30-year loan at 6.5%, total interest typically exceeds the principal, meaning you pay more than double the original loan amount.
The amortization schedule reveals the front-loaded nature of amortizing loans. In year one, approximately 75–90% of each payment goes to interest. This is why making extra payments early has such a dramatic impact — you are reducing the principal balance before decades of future interest have accrued on it.
The payoff date changes when you add extra payments. Each extra dollar of principal reduces the remaining balance, which lowers subsequent interest charges, which accelerates principal reduction in a virtuous cycle. The schedule shows the exact month your loan will be paid off with your specific extra payment strategy.