Forecasting Techniques

Overview:

This Forecasting Techniques course will teach you qualitative and quantitative forecasting techniques. Various quantitative techniques will be covered, including an application of each technique to a practical situation. The course will use these techniques in a financial model to produce compelling financial forecasts.

Course Content:

In this course, you will gain knowledge about the following topics:

• Qualitative techniques

• Quantitative techniques

   

Learning Objectives:

 Upon completing this course, you should be able to:

• Explain how Goal Seek can be used when forecasting in a financial model.

• Calculate an optimal solution for a forecast using the Solver tool in Excel.

• Build a financial model forecast using the slope and Y-intercept from a linear regression.

• Create a forecast using the coefficients from a multiple linear regression.

• Explain how forecast functions in Excel can be used to forecast a seasonal business.

• Build a forecast for a seasonal business showing the upper and lower confidence intervals.

   

Who Will Benefit: 

This course on forecasting techniques is designed for those responsible for producing and maintaining forecasts in financial models within their organizations. This may include professionals in financial planning and analysis (FP&A), accounting, treasury, financial reporting, corporate development, and capital markets.