Features of the AssumeIT Sensitivity tool for Excel Models

AssumeIT Sensitivity Tool for Microsoft Excel includes numerous easy locating and applying sensitivity tool applications for any Excel models. It is the perfect application for “What if” scenarios. Designers often try to make an application extra use-friendly, but in the process complicate it even more for the user. Not with this application. Simplicity is the key to its usability.

The AssumeIT Sensitivity Tool is perfect IFRS7 sensitivity analysis. It consists of a toolbar that automatically loads within the Excel version used. The toolbar consists of the following main options:

• Sensitivity applications
• Time saving applications
• Spreadsheet controls
• Div/0!
• Help

Sensitivity applications include:

• Inputs vs. Outputs which are used to allow running of a series of inputs through the spreadsheet model. It will record and then display the effects on the possible outputs.
• Best, Worst & Average Inputs which ensure that multiple inputs can be run against each other. The effects on the outputs are identified and displayed.
• Most Sensitive Inputs which can be used for the identification of which part of the input selection will have the biggest impact on the selected outputs.
• Scenario Sheet Creation allows for the creation of a separate sheet within the specific spreadsheet for the running of multiple scenarios through that spreadsheet.

Times saving applications include:

• Sheet protection where numerous spreadsheets can be protected through one password.
• Unprotection of the sheets.
• Hiding and unhiding of sheets.
• Div/0! Error function to ensure that the divide by zero error doesn’t display.

In addition to the above various spreadsheet controls are available as well as a comprehensive help function. Get the AssumeIT Sensitivity Tool and get the right help for sensitivity analysis tasks in Excel.