Mortgage Amortisation and Payment Breakdown Calculator
Build an amortisation schedule when the remaining term is known.
Calculate how long a mortgage balance takes to repay with your stated monthly payment. The result is a payoff projection, not a lender redemption statement or a fixed-rate contract term.
This payoff estimate starts with the principal currently outstanding and asks how long a fixed monthly payment would take to clear it. It follows the balance payment by payment, so the final instalment can be smaller than the regular amount.
The annual nominal percentage is divided by 12. Each month, that rate applies to the opening principal; the calendar dates label the schedule without changing the interest charge.
Interest is covered first and the remainder reduces principal. A payment that cannot cover interest is rejected, as is a scenario that cannot clear within 1,200 months.
Once the amount due is smaller than the normal payment, only that balance and its interest are paid. The table records the reduced final instalment and its date.
Sample inputs demonstrate the method. They are not a forecast or product offer.
The first example owes €1,000 at zero interest and pays €300 monthly. Three payments clear €900, leaving €100 for a fourth. Total interest remains zero, and the final payment is €100 rather than another €300.
Sample inputs demonstrate the method. They are not a forecast or product offer.
Payments until payoff is a count of monthly instalments. Dividing it by 12 gives the displayed years; it does not measure actual days between payment dates.
Compare payment scenarios using both interest and duration. A projected payoff date is not a lender redemption figure, which can include accrued daily interest or contractual charges.
No. Such a payment does not repay the principal, so no finite payoff date exists under this model.
Read our calculation and testing approach.