Forecasting Techniques

Forecasting Techniques Course 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 financial model to produce compelling financial forecasts.

Forecasting Techniques Learning Objectives

By the end of this course you will 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 Should Take This Course?

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.