>>>>>>>>>>>>I REPOSTED THIS in Pre-Algebra/algebra because I think that I was not too clear and I gave more info....and maybe this is more an algebra problem Please go there to help me.

HI

I am lost on what to do here. I know that I knew long time ago but i just cant remember now.

I am doing business plan projections on an excel spreadsheet.

I have 7 years of MONTHLY sales figures.

I want to use the same figures but do several different projections like what if I can do better than I expect and can do 7 years of these sales in 5 years. or 6 years. or whatever.

So the data is simple. The sales have some fluctuations so they do not go in a straight line.

month sales amount

1 5000

2 8000

3 7000

4... 8500

and so on for 84 months or 7 years.

Thank you for your help

tstmlone

Work Done

I currently have the variable expenses and other items set up to adjust for the new sales figure... but I do not know how to logically adjust the number of years to goal for the sales figure itself easily.