Financial modelling is important for all employees of a business, especially when it comes to financial analysis, and making business and investment decisions thereon.
This course will train the participants on ways to harness Excel’s capabilities and build financial models to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more.
Since this course is based on the use of Excel, accordingly, participants would be required to bring their notebooks and have some basic knowledge of Excel.
Date: 26/09/2025 – 27/09/2025
Brochure
— Course Fee: RM 1,580.00 (Inclusive of 8% Service Tax) —
Day 1
- Module 1: Introduction Excel basics
- Excel skills
- Excel features
Module 2: Excel’s functions and analysis tools
- Financial functions
- Logical functions
- Statistical functions
- Lookup and reference functions
- Date and time functions
- Text functions
- Analysis ToolPak
- Forecasting function
Module 3: What If Analysis and Sensitivity Analysis
- Use of Data Table
- Use of Goal Seek
- Use of Solver
- Scenario Manager in Excel
- Undertake Sensitivity Analysis
Module 4: Use of Excel – Part 1 (forecasting)
- Forecasting tool in Excel
- Moving averages
- Exponential smoothing (ETS)
- Linear regression
- Review of tools and functions in Excel
Day 2
Module 5: Use of Excel – Part 2 (Financial statements forecasting)
- Review of Theory and Concepts
- Sales, cost of sales, production costs
- Summary P/L, Balance Sheet and cash flows
- Free cash flows
- Financial ratios
- Modelling examples
Module 6: Use of Excel – Part 3 (Dashboards)
-
- Building dashboards
- Use of dashboards and charts
Module 7: Investments
- Yield-to-maturity (YTM)
- Yield and XIRR functions in Excel
- Valuation of bonds
- Valuation of equity
- Cost of capital
Module 8: Conclusion
- Summary
- Lessons learnt