Exercise Solution 10.5
Analyses such as these are most easily performed by coding a simple program. Another alternative is to use a Monte Carlo add-in for Microsoft Excel. Two standard add-inns are @Risk and Crystal Ball. However, this particular analysis is simple enough that we can perform it with a stand-alone spreadsheet.