Financial Modelling For Forecasting, Budgeting & Financial Statements In Excel

26-27 Jul, 2021, Virtual Classroom Training

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

Venue Details

Virtual Classroom Training

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Financial Models
  • Building The Financial Model
  • Forecasting Methods
  • Price Setting For Products & Services
  • Cashflow
  • Form Controls
  • Extracting And Consolidating Historical Accounting Data
  • NPV & IRR
  • Investment Metrics
  • Important Excel Knowledge
COURSE OBJECTIVES
  1. Learning how to apply statistical and judgmental forecasting techniques.
  2. Reducing turnaround-time in managing your forecast structure and worksheet process.
  3. Learning how to version-control multiple forecast worksets.
  4. Building your own dynamic scenarios with form controls.
WHO SHOULD ATTEND

This 2-day course 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.

METHODOLOGY
The use of MS-Excel is extensive and laptops affixed with Excel 2013 (or higher) with Power Query are required. This course is conducted with practical exercises and case studies.
DAY 1
9:00

FINANCIAL MODELS

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

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
12.00

FORECASTING METHODS

  • Qualitative & quantitative forecasting methods
  • Important Excel-related functions & tools
  • Forecasting accuracy
  • Regression analysis
1:00 Lunch
2:00

PRICE SETTING FOR PRODUCTS & SERVICES

  • Understanding price and demand curves
  • Price elasticity of demand computation methods
  • Decisions in price setting
3:45

CASHFLOW

  • Working capital components, ratios & cash conversion cycle
  • Cash flow projection using the direct method
  • Free Cash Flow (FCF)
5:00 End of Day 1
DAY 2
9:00

FORM CONTROLS

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

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
12.00

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
1:00 Lunch
2:00

INVESTMENT METRICS

  • ROE
  • Equity multiple
  • Peak capital
3:45

IMPORTANT EXCEL KNOWLEDGE

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