• Learn how to build effective Financial Model quickly and effectively to meet Business Needs
• Preparing What-if analysis to allow better Management Decision Making
• understand the dos and don’ts in Building a Financial Model using Excel
• prepare Financial Models using Excel systematically
• leverage on some Excel Functions to enhance the Financial Models
• prepare Financial Forecast by years with detail supporting worksheets to ease future changes

Course Introduction
 

Are you meeting your boss’s needs by providing quick, useful and up-to-date information for better decision making? Are you frustrated with the high demand from your boss for information and yet you were not able to get data from other functional teams to allow your financial tabulation? Are you able to immediately provide What-If Analysis during a Management Meeting? With globalization and rapid changes top management requires information quickly to make better business decisions. However, the general consensus are most Accountant or Finance Managers are too micro and not able to support such business needs and hence frustrating many top management. This training will equip you with the necessary tools, skills and also provide some insights of business sense you must possessed in order to support the Top Management more effectively.


Expected Outcomes:

At the end of the course, attendees should be able to:

• understand the dos and don’ts in Building a Financial Model using Excel
• prepare Financial Models using Excel systematically
• leverage on some Excel Functions to enhance the Financial Models
• prepare Financial Forecast by years with detail supporting worksheets for future changes

Special Features

Template for Financial Statement & Investment Model

Samples of the Financial Statement and Investment templates will be given to ease future preparation.

From General to Specific

The approach in training is designed to cover from general, broad principles to specific and client focused scenarios

Manual with ‘Fill-in-the-Blank’ & in Outline Form

The manual is prepared in a user friendly manner where the Fill-in-the-blank allows user to focus and the Outline form made it easy to refer

80/20

80% of the training is to cover the course content specified, 20% to address participants’ Questions to ensure their specific needs are addressed

Real Life Case Study

Participants will be given real life scenarios to discuss and suggest and present ways to overcome and manage the given scenario
 

Programme Outline

 

FINANCIAL MODEL 1: BUILDING LOAN SIMULATOR

• CASE STUDY:
• BUILDING LOAN CALCULATION MODEL WITH…
• Financial Functions: PMT, CUMIPMT
• Create: Combo Box, Check Box, Scroll Bar
• Understand the principles behind the design
• Enhancing the model with more creative Excel functions
• Understand the business perspective and how to effectively use the Financial Model to support management for better decision making

FINANCIAL MODEL 2: BUILDING FINANCIAL FORECAST & PROJECTIONS

• CASE STUDY:
• BUILDING MONTHLY FINANCIAL FORECAST WITH…
• BALANCE SHEET
• PROFIT & LOSS
• CASH FLOW PROJECTIONS
• FIXED ASSETS
• CHART
• SUPPORTING WORK SHEETS
• Macro Recording

FINANCIAL MODEL 3: BUILDING PROJECT APPRAISAL MODEL

• CASE STUDY
• BUILDING AN INVESTMENT MODEL TO CALCULATE..
• NPV
• IRR
• PAYBACK PERIOD
• INTERGRATING VARIOUS EXCEL FUNCTIONS
• Scenario Manager & Summary
• Financial Functions: NPV, IRR, Payback
• IF Function
• Multiple IF Function
• Group & Ungroup
• MATCH Function
• Creating Form – Combo Box
• Understand Basic Macro
• Assigning Macro to Box
• Sheet Protect

 
Software Version 

MS Excel 2010
 
Pre-requisites

• Must Possess at least: Intermediate Excel & Basic Financial Knowledge

Please take note of the following admission requirements:

• Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
• Mandatory for video camera to be turned on throughout the course
• Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
   

Training Methodology

• Lecture
• Group Discussion
• ​Hands On
• Exercise  

Intended For

Finance Managers & Supervisors, Accountants, Participants who need to prepare & understand financials or investment

Programme Facilitator(s)