Rolling Forecasts with Excel

Summary

The Rolling Forecast allows finance professionals to identify opportunities and risks that contribute to or impair success.  This course will demonstrate how to build a cash flow model from scratch complete with assumptions, financials, supporting schedules and charts. 

Venue details:  
Belfast, 8-10 Amelia Street, Belfast
Start date & time:  
21 November 2019 09:30
End date & time:  
21 November 2019 16:30
Price: €270.53  (€257.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
10.00
CPD hours:  
7.00
Speaker details
First nameLast name
Mullan Training

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend?

This course is not suitable for inexperienced Excel users. Delegates will be expected to be familiar with the following in Excel:

  • Linking Spreadsheets
  • IF Function & Nested IF Statements
  • And & Or Functions
  • Lookup Functions (Horizontal And Vertical Lookup)
  • Subtotals
  • Conditional Formatting

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 recognise the financial
  • Loading historical data (opening trial balance) automatically and accurately
  • Model accuracy verification technique
  • Formulae to distinguish history from the forecast
  • Graphical outputs and key reports including the use of conditional formatting and other techniques in KPI’s etc.
  • Sensitivity Analysis within the model as an inherent part of the same.
  • The second and much shorter part of the day will entail the creation of a 13-week rolling cash flow forecast. This will not be an integrated model but operate as standalone cash flow forecast at the tactical level i.e. at the creditor, debtor, sales order, individual payment etc.

Key learning outcomes

  • On completion of this course you will have the ability to use some or all of the techniques and concepts presented for forecast generation within your own company
  • Communicate business and data insights with visually compelling dashboards and models
  • Learn how to adjust model variables and source data sets using dashboard interfaces (radio buttons, drop down lists, command buttons etc.)
  • You will also learn how to calculate forecast errors to update your financial model with more accurate.
  • The second part of the day regarding cash flow forecasting will provide a similar tool for short- term tactical cash flow forecasting purposes.