Roll-over Forecasting

Hunter Jiang

IFA Australia Founder
Senior Group Financial Controller

Hunter has designed and delivered many practical hands-on step by step training courses to accelerate the acquisition of financial management skills. As well as identifying key financial concepts in budgeting, reporting and analysis, he supports this knowledge with many simple and sophisticated Excel models. He also has the ability to access complex BI and reporting tools and make them come alive in common sense ways which can be replicated by the learner back in the office environment.

Roll-over Forecasting

Typical Planning Models

12 Months Budget 5 Year Plan Financial Forecast Sales & Operations Forecast Capital Expenditure Plan Cash Flow Forecast Integration of Planning Models

Basic Financial Forecasting Model

Assumptions Data Formula Model

Statistical Forecasting

Types Uses

Problems with Traditional Budgeting

The Desire for Control Effort & Time – Class Survey 10 Big Problems

Driver Based Planning

Key principles Nature of Planning Models Predictive Logic Diagram – Breakout session Worked Example – Demonstration Building The Driver Based Model – PC Session

Forecasting and the successful business: a theoretical overview

Communication, strategy, execution and luck Need to STOP and smell the coffee Problems with static point modelling Of swans and turkeys: sensitivity and scenario analyses Other methods

Forecasting

Importance of forecasting: budget versus forecast The budget / forecasting cycle Common types of forecasting: Zero Based Method Incremental Method Top Down Method Bottom Up Method Top Down and Bottom Up Risk versus uncertainty Factors to consider in developing a budget Practical issues

Forecasting in context

Common methods of financial forecasting Useful Excel functions and features Alternative to point estimate modelling (practical exercises): Scenarios Sensitivities Simulations Waterfall and tornado charts Other dashboard reporting tips

Performance Reporting

Moving from Drivers to KPI’s Trends, Targets, and “Beating Yesterday” Worked Example – Demonstration

Planning Systems

Key Elements Excel Hyperion, Cognos, BPC Data Issues Implementation What is Practical Impact of Change Roles & Accountability Tips & Tricks

Case Study

Over 200 Corporate real case studies

Procedures

Apply industry benchmark level best practices

Modelling

Combine working knowledge and Excel skills

In This Class You'll Get to...

Free Consulting

Our experienced consultant's will help you identify the skill gaps for your next move.

CPD Certificate

A formal company letter will be issued to you after class to help you claim your CPD hours.

Free Resume Edit

Our experienced consultant's will help you edit your resume before you apply for the target role.

Michele Meng
Financial Accountant
Healthcare

“The course had a fresh approach and was very interesting. The case studies and readings were excellent. The presenter was engaging.”

Financial Closing Course

Christina Li
Financial Accountant, Retail Industry

“The 3 courses around month end ( Month End Closing, Balance Sheet Reconciliations, P&L Review) are fantastic. They provide very practical steps for the work for the first 2 weeks of the month. This is training that is not really available elsewhere and usually has to be passed on by the senior members of the team.”

Financial Analyst , Government

“The course was amazing with lots of practical examples and classroom exercises. I learned a lot od new techniques and I am looking forward to impressing my boss next week.”

Prerequisites

The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheet users. It is designed for users who do use Excel on a regular basis, and are comfortable with using its tools and functions. At minimum, it is assumed that participants will know how to: Navigate confidently in Excel Use absolute cell references (e.g. =$A$1) Create and use advanced Excel tools and functions on a regular basis

Excel Version

Public courses are run in classroom set-up without workstations provided. Participants must bring their own laptops . The course is demonstrated using Microsoft Excel 2016, but participants can use Excel 2007 or 2010 if they prefer. Course materials contain instructions for different versions, and Excel 2011 for Mac users are also catered for. Those who would like to use a Mac are most welcome to bring their own laptops but not preferred.

ERP Installation

Public courses are run in classroom set-up without workstations provided. Participants must bring their own laptops . The operation part of the course is demonstrated using fortune 500 global business ERP system , the participants can use their window system to install the interface so they can experience the real word working environment . Those who would like to use a Mac can not install the interface.

Our Customers

Visit us

Level 5 ,251-253 Elizabeth Street, Sydney NSW 200

Call us

+61 499 180 115

Contact us