• Home
  • Recorded webinar
  • Cash flow forecasting and budgeting in uncertain times for public practice firms

Cash flow forecasting and budgeting in uncertain times for public practice firms

The masterclass aims at assisting public practice with practical steps and tips they can take to assist their clients in developing robust cash flow forecasting and budgeting capabilities.

Included is onscreen practical concepts and steps of building robust Excel models and explore ways to accelerate and automate at scale.

The masterclass content will cover the following aspects:

  • Understand the core components and differences in cash flow modelling techniques that exist.
  • Understand why Excel remains the best cash flow modelling tool still despite the existence of other technologies and apps
  • How to overcome the challenges of rogue and messy Excel workbooks and ensuring we remove errors effectively and manage this environment cleanly.
  • Steppingstones of building a cash flow model from scratch
  • Detailed walk though of these building blocks in an onscreen practical manner with participants who are welcome to join along.
  • Explore automation that enables to do these manual steps with speed and greater robustness using Modano add-in.
  • Example models will be provided to participants at no extra cost and these can be used and adapted as needed.

  • The workshop will run through each of these briefly and explain their application.

  • Basic cash flow budget;
  • 1-way cash flow model;
  • Weekly 3-way model;
  • Monthly 3-way model

  • Learning Outcomes

    On successful completion of this masterclass, participants should be able to:

  • Understand and assess cash flow modelling capabilities
  • Absorb an appreciation of when this is done with a high degree of quality and identify areas of improvement in their own processes and tools.
  • Understand how they can obtain these capabilities with a relatively small investment over time.
  • Understand the challenges currently with the existing tools and why Excel continues to remain the tool of choice.
  • Lance Rubin

    Lance has a wealth of financial modelling experience from two of the Big 4 accounting firms (PwC & KPMG), Investec Bank & Advisory and NAB.

    Lance is a judge for the global Financial Modelling Innovation Awards.

    Lance was also previously the CFO of fintech start-up Banjo whilst founding Model Citizn, a financial modelling, analytics and automation consultancy firm following 20 years in corporate.

    He is also a certified trainer for the Financial Modeling Institute (FMI).


    Topic: Reporting

    Sub-Topic: Business Planning & Analysis, Business Reporting, Financial Modelling, Financial Planning & Advisory, Financial Reporting, Strategy

    Format: Recorded Webinar

    Proficiency Level: Foundation, Intermediate, Advanced

    CPD: Upto 1.5 hours