Help with forcasting

[ljf101]

Hi everyone
Can anybody help with this, I'm a complete excel rookie trying to show a rolling average forecast into 2005 (b9:g12) but want can other formula can I use to show the figures decreasing and not just averaging?

Thanks Lee

forecast.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Cost/RevenueElements	Jan04	Feb04	Mar04	Apr04	May04	Jun04	Jul04	Aug04	Sep04	Oct04	Nov04	Dec04
3	relief	343,087.33-	397,387.90-	381,699.85-	437,225.72-	322,024.60-	333,801.23-	349,781.71-	375,745.32-	283,673.94-	288,429.82-	296,707.87-	272,706.22-
4	expense	233,828.96-	248,983.76-	221,353.39-	273,932.24-	140,869.32-	160,253.73-	45,305.29-	134,954.92-	25,923.26-	165,780.98-	53,355.22-	93,806.39-
5	Profit	109,258.37-	148,404.14-	160,346.46-	163,293.48-	181,155.28-	173,547.50-	395,087.00-	240,790.40-	257,750.68-	122,648.84-	243,352.65-	178,899.83-
6		Rollingaverage
7	Cost/RevenueElements	Jan05	Feb05	Mar05	Apr05	May05	Jun05	Jul-05	Aug-05	Sep-05	Oct-05	Nov-05	Dec-05
8	relief	340,189.29-	339,925.83-	334,179.63-	328,899.60-	315,358.84-	314,406.59-	0	0	0	0	0	0
9	expense	149,862.29-	142,228.95-	131,553.47-	121,575.71-	102,531.14-	97,054.26-	0	0	0	0	0	0
10	Profit	197,877.89-	205,934.21-	211,687.21-	217,391.74-	224,154.02-	230,296.70-	0	0	0	0	0	0
Duff

 

[Oaktree]

Lee:

I'm a little confused. By "rolling average", how many months do you want to average? (e.g. January 2005 = the average of the 3? prior months).

What do you mean by "to show the figures decreasing and not just averaging"?

Also, as a suggestion, your data will be easier to manipulate, particularly with rolling averages, if you have both years side by side (e.g. put B8 into N3 etc.)

 

[ljf101]

I have figures for the whole of 2004 and I want to show a forcast of say 5 months into 2005 of these figures droping but if I show an average (which I think I've done) the figures in 2005 will not be any lower.
Also Point taken, I do have 2004 and 2005 all on the same rows but I thought it would be easier to see on the message board.

Lee