Model Library

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. 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. 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. 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.

MonthPaymentInterestPrincipalBalance
11199.101000.00199.10199800.90
21199.10999.00200.10199600.80
121199.10987.89211.21197366.79
601199.10930.63268.47185857.51
1201199.10838.06361.04167249.62
2401199.10533.49665.61106031.19
3601199.105.971193.130.00

Go deeper