IT and Computing > Financial Modelling for Forecasting, Budgeting & Financial Statements in Excel

Financial Modelling for Forecasting, Budgeting & Financial Statements in Excel

Course Objectives

This is a 2-day hands-on workshop in forecasting and budgeting delivered in Microsoft Excel. Participants learn how to create forecasting and budgeting financial models using Excel.

Being an Excel-intensive class, participants are expected to possess a mid-level working knowledge of MS-Excel. The session teaches participants the Excel and statistics know-how in building a robust budgeting and forecasting financial model.

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 2016 (or higher) with Power Query are required. This program is conducted with practical exercises and case studies.

Target Audience

Finance person

Methodology

Instructor-led follow-along workshop.
Datasets provided.

Course Modules

Module 1: Financial Models

Introduction & types of financial models
Program scope
Financial model structure
Budgeting & forecasting
The budgeting & forecasting process

Module 2: Building the financial model

Building revenue & expense drivers
Revenue & cost projection
Modelling the Income Statement & supporting cost centre sheets
Building the headcount & payroll model
Projecting the balance sheet

Module 3: Forecasting methods

Qualitative and Quantitative forecasting methods
Naïve method, Simple Moving Average, Simple Weighted Moving Average, Exponential Smoothing, Correlation, Regression Analysis
Forecast Sheet function (applies to Excel 2016 & above)
Multiple Regression Analysis, Coefficient Correlation, Coefficient of Determination
FORECAST, CORREL
Tracking forecasting accuracy as a KPI
Using Excel’s Data Analysis tools- Exponential Smoothing, Moving Average and Regression Analysis

Module 4: Price setting for products & services

Understanding price and demand curves
Price elasticity of demand computation methods
Decisions in price setting

Module 5: Cashflow

Working capital components, ratios & cash conversion cycle
Cash flow projection using the direct method
Free Cash Flow (FCF)

Module 6: Form Controls

Essential Form Controls & overview
Incorporating Form Controls into financial models & sensitivity analysis

Module 7: Extracting and consolidating historical accounting data

Using Power Query to extract & consolidate historical data
Building forecasting working templates from historical data
Building sensitivity analysis into forecast templates
The Analyze Data function

Module 8: NPV & IRR

Time value of money & discounted cashflows
Compounding and Discounting- what’s the difference?
NPV vs IRR introduction
Implications of NPV vs IRR in decision-making

Module 9: Important Excel knowledge

Essential Excel functions in financial modeling- VLOOKUP, SUMIF, SUMIFS, IFERROR, INDIRECT, IF, IFS
Utilize macros to automate simple tasks

Module 10: Managing multiple budget Version

Version controlling your budget forecast spreadsheets
Fitting in multiple budgets into your financial model

Module 11: Introduction to business intelligence tools in Excel

Utilizing Power Query, Power Pivot and the OLAP Pivot Table to extract, transform and stratify historical data

Get To Know The Trainer

Trainer Lim

Lim has been working in the IT industry for the past 20 years. He leads, plans and supports a functionally organized, technically oriented team and environment with a wide variety of technical activities and service operations.He is good in developing and implementing IT initiatives for regional service operation activities and actively participates in global projects to align corporate/regional direction and IT standard according to ITIL operational framework and software development.

VIEW PROFILE

Trainer CK

4.5

CK has been involved in Microsoft Office Consulting for more than 15 years with the intention of helping friends and working adults to reach their full capability which in return will increase their work productivity. Throughout his many years of working experience using Microsoft Office Applications, he participated with various projects involving Engineering Data Analysis, A Complete System for Employees such as Leave Application, Petty Cash Claim, Arranging Schedule and so on with Programming using VBA Programming.

VIEW PROFILE

Trainer P.L

4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

VIEW PROFILE

View more trainers