How a home loan repayment is calculated
A standard principal-and-interest home loan has equal repayments. Each one first pays the interest that has built up since the last repayment, and whatever is left reduces the amount you owe. The repayment is set so that the balance reaches exactly zero on the last one.
Repayment = P × r ÷ (1 − (1 + r)−n)
P is the amount borrowed: the property price minus your deposit. r is the interest rate for one repayment period, written as a decimal: the yearly rate divided by 12 for monthly repayments, 26 for fortnightly or 52 for weekly. n is the number of repayments: the term in years multiplied by 12, 26 or 52. When the rate is 0% the formula reduces to P ÷ n.
Worked example: $600,000 home, 20% deposit
- Amount borrowed. 20% of $600,000 is $120,000, so P = $600,000 − $120,000 = $480,000.
- Rate per month. 6% a year ÷ 12 = 0.5% a month, so r = 0.005.
- Number of repayments. 30 years × 12 = 360.
- The bracket. 1.005−360 = 0.166042, and 1 − 0.166042 = 0.833958.
- Repayment. $480,000 × 0.005 = $2,400, and $2,400 ÷ 0.833958 = $2,877.84 a month.
- Total cost. 360 repayments come to $1,036,023.31 (using the repayment before it is rounded to the cent), of which $556,023.31 is interest. Over 30 years the interest is more than the amount borrowed.
The first repayment is mostly interest: $480,000 × 0.005 = $2,400 of interest and only $477.84 off the loan. Over the first year you pay $28,639.65 in interest and $5,894.46 in principal. The balance does not fall to half the original loan until the end of year 21. This is why the chart curves: it falls slowly at first and steeply at the end.
How fortnightly and weekly repayments are worked out
This calculator treats each frequency as its own schedule. For fortnightly repayments it divides the yearly rate by 26 and uses 26 repayments a year; for weekly it uses 52. On the example loan that gives $1,327.60 a fortnight or $663.66 a week. A year of fortnightly repayments adds up to $34,517.56, almost the same as twelve monthly repayments ($34,534.11), and the interest saved over 30 years is small: about $497.
The large saving people associate with fortnightly repayments comes from a different method: paying half the monthly repayment every fortnight. Half of $2,877.84 is $1,438.92, and 26 of those equal 13 monthly repayments a year instead of 12. That extra month each year clears the example loan in 638 fortnights, about 24 years and 6 months, and saves about $118,600 in interest. To model it here, choose fortnightly and enter the difference, $111.32, as the extra repayment.
What extra repayments do
An extra repayment comes straight off the balance, so every later interest charge is smaller. Adding $200 a month to the example clears the loan in 304 months (25 years and 4 months), which is 4 years and 8 months sooner, and saves $102,297 in interest. Extra repayments made early in the loan save the most, because the amount they remove would otherwise have attracted interest for decades.
Reading the result
The repayment is very sensitive to the rate. At 7% instead of 6%, the same loan costs $3,193.45 a month, which is $315.61 more. Before committing, run the calculator one or two percentage points above the rate you are offered and check that the higher repayment is still affordable.
The figures assume a fixed rate for the whole term, interest charged once per repayment period, and repayments that start one period after the loan is drawn. Lenders often calculate interest daily, round to the cent and charge fees, so a real statement will differ slightly. Stamp duty or transfer taxes, lenders mortgage insurance, legal costs and offset accounts are not included, because they depend on where you live and on the lender.