Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inflation
What formula should I use to calculate vacation cost over 10 years at 3%
inflation. |
#2
|
|||
|
|||
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. . |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) |