Mortgage Interest Calulations

I have a mortgage details of which I give below for a 3 month period. The Interest Rate for the period 17/12/2011 to 19/12/2011 was 2.2%. Interest was paid on 16/12/2011 for the previous quarter. The next Interest deduction will be due on the 16th of March 2012. The current rate is still 1.95% and will be up to the 16th March 2012. I have a suspicion that based on previous quarter Interest charged that they are overcharging me. I just want the calculations from a few of your very helpful and able posters what INTEREST I should be expecting to be charged on 16/03/2012. I will update the site when I get my interest bill from the bank. Thank you.

20/12/11 New Interest Rate
20/12/11 Lending @ 1.950% 109,776.70 DR
03/01/12 Interest Rate
03/01/12 Lending @ 1.950% 109,776.70 DR
05/01/12 LOAN REPAYMENT 690.33 109,086.37 DR
06/02/12 LOAN REPAYMENT 690.33 108,396.04 DR
05/03/12 LOAN REPAYMENT 690.33 107,705.71 DR

Cannot edit my original post as I am trying to make my posting clearer so I hope this is clearer.
I have a mortgage details of which I give below for a 3 month period. Interest was paid on 16/12/2011 for the previous quarter. The next Interest deduction will be due on the 16th of March 2012. The current rate is still 1.95% and will be up to the 16th March 2012. I have a suspicion that based on the previous quarters Interest charged that they are overcharging me. I just want the calculations from a few of your very helpful and able posters what INTEREST I should be expecting to be charged on 16/03/2012 for the period 17/12/2011 to 16/03/2012. I will update the site when I get my interest bill from the bank. Thank you.

Date Lending Rate Repayments Balance

17/12/11 Lending Rate 2.2% €109,776.70 DR
20/12/11 Lending @ 1.950% €109,776.70 DR
05/01/12 LOAN REPAYMENT €690.33 €109,086.37 DR
06/02/12 LOAN REPAYMENT €690.33 €108,396.04 DR
05/03/12 LOAN REPAYMENT €690.33 €107,705.71 DR

Dermot said:

I just want the calculations from a few of your very helpful and able posters what INTEREST I should be expecting to be charged on 16/03/2012.

Click to expand...

I think €534.72

http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html

If you download this spreadsheet and set it up for the mortgage.

I found it very accurate.