How the german mortgage calculator works
Plan a home purchase: purchase costs (German real estate transfer tax 3.5–6.5 % by state, notary and land registry, estate agent), the loan you need after your down payment, monthly payment, balance after the fixed-rate period and amortisation schedule.
- Purchase costs€42,28010.57% on top of the €400,000 price
- Loan amount€362,280after €80,000 down payment
- Monthly payment€1,6603.5% interest + 2% repayment
Total cost€442,280
- Purchase price€400,000
- Real estate transfer tax€20,000
- Notary and land registry€8,000
- Estate agent fee€14,280
Financing€442,280
- Down payment€80,000
- Loan amount€362,280
- Loan amount
- €362,280
- Purchase price
- €400,000
- Tax
- Real estate transfer tax: 5%
- Notary
- Notary and land registry: 2%
- Agent
- Estate agent fee: 3.57%
- Down payment
- €80,000
- Monthly payment
- €1,660
- Rate
- Borrowing rate p.a.: 3.5%
- Repayment
- Initial repayment p.a.: 2%
- 1Purchase price: €400,000.
- 2Add €42,280 purchase costs: transfer tax €20,000, notary and land registry €8,000, agent €14,280.
- 3Subtract your €80,000 down payment. The rest, €362,280, is the loan.
- 4The monthly payment is a twelfth of interest plus repayment: €362,280 × 5.5% ÷ 12 = €1,660.
- 5The fixed-rate period (here 10 years) is how long the borrowing rate stays fixed. Whatever is still owed after that, the remaining balance, you refinance at the rate of the day.
- 6More repayment lowers the remaining balance, because every euro repaid shrinks the debt and the interest on it: with 3% instead of 2% the payment rises to €1,962, but after 10 years you owe only €232,373 instead of €275,676.
Working backwards: from the goal to the input
- How much can the property cost?Here you set the goal, for example Monthly payment €1,500. Fixed: Down payment €80,000, Borrowing rate p.a. 3.50%, Initial repayment p.a. 2%. The calculator looks for the value of Purchase price at which the calculation hits exactly this goal: €368,339.50 (rounded down to the cent so the limit is surely kept). Check: with €368,339.50, Monthly payment comes to €1,500.
- How much down payment do I need?Here you set the goal, for example Monthly payment €1,200. Fixed: Purchase price €400,000, Borrowing rate p.a. 3.50%, Initial repayment p.a. 2%. The calculator looks for the value of Down payment at which the calculation hits exactly this goal: €180,461.59 (rounded up to the cent so the goal is surely reached). Check: with €180,461.59, Monthly payment comes to €1,200.
- What repayment fits my payment?Here you set the goal, for example Monthly payment €1,500. Fixed: Purchase price €400,000, Down payment €80,000, Borrowing rate p.a. 3.50%. The calculator looks for the value of Initial repayment p.a. at which the calculation hits exactly this goal: 1.47%. Check: with 1.47%, Monthly payment comes to €1,500.
Inputs
- Purchase price
- Down payment
- Borrowing rate p.a.
- Initial repayment p.a.
- Real estate transfer tax
- Notary and land registry
- Estate agent fee
- Fixed-rate period (years)
- Special repayment p.a.
Results
- Purchase costs
- Total cost
- Loan amount
- Loan-to-value
- Monthly payment
- Amortisation schedule (annual)
- Remaining balance after fixed-rate period
- Interest during fixed-rate period
- Total term
- Total interest
Show formulas
- Purchase costs:
round(kaufpreis * (grunderwerbsteuer + notar + makler), 2) - Total cost:
kaufpreis + nebenkosten - Loan amount:
max(gesamtkosten - eigenkapital, 0) - Loan-to-value:
kaufpreis > 0 ? darlehen / kaufpreis : 0 - Monthly payment:
annuityPayment(darlehen, sollzins, tilgung, 12) - Amortisation schedule (annual):
yearly(plan) - Remaining balance after fixed-rate period:
count(plan) > 0 ? last(upTo(plan, "year", zinsbindung)).balance : 0 - Interest during fixed-rate period:
sum(upTo(plan, "year", zinsbindung).interest) - Total term:
round(count(plan) / 12, 2) - Total interest:
sum(plan.interest)
Add your own result fields with “+ Field” – every input is available as a variable.