Where each payment goes
Each month, interest is charged on the balance at the start of the month, and the rest of the payment reduces principal:
- Interest = opening balance x i
- Principal = PMT - interest
- New balance = opening balance - principal
In month 1 of the example, interest is 360,000 x 0.0055 = $1,980.00 and principal is only $319.17. Because the balance falls slowly at first, early payments are mostly interest.
The balance after k payments is the present value of the payments still to come:
Balance after k = PMT x [1 - (1 + i)^(-(n - k))] / i
After 5 years (60 payments) the example loan still owes $337,384.59: about $22,600 of principal repaid out of roughly $137,950 paid. A table of these figures is an amortization schedule; a financial calculator's AMORT function produces it.