Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Forecasting Expenditures in Excel
Name: GiveMePatience Date: February 26, 2007 at 07:14:53 Pacific OS: Windows XP CPU/Ram: 1.8ghz/512mb Product: IBM/Thinkpad
Comment:
I have historical expenditure data for 8 quarters (previous fiscal yrs) and 3 quarters (current fiscal yr). I'm trying to forecast the next 5 quarters based on historical data. The key is that percentage-wise the trends would be very similar (if not equal). The trending line for the first 8 quarters would mirror the trending line for the next. Since i already have the info for 3 of the 'current' quarters the start of the trend line seems to be parallel to the line of the 'historical' quarters. But I can't figure out how to forecast the next five quarters so that the lines parallel throughout. I've tried the forecast formula within Excel, but have not had any luck. In one row have 8 quarters running accross 8 columns, and in the next row I have 3 quarters running across 3 columns. Any ideas?
Name: Grok Lobster Date: February 26, 2007 at 11:26:40 Pacific
Reply:
If the data is graphed, it is very simple, just right-click on the data series you want to add the trend info to and choose Add Trendline. The second tab of the ensuing dialog let's you choose how many intervals.
0
Response Number 2
Name: GiveMePatience Date: February 27, 2007 at 06:08:48 Pacific
Reply:
Didn't work well as I hoped. I am trying to get estimated values as well. Thanks for your help anyway.
Summary: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any background colour on it, nor should the links being seen. O...
Summary: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date. I am making a spreadsheet that keeps track of Mo...
0 
