A Highly Interactive Training Course On

Financial Forecasting in a VUCA World

Sales, Valuation and Performance Forecasting Tools

Financial Forecasting in a VUCA World
Course Schedule

CLASSROOM

10-14 Feb 2025
Amsterdam
$5,950
12-16 May 2025
London
$5,950
04-08 Aug 2025
Barcelona
$5,950
06-10 Oct 2025
Dubai
$5,950
09-13 Feb 2026
Amsterdam
$5,950
Certificate
  • Coventry Academy Certificate of Attendance will be provided to delegates who attend and complete the course

Training Overview

Training Overview

One of the most challenging aspects of today’s economy is the growing environment of volatility, uncertainty, complexity, and ambiguity (VUCA). This makes financial forecasting increasingly difficult. Traditionally, spreadsheet models have been the primary tools for finance professionals to apply their expertise. In the wake of the recent financial crisis, the demand for skilled Financial Modelling professionals has risen, as organizations need to navigate and adapt to the VUCA landscape.This Financial Forecasting in a VUCA World Training Course offered by Coventry Academy focuses on equipping finance professionals with advanced skills in financial modelling, crucial for navigating the volatile, uncertain, complex, and ambiguous (VUCA) environment of today's economy.

This Coventry Academy training course will cover:

  • Financial Statement Modelling
  • Capital Expenditure (CAPEX)
  • Discounted Cash Flow (DCF)
  • Sensitivity Analysis
  • Scenario Analysis

What are the goals?

By the end of this training course, participants will be able to: 

  • Recognise the challenges of VUCA world
  • Recognize the purpose of Financial Modelling and Forecasting
  • Explain the key steps of Financial Modelling
  • Forecast future firm’s performance and Valuation
  • Use different planning tools: scenario and sensitivity analysis

Who is this Training Course for?

This Coventry Academy training course is suitable to a wide range of professionals but will greatly benefit:

  • Finance Professionals across the organisation
  • Head Office Planning Managers
  • Budgeting and Forecasting Teams
  • Commercial Managers
  • Finance Strategic Business Partners 

How will this Training Course be Presented?

This training course will utilise a various of proven learning techniques to ensure maximum understanding, comprehension and retention of the information presented.  This includes a presentation in a highly interactive manner, individual and group activities interspersed throughout the sessions, along with appropriate case studies and video documentaries that will highlight the significant teaching features.

The Course Content

Day One: Financial Modelling and VUCA World 
  • The Imperatives of a VUCA World: a sound of Financial Modelling
  • What is Financial Modelling?
  • Defining the Inputs and the Outputs of a Simple Financial Model
  • The Financial Modelling Process of More Complex Models
  • Excel as a Tool of Modelling: Capabilities and Limitations
Day Two: Financial Statement Modelling and Forecasting
  • How Financial Models Work
  • Collecting and Analyzing Historical Data
  • Selecting the Key Forecast Drivers
  • Modelling the Income Statement
  • Modelling the Balance Sheet
  • Modelling Interest and Circular References
  • Modelling the Cash Flow Statem
Day Three: Performance Forecasting
  • Designing a Dashboard-like Control Panel
  • Basic Statistical Methods Used for Forecasting
  • Forecasting Sales: Bottom-up Versus Top-down Forecasting
  • Forecasting Costs
  • Forecasting CAPEX and Depreciation
  • Forecasting Funding Needs
Day Four: Business Valuation
  • Valuation Approaches
  • Steps for Applying the DCF Method
  • Rewriting Financial Statements – Calculation of Free Cash Flows
  • Calculating the Weighted Average Cost of Capital
  • Estimating the Terminal Value
Day Five: Planning for Uncertainty  
  • One-Dimensional and 2-Dimensional Sensitivity Analysis
  • Choosing the Variables to Change
  • Modelling Example
  • Interpreting the Results
  • Scenario Analysis Example