Close
Close

QUICK SEARCH
Search your Courses by Keywords


An intensive professional development training course on

Financial Forecasting
in a VUCA World

Sales, Valuation and Performance Forecasting Tools

Why Choose this Training Course?

One of the most challenging facts in today’s new economy is the ever-increasing environment of volatility, uncertainty, complexity and ambiguity (VUCA). The latter makes of financial forecasting more of a challenging task.  As a matter of fact, spreadsheet models have been the dominant vehicles for finance professionals to implement their financial knowledge. Moreover, in the aftermath of the recent financial crisis the need for experienced Financial Modelling professionals has steadily increased as organizations need to plan and adjust to the VUCA world.

This AZTech training course will feature:

  • Financial Statement Modelling
  • CAPEX
  • 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 AZTech 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

The Certificate

  • AZTech Certificate of Completion for delegates who attend and complete the training course

In Partnership With

DO YOU WANT TO
LEARN MORE ABOUT THIS COURSE?

Request for In-House Solutions
Request for
In-House Solutions
Request for More Details
Request for
More Details
Share this Course With a Colleague
Share this Course
With a Colleague
Request Brochure
Download the
Course Brochure

Send to Colleague

© 2023. Material published by Aztech shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.


Sending your message. Please wait...

Send Successfully

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

USE THE COURSE FINDER TO
BROWSE OVER 400 COURSES

Online Training

DISCOVER OUR
ONLINE TRAINING
COURSES

LinkedIn
Facebook
Twitter
WhatsApp
Email
Other