Amortization Schedule Explained: How to Calculate Your Mortgage Payments

What is an Amortization Schedule?

An amortization schedule is a table that details each mortgage payment, showing how much goes toward principal and how much goes toward interest, along with the remaining balance after each payment. This schedule is a fundamental tool for understanding how your mortgage works and how long it will take to pay off your loan.

In Canada, mortgages typically have an amortization period of 25 years, which is the total length of time it takes to pay off the mortgage if you make all payments as scheduled. The schedule is built around this period, breaking down each payment over the life of the loan.

Your mortgage term, on the other hand, is the length of time your mortgage contract is in effect, often 5 years or less. At the end of each term, you must renew your mortgage, potentially with new terms and rates. The amortization period is separate from the term; you might have a 25-year amortization but renew your mortgage every 5 years.

Sources: Financial Consumer Agency of Canada

Key Components: Principal, Interest, and Balance

Each payment in an amortization schedule is split into two main components: principal and interest. The principal is the amount of the loan you still owe, and the interest is the cost of borrowing that money. The schedule shows how each payment reduces the principal and how much interest is charged for that period.

At the beginning of your amortization period, a larger portion of your payment goes toward interest, and a smaller portion goes toward principal. As you continue making payments, the interest portion decreases, and the principal portion increases. This means that later payments reduce your balance faster.

To illustrate, on a $500,000 mortgage at 5% interest with a 25-year amortization, approximately 70% of the first year's payments go toward interest. This ratio gradually shifts as the loan balance decreases, but it's important to understand that early payments are mostly interest, which is why paying down principal early can save you money in the long run.

Sources: WOWA.ca

How Payment Frequency Affects Your Schedule

The frequency of your mortgage payments can significantly impact your amortization schedule. Common payment options include monthly, semi-monthly, bi-weekly, and accelerated bi-weekly payments. Each option affects how quickly you pay down the principal and how much interest you pay over the life of the loan.

Accelerated bi-weekly payments involve making a payment every two weeks that is equivalent to half of your monthly payment. Because there are 52 weeks in a year, you end up making 26 half-payments, which equals 13 full monthly payments over the course of a year. This extra payment per year goes entirely toward principal, allowing you to pay off your mortgage faster and save on interest.

Choosing a longer amortization period, such as 30 years instead of 25, can reduce your regular payment amount because the loan is spread over more years. However, this also means you will pay more total interest over the life of the mortgage.

Sources: Financial Consumer Agency of Canada, WOWA.ca

Step-by-Step Calculation Example

To create an amortization schedule, you need to know your mortgage amount, the interest rate, and the amortization period. In Canada, fixed-rate mortgages have interest compounded semi-annually. The monthly interest rate is calculated using the formula: (1 + annual rate / 2)^(1/6) - 1. This adjusts for the semi-annual compounding and gives you the effective monthly rate.

Once you have the monthly interest rate, you can calculate your monthly payment using the standard loan payment formula. With the payment amount and the monthly interest rate, you can then determine how much of each payment goes toward interest and how much goes toward principal, and update the remaining balance accordingly.

Let's walk through an example: a $500,000 mortgage at 5% annual interest with a 25-year amortization. The annual interest rate is 0.05, so the semi-annual compounding gives a monthly rate of (1 + 0.05 / 2)^(1/6) - 1 ≈ 0.0041239. For the first payment, the interest portion is $500,000 * 0.0041239 ≈ $2,062, and the principal portion is $2,908 - $2,062 = $846, leaving a new balance of $499,154. Repeating this calculation for each payment period will produce the full amortization schedule.

1. Determine the mortgage amount, annual interest rate, and amortization period in years.
2. Calculate the monthly interest rate using the semi-annual compounding formula: (1 + annual rate / 2)^(1/6) - 1.
3. Calculate the monthly payment using the loan payment formula.
4. For each payment period, calculate the interest portion as the current balance multiplied by the monthly interest rate.
5. Subtract the interest portion from the total payment to find the principal portion.
6. Subtract the principal portion from the current balance to get the new balance.
7. Repeat for each payment period until the balance reaches zero.

Sources: WOWA.ca, Ratehub.ca

How to Use an Amortization Schedule for Financial Planning

An amortization schedule is a powerful tool for financial planning. It shows you exactly how much interest you will pay over the life of the mortgage, which can help you compare different loan options. For example, you can see the impact of a shorter amortization period versus a longer one, even if your monthly payments are higher.

You can also use the schedule to see how making extra payments, such as a lump sum or increased regular payments, can shorten your amortization period and reduce total interest. For instance, making a prepayment will directly reduce your principal, which means less interest accrues on the balance, potentially shortening your amortization schedule.

When comparing mortgage options, it's important to look at the total interest paid and the amortization period, not just the monthly payment. A lower monthly payment might seem attractive, but it could result in a significantly higher total interest cost if the amortization period is longer.

• Compare amortization periods: 25 years vs. 30 years on a $500,000 mortgage at 5% results in a monthly payment of $2,908 vs. $2,668, and total interest of approximately $372,000 vs.

Sources: WOWA.ca