Here is an example of a custom application written by Palisade Custom Development using @RISK's XDK in Excel. In this example, @RISK is used to analyze the investment of funds for retirement planning. The application prompts the user for profile characteristics of the client and portfolio parameters.
Once the information is entered, the application runs an @RISK simulation to assess the performance of the portfolio in future years as well as the effects of various withdrawal rates after retirement. Results are presented in tables and graphs.
This video demonstrates how easy it is to utilize this Custom Application:
Define Profile Parameters
The user inputs the profile characteristics of the individual whose profile is to be modeled.
Define Model Parameters
The next step is to add the probability distributions for the return of each of the investments.
Simulate and View Results
Observe multiple simulations and view the custom reports that are provided.
Automation takes the shape of an Excel add-in, which is shown to the user as a new Excel ribbon.
Custom Development in Excel
Palisade Custom Development
has written applications for cost estimation, retirement planning, oil and gas prospecting, portfolio risk management, and more – all utilizing @RISK technology in Excel. In each case, the interface is customized to include only what the users need, hiding unused @RISK functionality and preventing user access to the underlying model logic. You can also automate processes like reporting, generating only the charts and data you want. The result is a tailored application ready to roll out to your workgroup. Because the application is in Excel, the training required for users is minimal. XDKs come with the DecisionTools
, and Evolver
as well as @RISK
. This means we can create risk analysis solutions for you using a range of powerful analytics, including Monte Carlo simulation
, decision trees, statistics, neural networks
, and optimization.