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

•  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 form controls.

2 Days ( 9.00 am – 5.00 pm)


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 & quantitative forecasting methods
• Important Excel-related functions & tools
• Forecasting accuracy
• Regression analysis

MODULE  4 : CASHFLOW

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

MODULE 5 : FORM CONTROLS

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

MODULE 6 : EXTRACTING AND CONSOLIDATING HISTORICAL ACCOUNTING DATA

• Using Excel tools to extract & consolidate historical data
• Building forecasting working templates from historical data
• Building sensitivity analysis into forecast templates

MODULE 7 : 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
• Investment model using NPV, IRR, PMT, PPMT, IPMT

MODULE 8 : INVESTMENT METRICS

• ROE
• Equity multiple
• Peak capital

MODULE 9 : IMPORTANT EXCEL KNOWLEDGE

• Essential Excel functions in financial modeling- VLOOKUP, SUMIF, SUMIFS, COUNTIF, COUNTIFS, IFERROR, INDEX, MATCH, INDIRECT
• Utilize macros to automate simple tasks

MS-Excel intermediate-to-advance level knowledge required as a pre-requisite. This program is conducted with practical exercises and interactive discussions.