Mortgage Amortisation and Payment Breakdown Calculator
Inspect the full mortgage amortisation table.
Loans & mortgages
Mortgage Balance After Payments Calculator
Reconstruct the balance by applying a fixed monthly rate and the scheduled payments to the original principal. An irregular payment history or changing rate requires the actual statement details.
Your numbers
How the calculation works
This reconstruction starts at the beginning of a mortgage and follows its regular repayment pattern to a selected payment number. It is useful when the original principal, original term and constant rate are known, rather than as a substitute for a current settlement statement.
Start with original principal and apply interest, the scheduled payment and any monthly extra for the entered number of payments.
Calculate the original instalment
The entered nominal annual rate is divided by twelve and the annuity formula produces the regular payment over the original term.
Replay the payments
For each month, charge interest on the opening balance and apply the regular instalment plus the fixed extra. The balance cannot fall below zero when early repayment clears it.
Stop at the selected payment count
Read principal remaining after the chosen number of payments. Principal repaid is the original amount minus that balance; interest paid sums the charges incurred through that point.
Worked example: Half an interest-free term
Sample inputs demonstrate the method. They are not a forecast or product offer.
The example begins with €1,200, a twelve-month term and no interest or extra payments. The scheduled payment is €100. After six payments, €600 principal has been repaid and €600 remains; interest paid is zero.
- Original mortgage amount (€)
- 1200
- Annual nominal interest rate (%)
- 0
- Original term (months)
- 12
- Payments already made
- 6
- Extra principal paid every month
- 0
Expected result
- Estimated remaining balance
- €600.00
- Principal repaid
- €600.00
- Interest paid so far
- €0.00
Worked example: First payment at one percent monthly
Sample inputs demonstrate the method. They are not a forecast or product offer.
- Original mortgage amount (€)
- 1000
- Annual nominal interest rate (%)
- 12
- Original term (months)
- 2
- Payments already made
- 1
- Extra principal paid every month
- 0
Expected result
- Estimated remaining balance
- €502.49
- Principal repaid
- €497.51
- Interest paid so far
- €10.00
Understanding your result
Zero payments made returns the original principal. If the fixed extra clears the mortgage early, later payment counts within the original term still show a zero balance.
The result assumes every scheduled payment was made on time. A rate change, arrears, fees or an irregular payment history needs a statement-based reconstruction instead.
Questions you might have
Is this the amount needed to close the mortgage today?
No. A redemption figure may also include interest since the last payment, fees and contractual settlement adjustments.
Choosing the right inputs
- Original mortgage amount
- Enter the original mortgage principal. Supplying today’s balance here and then subtracting past payments would count those repayments twice.
- Original term (months)
- Use the original full term in months. The scheduled instalment is calculated over that term before the already-paid months are applied.
- Extra principal paid every month
- Enter an extra amount paid every month throughout the reconstructed history. A single past lump sum cannot be represented accurately by this field.
Common mistakes to avoid
- Do not enter the remaining term in place of the original term.
- Principal balance is not a redemption quote: interest accrued since the latest payment and settlement charges can change the amount due today.
Assumptions to check
- This is not a redemption statement. A changing rate or irregular history must be reconstructed from the actual statement.
Sources and method
Read our calculation and testing approach.