Learn how to create weights for different months based on seasonality and apply this to simple moving average calculation in Microsoft Excel.
- [Instructor] I'm in the 02_03_Begin exercise file.…I generated a line graph of our fictitious…sporting goods store sales figures over time.…Now, just by looking at the graph you can tell…that the sales are trending upward.…However, it's a bit difficult to make a prediction…of exactly what the July 2017 figure's going to be…in B32 by looking at this graph.…You can see that their are several irregularities here.…There are peaks and valleys, and ups and downs.…So it's a little bit difficult to figure out how do I zone…in on exactly what that 2017 July figure is going to be.…
Well, I could use a simple moving average, but I think…that approach is just a little bit too simplistic.…Remember, all we do is we take the average…of three months prior to the month that you want to predict.…It's a simple sum, you just divide it by three.…And I want to think about this another way.…What if we were to say that the month immediately…before the one we're trying to predict has more value…than the other two months in our three-month moving average.…
- 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.