“If you can’t describe what you are doing as a process,
you don’t know what you’re doing”
W. Edwards Deming

Monte Carlo simulation – New handbook guide

One of our latest financial modelling handbook guides is on Monte Carlo simulation.

We are really grateful to Gerald Strever for putting it together. Gerald is a leading expert on financial modelling and spreadsheet techniques. He is the Senior Managing Partner at Finance Training Solutions, specialising in Financial Strategy, Business Modelling and Company Valuation, and is based in Johannesburg.

It is a great topic for a handbook guide.  The topic itself has a great reputation for being complex – and like many things of complexity deserves a simple explanation. This guide gives an explanation that is both simple and practical.

The guide shows an approach to Monte Carlo simulation that requires nothing more than standard Excel. That’s not to deny the importance of software packages that work with Excel, but it is useful to see what can be done with RAND() and data tables.

Finally, it must be one of the longer guides published.  At 26 pages, it contains a lot of content – and it deserves your comments. We encourage you to download the guide and the accompanying Excel workbook – and let us know what you think.

Click here to see the guide.


  1. Awesome site, awesome guide, but why are the links ALWAYS screwed up, i.e, take you to something completely different than what you clicked on, e.g, the Monte Carlo link?

Help make the handbook better