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 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.
During 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. 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. Participants are required to bring their laptop and calculator to class.
There is no need to have advanced Excel skills for this programme.
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 interprete results
WHO SHOULD ATTEND
- Newly-appointed Finance Managers
- Finance Managers who want to widen their scope of knowledge and skill sets in financial modeling
- 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)
- Staff of audit or professional firms
||What is Financial Modeling?
||Why the need for a Financial Model and Financial Modeling?
||ow to construct a base financial model
||How to design a Financial Model
||Selection of “What if” variables
||Adjusting selected variables in
||Analysis and interpretation of results
||Application of Financial Modelling to: Budgeting, Sales force planning, Proforma financial statements, Corporate planning