Real Estate
The Amortization Schedule
Why your early payments are almost all interest — and how to see it row by row.
An amortizing loan keeps the payment constant but silently shifts what that payment buys. Early on you are mostly renting money (interest); only slowly do you start buying the asset (principal). Understanding the schedule explains refinancing, early-repayment maths, and why a small rate change moves the payment so much. The example is a $200,000 loan at 6% over 30 years.
Assumptions
- Loan principal
- $200,000
- Annual rate
- 6%
- Term
- 30 years (360 months)
- Monthly payment
- $1,199.10
Step by step
1. 1 · The fixed payment
Solve for the level payment that exactly retires the loan over periods at periodic rate : . Here , , , giving A \approx \1{,}199.10$ per month. This single number never changes.
2. 2 · Split each payment
Each month, interest is charged on the remaining balance: . Whatever is left of the fixed payment reduces principal: . In month one, interest is 200000 \times 0.005 = \1000$199.10$ goes to principal.
3. 3 · Watch the crossover
As the balance falls, interest shrinks and principal grows — the same payment buys more of the asset each month. The 'crossover point', where principal first exceeds interest, arrives surprisingly late (around year 19 of a 30-year 6% loan). This is why total interest paid can approach the size of the loan itself.
The spreadsheet
The full model as a table — download it as a CSV to open in any spreadsheet app.
| Month | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | 1199.10 | 1000.00 | 199.10 | 199800.90 |
| 2 | 1199.10 | 999.00 | 200.10 | 199600.80 |
| 12 | 1199.10 | 987.89 | 211.21 | 197366.79 |
| 60 | 1199.10 | 930.63 | 268.47 | 185857.51 |
| 120 | 1199.10 | 838.06 | 361.04 | 167249.62 |
| 240 | 1199.10 | 533.49 | 665.61 | 106031.19 |
| 360 | 1199.10 | 5.97 | 1193.13 | 0.00 |