Event Profile | |
Class/ Online | Classroom |
Date | July 27 - 28, 2017 |
Time | 9:00am to 5:00pm |
Venue | Mandarin Orchard Singapore 333 Orchard Road Singapore 238867 |
Fee | 7% GST will apply SGD 1098.002 & above: SGD1048.00 each For Member SGD 1043.1 2 & above: SGD995.6 each |
Note | Two tea breaks and buffet lunch will be served. Limited complimentary car parking coupons are available upon request. |
Other Date(s) | 1) Sep 12 - 13, 2024 |
Trainer | |
Activity | |
You may reach us via T: 6204 6214 E: info@ccisg.com Alternatively, you may send below details to register Contact Person Company (optional), Name, Job Title, Mailing Address, Tel, Email Participant(s) Name, Job Title, Email |
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.
Michael Matthew Lee's Profile
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.
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.