Hagiman2000
2016-02-04 15:03:14
- #1
I then took the trouble to calculate how bad the interest rate must be on the follow-up financing for the KFW loan for the Ing-Diba offer to be better (looking at the monthly rate).
The Ing-Diba loan is quickly calculated.
Loan amount: €312,000
Nominal interest rate: 2.12%
Repayment: 2%
Term: 15 years.
Rate: €1,071
Outstanding debt: €201,920
With the two Sparkasse offers it becomes more difficult, since after 10 years the KfW loan runs out and must be refinanced. When comparing all three offers after 10 years, the second Sparkasse offer (the one with 1.99%) is naturally the best (because you can collect the difference in the rate and use it as special repayment).
Sparkasse €262,000 (2.07% interest / 2% repayment) €50,000 KfW (with 1.61% interest and 2.22% repayment)
Rate in the first 10 years = €889 Sparkasse + €160 KfW = €1,049 (thus €22 better than the Ing-Diba offer)
After 15 years, an outstanding debt of €169,922 remains from the €262,000. (The rate for the Sparkasse loan remains at €889 per month for 15 years)
------------------------------------------------------------------------------------------------------------------------------------
After 9 years (one year is interest-only), an outstanding debt of €39,258 remains from the €50,000 KfW loan (the rate for the KfW loan was €160 during these 10 years). This must be refinanced.
Let’s say the best offer in 10 years is at 5%, then the following results:
*I have only calculated the refinancing for the 10-15 year period so that the comparison to Ing-Diba is possible*
Rate €236 and an outstanding debt of €34,319
Outstanding debt Sparkasse after 15 years + outstanding debt KfW after 15 years (at 5% for the 10-15 year period) = €169,922 + €34,319 = €204,241
The rate from the 10-15 year period is: €1,125 (889 Sparkasse + 236 KfW refinanced)
If you now consider that in the first 10 years we saved €22 compared to the Ing-Diba offer, that results in €2,640 (22 x 120). We subtract this from the outstanding debt = €201,601
I then also calculated how bad the refinancing loan must be for the monthly rate in the 10-15 year period to be identical for Ing-Diba and Sparkasse.
I came up with a value of 3.35%. Below that we pay less per month, above that more (as in the example above with 5%).
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I know this is quite a lot of text. Is the calculation correct?
With the second Sparkasse offer with 1.99% and only €40,000 KfW I come to a breakeven refinancing interest rate of 4.2% and an outstanding debt after 15 years of €199,779 (due to the lower monthly rate, even more special repayments were possible and due to the lower monthly rate the interest rate of the follow-up financing can also be higher until the rate is identical to Ing-Diba).
The Ing-Diba loan is quickly calculated.
Loan amount: €312,000
Nominal interest rate: 2.12%
Repayment: 2%
Term: 15 years.
Rate: €1,071
Outstanding debt: €201,920
With the two Sparkasse offers it becomes more difficult, since after 10 years the KfW loan runs out and must be refinanced. When comparing all three offers after 10 years, the second Sparkasse offer (the one with 1.99%) is naturally the best (because you can collect the difference in the rate and use it as special repayment).
Sparkasse €262,000 (2.07% interest / 2% repayment) €50,000 KfW (with 1.61% interest and 2.22% repayment)
Rate in the first 10 years = €889 Sparkasse + €160 KfW = €1,049 (thus €22 better than the Ing-Diba offer)
After 15 years, an outstanding debt of €169,922 remains from the €262,000. (The rate for the Sparkasse loan remains at €889 per month for 15 years)
------------------------------------------------------------------------------------------------------------------------------------
After 9 years (one year is interest-only), an outstanding debt of €39,258 remains from the €50,000 KfW loan (the rate for the KfW loan was €160 during these 10 years). This must be refinanced.
Let’s say the best offer in 10 years is at 5%, then the following results:
*I have only calculated the refinancing for the 10-15 year period so that the comparison to Ing-Diba is possible*
Rate €236 and an outstanding debt of €34,319
Outstanding debt Sparkasse after 15 years + outstanding debt KfW after 15 years (at 5% for the 10-15 year period) = €169,922 + €34,319 = €204,241
The rate from the 10-15 year period is: €1,125 (889 Sparkasse + 236 KfW refinanced)
If you now consider that in the first 10 years we saved €22 compared to the Ing-Diba offer, that results in €2,640 (22 x 120). We subtract this from the outstanding debt = €201,601
I then also calculated how bad the refinancing loan must be for the monthly rate in the 10-15 year period to be identical for Ing-Diba and Sparkasse.
I came up with a value of 3.35%. Below that we pay less per month, above that more (as in the example above with 5%).
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I know this is quite a lot of text. Is the calculation correct?
With the second Sparkasse offer with 1.99% and only €40,000 KfW I come to a breakeven refinancing interest rate of 4.2% and an outstanding debt after 15 years of €199,779 (due to the lower monthly rate, even more special repayments were possible and due to the lower monthly rate the interest rate of the follow-up financing can also be higher until the rate is identical to Ing-Diba).