What formula should I use to calculate vacation cost over 10 years at 3% inflation.
C Craig Schef Mar 17, 2005 #1 What formula should I use to calculate vacation cost over 10 years at 3% inflation.
J Jason Morin Mar 17, 2005 #2 A1: Vacation cost A2: Inflation % A3: Time Period =A1*(1+A2)^A3 HTH Jason Atlanta, GA
K Ken Russell Mar 17, 2005 #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 [email protected] Remove yourhat to reply by e-mail ..
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 [email protected] Remove yourhat to reply by e-mail ..
C Craig Scheffler Mar 17, 2005 #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
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
