Learn how to calculate a predicted sales figure for a particular month given averages for the previous 12 months using Microsoft Excel.
- Sometimes, it's better to handle chunks of data…when dealing with a time series.…So instead of looking at a sales figure one month at a time,…we may get a higher level insight by chunking a few months…together, and seeing how that chunk compares…to other months that are chunked together.…This is call a simple moving average.…Sometimes it's even referred to as a rolling average.…I'm in the 02_02_Begin worksheet in the exercise files,…so feel free to follow along there.…These are the same sales figures…as 02_01 from the sporting goods store.…
The moving average will give us a bit more…seasonal insight than the naive approach.…I like it a little bit better.…I'm going to do a three-month moving average.…This method will predict the sales figures for each month,…starting with April 2015.…So we're going to start here.…Since we don't have a figure for July in this data set,…I'm going to go ahead and delete it in Row 32, for now.…To do a three-month moving average, I'll have to take the…average of the first three months.…
- The four different types of financial statements
- Moving averages
- Seasonally adjusted trends
- Pro forma statements
- Sales forecasting
- Forecasting expenses
- Projecting cash flow
- Regression analysis
Skill Level Intermediate
Finance Foundations: Business Valuationwith Jim Stice1h 49m Appropriate for all
1. Finance Basics
2. Simple Financial Forecasting
3. Pro Forma Financial Statements
4. Projecting Cash Flows
5. Introduction to Regression Analysis
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.