R
Ralph
I had a year's worth of transactions figures, totalled for each month. It
only went up to May so I was able to use the forecast function to project
ahead to June and July. However I now need to project ahead for a whole
'nother year, but assuming that our transactions will go up by 10% in total.
I can't figure out how to project that way. I suppose I know what the total
for the year has to be (e.g. 10% more than the previous year), but I don't
know how to make Excel produce a projection that will chart a 10% growth over
12 months. Someone did suggest that it would involve multiplying by 1.1 (e.g.
110%) but I'm still lost!
only went up to May so I was able to use the forecast function to project
ahead to June and July. However I now need to project ahead for a whole
'nother year, but assuming that our transactions will go up by 10% in total.
I can't figure out how to project that way. I suppose I know what the total
for the year has to be (e.g. 10% more than the previous year), but I don't
know how to make Excel produce a projection that will chart a 10% growth over
12 months. Someone did suggest that it would involve multiplying by 1.1 (e.g.
110%) but I'm still lost!