Rolling Forecasts with Excel

Summary

The aim of this course is to produce a rolling forecast in Excel (18 months). This entails heavy automation to facilitate the re-use of the model to create updated forecasts on an ongoing basis. This automation involves rolling out into the future and recognising opening historical position and financial years.

Venue details:  
, Professional Training, Unit 22 Westland Square, Pearse street, Dublin
Start date & time:  
10 June 2020 09:30
End date & time:  
10 June 2020 17:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
12.00
CPD hours:  
7.00
Speaker details
First nameLast name
Damian O'Neill

Description

Product type:  
CPD course
Category:  
Technology and data

Who should attend

Accountants, or other business professionals, who have attended or have equivalent knowledge of the Institute's CPD Intermediate and/or Advanced Excel courses. The course is not suitable for inexperienced Excel users.

Course overview

  • Design of fully integrated model (self balancing etc.)
  • High level of automation of model: based on a case study approach
  • Macro usage for basic assumption setting (e.g. dates covered), automation and report generation
  • Hierarchical bottom up reporting structure from monthly detailed to quarterly top level reporting
  • Reconciliation between the rolling aspect of the model with the requirement to recognize the financial year
  • Loading historical data (opening trial balance) automatically and accurately
  • Model accuracy verification technique
  • Formulas to distinguish history from forecast
  • Graphical outputs and key reports including use of conditional formatting and other techniques in KPI's etc
  • Sensitivity Analysis within the model as an inherent part of same

Key learning outcomes

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

  • Use some, or all, of the techniques and concepts presented for forecast generation within the participant's own organization.
  • Gain the corresponding Excel tools for short-term tactical cash flow forecasting purposes

Speaker bio