Need an Excel formula
 

I need an excel formula that will calculate the total sum of a number when
escalated by a fixed percentage rate over a variable number of years. My
variables would be the initial cost and the number of years. the fixed
number would be the 6% increase compounded each year. Can you help?

Need an Excel formula
 

=A2*(1+6%)^B2
--
David Biddulph

"Paul G" <Paul wrote in message
...
I need an excel formula that will calculate the total sum of a number when
escalated by a fixed percentage rate over a variable number of years.
My
variables would be the initial cost and the number of years. the fixed
number would be the 6% increase compounded each year. Can you help?

Need an Excel formula
 

Use the FV function, as in:

=FV(6%,a1,,-a2)

Regards,
Fred

"Paul G" <Paul wrote in message
...
I need an excel formula that will calculate the total sum of a number when
escalated by a fixed percentage rate over a variable number of years.
My
variables would be the initial cost and the number of years. the fixed
number would be the 6% increase compounded each year. Can you help?