Pre-conference training

Cash flow forecasting

This course will examine the variety of approaches that can be taken depending on the purpose and profile of your company.

The relationship between forecasting, liquidity and working capital is examined in detail so that forecasting is not considered in isolation, but at the center of the drive to maximize shareholder value.

You will learn how different kinds of cash flow forecasting support different treasury functions and what are the best ways to generate cash flow forecasting. Beyond theory, this course uses live excel simulations to ensure practical and functional takeaways, and case studies to show cash flow forecasting techniques in real life treasuries.

Participants will need to bring a laptop with MS office.

Learning objectives

  • Optimise the accuracy of your forecasts
  • Manage differing scenarios and pressures
  • Maximise the benefits of improved cash generation

Overview

Cash flow forecasting

  • Objectives and uses of cash flow forecasts
  • Accurate data collection
  • Constructing an effective forecast model
  • Alternative techniques
  • Analyzing the forecast
  • Linking cash flow forecasting to working capital management
  • The end game: Increasing shareholder value via cash flow management

David Blair

Tutor: David Blair, Managing Director, Acarate

David Blair
David Blair Acarate Managing Director

David Blair puts his 25 years of treasury and management experience to work for a broad range of clients through Acarate in Singapore. After starting his career with Price Waterhouse, David went on to set up international treasury operations for ABB and Nokia. David became Group Treasurer at Nokia, and subsequently Vice President of Treasury at Huawei.

  • 8:30am
    Registration
  • 9:00am
    Types of cash flow forecast

    Understand the role of forecasting in your organisation and explore the three most popular types of forecast and how they are used.

    • Context of cash flow forecast
    • Purpose of cash flow forecast
    • Short term cash plan
    • Long term cash forecast
    • FX forecast

  • 10:30am
    Refreshment break
  • 10:45am
    Cash flow forecast checklist

    A practical checklist of key issues that must be addressed when you are designing a new forecast or reviewing an existing one.

    • Why
    • What
    • Who
    • How
    • When

  • 11:45am
    Practical exercises & case study
  • 1:00pm
    Lunch
  • 2:00pm
    Cash flow forecast methodologies

    Understand the most common methodologies and when and how you should use them.

    • Top down
    • Bottom up
    • Macro
    • Plan / Budget
    • Modelling
    • Heuristic
    • Statistics
    • Scenarios

  • 3:30pm
    Refreshment break
  • 3:45pm
    Cash flow forecast technologies

    How to improve the efficiency and accuracy of your forecasts with the latest technologies as well as measure for maximum benefits.

    • TMS (Treasury Management System)
    • ERP (Enterprise Resource Planning)
    • BI (Business Intelligence)
    • Measuring forecast accuracy

  • 5:00pm
    Training concludes

X