PLease HElp on Complex Formula!

  • Thread starter Thread starter Diego
  • Start date Start date
D

Diego

Hi everyone,

I have a very complicated issue, maybe you guys can help.

Here is the situation

I have 600+ records (assume they are rates) and they increase ever
year by 4%. I need to take these 30 years ahead in time not a big dea
X^30.

Now here is the problem, each year I have to calculate 1% of the tota
amount so 1% of year 1 + 1% of year 2 ... 1% year 30 and this 1% wil
generate a 8% profit per year creating a compound interest issue. I’
trying to find out what is the amount of each record after 30 growin
by 4% and taking a 1% generating 8%. Since I have 600 records at 3
years each I do not wish to create a huge table, anybody can think of
formula that resume this?

Gladly appreciate all the help I could get!!

Thank
 
Diego,

You've also posted this in other excel groups. This may cause others to
work on a solution not knowing it's already been done.
 
Back
Top