What formula should I use to calculate vacation cost over 10 years at 3%
inflation.

A1: Vacation cost
A2: Inflation %
A3: Time Period

=A1*(1+A2)^A3

HTH
Jason
Atlanta, GA

-----Original Message-----
What formula should I use to calculate vacation cost
over 10 years at 3%
inflation.
.

If cell A1 contains the first year's cost, then the formula is =A1*1.03^9.
(Note that 9 and not 10 is the incremental years, 10-1=9).

--
Ken Russell


Remove yourhat to reply by e-mail
..

"Craig Schef" <Craig wrote in message
...
What formula should I use to calculate vacation cost over 10 years at 3%
inflation.

I think I phrased the question wrong. Instead, what is the total cost of the
inflation after 10 years. The calculation below figures the inflation for the
10th year.
Thanks

"Jason Morin" wrote:

A1: Vacation cost
A2: Inflation %
A3: Time Period

=A1*(1+A2)^A3

HTH
Jason
Atlanta, GA

-----Original Message-----
What formula should I use to calculate vacation cost
over 10 years at 3%
inflation.
.