Just got the mortgage statement from my bank for the year and the last interest rate applied was based on the 12th november cut. The rate has changed by 1.25% since that so I'm wondering how I can figure out what my repayment will be once this rate is in effect?
I can give figures if that helps because I have the statement!
PaddyW;795301 unfortunately it won't allow me put in decimals and that said:If you have Microsoft Excel, the formula below can be copied and pasted into the tool bar and press enter, it gives a repayment of €704.08.
=pmt(3.25%/12,379,-166699.84)
The page can be saved and a different interest rate, term and amount owed inserted to get an instant accurate repayment.
The advantage over jeacle is you can have any number of months (in this case 31 years, 7 months is 379), and any uneven amount owed.
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?