Adobe Flash was discontinued from the end of 2020 and is now inaccessible to most users of either Apple or Windows. Having now found out how to generate interactive charts in HTML5, I have switched. It is still possible to play Flash files on Windows.

Using the random numbers generated, the model is run in Excel and the final results exported and saved in Excel. The 5 charts show “fund development”, “success likelihood”, “discount rate adjustments”, “annuity failure” and “excess caution”. Each chart has two colour-coded (blue and red) sets of parameters on the right and the grey bar is defined as “red” minus “blue”.

The statistic of interest can be mean, standard deviation, highest 5.0% or lowest 5.0% but sometimes only the mean exists. Even though they probably won't have been generated from the same scenario sets, I think it is still reasonable to compare the highest 5.0% for one measure with the highest 5.0% for a different measure.