Financial modelling and forecasting Online course Centre for Econometric Analysis Delivered by: Professor Giovanni Urga Course overview
CATALOG DESCRIPTION: Basic and advanced excel functions and charts for financial analysis Forecasting of the main financial statements Equity valuation using
This 2-day training session is targeted audience whose work function involves crunching forecasts and budgets Participants will learn qualitative &
•Financial Modeling helps Investment Banker in Valuing the company by forecasting the revenues On the basis of Valuation they recommend the buyer or seller
The models used for this purpose include those covering financial statement forecasts, asset pricing, portfolio management, risk management, and other
The mathematical tools for analysing and forecasting the research data inputs in a model, general structure of a financial model, calculation algorithms for
105625_2Financial1.pdf 1 Financial Modelling for Forecasting, Budgeting & Financial
Statements in Excel
TARGET PARTICIPANTS
This 2-day training session is targeted audience whose work function involves crunching forecasts and budgets. Participants will learn qualitative & quantitative techniques, sensitivity analysis, file consolidation, dynamic version control, form controls and visualization. Quantitative methods include multiple regression analysis and exponential smoothing. Being an Excel-intensive class, participants are expected to possess a mid-level working knowledge baseline of MS-Excel. The session deep-dives into certain useful Excel functions & tools, and breaking them to show their application and null-application. The class also welcomes persons who would like to understand the forecasting and forecasting process, understand quantitative and qualitative forecasting and acquire the know-how in building robust financial models. Financial Models covered are the Budgeting Model, Forecasting Model and the 3- Statement Model. The use of MS-Excel is extensive and laptops affixed with Excel 2013 with Power Query are required. This program is conducted with practical exercises and case studies.
COURSE OBJECTIVES
Learn to apply statistical and judgmental forecasting techniques. Reduce turnaround-time in managing your forecast structure and worksheet process. Learn how to version-control multiple forecast worksets. Build your own dynamic scenarios with data visualization.
SETUP REQUIREMENTS
Required software: Excel 2013 or above.
Required add-in to be set up in Excel: Power Query. Participants need to ensure Power Query is in operational condition before training commences.
Internet connection for participants required.
DURATION
2 days
2
OUTLINE
1. What is Forecasting and Budgeting
What is forecasting and budgeting- an introduction Objectives of financial modelling, timeframe and data patterns
Template design and structure
2. Quantitative vs Qualitative methods
Qualitative and Quantitative forecasting methods
Naïve method, Simple Moving Average, Simple Weighted Moving Average, Exponential
Smoothing, Correlation, Regression Analysis
([ŃHO 2016·V QHR )RUHŃMVP 6OHHP IXQŃPLRQ (applies to Excel 2016 only) Multiple Regression Analysis, Coefficient Correlation, Coefficient of Determination CORREL, TREND and new iterations of the FORECAST functions
Tracking forecasting accuracy as a KPI
8VLQJ ([ŃHO·V GMPM $QMO\VLV PRROV- Exponential Smoothing, Moving Average and
Regression
Case study
3. Extracting and uploading data with Power Query (applies to Excel
2013 and above only)
Introduction to Get & Transform and the Query Editor Data sources, extracting, transforming and loading data using Power Query
Combining worksheets
Case study
4. Incorporating graphs and charts
Excel 2016 new useful charts (Excel 2016 only)
Dynamic application of charts & graphs into the financial model
Case study