Formula-Compound Sales Forecast
Hi
With Initial value in B1, Percent increase in C1 and Number of years in
D1
=B1*(1+C1)^D1
--
Regards
Roger Govier
"GatorGirl" wrote in message
...
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!
|