Rolling Forecasts with Excel

The key benefit will be the ability to use some or all of the techniques and concepts presented for forecast generation within the participant’s own organisation. The second part of the day regarding cash flow forecasting will provide a similar tool for short- term tactical cash flow forecasting purposes.

Pre-requisites

The preferred skills required would be for a participant to have attended or have equivalent knowledge of the Intermediate and/or Advanced Excel courses. The course is not suitable for inexperienced Excel users.

Course Content

• 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 bottomup reporting structure frommonthly detailed to quarterly top level reporting.
• Reconciliation between the rolling aspect of the model with the requirement to recognise the financial implications
• Loading historical data (opening trial balance) automatically and accurately
• Model accuracy verification technique.
• Formulae 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.
• 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.

Click here to download:

Rolling Forecasts with Excel(1)