6 & 7 Jul 2017 (Thu & Fri)
Having trouble viewing?
Click Here
 
 
FINANCIAL MODELLING, FORECASTING, PLANNING AND ANALYSIS USING EXCEL
BUILD FINANCE MODEL, GENERATE FORECAST & DRIVE BUSINESS GROWTH
 
 
Registration
 
  Date   6 & 7 Jul 2017 (Thu & Fri)
       
  Venue   100 Orchard Road,
Concorde Hotel Singapore
       
  Time   9.00am to 5.00pm
       
  Fees  

S$1,950 | S$1,170 After PIC Grant of 40%
Inclusive of 2 coffee breaks, light refreshments and buffet lunch

 
 
Register Now
 
Download Registration Form
 
Ms Grace Zheng at (65) 6720 3333 or email: grace@aventisglobal.edu.sg
 
Unsubscribe

To unsubscribe, please click here
 
 
 
Fast and Simple Way to Create Powerful and Accurate Forecast and Project Finance Model

Create powerful and more accurate forecasting models to better analyze data, predict revenues, control costs, manage risks - and justify critical business decisions.  Develop the capability to perform accurate and realistic financial analysis in today’s fast changing business environment and stress test any proposal and projects to its limit, incorporating all the “what if” scenarios. All these are made possible with the use of financial modelling techniques which are so critical to improve the quality of decision making and investment.

 

 
Highly Interactive and Practical Oriented

This Practical hands-on 2 Day Workshop will help you create powerful and accurate forecasting models that better analyze data, predict revenues, control costs, manage risks—and justify critical business decisions. Participants will learn how to use and incorporate important analytical models (i.e. spreadsheet Modelling, optimization and simulation) in managerial and financial decision-making.

Using practical and interactive case studies and exercises, you will gain practical, hands-on experience of the design and construction of financial models in Excel correctly and confidently

 
Gain Key Insights from the Expert: Mr Thierry Mezeret with 30 years of Industry Experience

Join former General Manage, Asia Pacific of Global European Bank - Mr Thierry in this 2-day high impact, hands-on program using EXCEL to build financial models for projects and businesses. You will learn how to create powerful and accurate forecasting models that steer you to fast-track, business-improving decision making.

  • Build a financial model from scratch, or modify and improve an inherited model
  • Use Monte Carlo simulations to handle uncertainty in forecasting
  • Apply simple yet effective diagnostics to validate your models
  • Mitigate errors by building in error checks
  • Make better business decisions using advanced valuation techniques
  • Identify key business drivers and integrate them into your forecast
  • Develop advanced modelling skills to build complex, yet robust and user-friendly financial models  
  • Communicate the results of your model clearly and concisely
 
Highly Interactive and Practical Approach

This program will use a combination of lectures, practical and interactive case studies and exercises, and group discussions to support the concepts covered in each training session. Strong emphasis will be placed on participants gaining practical, hands-on experience of the design and construction of financial models in Excel.

Note: Participants are required to bring a laptop equipped with Excel.

 
Former Trader, Treasurer and Regional General Manager, Mr Thierry Mezeret
Thierry Mezeret

Thierry Mezeret comes with more than 30 years of banking experience spanning Treasury, Risk Management, Commercial and Investment Banking. He was a Trader and Treasurer for 12 years, trading foreign exchange, interest rates and derivatives in several banks’ dealing room, before setting-up the Risk Management department of KBC Bank (of Belgium).

He has spent 20 years in KBC Bank (Belgium), with assignments in France, Belgium, Hong Kong and Singapore, Asia Pacific Regional General Manager, managing branches in China, Hong Kong, Taiwan, Labuan and Singapore. During his tenure in Singapore, he acquired an in-depth view and understanding of the financial needs and challenges of Singaporean mid-sized companies.

Since then, he decided to continue his career in Asia and recently became CEO of Cana Securities which is part of Canadia Bank, the largest bank in Cambodia, based in Phnom Penh.  Thierry has a Master Degree from Rouen Business School (France) and the Executive Program at INSEAD.

 
Who Should Attend

This course is designed for business professionals who need to explore the practical usage of advanced excel functions in a financial model. By creating your own user-friendly financial model, you will learn to translate business concepts into a structured format to identify weaknesses and predict future performance.
Highly recommended for

  • CFOs, Accountants, Financial Controllers and Managers
  • Senior Analysts, Government Officers, Project Managers, Country Heads  who uses financial models for:
    • Capital budgeting, fund raising and financing
    • Forecasting and cash flow projection
    • Project and Business valuation
    • Mergers and acquisitions
    • Investment and Financing
    • Auditing and Corporate Advisory
  • Business consultants, business owners, trainers and academics seeking to enhance their financial skills
 
Program Highlights

Session 1: Financial Modelling Theory and Best Practice

  • Overview of best practice financial modelling techniques
  • Create effective financial models that meet your business needs
  • Understanding the co-relation of financial statement for business forecasting and valuation.
  • Proficiency and confidence use of Excel for financial modelling
  • Selecting the tool which is most appropriate for each modelling situation
  • Attributes of a good financial model

Session 2: Advanced Financial Modelling Techniques

  • Develop valuation techniques for projects, assets & portfolio
  • Make better profitable business decisions using advanced Modelling methods
  • Apply WACC , NPV , EVA, IRR and VaR into your business analysis
  • Identify and utilize key business drivers and integrate them into your forecast
  • Using available and free financial data in your models

Session 3: Scenarios and Sensitivity Analysis

  • Deal with uncertainty and risk in financial Modelling
  • Economic inputs to model and modelling fluctuations in external factors
  • Use of stress testing to validate your underlying assumptions and risk calculations
  • Advanced “What-if” analysis

Session 4:  Construct a model portfolio of companies based on actual data from Singapore

  • Effectively communicate the results of your models to key stakeholders
 
What Past Participants Say:
 

“Thierry is very knowledgeable and able to impact concepts clearly. Best instructor among all the instructors I have experienced.”

“I have attended similar course before but with Thierry, he managed to engage me to understand the course better. His teaching methods, patience, and explanations, worked very well.”

 
Limited Seats Only! Register NOW!
 

Enrolment is limited. To register, please kindly DOWNLOAD REGISTRATION FORM and email/fax to Ms Grace Zheng at grace@aventisglobal.edu.sg | +65 6720 2222

 
Date 6 & 7 Jul 2017 (Thu & Fri)
Venue 100 Orchard Road, Concorde Hotel Singapore
Time 9am to 5pm
Fee S$1,950 | S$1,170 After PIC Grant of 40%
Inclusive of 2 coffee breaks, light refreshments and buffet lunch
Enquiries

Ms Grace Zheng at (65) 6720 3333 or email: grace@aventisglobal.edu.sg

 
Over 100 Upcoming Courses

Engage, motivate and inspire your team today! Check out our latest course listing or contact us @ 6720 3333 for A FREE Quotation for Customized In-house training
 
Save 40% or up to 400% Tax Rebate via Productivity and Innovation Credit (PIC)
For more information, contact us or visit http://www.iras.gov.sg/irashome/picredit.aspx