See how a customized Retirement Saving template assesses the performance of a portfolio in future years

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:
  1. Define Profile Parameters
    The user inputs the profile characteristics of the individual whose profile is to be modeled. 
     
  2. Define Model Parameters
    The next step is to add the probability distributions for the return of each of the investments. 
     
  3. 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 software PrecisionTree, StatTools, NeuralTools, RISKOptimizer, 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. 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s