Mortgage amortization calculator for Germany with annual overpayments
Calculate how much you will still owe when your fixed-rate period ends. The calculator shows your monthly payment, interest costs for the fixed-rate period and remaining balance year by year. You can also include an annual extra repayment.
Use this mortgage overpayment calculator for Germany by entering an annual extra repayment. Compare the remaining balance at the end of the fixed-rate period with and without it.
How does a mortgage amortization calculator work out the payment, balance and schedule?
The calculator assumes an annuity loan whose monthly payment stays constant during the fixed-rate period. Because interest only accrues on the outstanding balance, the split shifts towards repayment year by year. What matters most is the remaining balance at the end of the fixed-rate period, because it becomes the follow-up financing. A higher initial repayment rate reduces it.
Which documents would help?
Free · 30 seconds · no sales pressure
We use your email address to send the files you request. If needed, we may contact you personally about your request.
Mortgage repayment schedule: how does your balance change?
With an annuity loan, the instalment stays constant; each year the interest portion falls and the repayment portion rises. A higher initial repayment (Anfangstilgung) or regular special repayments significantly reduce the outstanding balance at the end of the fixed-rate period — and with it the follow-up financing risk.
The calculator takes the interest rate from our overview of rates, matching the selected loan-to-value ratio.
For a KfW loan with repayment-free initial years or a repayment subsidy, there is the separate KfW repayment calculator.
Enter the loan amount, loan-to-value ratio, initial repayment rate and fixed-rate period. You can also add an annual extra repayment.
What does the repayment schedule show? The monthly instalment is only part of the picture. The annual schedule shows the remaining balance at the end of each year. The calculator displays the monthly payment and total interest costs for the fixed-rate period separately. You need this view to assess your follow-up financing in ten years; the instalment alone does not show the size of that commitment.
The calculator produces a schedule showing the remaining balance at the end of each year. Compare the remaining balances as well as the instalments: mortgage offers can differ by a five-figure amount in the debt still outstanding.
Extra repayments: when do they have the greatest effect?
The main benefit of an extra repayment appears in the following years. Every euro repaid early reduces the balance on which interest is charged for the rest of the term. That is why the same extra payment saves considerably more in the third year than in the twelfth.
Enter an annual extra repayment and compare the balance at the end of the fixed-rate period with and without that payment. See Special repayment for when this right can be agreed in the contract and what it costs.
Keep the full repayment schedule as an Excel file: The calculator shows the first five years. You can get the full schedule up to the final instalment as an Excel file, including each extra repayment at the time it is made. Change the assumptions, save them and discuss them with your bank. The spreadsheet recalculates whenever you change a value.
The Excel file includes the full annual schedule rather than an extract. You can compare any number of extra repayment scenarios side by side and keep the file after closing your browser tab. The Repayment schedule Excel page explains its contents and limitations. You can also open the file there without a form.
What loan type does the calculator assume? An annuity loan whose monthly payment stays constant over the fixed-rate period — the standard form of German property financing.
Loan repayment calculator: why does the outstanding balance change the split of each instalment?
An annuity loan has a fixed monthly repayment, but the breakdown of that repayment is constantly changing: at the start, almost all of it is interest and very little goes towards the capital; with each repayment, the ratio shifts because the interest is calculated on a smaller outstanding balance. This shift is the reason why the initial repayment has a much greater impact than it appears.
The key point: After ten years of a fixed-rate period, your loan will not have been paid off. The outstanding balance will need to be refinanced — on terms that nobody knows today. It is this remaining debt, not the initial instalment (Anfangsrate), that causes refinancing to fail.
Which documents do you need after calculating your repayment schedule?
The calculation is a starting point. For a financing decision, you need the right documents ready before speaking to a bank. We will send you the checklist for your situation free of charge, with no follow-up sales call.
Do you need the blank forms straight away? Request them quickly via the form: Self-disclosure (DE/EN) · Statement of assets and liabilities (DE/EN).
Open the file directly — by email: Mortgage documents — checklist (PDF, 9 pages) (Dutch (Germany) · French (Germany)) · Property loan for non-residents for tax purposes — checklist (PDF, 9 pages) (Dutch (non-residents) · French (non-residents)) · KfW funding overview 2026 (PDF, 4 pages) (Dutch (KfW)) · Request the repayment schedule Excel by email (Dutch (amortisation))
Three levers: how do initial repayment, fixed-interest period and special repayments differ in effect?
Initial repayments have the greatest impact on the outstanding balance, whilst the fixed-interest period primarily postpones the timing of the refinancing risk. Special repayments reduce the outstanding balance without increasing the monthly instalment.
Initial capital repayment. The most powerful lever for reducing the outstanding debt; special repayments also reduce it directly. If you increase it, you pay more each month — but the effect at the end of the fixed-interest period is disproportionately large, because every additional capital repayment immediately reduces the interest burden in subsequent years. If you have little equity, this is not a luxury, but a safeguard.
Fixed-rate period. It barely affects the outstanding debt, but it does change when you bear the risk of the subsequent interest rate.
For anyone whose banking situation might change in ten years’ time — moving abroad, becoming self-employed, retiring — a long-term commitment is worth more than a low initial interest rate.
Special repayment. The underrated feature: usually free, often unused. For anyone with a fluctuating income, it is the most important tool for flexibility of all — it reduces the outstanding debt without increasing the monthly repayment. If you don’t negotiate this as part of the deal, you’re missing out.
The calculator uses the interest rate from our rate overview. Your actual rate depends on your creditworthiness, loan-to-value ratio and chosen bank. Comparing lenders is therefore essential to finding suitable terms.
Can you keep the amortisation schedule as an Excel file?
Yes. You can keep the amortisation schedule as an Excel file with your own figures and all formulas. The full schedule recalculates when you change the interest rate, repayment rate or extra repayment.
Keep the Excel repayment schedule: The file includes your figures and all formulas. Change the interest rate, repayment rate or extra repayment to recalculate the full schedule and compare different assumptions.
Need the blank forms right now? Get them via a quick form: self-disclosure form (DE/EN) · net-worth statement (DE/EN).
Request by email: Germany property financing checklist (PDF, 9 pages) (Dutch (Germany) · French (Germany)) · Non-resident mortgage checklist (PDF, 9 pages) (Dutch (non-residents) · French (non-residents)) · KfW funding overview 2026 (PDF, 4 pages) (Dutch (KfW)) · Amortisation Excel by email (Dutch (repayment))
Mortgage interest rate: what stays constant while the split shifts towards repayment?
The monthly payment of an annuity loan stays constant.
Interest accrues only on the outstanding balance, so each year the interest share falls and the repayment share rises, and the effect accelerates over time. A higher initial repayment rate or regular extra repayments noticeably reduce the remaining debt at the end of the fixed-rate period.
Frequently asked questions
Loan repayment calculator: How does a higher initial repayment affect the outstanding balance?
A higher initial repayment lowers the outstanding balance at the end of the fixed-rate period considerably and with it the follow-up financing risk. The monthly payment results from the loan amount times the nominal interest rate plus the initial repayment, divided by twelve. Regular special repayments have the same effect.
Repayment schedule Excel template free of charge: Do I need the file, or is the calculator enough?
You do not need an Excel template, because the calculator creates the repayment schedule free of charge directly on this page. It shows the first five years. If you need the full schedule up to the last instalment, you can get it as an Excel file, in which every assumption can be changed, saved and gone through with the bank.
Repayment calculator in Excel: Is the calculation also available as a file that I can keep?
Yes, the repayment schedule is available as an Excel file for you to keep. It contains the full schedule right up to the final instalment, shows each additional repayment at the point in time it is actually made, and recalculates the figures whenever there is a change.
Why does the interest share fall over the years?
Because interest is only ever charged on the remaining debt. As the payment stays constant and the remaining debt falls, a growing part of the payment goes to repayment — the effect accelerates over time.
Are extra repayments worthwhile?
They reduce the remaining debt and thus the interest cost and the follow-up risk. It is important that the contract permits extra repayments (often up to a certain percentage per year). Whether they are wiser than other uses of the money depends on your overall situation.
Interest calculator for repayment: How much interest accrues up to the end of the fixed-rate period?
The repayment calculator shows the interest costs up to the end of the fixed-rate period as the result “Interest costs in the period”, alongside the monthly payment and outstanding balance. The basis is your loan amount, the loan-to-value, the initial repayment and the fixed-rate period. The calculator takes the interest rate from our overview of terms; actual terms only arise in the offer.
What happens at the end of the fixed-rate period?
The remaining balance is refinanced through follow-up financing. Compare offers before accepting your current bank's renewal terms.
What does this mortgage amortization calculator show?
For a given loan amount, loan-to-value, interest rate and initial repayment rate, it works out your monthly instalment, total interest costs for the fixed-rate period, the year-end remaining balances and the remaining balance when the fixed-rate period ends — optionally including an annual extra repayment. It is a non-binding guide; your actual terms depend on your bank and creditworthiness.
Any questions on this topic?
A first consultation is free and without obligation — the commission is, as a rule, paid by the bank. We tell you what this means for your own financing.
For a property loan, most banks only arrive at a workable calculation from a household net income of around €3,500 a month — for couples, the joint income counts.
Bring the amount, interest and monthly payment you entered. We can compare the repayment schedule and remaining balance if you change the initial repayment rate.
Buying now? Use the purchase budget calculator. If a fixed rate is ending, see refinancing options and tell us the current balance and the end date.
Related pages
Follow-up financing
What happens to the remaining debt after the fixed-rate period — and how switching banks helps.
Repayment schedule (Excel)
The same plan as a calculable Excel file — five input fields, 480 rows for each month.
Mortgage rates
What determines the interest rate used by the calculator — its history, trends and the current interest rate band.
