Rolling Forecasts with Excel

Total time

Rolling Forecasts with Excel

Mullan Training
Logo Mullan Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

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

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 Content

  • Design of fully integrated …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

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

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 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.
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.