Rolling forecasts with Excel

Summary

The aim of this course is to produce a rolling forecast in MS 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:  
Dublin, Professional Training, Unit 22 Westland Square, Pearse Street, Dublin
Start date & time:  
11 December 2019 09:30
End date & time:  
11 December 2019 17:00
Price: €468.75  (€375.00 Member 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
Damien O'Neill

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend

The preferred skills required would for a participants to be accountants who have attended or have equivalent knowledge of the CAI 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

Professional Training is a group of experienced specialists providing focused training in IT and Management skills. Our trainers use a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation by our course participants. We have delivered a range of CPD programmes with Chartered Accountants Ireland since 1997. Website: www.professional.ie