Solved: Sales forecast [Archive]

mariusc

01-25-2011, 11:57 PM

Hello,

I have the excel attached.
How can I estimate the forecast for the followings 5 years considering the info that I have already ?

Bob Phillips

01-26-2011, 01:04 AM

Surely, with only one year of data it is not possible to forecast. Is the trend up or down? With just one number there is no trend.

mariusc

01-26-2011, 01:06 AM

Hi James,

Trend is up

Bob Phillips

01-26-2011, 01:10 AM

But by how much? 5% per month, variable? Again, no information to use as a forecast.

mariusc

01-26-2011, 01:19 AM

2 %

Bob Phillips

01-26-2011, 01:59 AM

So just enter

=INT(B2*(1+2%))

in C2, and copy down and across

mariusc

01-26-2011, 02:16 AM

Thank you, James.
I didn`t knew about this posibility.

Bob Phillips

01-26-2011, 02:36 AM

It would be better to put the 2% in a cell and reference that cell. easier to change then.