Public Sector Financial Modelling Workshop

Best-practice & flexible financial modelling to support decision making in a dynamic Public Sector environment

  • August 27th - 28th, 2019
  • Cliftons Sydney

OVERVIEW

Download the brochure Download the brochure

- Develop & apply technical excel skills to produce a best practice financial model
- Gain the analytical skills needed to interpret complex or big data
- Develop a robust & informative financial model to drive strategic direction
- Overcome the common challenges associated with financial modelling in the Public Sector

SPEAKERS

Nico Mellett

Nico has been working with Axium Solutions since 2016. He is a qualified Chartered Accountant and has a core focus on financial modelling, data analysis and stakeholder management to ensure value is achieved and benefits are realised. Nico has been a contractor to the Department of Defence, delivering financial tender evaluation and RFT development services to large-scale capability acquisition projects. He was also Manager of Portfolio Analysis, where he developed and maintained financial forecasting models supporting DHA’s property portfolio.

Senior Consultant
Axium Solutions Pty Limited

SPONSORS

Become a Sponsor

PARTNERS

Become a Partner

PRICE & DISCOUNTS

Hurry!

Current discount ending!

3 Days

Prices start at

$2995*

More people? More savings!

3 - 4

Delegates

15%

Discount

5 - 7

Delegates

20%

Discount

8 +

Delegates

25%

Discount

THE SCHEDULE

Download the brochure Download the brochure
Workshop Day One
Workshop Day Two
Public Sector Financial Modelling Workshop

27 Aug - 28 Aug

Workshop

Essential soft skills that support best practice financial modelling

- Routinely consult with management to embed senior level awareness of project milestones

- Administer case by case benchmarking to ensure best practice and excellent outcomes

- Work closely with business and policy teams to meet organisational expectations and inform decision making

- Set written standards for models to maintain modelling quality and consistency


Planning techniques to support effective research, data gathering and analysis      

- An overview of the challenges associated with accessing robust and consistent data from a variety of sources

- Extend reach to broaden analysis and incorporate innovative types of qualitative and quantitative data

- Establish a data working group to maximise model value

- How to deal with large datasets when conducting in depth analysis


Financial modelling with uncertain and emerging variables  

- The challenges of working with uncertain variables and parameters

- The cornerstones of a flexible model

- Incorporate Sensitivity Analysis into a financial model to mitigate risk and increase accuracy

- Apply controls to ensure model accuracy and robustness


Financial modelling in a changing and political environment

- The art of project management and flexibility in a restructuring workforce

- Understand the key elements of scenario analysis and how it can inform senior level decisions

- Maintain a capable team whilst working with strict deadlines and limited funding

- Meeting internal stakeholders’ expectations whilst operating in a political environment

  • Nico Mellett Senior Consultant Axium Solutions Pty Limited

Workshop

Applying technical skills to aid best practice modelling     

- Common pitfalls of complex financial models and tools to overcome them

- Best practice methods to efficiently derive project budgets in a large and dynamic organisation

- Maintain vigilance in order to identify technical risks of a new model to mitigate user difficulties

- The value of developing a model based on structured data 


Ensure model quality through testing and evaluation     

- Techniques to measure model effectiveness through evaluative methods

- Methods to conduct thorough pilot testing to scrutinise a financial model

- A review of tools and functions that protect your data and increase model security


Create a clear model for finance and non-finance employees

- Tools to clearly visualise financial models that comprehensively display data and outcomes

- Apply basic VBA for simplicity and easy model navigation

- Understand the importance for best practice model documentation and specification to benefit multiple users

- A review of Graphical User Interfaces that enable clear presentation

 

Advanced financial modelling tools and functions

- Explore shortcuts that increase efficiency when building a robust, thorough financial model

- Review Aggregate Functions to simplify complicated and conditional calculations

- Understand different types of cell referencing to speed up variable calculations - Relative, absolute and mixed referencing

  • Nico Mellett Senior Consultant Axium Solutions Pty Limited

GETTING HERE / THE LOCATION

Cliftons Sydney

Level 13, 60 Margaret St, Sydney, NSW, 2000, Australia

+61 2 9250 0999

* Terms and conditions apply

All Event Categories

Find Your Next Event

or
or