How an amortisation schedule is built
To amortise a loan is to pay it off gradually with regular repayments. The schedule is the table that shows, for every repayment, how much is interest, how much reduces the debt, and what is still owing. It starts from the repayment amount:
Repayment = P × r ÷ (1 − (1 + r)−n)
Then each row is built from the row before it using three small steps:
Interest = previous balance × r
Principal = repayment − interest
New balance = previous balance − principal
P is the amount borrowed, which is also the balance before the first repayment. r is the interest rate for one repayment period as a decimal (the yearly rate ÷ 12 for monthly repayments, 26 for fortnightly, 52 for weekly). n is the number of repayments. Interest is rounded to the nearest cent on each row, as it is on a statement.
Worked example: $20,000 at 7.5% over 5 years
- Rate and number of repayments. 7.5% ÷ 12 = 0.625% a month, so r = 0.00625, and n = 5 × 12 = 60.
- Repayment. 1.00625−60 = 0.688092, and 1 − 0.688092 = 0.311908. $20,000 × 0.00625 = $125, and $125 ÷ 0.311908 = $400.76.
- Row 1. Interest: $20,000 × 0.00625 = $125.00. Principal: $400.76 − $125.00 = $275.76. Balance: $20,000 − $275.76 = $19,724.24.
- Row 2. Interest: $19,724.24 × 0.00625 = $123.28. Principal: $400.76 − $123.28 = $277.48. Balance: $19,724.24 − $277.48 = $19,446.76.
- Row 3. Interest: $19,446.76 × 0.00625 = $121.54. Principal: $400.76 − $121.54 = $279.22. Balance: $19,167.54.
- Keep going to row 60. Before the last repayment $398.18 is owing. Interest on it is $2.49, so the final repayment is $400.67, nine cents less than the others.
Added up, the 60 rows show $4,045.51 of interest and $24,045.51 repaid in total. In the first year $1,383.86 of your repayments is interest; in the fifth year only $189.79 is.
How to read the schedule
The principal column grows as the interest column shrinks
The repayment stays the same, but its make-up changes with every row. Because each repayment lowers the balance, the next interest charge is smaller and more is left over for principal. The principal part grows by a factor of (1 + r) each period: $275.76 × 1.00625 = $277.48, which is row 2.
On a long loan the effect is dramatic. For $100,000 at 6% over 30 years the repayment is $599.55, and the first one is $500.00 of interest and only $99.55 of principal. Principal does not overtake interest until repayment 223, in year 19, and it takes 21 of the 30 years to pay off the first half of the loan.
The balance column is your payout figure
The balance on any row is what you would owe immediately after that repayment, before fees or any interest that has built up since. You can also jump straight to any row without building the ones before it:
Balance after k repayments = P × (1 + r)k − Repayment × ((1 + r)k − 1) ÷ r
For the example after 36 repayments this gives $8,905.84. The schedule shows $8,905.79, five cents different, because the schedule rounds every row to the cent and the formula does not.
Why the last repayment is different
The exact repayment in the example is $400.7590, but you can only pay $400.76. That tenth of a cent, and the rounding of each interest charge, accumulate over the term and are settled in the final repayment. On the 30-year example the last repayment is $600.00 rather than $599.55, and the rounded schedule totals $115,838.45 of interest against $115,838.19 from the formula alone. A lender’s schedule can differ from this one by similar small amounts.
Extra repayments in the schedule
An extra repayment goes entirely to principal, so it lowers every later interest charge and removes rows from the end of the table. Adding $50 a month to the example finishes the loan in 53 repayments instead of 60 and cuts the interest from $4,045.51 to $3,496.50, a saving of $549.01.
Limits of the method
The schedule assumes a fixed rate, repayments made on the due date, and periods of equal length. Many lenders charge interest daily, so a 31-day month costs slightly more than a 28-day one and their interest figures will not match these to the cent. If your rate changes, start a new schedule from the current balance with the new rate and the remaining term. Fees are not included.