Learn how to use a damping factor on simple moving averages to obtain a more aesthetically pleasing representation of future forecasts.
- [Instructor] Another technique we can use…to make some predictions using just revenue…is called exponential smoothing.…Exponential smoothing is analogous to a rolling average…but it's not quite the same thing.…Let's get started and you'll be able to see the difference.…I'm in the 02_05_Begin exercise files.…We'll use columns J and again, so I'm going to scroll over…to the right, this is our quarter and sales.…Now, we're going to be using a built-in function, and to do…this, you'll have to install the analysis tool pack.…
On Windows, I believe you can access the tool pack…by going to file, options, and then under add-ins,…you can choose the analysis tool pack and click go.…On Mac, it's a bit different, so let me just show you…how to do that here.…Go up to tools, Excel add-ins, and then click on…the analysis tool pack checkbox for the add-ins available…and then press OK.…So now, when I go into the data tab,…I should have a data analysis option.…And the same thing should hold true for Windows users.…
So let's go ahead and go to it.…
- 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.