Amortization schedule

Before you rely on it

What to check

Make sure the schedule starts from your actual balance and remaining term, not the original loan amount.

The common error

Where people go wrong with amortization schedule

Running a schedule off the original figures years into a loan. Every row after the first is wrong, and the payoff date it produces is fiction.

Worked through

Amortization schedule in plain numbers

Here are the first three rows of a $10,000 loan at 12% a year over 12 months, with a payment of $888.49. Month one: interest $100.00, principal $788.49, balance $9,211.51. Month two: interest $92.12, principal $796.37, balance $8,415.14. Month three: interest $84.15, principal $804.34, balance $7,610.80, and the interest column falls by a little under eight dollars each month and the principal column rises by the same amount. Add all twelve interest cells and borrowing costs $661.88; the schedule turns a rate into a bill, and it lets you see the bill before you agree to it.

Easily confused

Amortization schedule and its neighbours

A schedule is not the same as the amortization it describes, and it is not a payment plan you can change at will; the concept is the process. The schedule is the table that shows the process row by row, with dates, interest, principal and balance; a payoff quote is different again. It states what you owe today, including accrued interest and any fees, and it may be higher than the balance printed on the last row you paid. Keep the schedule for planning and use the payoff letter when you actually close the loan. Mixing the two up is how people end up a few hundred dollars short at closing.

In real decisions

Where amortization schedule turns up

People open a schedule to see the balance on a given date, to check that a lender has applied payments correctly and to plan extra payments. Accountants use it to split each payment between interest expense and principal reduction. Someone selling a house reads the remaining balance from it to estimate proceeds; a borrower deciding between a 15- and a 30-year loan can compare the total interest in the last column of each, and that comparison is more revealing than comparing monthly payments. It also settles disputes: a printed schedule is a shared reference both sides can point to.

Know the edges

Where amortization schedule stops being reliable

The table is only as good as the inputs. Start it from the wrong balance or the wrong remaining term and every row is wrong; it assumes the rate stays fixed and payments arrive on time, and it cannot know about late fees, skipped payments or a servicer that rounds differently from your software. If you make extra payments, rerun the schedule from the current balance instead of trusting the original, because the original no longer describes the loan you actually have.

Quick answers

What people ask about amortization schedule

Can I build a schedule without my lender's help? Yes. You need the balance, the annual rate, the payment and the number of payments left. Each row multiplies the balance by the monthly rate, subtracts that from the payment to get principal and lowers the balance. Compare your last row with the lender's statement.

Why does my statement differ by a few cents? Rounding and day-count rules. Some servicers round each payment, others carry fractions, and a few charge interest by the actual days in the month. Small gaps are normal. Gaps of several dollars deserve a call.