Monte Carlo simulation is a statistical technique that models uncertainty by running thousands of iterations of a financial model, each time randomly sampling input variables from probability distributions. The result is a probability distribution of outcomes rather than a single point estimate, enabling FP&A teams to quantify risk and uncertainty.
In Depth
Monte Carlo simulation takes financial modelling beyond deterministic forecasts ("we will earn £5M") into probabilistic territory ("there is a 70% chance of earning between £4.2M and £5.8M"). This approach more honestly represents the uncertainty inherent in financial planning.
The process involves defining probability distributions for key input variables (normal, triangular, uniform, etc.), running the model thousands of times with randomly sampled inputs, and analysing the resulting distribution of outputs. The output might show that the project has a 75% chance of achieving positive NPV, or that the company has a 90% probability of maintaining covenant compliance.
Monte Carlo is most valuable when multiple uncertain variables interact in complex ways that cannot be adequately captured by simple sensitivity analysis or scenario modelling. It accounts for correlations between variables and captures the full range of possible outcomes.
Practical applications in FP&A include capital project risk assessment, portfolio risk analysis, cash flow forecasting (probability of running out of cash), and revenue forecasting (probability of hitting targets).
The technique requires statistical knowledge and appropriate software tools. While Excel add-ins (like @RISK or Crystal Ball) enable Monte Carlo, dedicated FP&A platforms increasingly offer built-in simulation capabilities.
For UK businesses, Monte Carlo is particularly useful for modelling currency risk on international revenues, interest rate risk on variable-rate borrowings, and demand uncertainty in cyclical industries affected by UK economic conditions.
Real-World Example
A UK property developer uses Monte Carlo simulation to assess a £15M development project. Key uncertain variables — construction costs, completion timeline, selling prices, and interest rates — are each assigned probability distributions based on historical data. After 10,000 iterations, the simulation shows a 65% probability of achieving the target 18% IRR, an 85% probability of remaining above the 12% minimum acceptable return, and a 5% probability of loss. The board approves the project with the risk profile understood.
Related Terms
Net present value (NPV) is the difference between the present value of future cash inflows and the p...
Scenario analysis is a financial modelling technique that evaluates the impact of different future c...
Sensitivity analysis tests how changes in individual input variables affect the output of a financia...
What-if analysis is a financial modelling technique that explores the impact of changing one or more...
A financial model is a quantitative representation of a company's financial performance, built in sp...
Stop wrestling with spreadsheets. Grove FP gives your finance team a purpose-built platform for budgeting, forecasting, and financial modelling — designed for UK businesses.
FAQ