Loan Amortization Schedule Calculator
Generate a month-by-month loan amortization schedule.
See how each payment splits between principal and interest over time.
What Is Loan Amortization?
When you take out a loan — for a house, a car, or anything else — you make the same monthly payment every month. But here is the surprising part: even though your payment stays the same, the split between principal and interest changes every single month.
In the early months, most of your payment goes toward interest (the bank’s profit). In the later months, most of your payment goes toward principal (actually paying off what you owe).
Think of it like a seesaw. At the start, interest is heavy and principal is light. Over time, they gradually swap places.
The Monthly Payment Formula
M = P × [r(1+r)^n] / [(1+r)^n - 1]
Where:
- M = Monthly payment amount
- P = Principal (the total loan amount you borrowed)
- r = Monthly interest rate (annual rate divided by 12)
- n = Total number of monthly payments (loan term in years × 12)
How Each Monthly Payment Is Split
For any given month:
- Interest portion = Remaining Balance × Monthly Rate
- Principal portion = Monthly Payment - Interest Portion
- New Balance = Previous Balance - Principal Portion
This is why the schedule matters. On a $300,000 mortgage at 6.5% over 30 years, your first payment of $1,896 splits as:
- Interest: $1,625 (86% of payment!)
- Principal: $271 (only 14%)
By payment number 300, that same $1,896 splits as:
- Interest: $120 (6%)
- Principal: $1,776 (94%)
Worked Example
Loan amount: $200,000 Annual interest rate: 6% Loan term: 30 years (360 months)
Monthly rate: 6% / 12 = 0.5% = 0.005 Number of payments: 30 × 12 = 360
Monthly payment = $200,000 × [0.005 × (1.005)^360] / [(1.005)^360 - 1] Monthly payment = $1,199.10
Total paid over 30 years: $1,199.10 × 360 = $431,676 Total interest paid: $431,676 - $200,000 = $231,676
That means you pay more in interest than the original loan amount! This is why understanding amortization is so important.
Why This Calculator Is Useful
- Home buyers: See exactly how much interest you will pay over the life of a mortgage
- Refinancing decisions: Compare your current schedule with a new loan to see if refinancing saves money
- Extra payments: Understanding amortization helps you see why even small extra payments toward principal can save thousands in interest
- Financial planning: Know exactly when your loan will be paid off
Important Terms
| Term | Meaning |
|---|---|
| Principal | The original amount you borrowed |
| Interest | The cost the bank charges you for borrowing their money |
| Amortization | The process of paying off a loan through regular payments over time |
| Remaining Balance | How much you still owe at any point during the loan |