The course familiarizes you with risk analysis modeling environments (in this case @Risk or CrystalBall with Excel, but the lessons apply equally well to other modeling environments).The course will give you the ability to conduct, present and critique financial risk analysis that uses the latest methods. Concepts and topics covered in this course include the fundamentals of model building, probability theory, Monte Carlo simulation (using @Risk/CB or alternative modeling environments), using expert opinion, times-series modeling, including risk in NPV analysis and real option analysis.
The course covers the basics of financial risk modeling, and is ideally suited to corporate finance professionals, M&A analysts, risk managers, management consultants, and corporate strategy planners. Financial risk analysis tools can be applied in a very wide range of industries (from venture capital to the pharmaceutical industry, oil and gas, banking and retail) and to numerous capabilities such as new product and business development, corporate finance, strategy, marketing and mergers and acquisitions.
Participants will be primarily using @Risk (version 5.0 or newer) or alternatively CrystalBall (v 7.0 or newer) with Microsoft Excel to solve the exercises. However, participants can also choose to use another Monte Carlo package of their choice. It is essential that all participants are reasonably proficient in Excel. Trial versions of @Risk can be found from Palisade’s website here and trials of CrystalBall can be downloaded from Oracle’s website. As the trial licenses last 15 days, participants should install it only a few days before the course. In addition to @Risk/CB and MS Excel, participants are required to bring laptops with Microsoft Word and PowerPoint installed.
The course runs from 09:00 to 17:00 each day. Morning and afternoon coffee, and lunch are provided. Optional evening workshops on the first and second days allow extra time for running through example models and exercises.
ModelAssist is a comprehensive risk analysis training reference and is free of cost. This reference tool provides an in-depth explanation of all of the risk analysis concepts, techniques and methods introduced in this course and greatly complements the course material. ModelAssist can be downloaded or accessed directly from our website.
All of our courses aim to help the participants understand risk analysis from the bottom-up, which is achieved through a relaxed, informal and interactive environment, using plenty of examples and hands-on exercises where students apply and adapt what they have learned.
Our training courses provide an opportunity to develop or extend your professional network. We therefore arrange optional fun, interactive social events which take advantage of local attractions, cuisine, and culture. All social events are included in the course fee.
Course participants must arrange their own accommodation. However, we will be happy to provide information and alternatives for your travel arrangements. After you complete your registration form, please let us know that you will need our help.
Please contact us to obtain a code for the discounts below, or to discuss a special rate when registering 5 or more people. Discounts for groups of 3 or 4 people are applied automatically at registration. Discount rates cannot be combined.
* Early registration – 10% off registration (register and pay 30 days before course start date)
* Government/Academic – 5% off registration (Proof of eligibility requested after registration)
* Student – 25% off registration (Proof of eligibility requested after registration)
Use our contact form if you are interested in a course not currently in our schedule.
If you are looking to ground an important decision in robust analysis and evidence, let’s start the conversation.