About the Course

In recent years, companies and business professionals have faced the challenges of dealing with changing economic trends and uncertainties. While the financial analysis indicates the past and present situation of the company, dealing with the uncertainty of the future is a different ball game.  Financial modelling and forecasting have been the dominant methods to manage uncertainty and implement financial and economic knowledge. Understandably, it is vital for business professionals and business managers to acquire forecasting skills and how financial modelling works.

This Financial Analysis, Modelling & Forecasting training course is designed to be an informative and practical guide to the essential skills needed to produce Financial Models. It also describes how forecasted cash flow models are structure. The methods and techniques of financial modelling in Excel will equip the delegates with a set of robust financial tools to anticipate and manage the opportunities and threats confronting the organisation.

Core Objectives

Delegates will achieve the following objectives:

• Thoroughly analyse and interpret financial statements
• Understand the rationale behind traditional financial models
• Understand the dynamics and challenges of financing forecasting and modelling
• Apply quantitative techniques to modelling financial statements
• Identify proper tools to forecasting
• Use capital budgeting process and valuation models

Training Approach

This training course will use proven learning techniques to ensure maximum understanding, comprehension and retention of the information presented. The training course will follow a participative workshop format. It will be focused on developing practical skills that delegates can apply in real-life business situations on return to their organisation.

The Attendees

This training course is suitable for anyone who wants to learn how the effectively constructed financial models and forecasts, whether the delegates come from Business, Legal or Technical backgrounds.

This training course will be valuable to professionals, including (but not limited to) the following:

• Engineers
• Production Managers
• IT Managers
• Sales professionals
• Marketing Managers
• Legal Managers
• HR Managers
• Project Managers
• Banking Professionals
• Public and Semi-Public sectors' professionals
• Entrepreneurs and Business Owners
• Consultants

Daily Discussion

DAY ONE: UNDERSTANDING THE FINANCIAL STATEMENTS

• The components of an Annual Company's Report
• Income Statement
• Statement of Change in Owner's Equity aka Retained Earnings Statement
• Balance Sheet Statement
• Cash Flow Statement

DAY TWO: FINANCIAL ANALYSIS

• The use and rationale of Financial Statement Analysis
• Profitability Ratios
• Liquidity Ratios
• Solvency Ratios
• Asset Utilisation Ratios
• Other Ratios
• The Limitations of Financial Ratios

DAY THREE: THE 101 TO FINANCIAL MODELLING

• What is Financial Modelling?
• Definitions of the Inputs and the Outputs of a Simple Financial Model
• The Financial Modelling Process of More Complex Models
• How financial models work?
• Selecting the Key Forecast Drivers

DAY FOUR: FINANCIAL STATEMENT MODELLING & FORECASTING

• Modelling the Income Statement
• Modelling the Balance Sheet
• Modelling the Cash Flow Statement
• Basic Statistical Methods Used for Forecasting:
• Forecasting Sales
• Forecasting Costs
• Forecasting CAPEX and Depreciation
• Forecasting Working Capital and Funding Needs

DAY FIVE: 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
• Enterprise Value Adjustments