Course Detail(IT037 : Financial Modelling & Analysis)

SDF Funding, SkillsFuture Credit, UTAP Funding

IT037 : Financial Modelling & Analysis

14.00 CPE Hours (Others)
Classroom

Notice
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
You may opt to bring along your laptop if you wish to use Excel 2013.

Programme Objective 

  • 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

Pre-Requisite
 
• Must Possessed at least: Intermediate Excel & Basic Financial Knowledge
 
Software Version 

MS Excel 2010
 
Training Methodology

  • Lecture
  • Group Discussion
  • Hands On
  • Exercise  

Intended For

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

Competency Mapping

Others = 14.00 Hours

Schedule & Fees

Date & Time

20 Jan 2020 (9:00 AM - 5:00 PM)
21 Jan 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Bryan Ng Chun Seong

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

23 Apr 2020 (9:00 AM - 5:00 PM)
24 Apr 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 749.00
For Non-Members: $ 898.80

Programme Facilitator(s)

Bryan Ng Chun Seong

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

28 Jul 2020 (9:00 AM - 5:00 PM)
29 Jul 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 749.00
For Non-Members: $ 898.80

Programme Facilitator(s)

Bryan Ng Chun Seong

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

26 Nov 2019 (9:00 AM - 5:00 PM)
27 Nov 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Bryan Ng Chun Seong

Date & Time

06 Aug 2019 (9:00 AM - 5:00 PM)
07 Aug 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Bryan Ng Chun Seong

Date & Time

27 May 2019 (9:00 AM - 5:00 PM)
28 May 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Bryan Ng Chun Seong

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 3 April 2020
Course Reference Number: CRS-N-0045947

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. The credits will not expire and periodic top-ups will be provided by the government. SFC may be accumulated to pay for skills related course fees. You may wish to use your SFC to pay for partial/full ISCA course fees.  (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for SkillsFuture Credit?”, click “Yes” and input all required information. At the Cart page, please ensure that SFC funding is applied before clicking “Checkout”.
  • Step 2: After successful enrolment, please proceed to submit SFC claim on Skillsfuture Portal within 60 days before the course start date and obtain the necessary approval. Please submit SFC claim via SFC portal here: http://www.skillsfuture.sg/credit.

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 

Funding Period: Until 3 April 2020
Funded Hours: 14 hours
Course Reference Number: CRS-N-0045947

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
     
  • Step 2: After successful enrolment, please proceed to submit the Training Grant application via SkillsConnect Portal here: https://www.skillsconnect.gov.sg/

 

Employers of company-sponsored participants must submit training grant via SkillsConnect system to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date. Please note that there will be an administrative fee of $42.80 for any revision of invoice.

 

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

3] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members. NTUC member gets to enjoy UTAP funding 50% of the unfunded course fee capped at $250 every year. This excludes miscellaneous fees such as GST and registration fee etc.
 
This course is approved for UTAP support for intakes conducted between 01 April 2019 – 31 March 2020.
 
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.

  • Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
  • Course by training provider must be supported under UTAP and training must commence within the supported period and;
  • Unfunded course fee must not be fully sponsored by company or other types of funding
  • Unfunded course fee must be S$20.00 and above, and;
  • Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
  • UTAP application must be made within 6 months after course ends.


To submit for UTAP claims, please visit http://skillsupgrade.ntuc.org.sg/. Terms and conditions apply.
 
Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008

 

Programme Facilitator(s)


Mr Bryan Ng, Chun Seong

BSc(Hon)(UK) Acct & Fin Mngt, (MSc Mngt Psychology (UK), CA, CIMA, MSP, Satir) an international speaker


He has effectively helped organisations improve performance through training and consultancy focusing on increasing Personal Effectiveness. He and his team specialize in the areas of Smart Technology, Financial Modeling & Dashboard Reporting. His technology programs focuses not only on teaching participants to understand technical functions one at a time, but more importantly, his program offers smart tips, practical applications and how one can creatively integrate various functions to create even powerful results.

His diverse experience in management, finance as well as IT knowledge makes his training unique and is very well received by many participants as they now able to link what they learnt to what is required from the management. The techniques learnt enhance participant’s effectiveness at work from day-to-day operations to providing useful, speedy information for business decision making. People who attended his training will find his training easy to understand, systematic and practical. He advocates practical, fun and smart learning throughout his training.

He also specializes in coaching individuals and companies in leveraging on common applications such as Excel and Powerpoint to build Financial and Data models in meeting their operation needs. He has worked hand in hand with companies to conduct a series of smart technology programs aiming to equip their team with creative and practical technology skills, raising the productivity immediately.

Being a powerful speaker, he has frequently been invited to speak in different overseas countries such as China, Brunei and Singapore.

Notice
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
You may opt to bring along your laptop if you wish to use Excel 2013.

Programme Objective 

  • 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

Pre-Requisite
 
• Must Possessed at least: Intermediate Excel & Basic Financial Knowledge
 
Software Version 

MS Excel 2010
 
Training Methodology

  • Lecture
  • Group Discussion
  • Hands On
  • Exercise  

Intended For

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

Competency Mapping

Others = 14.00 Hours

Programme Facilitator(s)

Mr Bryan Ng, Chun Seong

BSc(Hon)(UK) Acct & Fin Mngt, (MSc Mngt Psychology (UK), CA, CIMA, MSP, Satir) an international speaker


He has effectively helped organisations improve performance through training and consultancy focusing on increasing Personal Effectiveness. He and his team specialize in the areas of Smart Technology, Financial Modeling & Dashboard Reporting. His technology programs focuses not only on teaching participants to understand technical functions one at a time, but more importantly, his program offers smart tips, practical applications and how one can creatively integrate various functions to create even powerful results.

His diverse experience in management, finance as well as IT knowledge makes his training unique and is very well received by many participants as they now able to link what they learnt to what is required from the management. The techniques learnt enhance participant’s effectiveness at work from day-to-day operations to providing useful, speedy information for business decision making. People who attended his training will find his training easy to understand, systematic and practical. He advocates practical, fun and smart learning throughout his training.

He also specializes in coaching individuals and companies in leveraging on common applications such as Excel and Powerpoint to build Financial and Data models in meeting their operation needs. He has worked hand in hand with companies to conduct a series of smart technology programs aiming to equip their team with creative and practical technology skills, raising the productivity immediately.

Being a powerful speaker, he has frequently been invited to speak in different overseas countries such as China, Brunei and Singapore.


Upcoming Schedule

Date & Time

23 Apr 2020 (9:00 AM - 5:00 PM)
24 Apr 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 749.00
For Non-Members: $ 898.80

Programme Facilitator(s)

Bryan Ng Chun Seong

Venue

60 Cecil Street
ISCA House
Singapore 049709