Evaluation and Improvement of the Financing Option

  • Erstellt am 2024-05-03 15:59:00

nordanney

2024-05-07 10:33:12
  • #1

That's correct. The fixed interest period is a fixed term.

The interest rate remains the same during the fixed interest period. But since you are making repayments, after the first installment you already have the original debt minus the repayment portion. So with the second installment, you are paying interest only on a smaller loan amount.

Example:
Loan €100,000 with 5% interest and 5% initial repayment ==> yearly consideration for simplicity
first installment €10,000 = €5,000 interest and €5,000 repayment
second installment €10,000 ==> since you have already repaid €5,000, you now pay interest only on €95,000 = €4,750 interest and €5,250 repayment
and so on.
That is why the repayment always includes the initial repayment plus the interest saved.
 

r4id-91

2024-05-07 12:53:24
  • #2
That makes sense to me. I just don’t understand how I get to that mathematically and how I can consider the following statements in the financing decision: Can you please tell me exactly what I have to calculate?
 

Tolentino

2024-05-07 13:30:21
  • #3
Do you have Excel?
If yes,
Then create a table
Column A: Date (Can also just be a counter column, each row gets a new number (one month later) 1-300 or so)
Column B: Loan amount (Period start), Just enter in the first row, from row two = cell reference: *Column G of the previous row*
Column C: Annuity (the total installment you want to transfer monthly)
Column D: Interest rate (the percentage (nominal) agreed)
Column E: Interest = Loan amount * Interest rate / 12
Column F: Repayment = Annuity - Interest (Column E)
Column G: Loan amount end of period = Column A - Column F

From row two you have to get column A from column G of the previous row (just = and click on the row).

Then drag down.

After 10 years (120 rows) you can play with the interest rate. Simply sum up interest, repayment and annuity over the rows at the top, then you see how the total interest paid and repayment relate to the total amount of installments paid.
 

r4id-91

2024-05-07 14:11:34
  • #4


Thanks for the effort, but I’ve already created repayment schedules for myself and understood them.



Maybe I misunderstood the statements. I thought there is a simple formula that I can drag over all rows and that spits out an interest over the months, so that I can follow your above statements like "if after 15 years the interest is more than 8.4%."

But how exactly do I do that so that I can compare the two variants to come to your statements?
What knobs do I have to turn and which values do I have to compare? Here I’m stuck.
 

r4id-91

2024-05-07 14:30:04
  • #5
We had also considered the program. However, we want to have a fireplace. If you have an architect-designed house, how did you demonstrate the EH40 level? We are building with 42.5 cm hollow bricks, uninsulated.
 

Tolentino

2024-05-07 14:45:31
  • #6
You have the different variants and change the interest rate, e.g. after 10 years, 15 years, 20 years (whenever the components fall out of the fixed interest period). And then the total amount of interest paid over the entire term changes. As soon as the sums of the different variants become equal, you have the break even. And at some point, you simply pay more interest with the other variant. There are also built-in functions in Excel for this, but I never understood them or they don't work properly.
 

Similar topics
30.04.2013Loan with an interest rate of 2.51% - Tips for financing22
20.05.2013Question: 1% repayment and 10 years fixed interest rate. Will the house never be paid off?13
29.07.2014Fixed interest period and loan term for 10, 15, or 20 years?12
24.10.2014Repay savings or save? + Secure interest rate47
18.04.2015Is a building savings contract still worthwhile with the current interest rates?10
14.03.2016Financing completed - is the interest rate good?23
29.05.2016Conditions for Riester home savings contract - What interest rate?16
22.06.2016Is a TA loan sensible? Interest and loan offer are okay13
11.07.2016Interest rate fixation - financing assessment23
03.09.2016Interest rate / rate - bank calculation16
31.07.2018For how many years of fixed interest period would you currently finance?57
14.12.2019Fixed interest rate for the entire term or only 10 years?52
17.06.2021House purchase - Is the fixed interest rate realistically estimated?11
28.02.2022Current financing offer from the house bank173
25.09.2022Financing monthly installment €2500 with 40 years term117
29.09.2022High interest rates with fixed interest, alternative flex loans?54
17.12.2022End of fixed interest period 2027 - increase repayment or other options?33
13.01.2023Forward loan, special termination, fixed interest rate, experiences?12
29.04.2023Interest rate fixation 10 vs. 15/20 years14
22.03.2024Home purchase financing despite high interest rates?24

Oben