Try:

Not sure what you mean by "automatically generate 3 5 or 10 years column".

To create an annual increase, multiply the value by 1.10.

10*1.10=11

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Derrick Robinson" wrote in message
news:Todve.472$GP6.225@trndny03...
I am creating a New product development business analysis spread sheet. I
would like to know how I can automatically generate 3 5 or 10 years column
for the analysis.
Also whenever I enter a sales revenue for year one I would like year 2 to
be a specified percentage increase of year 1 sales and the same percentage
increase over year 2 sales. Its like a constant 10% increase. The same
would be for the variable and fixed cost. I cannot come up with the
formula to do these automatically. Any help would be highly appreciated
Derrick