
 Rate Projections Functions Walkthrough
 Accruals and Cash
 Repeating Formulae
 Range Names and References
 Optional Parameters
 Using PmtsPerYear
 Modelling Seasonality
 Calculating Interest
 Using Business Functions in VBA (Visual Basic for Applications)
 Array Functions
 Volatility
 Annual Equivalent Rates
 Array Function
 Auto Multi Functions
 Variable Plurality
 GoalSeek
 MonteCarlo probability functions in the Monte Carlo family. A very useful and simple function called Distribution is the best bet for specifying variables as it handles several distributions. You can also use the distribution functions in Excel too, such as Normal or GammaDist. Look also at PartialDependency for partially dependent variables, DistCumulative for a cumulative probability distribution and DiscreteOutcome for a discrete outcome distribution.
 A MonteCarlo simulation tool on the menu. This script based tool allows you to run and store all MonteCarlo variables and calculate means, percentiles etc. There is no graphic output from MonteCarlo  this is something we think you are better placed to do, if you so wish. (There are other proprietary MonteCarlo products on the market that provide excellent graphical output.)
 Each MonteCarlo simulation requires a worksheet dedicated to it
 The Monte Carlo script starts in cell A1.
MonteCarlo  
How to use BF"s nofrills MonteCarlo Simulator  
Business Functions contains a basic but powerful Monte Carlo simulation system comprising: The best way to see how MonteCarlo works is to look at the Monte Carlo example from the Examples menu. MonteCarlo Syntax
