Methodology

The course is a hands-on workshop that applies the forecasting techniques utilizing MS Excel through the use of different exercises and case studies.

Course Objectives

By the end of the course, participants will be able to:

Apply different forecasting techniques that will help in making financial and business decisions

Utilize Microsoft Excel to build forecasting models effectively

Explain the different macro and micro assumptions affecting financial and business forecasts

Build models for forecasting income statements, balance sheets and cash flow statements and their components

Differentiate between various forecasting models and approaches and assist senior management in understanding their impact

Target Audience

Financial controllers, analysts, finance and accounting managers, supervisors, and finance professionals who need to create, interpret and maintain forecasts in their organizations.

Target Competencies

Forecasting

Time series analysis

Regression analysis

Modeling financial statements

Applying Excel functions and tools