> calculator loan
Loan calculator with repayment plan
Work through a loan with a fixed monthly payment: for a home loan, a car loan or a personal loan. You enter the amount, the borrowing rate and the repayment or the term and see the monthly payment, total interest, the balance after the fixed-rate period, what a yearly extra repayment saves, and the repayment plan year by year. A calculation aid, not financial advice.
This means the borrowing rate (in Germany Sollzins), not the annual percentage rate. The APR on your bank offer is higher because fees, discount points and commitment interest are included. This tool does not include them.
The fixed-rate period is optional. It does not change the payment, it only shows how much is still owed when it ends. Whole years, at most 80.
Optional. It is paid once a year together with the twelfth payment. The monthly payment stays the same, the loan is paid off sooner. How much extra you may pay is in your contract, often 5% of the loan per year.
How it is calculated: the payment stays the same. Each month the interest on the remaining balance is paid first, the rest repays the loan. That is why the interest share falls from month to month and the repayment rises. The last payment is usually smaller because only the rest is left; at 0% interest all payments are the same. “Total interest” and “Total cost” use your borrowing rate up to the last month. If the fixed-rate period ends earlier, you need a new contract for the remaining balance at a rate nobody knows today. Then the total cost turns out differently.
“Total interest” and “Total cost” only apply if the interest rate stays the same for the whole term. After the fixed-rate period the rate is negotiated again.
View year by year
| Year | Payments | Interest | Repayment | Balance |
|---|---|---|---|---|
| Total | – | – | – | – |
Related: Interest and savings plan · Buying costs for a home (German) · Car costs (German) · Percentage calculator
The calculation runs only on your device.
How it works
- 01Type the loan amount and the borrowing rate with a decimal point: 250,000.00 and 3.5.
- 02Choose what you set: the initial repayment in percent or the desired term in years.
- 03Payment, term and interest appear at once. “View year by year” shows the repayment plan.
Calculating a loan: the annuity. The payment stays the same every month. With a set repayment: monthly payment = loan × (borrowing rate + repayment) ÷ 100 ÷ 12. Each month the interest on the remaining balance is paid first, the rest of the payment repays the loan.
Example 1: home loan. €250,000 at a borrowing rate of 3.5% with 2% repayment: 250,000 × 5.5 ÷ 100 ÷ 12 = €1,145.83 a month. You are debt-free after 29 years, the interest adds up to €147,995.11. After a 10-year fixed-rate period, €190,236.91 is still owed.
Example 2: what a higher repayment does. The same loan with 3% repayment costs €1,354.17 a month, is paid off after 22 years and 2 months and costs €109,504.37 in interest. A good €208 more a month therefore saves about €38,500 in interest.
Example 3: extra repayment. The same €250,000 with 2% repayment and an extra €5,000 every year: the payment stays €1,145.83, you are debt-free after 18 years and 2 months instead of 29 years, and the interest drops to €89,247.40. That is €58,747.71 less. In the table the extra repayment is part of the Payments and Repayment columns.
Example 4: personal loan. €20,000 at 6% over 5 years: €386.66 a month, €3,199.35 in interest, €23,199.35 in total.
The term goes up to 80 years. “Total interest” and “Total cost” only apply if the interest rate stays the same until the end. The result is a calculation aid for an overview and does not replace an offer from your bank.