Home purchase financing - we cannot decide

Thank you! Thank you also for the link, which is already 3.5 years old. However, it clearly illustrates what you mean. Meanwhile, loan fees are no longer permitted, and only origination fees are allowed. To be able to compare our two offers, we calculated without special repayments and referred to the same period of 20 years for offer 2 (as with offer 1). In offer 2, the following was examined in detail: - What is the residual debt of the 100k loan after 20 years, assuming constant interest rates - How much interest was paid after 20 years - What is the residual debt of the building savings contract after 20 years (can be seen in the repayment plan) - How much interest was paid after 20 years. And from this data, a good comparison can be drawn, right? Very roughly, the overall cost with constant interest rates also gives an idea of how the offers stand. And here, the building savings contract is also lower (in our first offers, the combination was significantly higher, but there were strong improvements made, fees reduced, moved to a different tariff, interest rates lowered).

How much interest has been paid after 20 years.

This sum consideration does not take into account the timing of the individual payments. The result may be correct, but that would be a coincidence, right? I, for lack of better knowledge, would represent the entire cash flow in Excel for both variants and calculate the internal rate of return. I would be curious whether your result will then be confirmed.

which is already 3.5 years old

Mathematics does not change ...

And from this data the comparison can be made quite well, can't it?

No, the temporal component is missing.

I think we are talking past each other, or I don’t understand you, or you don’t understand me, or I am too tired.

Why is it a coincidence how much interest I pay in 20 years and how much remaining debt I have in 20 years? I see that clearly in offer 1, black on white in the repayment plan.
With offer 2, for simplicity’s sake, we also fixed the point in time to 20 years. For that, it was necessary to extend the 100k loan from 15 years to 20 years (with the same interest rates), and with the building savings contract I see black on white how much remaining debt I have after 20 years. I also then see how much interest I have paid.
Within offer 2, the total interest and total remaining debt can very well be compared to offer 1?! That is not a coincidence... :-/

Yes, an Excel file would be great, do you happen to have a template? (at least for a simple loan) I have played through the remaining debt, terms, interest, etc. on the website Zinsen minus berechnen de. That saves having to create your own Excel sheets.

My argument is that the comparison of the total interest to be paid does not allow any conclusion as to which option is better. Instead, you should compare the respective effective overall interest rates (blended rate).

With offer 1, the bank should have actually stated the effective overall interest rate to you. With offer 2, to my knowledge, it does not have to do so. That makes the matter so difficult.

Finally had the time to deal with it again. It is clear to me that the overall effective interest rate is important, especially with combined yields. This was not specifically mentioned to us. Now I have calculated this myself for the combined loan in variant 2 for the amount of 203k [Bausparvertrag]. Result:
Effective interest rate over the entire financing period 2.17%

The first 100k in variant 2 already has the correct effective interest rate stated, as this is a simple annuity loan: 1.91%

Compared to variant 1, which is also a simple annuity loan, amount 303k, effective interest rate 2.17%.

Summary:
Offer 1:
303k, 2.17% effective, 20 years, RS 121.1k, annuity

Offer 2:
100k, 1.91% effective, 15 years, RS 65.4k, annuity
203k, 2.17% effective, 28 years, full repayment without RS as [Bausparvertrag]
Simple mixed interest rate: 2.04%

Offer 2 therefore has the better rate, less RS and more security.

After long research, this is the only understandable calculator. Data was entered 1:1, terms, installments, etc., the sums almost matched.

In my opinion, now you are on the right track!

Option 2 [...] Result:
Effective interest rate over the entire financing period 2.17%

Offer 2:[...]
Simple mixed interest rate: 2.04%

Offer 2 therefore has the better interest rate

I am confused. If everything is clear to you, then that’s good. I would take a beer coaster and write on it
- Option 1
- Option 2
and next to it I would write the respective total effective interest rates. So that we don’t misunderstand each other, these are only two (!!) numerical values, one per option. You leave out all the other numbers.