Sales projections

  • Thread starter Thread starter tina
  • Start date Start date
T

tina

Hello,

I need to post sales projections for the end of the year.
I am not sure the best way to go about this. Is it
possible to take the YTD sales and multiply by a
percentage increase? Or could I divide the YTD sales by
LYTD sales then multiply by the number of months remaining?

Any help that you could give I would greatly appreciate.

T
 
If your YTD sales figure is in cell a1 and your sales are
steady throughout the year (not seasonal - high in winter,
low in summer):

+(a1/y)*12 where y is the months that have past. This is
the monthly average times the number of months in a year.
You could also project an increase:

=((a1/y)*12)*(1+a2) a2 is the percentage increase (.05,
for example) which you can change so you can see the
results if it was a 10% (.10), or 7.5% (.075), etc.

Hope this helps..
 
Back
Top