Spreadsheet functions
 

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

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

I have seen spreadsheets asking you to specify number of year analysis you
want to generate. You put 5 or 3 and it generates a 5 -year or 3- year
column spreadsheet. The formula was not visible so I could see how it was
done.


"Damon Longworth" wrote in message
...
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

It is hard to advise, because your application will be specific. You could
add a message box asking the user the number of years. Your code would take
this number and generate the appropriate columns formatted with the required
data.

You should be able to record most of the required steps. Have a look at
MsgBox in help. Post back if you get stuck.

--
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:t1eve.98$bz6.96@trndny06...
I have seen spreadsheets asking you to specify number of year analysis you
want to generate. You put 5 or 3 and it generates a 5 -year or 3- year
column spreadsheet. The formula was not visible so I could see how it was
done.


"Damon Longworth" wrote in message
...
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

Thanks I will give it a try.
Derrick


"Damon Longworth" wrote in message
...
It is hard to advise, because your application will be specific. You could
add a message box asking the user the number of years. Your code would
take this number and generate the appropriate columns formatted with the
required data.

You should be able to record most of the required steps. Have a look at
MsgBox in help. Post back if you get stuck.

--
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:t1eve.98$bz6.96@trndny06...
I have seen spreadsheets asking you to specify number of year analysis you
want to generate. You put 5 or 3 and it generates a 5 -year or 3- year
column spreadsheet. The formula was not visible so I could see how it was
done.


"Damon Longworth" wrote in message
...
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