Mortgage calculator

EUR
%
Monthly payment
€1,372
Year 025
  • Total interest€151,713
  • Total paid€411,713
Year-by-year breakdown
YearTotal interestBalance
1€10,287€253,819
2€10,036€247,386
3€9,774€240,691
4€9,501€233,724
5€9,217€226,472
6€8,922€218,925
7€8,614€211,071
8€8,294€202,896
9€7,961€194,389
10€7,614€185,534
11€7,254€176,320
12€6,878€166,729
13€6,488€156,748
14€6,081€146,361
15€5,658€135,550
16€5,217€124,298
17€4,759€112,589
18€4,282€100,402
19€3,785€87,719
20€3,268€74,519
21€2,731€60,781
22€2,171€46,483
23€1,589€31,603
24€982€16,117
25€351€0
How it is calculated

The calculator uses the standard annuity formula: the same payment every month, where the interest part shrinks and the principal part grows as the balance falls. Interest is charged monthly at one twelfth of the annual rate.

Total interest is everything you pay above the amount borrowed. Fees, insurance and property taxes are not included, so add them to the monthly payment when you plan your budget.

Questions

How much does a shorter term save?

A shorter term raises the monthly payment but cuts total interest sharply, because the balance falls faster. Try 30 and 20 years with the same rate to see the difference.

Does the calculator work for fixed and variable rates?

It assumes one rate for the whole term. For a fixed period followed by a variable rate, run the calculator again with the new rate and the remaining balance.

Now keep it on track Set the result as a budget in Spendee and see each month how much is left.