Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Monte Carlo Simulation Using Crystal Ball and Excel - Training course

By: LEORON Professional Development Institute

United Arab Emirates

24 - 28 Apr, 2016  5 days

Follow Event

  

USD 4,190

We are all concerned about the future, who doesn’t? No one knows what will happen in the future. It is a challenge to deal with uncertainty. Monte Carlo simulation puts the future within the right context, which is probabilistic.

Successful companies of various sizes and governments in developed countries are quickly moving far from the naïve conventional way of setting the future possible outcomes as Best Case, Normal Case and Worst Case Scenarios. Whether you are a finance manager, government employee, project manager, or an investment professional, the common element is the concern of what the future entails.

If you are not using Monte Carlo Simulation in making decisions related to the future, so you have deterministic models which are most definitely not the best practice. Here are some examples of companies applying Monte Carl simulation:

  • General Motors, Procter and Gamble, and Eli Lilly use simulation to estimate both the average return and the riskiness of new products. At GM, this information is used by the CEO to determine the products that come to market.
  • Lilly uses simulation to determine the optimal plant capacity that should be built for each drug.
  • The trainer of this course helped a utility company in the region to establish the foundation of implementing Monte Carlo Simulation in planning water demand and the required infrastructure accordingly.
  • The trainer of this course helped two big financial institutions in setting the asset allocation decisions using Monte Carlo Simulation to maximize future expected return at the acceptable level of risk.
  • Wall Street firms use simulation to price complex financial derivatives and determine the Value at RISK (VAR) of their investment portfolios.
  • Shell uses Monte Carlo Simulation in their project evaluation to determine whether to invest billions of dollars in a certain project or not.
  • Financial planners use Monte Carlo simulation to determine optimal investment strategies for their clients’ retirement. In this very intensive course, we will look at how we can use Monte Carlo simulation through Crystal Ball which is a product of Oracle and it is 100% utilized in Excel.

The training course is very practical and will uncover the extensive range of the various business applications in which Monte Carlo Simulation can be utilized. You don’t need to have masters in Statistics to start utilizing this advanced tool. The course will equip you with the necessary statistical background. You will return to your companies with a value-adding tool.

Ocean View Hotel, Dubai, UAE Apr 24 - 28 Apr, 2016
USD 4,190.00
(Convert Currency)

+971 (0) 4 447 57 11 ext.654

discount and installments available
Hamed Behairy
Related Courses
CFM Certified Financial Modeller - Advanced Financial Modelling Using Excel and VBA CFM Certified Financial Modeller - Advanced Financial Modelling Using Excel and VBA

4 days, 29 May - 01 Jun, 2017 

2017-05-29 12:05:00
Ghana

LEORON Professional Development Institute

The ability to create and understand financial models is one of the most valued skills in business and finance today. Microsoft Excel with Visual Basic for Application (VBA) macros programming has ...

Senior International Project Manager Senior International Project Manager

4 days, 29 May - 01 Jun, 2017 

2017-05-29 12:05:00
Ghana

LEORON Professional Development Institute

SIPM is a fast moving and engaging seminar, focusing on a pragmatic approach and applying a series of processes that are regarded as first-class practices within project management. This course seeks ...

Contract and Commercial Management Practitioner Contract and Commercial Management Practitioner

4 days, 29 May - 01 Jun, 2017 

2017-05-29 12:05:00
Ghana

LEORON Professional Development Institute

People enter Contract and Commercial Management discipline from a wide variety of backgrounds, often with little or no specific training. They may be financial or legal professionals, they may ...

Certified Human Resources Manager Certified Human Resources Manager

4 days, 27 - 30 Nov, 2017 

2017-11-27 12:11:00
Angola

LEORON Professional Development Institute

This program will guide you to develop and implement "best practice" in your organization. You will ensure that your employment contracts and HR manuals meet your business needs, whilst ...