Reading the table like a lender
Banks generate this exact table when they price your loan; borrowers rarely look at it. Three rows repay attention:
- Row 1 tells you the true monthly cost of the debt right now, the interest figure is what having the loan costs this month, regardless of the payment size.
- The row at your exit horizon, if you expect to sell or refinance in five years, the balance in month 60 is what you will need to clear. On long loans it is startlingly close to what you borrowed: $300,000 at 6% still owes $279,163 after five full years of payments.
- The crossover row, where principal first exceeds interest, the psychological halfway point, and it arrives far later than the calendar midpoint.
The recurrence behind every row
interest = balance × (annual rate ÷ 12)principal = payment − interestbalance = balance − principal
That is the entire algorithm. Its consequence: the balance falls slowly at first (small principal), then faster and faster, the curve is convex. Halfway through a 30-year term, roughly two-thirds of the balance typically remains.
What the schedule is used for
- Payoff quotes. The balance column is (near enough) your payoff amount at any month, before per-diem interest.
- Tax paperwork. Where mortgage or home-loan interest is deductible, the year's deduction is the sum of twelve interest cells, the schedule gives it precisely.
- Equity planning. Home equity = value − balance. The schedule provides the second term for any future month.
- Sanity-checking lenders. If a servicer's statement disagrees with the recurrence above, ask why. Errors are rare but not unheard of, and they are always in someone's favour.
Related tools
To see how extra principal reshapes this table, use the early payoff calculator. For the payment itself and the down-payment picture, the mortgage calculator; for loans quoted in rupees with Indian conventions, the EMI calculator produces the same schedule.