HELP!! very complex formula
 

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 every
year by 4%. I need to take these 30 years ahead in time not a big deal
X^30.

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

Gladly appreciate all the help I could get!!

Thanks


---
Message posted from http://www.ExcelForum.com/

HELP!! very complex formula
 

Diego,

You've also posted this in other excel groups (at least three others). This
may cause others to work on a solution not knowing it's already been done.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Diego " wrote in message
...
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 every
year by 4%. I need to take these 30 years ahead in time not a big deal
X^30.

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

Gladly appreciate all the help I could get!!

Thanks


---
Message posted from http://www.ExcelForum.com/