Public Sector Financial Modelling Workshop

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

  • November 27th - 28th, 2019
  • Cliftons Wellington


Download the brochure Download the brochure

- Develop & apply technical skills & spreadsheet tools to produce a best practice financial model
- Explore the financial impacts of digital transformation & shared service trends
- Overcome the common challenges associated with financial modelling in the Public Sector
- Effectively engage complex ideas with ‘non finance’ employees & stakeholders


Lance Rubin

Lance has a wealth of modelling experience across financial and professional services having worked at two of the Big 4 accounting, Investec Bank Corporate Finance & Advisory and National Australia Bank across both retail and wholesale banking divisions and products.

Lance started his own financial modelling consultancy firm following over 20 years' corporate experience, having moved most recently from the KPMG modelling team (and prior to that, NAB).

Founder & Chief Executive Officer
Model Citizn


Become a Sponsor


Become a Partner



Current discount ending!

11 Days

Prices start at


More people? More savings!

3 - 4




5 - 7




8 - 9




10 +




*Only one discount applies at any given time.


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

27 Nov - 28 Nov


Start with the big picture: What are you modelling and why?

- The role of financial modelling in a Government context

- Understand your stakeholders, services, people, resources and outcome needs

- Determine resource and service delivery consumable costs

- Explore financial impacts of new frameworks, digital transformation, and shared service trends

Design your model to meet organisational expectations and deliver value

- Establish model dimensions, define fixed and variable parameters

- Case-by-case benchmarking to ensure best practice outcomes

- Ensure the right assumptions are made - Are they realistic? Do they reflect what is really happening?

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

Data sourcing, analysis and dealing with large datasets

- What are the differences or similarities between analytics and modelling 

- Overview of challenges with accessing robust and consistent data from a range of sources

- Incorporate innovative types of qualitative and quantitative data to broaden analysis

- Extract relevant information, identify cost drivers, and conduct unit cost analysis

Financial modelling with uncertain and emerging variables

- The cornerstones of a flexible model, managing variable uncertainty

- Incorporate sensitivity analysis to mitigate risk and increase accuracy

- Apply controls to ensure models are achievable and produce robust financials

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

Technical skills think-tank: Advanced financial modelling tools and functions

- Shortcuts to increase efficiency when building a robust, thorough financial model

- Review aggregate functions to simplify complicated and conditional calculations

- Speed up variable calculations with relative, absolute and mixed referencing

  • Lance Rubin Founder & Chief Executive Officer Model Citizn


Ensure model quality through testing and evaluation

- Techniques and tools to measure model effectiveness through evaluative methods

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

- Ensure financial models integrate properly

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

Translate modelling into effective management action plans

- Help your organisation to identify savings targets, add value, and develop savings or revenue plans

- Clarity on how to use models to plan for long-term viability, and understand systems and processes to facilitate change

- Ensure action plans in place to achieve savings or increased revenue targets

- Effective articulation and presentation of complex ideas that achieve stakeholder expectations

Developing the model for finance and non-finance employees

- Explore information presentation tools

- Assist operational management to understand the financial ramifications of their service

- Ensure model can be understood, maintained, and updated without reliance on subject matter expertise

- Ensure technical changes can be made to model with rebuilding

Soft skills think-tank: Essential soft skills to support best practice financial modelling

- Routinely consult with management to embed senior level engagement and awareness

- Liaise with business and faculty teams to understand needs and inform decision making

- Practical exercise - Use a model to present with influence and make better decisions collaboratively 

  • Lance Rubin Founder & Chief Executive Officer Model Citizn


Cliftons Wellington

Level 28, The Majestic Centre 100 Willis Street, Wellington, 6011, New Zealand

+64 4 901 9011

* Terms and conditions apply

All Event Categories

Find Your Next Event