Wehrspohn Risk Management

Video tutorials.

Discover new techniques with our video tutorials.

Whether you are a beginner or advanced user, our tutorials guide you step by step through the techniques and concepts of risk analysis, the Monte Carlo simulation method, and our products. Each tutorial is designed to foster hands-on learning, so you can apply what you have learned right away.

Confidence in decisions

What is Risk Kit in a nutshell?

What you can do with Risk Kit and how.

The first steps

Running a Monte Carlo simulation

A basic introduction to how Risk Kit transforms calculations in Excel into a comprehensive risk analysis that uses advanced techniques such as the Monte Carlo simulation.

Read the article

The control center

The toolbar

A quick overview of all the functions of the Risk Kit toolbar and what you can do with them.

Presenting simulation results

Creating charts

When developing and evaluating risk models, it is often helpful to display results and input variables graphically.

Risk Kit lets you create charts quickly and easily with a single click, or use the plot function to design charts precisely, style their colors and appearance, and use them for reports.

Watching the development

Charts in cells

To see how the distributions of risk factors and results evolve, histograms and distribution functions can be displayed in cells. The charts are saved with the model. The feature can be switched on and off with a mouse click. The display is available effortlessly.

Prioritizing uncertainties

Sensitivities

In risk models, the question often arises which influencing factors have the strongest effect on the results. Risk Kit provides several methods to analyze and graphically display how sensitive the results are to uncertainties in the input variables and risk factors.

Read the article

Presenting dependencies

Using correlations

Dependencies between risk factors in the form of correlations are a common use case. Using a business example, the video shows how correlations can be applied to arbitrary risk factor distributions in Risk Kit in Excel with the normal distribution copula.

Read the article

Which distribution should I use?

Estimating distributions and correlations

Risk Kit lets you calibrate the parts of models for which data is available. For each risk factor, distributions are displayed in order of goodness of fit, compared with the data, their parameters are stated, and the correlations with the other factors are calculated. These values can be used directly as a model for the matter at hand, or used to benchmark expert judgments.

Read the article

Risk Kit Data

Loading, consolidating, and synchronizing data

Managing investment, interest rate, exchange rate, share price, commodity price, and many other types of risk requires a data foundation to build on. The video shows how Risk Kit Data makes high-quality international data sources such as Federal Reserve Economic Data, the European Central Bank, the World Bank, Eurostat, and Apilayer Marketstack available with a mouse click.

Read the article

Price risks

Simulating price developments

The video shows how models can be selected and calibrated to simulate price developments with their specific characteristics.

Read the article

Distributions explained one by one

Each important distribution has its own video and an article that presents the content for reading. For an overview of all distributions, see our guide “When Do I Use Which Distribution?”.

Bernoulli distribution

When do I use a Bernoulli distribution in a Monte Carlo simulation?

Definition, formula and examples: when the Bernoulli distribution fits and what role it plays as a switch in a simulation.

Read the article

Binomial distribution

When do I use a binomial distribution in a Monte Carlo simulation?

Definition, formula and examples: how the binomial distribution describes the number of successes in n independent trials and how to calculate it in Excel.

Read the article

Poisson distribution

When do I use a Poisson distribution in a Monte Carlo simulation?

Definition, formula and examples: how the Poisson distribution describes the frequency of independent events and when it fits.

Read the article

Normal distribution

When do I use a normal distribution in a Monte Carlo simulation?

Definition, formula and examples: when the normal distribution fits, where its limits lie and how to truncate it.

Read the article

Triangular distribution, part 1

When do I use a triangular distribution in a Monte Carlo simulation?

Definition, formula and example: when the triangular distribution fits, why the most likely value is not the expected value and where its limits lie.

Read the article

Triangular distribution, part 2

When do I use a triangular distribution in a Monte Carlo simulation?

Part 2 uses an example to show how to model several uncertain quantities with triangular distributions and which of them has the strongest effect on the profit.

Read the article

Expert distribution

Quantifying expert estimates in a Monte Carlo simulation: the Expert distribution

Quantifying expert estimates better: how the Expert distribution captures estimates through bounds and quantiles, even without a fixed minimum or maximum.

Read the article

PERT distribution

When do I use a PERT distribution in a Monte Carlo simulation?

Definition, formula and example: how the PERT distribution describes a bounded duration with minimum, most likely value and maximum, and where its limits lie.

Read the article

Lognormal distribution

When do I use a lognormal distribution in a Monte Carlo simulation?

Definition, properties and limits: when the lognormal distribution correctly describes proportional growth processes and how to parametrise it in Excel.

Read the article

Flex distribution

Custom distributions in a Monte Carlo simulation: the Flex distribution

Custom distributions: how the Flex distribution is built from values and probabilities and when it fits, from expert estimates to transferring simulation results.

Read the article

Wehrspohn on YouTube

All tutorials appear on our YouTube channel, from the first steps to advanced modeling topics. New videos are added continuously.

Open YouTube channel