Quick Answer
Monte Carlo simulation is a statistical technique that runs thousands of random iterations of your financial model, varying key assumptions within defined probability distributions. Instead of producing a single forecast number, it generates a range of outcomes with associated probabilities, showing you the likelihood of achieving different results. This provides a more realistic view of uncertainty than simple scenario analysis.
Traditional forecasting produces a single number: "We expect £5M in revenue." Monte Carlo simulation asks: "Given the uncertainty in our assumptions, what is the probability distribution of our revenue?"
1. Define input distributions. Instead of single values for key assumptions, define probability distributions. Revenue growth might be normally distributed with a mean of 25% and standard deviation of 10%. Churn might be uniformly distributed between 5% and 15%.
2. Run iterations. The model randomly samples from each input distribution and calculates the output (revenue, profit, cash flow) for that combination. Repeat 1,000-10,000 times.
3. Analyse the output distribution. Plot the results as a histogram or cumulative probability curve. You might find: "There is a 70% probability of achieving at least £4M revenue, a 50% probability of exceeding £5M, and a 10% probability of reaching £7M."
Revenue forecasting: Model the range of possible revenue outcomes given uncertainty in new business, churn, and expansion.
Cash flow and runway: Calculate the probability of running out of cash under different conditions. "There is a 15% chance we need to raise capital before Q3."
Project evaluation: Assess the risk-return profile of capital investments. "This project has a 60% chance of generating positive NPV."
Budget risk assessment: Understand the probability of exceeding the budget on key cost lines.
Monte Carlo simulation requires: - Understanding of probability distributions (normal, uniform, triangular, log-normal) - Sufficient historical data or expert judgment to parameterise distributions - Software capable of running many iterations (Excel with @RISK or Crystal Ball, Python, or specialised FP&A tools)
Monte Carlo is only as good as the distributions you define. If you specify the wrong distribution shape or parameters, the output will be misleading. It also assumes independence between variables unless you explicitly model correlations. For many FP&A applications, simple scenario analysis with three cases provides sufficient insight at lower complexity.
Related Questions
Sensitivity analysis is a technique that tests how changes in individual input variables affect your financial model's o...
Scenario planning in FP&A is the practice of creating multiple versions of your financial plan based on different assump...
A good revenue forecast should be within 5-10% of actuals for the current quarter and within 10-15% for the next quarter...
During economic uncertainty, shift from single-point forecasts to range-based planning with multiple scenarios. Shorten ...
MAPE (Mean Absolute Percentage Error) is the most widely used metric for measuring forecast accuracy. Calculate it by ta...
FAQ
Most mid-market FP&A teams do not need Monte Carlo — scenario analysis with 3-5 cases covers the majority of planning needs. Monte Carlo adds value for large capital allocation decisions, complex risk modelling, or when communicating probability-based outcomes to sophisticated investors.
Excel add-ins like @RISK and Crystal Ball, Python (NumPy/SciPy), R, and some enterprise FP&A platforms. For simpler needs, you can build basic Monte Carlo models in Excel using RAND() functions.
Typically 1,000-10,000 iterations produce stable results. More iterations give smoother probability distributions but take longer to run. Start with 1,000 and increase until the output distribution stops changing meaningfully.
Show the key probability statements: "We have a 75% chance of achieving our revenue target" or "There is a 90% probability that cash runway exceeds 12 months." Use simple histograms rather than complex statistical charts.
Monte Carlo is more rigorous and produces probability distributions rather than discrete outcomes. However, it is more complex to set up and harder to explain. For most FP&A applications, well-constructed scenario analysis is sufficient and more practical.
Grove FP gives UK finance teams a modern platform for budgeting, forecasting, and reporting — so you can focus on the decisions that matter.
Budgeting, forecasting, and workforce planning in one platform. No credit card required.