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