Skip to main content

Amortization Schedule Calculator

Generate a full amortization schedule with principal, interest, and balance by month.

An amortization schedule breaks every mortgage payment into its principal and interest components and tracks your outstanding balance month by month. Use this calculator to see exactly how much of each payment reduces your debt versus goes to the lender as interest β€” and to model the dramatic savings from even a small extra monthly prepayment.

Inputs

CA$
%

Optional additional payment each month

CA$

Results

Monthly Payment

$2,326

Total Interest

$297,926

Payoff Period

25y 0m

Interest Saved (vs no extra payment)

$0

Understanding This Calculator

See how each mortgage payment splits between interest and principal over time, and how small extra payments shorten the loan.

How the math works

Every month the lender first charges interest on the outstanding balance: Interest = Balance Γ— effective monthly rate. Whatever is left of your fixed payment reduces the balance: Principal = Payment βˆ’ Interest. Because the balance shrinks a little each month, the interest portion falls and the principal portion grows β€” slowly at first, faster near the end.

An extra monthly payment goes entirely to principal. That skips ahead on the schedule, so all future interest is charged on a smaller balance β€” which is why modest prepayments save a disproportionate amount of interest and cut months or years off the payoff date.

Worked example

With the defaults β€” a $400,000 loan at 5% over 25 years, semi-annual compounding β€” the payment is about $2,326.

  1. Month 1 interest: 400,000 Γ— 0.4124% β‰ˆ $1,650
  2. Month 1 principal: 2,326 βˆ’ 1,650 β‰ˆ $676
  3. New balance: about $399,324

Only about 29% of the first payment reduces the debt. Add an extra $200 per month and the loan pays off roughly three years sooner, saving tens of thousands in interest β€” the calculator shows the exact figure for your numbers.

How to read the result

Focus on three outputs:

  • Total interest β€” the real cost of borrowing over the full amortization; it is often 60–75% of the original loan at today's rates.
  • Payoff period β€” how the extra payment shortens the schedule.
  • Interest saved β€” the dollar benefit of prepaying versus doing nothing.

Use the schedule to decide between prepaying and investing spare cash: prepaying earns a guaranteed, tax-free return equal to your mortgage rate. Check your lender's prepayment privileges first β€” many Canadian closed mortgages cap extra payments at 10–20% of the original balance per year.

Frequently Asked Questions