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.
Este curso de formação da Coventry Academy inclui
Financial Statement Modelling
CAPEX
DCF
Sensitivity Analysis
Scenario Analysis
Quais são os objectivos?
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
A quem se destina este curso de formação?
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
Como é que esta ação de formação será apresentada?
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.
Descrição do curso
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
O certificado
Coventry Academy Certificate of Attendance will be provided to delegates who attend and complete the course