Rolling Forecasts with Excel
Starting dates and places
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 …
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.
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.