How the loan calculator (annuity loan) works
Mortgage or instalment loan with initial repayment, fixed-rate period and special repayments.
Inputs
- Loan amount
- Borrowing rate p.a.
- Initial repayment p.a.
- Fixed-rate period (years)
- Special repayment p.a.
Results
- Monthly payment
- Amortisation schedule (annual)
- Remaining balance after fixed-rate period
- Interest during fixed-rate period
- Total term (years)
- Total interest
Show formulas
- 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 (years):
round(count(plan) / 12, 2) - Total interest:
sum(plan.interest)
Add your own result fields with “+ Field” – every input is available as a variable.
More calculators
- Compound interest calculatorHow much will my money grow?
- Savings planRegular saving with compound interest
- Mortgage calculatorPurchase costs, loan amount and monthly payment
- Rental yield calculatorIs the buy-to-let worth it?
- Withdrawal planHow long will my savings last?
- VAT calculatorNet, gross and VAT
- Capital gains tax calculator (Germany)What is left of interest and dividends?
- Inflation calculatorWhat will my money be worth tomorrow?