VALUEXPLORER (VXP)Ôäó

Facilitates, manipulates and support the development of Executive Analytics Solutions
  • Efficiently manipulates business and financial information and models
  • Provides enhanced analytical support to implement Value Based Management
  • Deliver increased shareholder value by improving the Budgeting, Planning and Forecast process
  • Enable the alignment of strategies, policies, performance measures, rewards, organisation, processes, people and systems between short term budgets and long-term forecasts
  • Adjust business scenarios and evaluations to identify the impact thereof in real time

Business and investment managers are often limited to the use of standard Microsoft?« Excel functionality to perform short and long term forecast within the various business areas (Finance, Human Resources, Operational etc). The outcome of this is that forecast methodology and processes applied by businesses often lack the ability to:

  • Quantify key value drivers; and
  • Perform scenario and sensitivity analysis on such key drivers

VXPÔäó, a collection of software tools developed by EPI-USE Analytics, is at the focal point of many business decisions, hence the rapid growth in the use of high quality financial models by decision makers.?á The VXPÔäó value model is a real-time business model that links the operational and financial value drivers of the business to pro-forma future financial statements.

Ultimately, with a subscription to the solution, businesses can adjust their financial scenarios and evaluations to identify the impact thereof in real time.

LetÔÇÖs compare standard Microsoft?« Excel and VXPÔäó

Functionality

Window pane navigation.


Optimisation of large spreadsheets/ creation of multiple similar workbooks.


Formula tracer facility.


Scenario analysis.


Sensitivity analysis.

Microsoft?« Excel

Limited to tabs at bottom of spreadsheet


Requires substantial time and resources to calculate complex formulas, resulting in increased development time

Multiple copies of the same workbook containing various scenarios and/or versions

Multiple updates are required in a single Excel spreadsheet to add additional members to ranges

Multiple spreadsheet changes are to be made each time in the same spreadsheet, or across a range of spreadsheets.


Limited to only view one cell of formula precedents and dependents within a spreadsheet.


Limited ability to perform ÔÇ£what-ifÔÇØ analysis.


Limited ability to perform sensitivity analysis.

VXPÔäó

Navigation pane indicating, grouping and separating inputs, calculations and reports.


Builds highly efficient and optimised spreadsheets, thereby reducing development time in creating multi-dimensional spreadsheets.

Provide the ability to load and save input data from a database – avoiding the need for multiple copies of the same workbook.

Creates dynamic functionality to add or remove calculations and information from spreadsheets based on master data in the database.

Centralise all spreadsheet changes – if spreadsheet changes are required, the user only needs to make those changes once.


Extensive model navigation functionality that traces all formulae from calculated cells to the input cells in one window pane.


Extensive ability to perform various ÔÇ£what-ifÔÇØ analysis.


Extensive ability to perform sensitivity of key drivers and rank financial impact from most to least sensitive.

What VXPÔäó delivers

Three main components:

  • Excel model – VXPÔäó configures and builds a standard Excel model/workbook. As such, all standard Excel functionality is available for use (including in a non-VXPÔäó environment).
  • VXPÔäó client software – VXPÔäó builds an Excel model using a configuration sheet and master data which is preconfigured according to individual requirements.
  • Database – The database contains the master data, saved user inputs and comments for use by the model. This is provided in the form of a portable standalone SQL database (Microsoft SQL LocalDB) or a server based SQL database (Microsoft SQL Express or Microsoft SQL Server).

Furthermore, VXPÔäó adds the following additional functionality, made assessable to the user in the form of an Excel add-in, in addition to Excel functionality:

  • Model navigation
  • Sensitivity manager
  • Scenario manager
  • Formula tracer

In order to facilitate model use, data can be aggregated from actual or budget data into the format and level of detail required by the VXPÔäó model and loaded directly into the underlying SQL database, removing the requirement for the user to manually input base data for the model from other solutions.

EPI-USE Analytics combines deep local market knowledge and capability with a broad global perspective to deliver extensive modelling solutions.

Should you have any queries about the new solution and/or require a demonstration of it, you are welcome to contact Pieter Uys or Gerrit Scheepers.