Wehrspohn Risk Management

Monte Carlo simulation in Excel in under 5 minutes

November 21, 2025

In under 5 minutes, an Excel calculation becomes a risk analysis, even for beginners. Many Excel calculations contain inputs that nobody knows exactly: the number of units that will be sold, possible sick days, or costs that are hard to estimate. The question is how to represent this uncertainty realistically and turn it into a well-founded risk analysis.

Many people shy away from Monte Carlo simulations because they believe it takes deep statistical knowledge. With the right guidance, however, doing it in Risk Kit is easier than you might think. Anyone who has ever used an Excel formula can manage it. Our new one-minute spotlight video shows how a perfectly ordinary Excel spreadsheet becomes a risk analysis in a few steps, and which terms and actions you need for it: 1. You specify which cells in your calculation do not contain exactly known values, for example the number of products you will sell in the future. 2. For these cells, you enter a range that is easier to estimate, such as a triangular distribution with minimum, maximum and most likely value, or another suitable input from Risk Kit. 3. You mark the results you want to analyze and forecast, for example profit or cash flow. 4. You start the simulation with one click, and Risk Kit automatically generates thousands of scenarios. 5. Risk Kit automatically creates charts and metrics and shows them in a clear dialog, so you can evaluate the results right away. Watch the short video. It shows you directly how simple a risk analysis with Risk Kit is.

This post was originally published on LinkedIn. View and join the discussion there