projected sales?

how do i caluclate or create a formula and graph for projected sales

Hi!

You'll have to tell more!

What assumptions are you making about sales forecasts (e.g. + 4.5% p.a.)?

What base position (date: amount (fictitious, I assume!)).
How long the forecast? Intervals (month/year...).

That's the hard part. Come back and we can see if we can then turn it into a suitable graph.

Alf

There's information on the Microsoft site that may help you get started:

http://office.microsoft.com/en-ca/te...347891033.aspx

http://office.microsoft.com/en-us/as...119631033.aspx

http://office.microsoft.com/en-us/as...413031033.aspx

briansoliz wrote:
> how do i caluclate or create a formula and graph for projected sales


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html