October2019
Registered User
- Messages
- 125
1. Insert the principal amount when you came off the Fixed rate in the highlighted blue cell | |||
2. Highlight, right click and delete out all rows up to the date you came out of the fixed rate. | |||
3.In the first cell under the write down amount (cell B11) replace #ref! with the figure in the yellow box | |||
4. insert the actual interest rate you were charged in column C- the rates that are currently there are the Standard Variable rates | |||
5. scroll down to the end of the sheet to see your Interest overcharged amount ( hit Control and End and it will bring you to it) |
4. insert the actual interest rate you were charged in column C- the rates that are currently there are the Standard Variable rates
Hi everyone, I have done up a calculator which should give a fairly accurate idea of how much you will receive. It is a bit of a large sheet but the procedures at the top of the page are pretty simple, anyone familiar with basic excel can have it done in 2 minutes once they have their information. It is based on the standard variable rates that AIB were charging over the period but if you were on a different rate just follow the procedures at the top of the page. I have Capitalised the Interest quarterly as that is when AIB charge Interest. I have used the last day of the month in each quarter, I know this probably differs to the dates that AIB charge the Interest but this should not make much of a difference. Happy to take any advice/constructive criticism of the attachment.
Hello Brendan,It is from the date your first fixed rate ended up until now. What happened after that is not relevant.
Brendan
October2019 looking for help with the calculator I’ve no excel on my phone my fixed rate ended 3/4/2012 mortgage of £231-378Hi everyone, I have done up a calculator which should give a fairly accurate idea of how much you will receive. It is a bit of a large sheet but the procedures at the top of the page are pretty simple, anyone familiar with basic excel can have it done in 2 minutes once they have their information. It is based on the standard variable rates that AIB were charging over the period but if you were on a different rate just follow the procedures at the top of the page. I have Capitalised the Interest quarterly as that is when AIB charge Interest. I have used the last day of the month in each quarter, I know this probably differs to the dates that AIB charge the Interest but this should not make much of a difference. Happy to take any advice/constructive criticism of the attachment.
Happy for them to use it if they can get it rightOctober
I think you should put a copyright symbol © on your calculator.
AIB doesn't know how to calculate the interest and so they might plagiarise yours.
Brendan
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?