>>>>>>>>>>>>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.
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
and so on for 84 months or 7 years.
Thank you for your help
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.