The System Management module is only available to users who have responsibility for maintaining master data for “slow moving dimensions”. For example Investment Vehicle or Investor.

Open

Within System Management you can always access the this only documentation, by clicking on “Handbook”

System settings

System settings such as the first quarter of capital account data, snapshot facility start and reporting currency are set during implementation and should never be changed in a running system.

The default value for the projection period is 10 years. This is possible to change but should be done in consultation with your Apliqo support partner.

Open

The main parameters which need to be updated on a quarterly basis are the current (last) quarter for which actual data is available for both fund level and asset level. These parameters are manual rather then being calendar based due to the variability of GP publishing schedules. In general the current last quarter parameter should be updated after all reports are finalised and the final snapshot has been run for a given reporting quarter. At this point the final quarter should be “rolled over” to the next quarter (otherwise data for the new quarter will be ignored by the model).

Snapshots

Using the Snapshot function copies all current data in the application to a timestamped read-only version. By switching the snapshot version in any report with this facility the user can “rewind” the portfolio to see values as they were for any previous reporting period.

Dimension maintenance

The main dimension or masterdata maintenance activity is the creation of new investments and asset level information which is handled during the quarterly data updates. However, there are some other critical masterdata which may be updated infrequently (or possibly not at all). This module gives you the ability to self-administer such changes.

Currency

The currency maintenance gives you the ability to add additional currencies to the model or to change the reporting currency. A precondition of adding a currency to the model is that the currency must be the local reporting currency of at least one fund/investment.

The reporting currency is selected by default in all reports and all KPI calculations and analysis rollups are based on reporting currency.

Although it is possible to change the reporting currency from EUR to USD in practice this would never be performed on a running model as reporting currency is a key up front decision during implementation. Note that updating the reporting currency from this screen will also update the value in the system settings screen.

Investor

The investor maintenance screen gives you the ability to add (or remove) investors.

Investment vehicle

The investment vehicle/entity type maintenance screen gives you the ability to add (or remove) investment vehicles.

Scenarios

Scenarios are a special type of version which allow assumptions in the model to be played with to see the impact on valuation and cashflows.

All changes in the model are always performed on the Current version. However, using the scenario functionality allows the user to first back up current assumptions and masterdata and then restore the current assumptions after scenario analysis. Likewise it is possible to prepare different sets of assumptions as a named scenario and replace the current version with the selected scenario and see the impact on the portfolio.

FX data and currency rates

These screens allow the user to load currency rates from online financial market data hubs. Historic rates are updated automatically on a monthly cycle. However, should you want to update rates manually this facility is also available on demand.

Region & Sector Spit

Region and sector split can be managed fund by fund in the fund setup and quarterly data input sections. This screen provides an interface to be able to update splits for all investments in one location.

Shareholding

This screen provides an interface to be able to view and update the shareholding matrix for all investments in one location.

Projections

projection assumptions

Projection Assumptions can be managed fund by fund in the fund setup and quarterly data input sections. This screen provides an interface to be able to update projection assumptions for all investments in one location.

Statistical tables

This report provides a read only view of the distillation of the Preqin dataset into statistical tables by performance quartile which is used in the cashflow projection model.

Measure descriptions

This interface allows to maintain their own display captions for reporting accounts and KPIs in multiple display languages.