This section includes examples on how Monte Carlo simulation can be used. Two examples, hydraulic engineering (1) and market analysis (2), are demonstrated by our Excel consultants.
Web Application example demonstrates how an Excel spreadsheet can be used on the web through our Excel consulting services. An option calculator is used in this example.
Web Application and Simulation Analysis
Monte Carlo Simulation (1) Example Details
The hydraulic engineering simulation project utilized Pearson Type III distribution. Provided the mean, standard deviation, skewness, and other inputs, the discharge-frequency curve with 95% confidence interval uncertainty bans is constructed. The screen shot is shown on Figure 1. below.
Figure 1. Screen shot of the hydraulic simulation project
Monte Carlo Simulation (2) Example Details
This model is taken from our XL Modeling VBA program. Given the market assumption, profit equation, and input variables distributions
(uniform, normal, and truncate normal), we derived the probability distribution of the profit and generate the histogram.
From the
probability distribution, we can obtain the probability of the profit that excesses any given number of value. We can also obtain
the median and average of the profit from the distribution.
For more detail of this example, please go to the following page in our
Anthony's VBA page site.
http://www.anthony-vba.kefra.com/vba/vba12.htm
Figure 2. Screen shot of the profit/market simulation program
Web Application Example Details
This interactive web application allows uses to compute call and put price right on the Web. The
quotation calculator
program demonstrated on this site can also be used in this matter.
To test out our online applications such as mortgage calculator
and others, please visit our
Online Tool page.
Figure 3. Screen shot of the web interactive option calculator
Copyright © Excel Business Solutions. All Rights Reserved.
37 advanced Excel VBA prorgrams in finance & statistics with VBA source codes.
