Admission in Executive Fellow Programme in Management (EFPM) AY 2024-25. (Apply Online )   | Admission in Full-Time Fellow Programme in Management (FPM) AY 2024-25. (Apply Online )   | Applications are Invited for NRI/NRI Sponsored Seats. (Apply Online )   

Fore School of Management
  • Library
  • FORE in Media
  • Campus Tour
  • Alumni
  • Vacancy
  • Tenders
  • Blog
  • Login
Menu Icon

Forecasting Methods for Basic Financial Analysis (Using Excel and R)

Download Brochure

Duration: 2 days
Timings: 1000hrs -1730hrs
Dates: June 18-19, 2022
Programme Director: Prof. Aditya Banerjee
Mode: Online
Fees: Rs.8000 Plus GST @18%

Programme Introduction:

This programme is aimed at executives who want to use cutting edge forecasting methods in their business using R and Excel and want to learn application of statistical models like ARIMA in real world scenarios.

Various real-world examples and datasets are used for all topics. The programme strikes a great balance by bringing together statistical concepts in easy-to-understand format and their applications in managerial decision-making.

Programme Objective:

The program has been designed to:

  • Provide an overview of statistical forecasting methods
  • Teach participants the use of Excel and R in forecasting
  • Application of linear regression (2-variables and N-variables) in forecasting
  • Provide the participants a conceptual understanding and teach them practical application of forecasting with Time Series data
  • Teach the application of Box-Jenkins (ARIMA) methodology for forecasting

Programme Content:

An indicative list of the sessions to be covered in the programme is as follows:

Session 1:

  1. Introductory Session: Why Forecast?
  2. Getting Started with R and Excel
  3. Linear regression in 2-variables and N-variables

Session 2:

  1. An application of linear regression in forecasting
  2. Regression with time component

Session 3:

  1. An overview of time series and Moving Average
  2. Time series decomposition and Forecasting with Moving Averages and Exponential Smoothing

Session 4:

  1. Box-Jenkins Methodology (ARIMA)
  2. Forecasting with ARIMA Models

Programme Methodology:

All the topics contain a blend of discussions on basic theories and advanced topics, focusing on the practical implementation of knowledge. The sessions will be conducted in an online mode and it will be mostly practical oriented (using Excel and R). Participants will be able to gain a strong understanding of the course via theoretical sessions, practical sessions, case study discussions, problem-solving and discussions with the facilitator.

Target Organizations:

IT Sector, Financial Sector, Marketing Sector, Banks, Government Organizations.

Target Participants:

Participants working in IT sector, banking sector, consulting firms, and marketing roles.

Program Faculty:

Prof. Aditya Banerjee is currently an Assistant Professor in the Finance and Accounting Area at the FORE School of Management (FSM). He has completed his PhD in Finance from IIM Ranchi. Before joining FSM, He was an Assistant Professor in the Finance Area at the University of Petroleum and Energy Studies (School of Business). He has been a Lecturer in the Finance area at the Royal University of Bhutan (GCBS). He has several publications in peer-reviewed journals indexed in Scopus and listed in ABDC and ABS. His research focuses on understanding how information from different sources affects stock price movement differently.

Corporate Group Discount:

One complimentary nomination for every group of three nominations from the same organization, i.e., 3+1 participants for the fee of 3 participants.

For registration/enquiries , please mail to or call at 011-26856301/ + 91 9166085159/ +91 9810875278/ + 91 7976445970

Executive Education/MDPs

FORE School of Management has been designing, developing and conducting innovative Executive Education (EE)/ Management Development Programmes (MDPs) for working executives in India for over three decades.