Financial Modelling For Forecasting, Budgeting & Financial Statements In Excel

By the end of the Financial Modeling with Excel course, you will be able to:

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

Anybody dealing with any decision related to money, investment, budgeting and costing, and building working templates. If you are involved in financial decision-making/ planning related to large / semi/ small corporations, then you would need financial modeling day in and day out. Financial modeling is a mandatory activity for investment bankers, bankers, project finance persons, equity researchers, PE & VCs. This course focuses on creating financial models for Budgeting, Forecasting, and Financial Statements. 

There will be extensive use of MS-Excel during the sessions and laptops are required.
Required software: Excel 2016 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 is required.

If you have 2 screens, that would be even better. One screen to look at the trainer & his instructions. The other screen is for you to work on your screen. 

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
• Modeling the Income Statement & supporting cost center sheets
• Building the headcount & payroll model
• Projecting the balance sheet

MODULE 3: FORECASTING METHODS

• Qualitative & 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
• CORREL, TREND, and new iterations of the FORECAST functions
• Tracking forecasting accuracy as KPI
• Using Excel’s Data Analysis tools- Exponential Smoothing, Moving Average, and Regression

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

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, COUNTIF, COUNTIFS, IFERROR, INDEX, MATCH, INDIRECT
• Utilize macros to automate simple tasks

MODULE 10: MANAGING MULTIPLE BUDGET VERSIONS

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

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

VINCENT CHIN
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer

Vincent has held financial, continuous improvement and I.T. positions in the banking, shared services, and hospitality industry. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Certified Trainer, Microsoft Office Specialist, and HRD Corp accredited trainer. His previous roles include being an internal change consultant of a global team, a financial shared-services local head and a finance regional head.
He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA and process improvement.

Vincent brings to you his 20+ years of work and training experience in multiple industries where he was in charge of financial and business reengineering functions. He also develops complex VBA applications regularly in process improvement projects which require his expertise.

One of his highest achievements in the role of a Financial Controller for several multinational conglomerates, he was being able to turn a loss-making company into a profitable one within the year. Vincent has also managed a portfolio of business improvement projects with realized benefits of USD2 million in the prior year in an international bank.

Vincent has trained employees from Genting Group, Dell, Motorola, Technip, CIMB, Malakoff, Digi, IBM, Starwood Hotels & Resorts, Petronas ICT, HSBC.

Vincent adapts a highly practical approach in his training and relates topics he conducts to real-life scenarios. Because he is a no-nonsense person, his solid background in financial operations and process re-engineering experience aid him to create a unique training methodology that mimics closely the solutions that are needed in his participants’ organizations.
Or
We have a faculty of equally talented specialists who can cater to your organization's specific needs in the event of a substitution.
For training and advisory services, feel free to contact us at info@itrainingexpert.com or call us at +603 8082 3707 | +603 8074 9056 | +6012 6869 628 | +6018 2175 123.

Vincent is an excellent trainer with excellent knowledge in the subject.” - Housekeeping Director, Westin Langkawi.
Before this I never understood what Six Sigma was. Vincent crystalised it and cla so well.rified it for me” - Manager, HSBC.
This course helped me understand forecasting and budgeting better. Also, learning the Excel functions and tricks will help me in my daily work.”
I never knew Excel could do so much in forecasting.”

Upon successful completion of this program, you will receive a Certificate of Achievement.

1. Online Payment by Credit card: You can opt to register and pay online with our latest payment integration system through our website.

2. Bank Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.

3. HRD Corp Claimable Courses Skim Bantuan Latihan Khas - Applicable to Malaysian Employer Only.

We'd happy to help.
Feel free to talk to us today, however most suitable for you.
Mobile call/ whatsapp: +6012 6869 628 | +6018 2175 123
Office: +603 8074 9056
Email: info@itrainingexpert.com
Website: www.itrainingexpert.com