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!