Financial Modelling with Excel for Budgeting and Costing
Details
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.
Outline
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
- 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
Speaker/s
VINCENT CHIN
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer
Special Offer
STANDARD PRICE:
1Pax = RM 2,990.00
GROUP PRICE:
3Pax or more = RM 2,490.00 (Valid until 14 DAYS prior to registration).
Payment mode:
Schedules
Tue | 09:00 AM — 05:00 PM | |
Wed | 09:00 AM — 05:00 PM |
Thu | 09:00 AM — 05:00 PM | |
Fri | 09:00 AM — 05:00 PM |
No. of Days: | 2 |
Total Hours: | 16 |
ITRAININGEXPERT GLOBAL PLT is the corporate training arm of The English Expert Publishing and Training Group established since 1999 by consulting partners with extensive training experience from both the government and corporate sector covering Malaysia, Singapore, Australia, China, Vietnam and Indonesia.
All our trainers are experienced practitioners, professionally certified, dedicated and specialized in their respective fields. Our corporate philosophy is of Total Customers Satisfaction. We carry out our task with integrity and full commitment. We continue to keep abreast with industry developments through individual and ongoing continuing education, in-depth training and consulting that your organization demands and deserves.
For 18 years now and counting, we have trained more than 100,000 people to improving their work productivity, leadership & communication skills, language proficiency, sales, negotiation & presentation skills, workplace management and personal development.
What do we SPECIALISE in?
Put it in an easy way, we specialize in Training and Human Development training and consultancy services covering both soft skills and technical skills, a wide range of courses pertinent to the human capital development of high performing organization. ...