S$749.00

Course Info

  • 10 meetings

  • 0 hour/meeting

  • Beginner

  • 16-17 August, 2018

  • Finance
  • STADA Member Rate: $642.00 SkillsFuture Credit Available
Financial Modelling for Decision Making

Creator

Singapore Training and Development Association

Program Overview

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 - 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) - Staff of audit or professional firms

Topics

Topic 1 What is Financial Modeling?
Topic 2 Why the need for a Financial Model and Financial Modeling?
Topic 3 ow to construct a base financial model
Topic 4 How to design a Financial Model
Topic 5 Selection of “What if” variables
Topic 6 Adjusting selected variables in
Topic 7 Financial model
Topic 8 Analysis and interpretation of results
Topic 9 Application of Financial Modelling to: Budgeting, Sales force planning, Proforma financial statements, Corporate planning
Topic 10 Class project(s)