The formula by Roger would give you the compounded sales figure based on
Percentage increase every year for the duration you need.

However, if you need to find an estimation of what your sales would look
like by 2012, based on sales historically, you ll need to use advanced
statistics and consider seasonality and Trending.
You can also use the built in function "Forecast" which exists in excel,
which could help you to some extent.

Thanks.

"GatorGirl" wrote:

I am looking for a formula which would give me a sales figure for 2012 (5 yrs
from now) based on a % increase from 2006 year end.

I have a specified cell for 2006 figures, an input cell for the % increase
per year. Now I am trying to find a formula which will take this and
compoundly increase sales for 5 years.

I'm sure it it right in front of me but I cannot seem to make sense of some
of the formulas.
HELP!