Classroom/ Online: Yes/ Yes
Scheduling Date(s):
Note: Please click specific date for detailed venue and course fee etc.
Financial Modelling for decision making
In most aspects of Finance, there is a need to evaluate scenarios and "What if" situations, in investment appraisals, corporate planning, budgeting, financial projections and the like. This is normally achieved by designing a financial model with selective variables that are critical in decision making.
This two-day's course teaches the participant how to design a financial model using simple Excel functions and how to determine the variables that are required for analysis.
This two-day's course teaches the participant how to design a financial model using simple Excel functions and how to determine the variables that are required for analysis.
Objective
At the end of the course, you will be able to:
- Identify financial decision making that requires financial modelling
- Construct a base model for financial modelling
- Design an appropriate financial model to aid decision making
- Identify the right "What if" variables
- To work on scenarios by adjusting selected variables
- To analyse and interpret results
At each session participants are encouraged to share their work experiences, issues and challenges, relating to the topic in discussion, and in the process, seek advice, coaching and resolution.
Outline
- What is Financial Modelling?
- Why the need for a Financial Model and Financial Modelling?
- How to construct a base financial modelHow to design a Financial Model
- Selection of "What if" variables
- Adjusting selected variables in Financial model
- Analysis and interpretation of results
- Application of Financial Modelling to
a. Budgetting
b. Projected financial statements (P&L and Balance Sheet)
c. Corporate planning
d. Breakeven/CVP analysis
e. Sales staff additions
Who should attend
- Newly-appointed Finance Managers
- Finance Managers who want to widen their scope of knowledge and skill sets in financial modelling
- CFO-aspirants
- Finance Managers who seek a refresher course in financial modelling
- Heads of Finance Department
- Finance Manager aspirants
- Finance Managers who want to fill knowledge and experience gaps.
- Relationship Managers (banks)
Methodology
This course will be conducted in an environment conducive to learning where participant sharing, group/individual work and coaching will be applied to reinforce learning.
Participants are advised to share their real-life cases. Some of the cases could be used to design a financial model as a class project.
Participations are required to bring their laptop and calculator to class.
Participants are advised to share their real-life cases. Some of the cases could be used to design a financial model as a class project.
Participations are required to bring their laptop and calculator to class.
Profile of Michael Matthew Lee
Michael Matthew Lee is a trained teacher, lecturer, C-suite coach, and facilitator, and is himself a life-long learner. Being trained, he is skilful in explaining difficult concepts in a simple and understandable manner. With his more than 40 years of corporate working experience, which include serving as Group CFO of 3 large Main Board public-listed groups, and as CXO (MD/CEO/COO) of various companies across industries, he specialises in Finance and Strategic Marketing, and is exposed to senior executive management practices, issues, and challenges.
He authored the book “The Essence of Corporate Cashflow Sustainability” launched in June 2022 and has written 15 accounting & finance articles. His 2nd book “Corporate Growth & Cashflow Sustainability” was launched on 6th Jan 2024.
Michael Matthew Lee’s credentials are:
Chartered Accountant (ISCA)
Chartered Marketer (CIM(UK))
Associate CVA
MBA (Finance, NUS Business School)
MBA (Strategic Marketing, University of Hull)
BAcc (NUS); DipM (UK); PDipM (APAC); ACTA; PMC. CertEd
ASEAN CPA; FCA(Singapore); FCPA(Aust); FCCA(UK); FCIM(UK); MSID.
