excel sheet to calculate bank intrests over three years

[littlepete]

Hello all

it has been a while... the last week i have been trying to make an excel sheet that calculates the intrests of my bank. basic : 1,2% and loyalty: 1,8% both on yearly basis.
who can check my formula because the end total after three years is still not what i can check on websites doing the same calculation...
thank you so much !!!
here is the link to my file in the cloud:

intrest argenta.xlsm

1drv.ms

peter, leuven, belgium

 

[Drrellik]

Hey Peter,

I was looking at your sheet, are your calculation off by a little or a lot and are your projections over?

Looking at the second year 2025, you are getting 1.2% on the Basis + the 1.8% loyalty in Getrouw so are you making the 1.2+1.8 or should you only be getting the 1.8? because of the loyalty

Don

 

[littlepete]

Hey Peter,

I was looking at your sheet, are your calculation off by a little or a lot and are your projections over?

Looking at the second year 2025, you are getting 1.2% on the Basis + the 1.8% loyalty in Getrouw so are you making the 1.2+1.8 or should you only be getting the 1.8? because of the loyalty

Don

hello

top row in yellow are the numbers you can change: starting amount ; amount added each month ; rate at daily base ; loyalty rate : that only counts for money that has been a full year on the bank.
so: first year : only basic rate ; second year: basic rate + loyalty rate on the months in the first year and so on
the difference over three years is a difference of around 100 euro so there is still something not quiet ok... (should be 735 it's only almost 600) ... i'm still trying to find the difference ...
thanks for your reply !

 

[littlepete]

hello

top row in yellow are the numbers you can change: starting amount ; amount added each month ; rate at daily base ; loyalty rate : that only counts for money that has been a full year on the bank.
so: first year : only basic rate ; second year: basic rate + loyalty rate on the months in the first year and so on
the difference over three years is a difference of around 100 euro so there is still something not quiet ok... (should be 735 it's only almost 600) ... i'm still trying to find the difference ...
thanks for your reply !

 

[littlepete]

Hey Peter,

I was looking at your sheet, are your calculation off by a little or a lot and are your projections over?

Looking at the second year 2025, you are getting 1.2% on the Basis + the 1.8% loyalty in Getrouw so are you making the 1.2+1.8 or should you only be getting the 1.8? because of the loyalty

Don

hello
can you see any error in my formulae ? have you understood how the intrests work? very curious to see if this gets a solution ! thank you !