I want to estimate the profit of money in bank

Hello
I want to estimate the profit of money in bank

initial =100$ for 3 years
incearse per year = 10%

profit taken each 3 months should be 2.5$

the next month of the 3 months means in month number 4,7,10,1 the profit(2.5$) is added to the original amount so at month number 4 the inital money will be 102.5$ also for 10% yearly increase

I want to know how much the money at the end of each 3 months and at the end of 1 , 2, 3 years

Thanks

Is this what yopu are after?


Dave H

Thanks Dave so so much

I want to know why in 4th Quarter4 you multiply by 0.125

Hi,

I assumed you would still receive the 2.5% as well as the 10% but if this is not the case alter to 0.1

If you feel your problem has been solver please mark your thread as solved.

Thanks

Dave H

Apologies after re-reading your original post you have 2.5$ profit a month not 2.5%.

I have modified to suit (in the fourth quarter I have added the 2.5$ before applying the 10% increase.

Dave H

Thanks alot for your help