Musketier
2012-10-18 09:19:36
- #1
So I would try to replicate this using Excel.
If you are reasonably proficient in Excel, you can create 3 tables.
Building savings phase:
1st table
Loan without repayment.
There you only calculate the loan interest.
You should have received the interest rate.
You also have these interests as the payment for the building savings phase there, so that the loan balance remains the same.
2nd table
Building savings contract
There your payments are your contributions.
To this, you add your interest on credit balance (probably around 1%)
From the first installments you still have to deduct the fees (1% of the building savings sum).
When the building savings contract is eligible for allocation – 30%/40%/50% of the contributions reached (depending on contract conditions) –
the building savings loan phase begins. Then the two tables are merged into the building savings loan.
Here you then calculate monthly loan interest for the building savings loan and deduct the repayment rate monthly.
You calculate this until full repayment like with a normal annuity loan.
3rd table
Independently, you calculate a normal annuity loan in table 3. The monthly loan payment is for the savings phase the interests from table 1 + the contributions to the building savings contract from table 2 and in the building savings phase the rate analogous to the building savings contract.
You adjust the interest rate in table 3 up or down until the loan is repaid at the same time as the building savings loan.
If you don’t understand it at all, you can also send me all the data mentioned below via PM and I’ll roughly calculate it.
Of course without any guarantee of correctness.
Alternatively, I just found a comparison calculator at the Stiftung Warentest.
Google search: stiftung warentest Bausparrechner
If you are reasonably proficient in Excel, you can create 3 tables.
Building savings phase:
1st table
Loan without repayment.
There you only calculate the loan interest.
You should have received the interest rate.
You also have these interests as the payment for the building savings phase there, so that the loan balance remains the same.
2nd table
Building savings contract
There your payments are your contributions.
To this, you add your interest on credit balance (probably around 1%)
From the first installments you still have to deduct the fees (1% of the building savings sum).
When the building savings contract is eligible for allocation – 30%/40%/50% of the contributions reached (depending on contract conditions) –
the building savings loan phase begins. Then the two tables are merged into the building savings loan.
Here you then calculate monthly loan interest for the building savings loan and deduct the repayment rate monthly.
You calculate this until full repayment like with a normal annuity loan.
3rd table
Independently, you calculate a normal annuity loan in table 3. The monthly loan payment is for the savings phase the interests from table 1 + the contributions to the building savings contract from table 2 and in the building savings phase the rate analogous to the building savings contract.
You adjust the interest rate in table 3 up or down until the loan is repaid at the same time as the building savings loan.
If you don’t understand it at all, you can also send me all the data mentioned below via PM and I’ll roughly calculate it.
Of course without any guarantee of correctness.
Alternatively, I just found a comparison calculator at the Stiftung Warentest.
Google search: stiftung warentest Bausparrechner