OVERVIEW

Forecasting, simulation, and optimization techniques are increasingly popular tools that provide Financial Analysts with analytic power well beyond the traditional toolset. Through workshops, case examples and practical Excel based learning models, participants will actively learn and practice essential skills and techniques to:

Obtain accurate estimates from subject matter experts,

Test & validate planning assumptions,

Leverage historical data in planning/estimating scenarios,

Assign a probability of realizing an objective,

Forecast market conditions probabilistically

Etc.

TARGET AUDIENCE

This workshop is designed for both the beginner and advanced financial analyst who want to learn how to simulate and stress test their forecasts and projections using @RISK.

Banking, Credit & Insurance Professionals

Forecasting and Planning Professionals

WORKSHOP CONTENT

MODULE 1 - ENHANCING THE MODELING PROCESS WITH SIMULATION

Why is Risk Analysis SO important in today’s world?

Challenges in corporate finance

The flaw of averages

Understanding risk analysis key concepts and definitions

Workshop:What does 90% confidence really mean?

Modeling vs. Simulation

Overview and history of Monte-Carlo Simulation

Advantages and Disadvantages of simulation

How and Where simulation and risk analysis can have a positive impact on the organization

The Modeling Process

Understanding how the modeling process works in the business

Obtaining and using historical or published data

Discussion on using the Monte-Carlo Method for properly scoping the need, building assumptions and establishing model constraints with Subject Matter Experts

Portfolio Optimization Techniques : With the help of several integrated financial models, this workshop will provide financial analysts with a complete understanding of why, where and how to apply spreadsheet forecasting, simulation, real options and optimization within their analyses.

Project Portfolio Selection: Use OptQuest to pick the best projects based on Organizational Budget Constraints

Portfolio & Resource Allocation Optimization: Allocate resources or budgets among various investments to maximize NPV or ROI or minimize risk or expense.

OVERVIEW

Forecasting, simulation, and optimization techniques are increasingly popular tools that provide Financial Analysts with analytic power well beyond the traditional toolset. Through workshops, case examples and practical Excel based learning models, participants will actively learn and practice essential skills and techniques to:

Obtain accurate estimates from subject matter experts,

Test & validate planning assumptions,

Leverage historical data in planning/estimating scenarios,

Assign a probability of realizing an objective,

Forecast market conditions probabilistically

Etc.

TARGET AUDIENCE

This workshop is designed for both the beginner and advanced financial analyst who want to learn how to simulate and stress test their forecasts and projections using @RISK.

Banking, Credit & Insurance Professionals

Forecasting and Planning Professionals

WORKSHOP CONTENT

MODULE 1 - ENHANCING THE MODELING PROCESS WITH SIMULATION

Why is Risk Analysis SO important in today’s world?

Challenges in corporate finance

The flaw of averages

Understanding risk analysis key concepts and definitions

Workshop:What does 90% confidence really mean?

Modeling vs. Simulation

Overview and history of Monte-Carlo Simulation

Advantages and Disadvantages of simulation

How and Where simulation and risk analysis can have a positive impact on the organization

The Modeling Process

Understanding how the modeling process works in the business

Obtaining and using historical or published data

Discussion on using the Monte-Carlo Method for properly scoping the need, building assumptions and establishing model constraints with Subject Matter Experts

Portfolio Optimization Techniques : With the help of several integrated financial models, this workshop will provide financial analysts with a complete understanding of why, where and how to apply spreadsheet forecasting, simulation, real options and optimization within their analyses.

Project Portfolio Selection: Use OptQuest to pick the best projects based on Organizational Budget Constraints

Portfolio & Resource Allocation Optimization: Allocate resources or budgets among various investments to maximize NPV or ROI or minimize risk or expense.

Do you already have Oracle Crystal Ball and want to tackle the next generation of problems?

The Crystal Ball Decision Optimizer upgrade provides users with both industry-leading optimization using OptQuest and unparalleled speed (PSI). OptQuest is an optimization tool that runs with Crystal Ball as an add-in and enhances simulation models by automatically searching for and finding optimal solutions.