The last model used to estimate cash flow effects of volatile exchange rates is a Monte Carlo
simulation. The program Crystal Ball for Excel has been used to conduct the simulations. As in the
prior VaR analysis, the combined US Dollars and Chinese Yuan cash flow estimation measured in
euro has been used. The Monte Carlo simulation conducts a number of trials based on a standard
deviation and mean return defined by the user. The Monte Carlo simulations conducted in this
analysis are based on data obtained from three different periods, like in the other VaR analyses.
Considering the large sample size, the simulation has been based on a normal distribution even
though the data does not fit the distribution perfectly