J&L Software LLC Home Page
J&L Financial Planner's Monte Carlo Analysis
The following paragraphs outline how the Monte Carlo Analysis is implemented by the J&L Financial Planner.
The J&L Financial Planner allows you to create simple or complex financial planning scenarios (financial plans) revolving around your existing accounts, consisting of investment, retirement, asset, and equity accounts. You assign a nominal return rate to each account, the traditional expected average yearly rate of return, as well as a minimum expected rate, a maximum expected rate and an optional Standard Deviation. This minimum rate to maximum rate defines a range for each account which is used by one the Monte Carlo Analysis options. As another option the Monte Carlo Analysis uses the supplied Standard Deviation.
The J&L Financial Planner also gives you the option to collect accounts into groups of accounts. Each group of accounts is assigned a minimum expected rate and a maximum expected rate. This minimum rate to maximum rate defines a range for each group of accounts which is used by the Monte Carlo Analysis as its third option.
The J&L Financial Planner allows you to assign a range of inflation rates used by the Monte Carlo Analysis.
As shown in Figure 1.0 the Monte Carlo Analysis allows you to execute your financial plan up to 25000 times. Each gray graph is a separate execution of your scenario. Each time it is executed the analysis generates a random rate for each of your accounts or group of accounts each year of your plan. The rates are generated within the range of rates or the Standard Deviation you specify. You have control over the extremes to which the analysis performs. The J&L Financial Planner also gives you the option of choosing uniformly distributed random rates or Gaussian (normal) distributed random rates, as well as the option to use account rate ranges or group rate ranges. There is also a distribution factor setting that permits you to adjust the Gaussian Distribution.
In summary, the Monte Carlo Analysis is able to estimate the probability of achieving the success of your financial plan by accounting for the yearly variability in the two main factors contributing to it's outcome, the return rate on your investments and the inflation rate. You can execute up to a thousand trials of your financial plan. Each trial is a fully independent execution of your financial plan, where each year the return rate on your investments and the inflation rate can take on a range of possible random values.
The large number of trials allows the analysis to compute the statistical probability your financial plan will be successful. For example, if after 1000 trials, 750 of those trials achieved your financial goals, your financial plan success rate is 75.0%.
If your financial plan rate is below your expectations the J&L Financial Planner allows you to make easy scenario changes to play "what-if" with your financial future.
Back to Screens Menu
J&L Software LLC Home Page
1997-2017 J&L Software LLC
All Rights Reserved