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
Certified Financial Modeller - Advanced Financial Modelling Using Excel and VBA Course Certified Financial Modeller - Advanced Financial Modelling Using Excel and VBA Course

5 days, 28 May - 01 Jun, 2018 

2018-05-28 12:05:00
Ghana

LEORON Professional Development Institute

The procurement profession has undergone a major transformation in the last 10 years and is widely recognised as being a function that can have a dramatic impact on an organizations bottom line. Best ...

Certified International Procurement Professional Certified International Procurement Professional

4 days, 28 - 31 May, 2018 

2018-05-28 12:05:00
Ghana

LEORON Professional Development Institute

The procurement profession has undergone a major transformation in the last 10 years and is widely recognised as being a function that can have a dramatic impact on an organizations bottom line. Best ...

Certified Budget Analyst - Advanced Budgeting and Financial Forecasting using Advanced Excel Certified Budget Analyst - Advanced Budgeting and Financial Forecasting using Advanced Excel

4 days, 11 - 14 Jun, 2018 

2018-06-11 12:06:00
Mozambique

LEORON Professional Development Institute

In our rapidly developing markets, the need for companies to react promptly to the changing environment is crucial. Historical accounting records are essential but are not enough for managers to make ...

Certified Financial Modeller - Advanced Financial Modelling Using Excel and VBA Certified Financial Modeller - Advanced Financial Modelling Using Excel and VBA

5 days, 18 - 22 Jun, 2018 

2018-06-18 12:06:00
Mozambique

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 ...