Skip to content

Consolidation: Contributions

Grid Help

Right-clicking on a column heading presents a menu with the following options which allow you to expand or reduce the number of columns of data to be entered:

  • Add a new column to the right of the grid;
  • Insert a new column at the position of the cursor; and
  • Delete the current column at the position of the cursor.

Grid Help

Right-clicking on the Top Left Corner of the grid displays a menu which allows you to set the following Grid Editing Options:

  • Editing of a cell can be invoked by either clicking on the cell or by pressing F2 when the cell is active (Clicking will only change the current active cell); and
  • determine the cursor movement once editing is complete to be either to the next cell down, the next cell to the right or to stay in the current cell.

Amortisation Interest Rate (% p.a.)

This is the annual rate at which the amortisation contributions will be discounted. This will typically be the same as the discount rate.

Select from the drop-down list the Global Financial Parameter that contains the rate applicable. Once selected the current value of the Global Financial Parameter is shown to the right of this field.

To add a new Global Financial Parameter use the Edit Scheme Financials button at the bottom of this tab.

Edit Scheme Financials

Clicking the Edit Scheme Financials button takes you to the Scheme Financials menu.

Here you will be able to see a list of all the Financials that are currently defined. Double-click on the tree to see an expanded list of all financial assumptions that are defined.

Click the Add/Edit Financials to change the value of one of the assumptions.

Use QSM Settings

User can select the parameters that are suitable for Quick Scenario Modelling i.e. selecting this button will set ALM/LDI Interface to "Exclude Left Servce" and tick "Retain Category Splits in Database"

Run

Click the Run button to run the calculations.

SaveAs

Click the Save As button to save with a new file name.

Save

Clicking on the Save button allows you to save the entries.

Quit

Clicking on the Quit button allows you to exit without saving any of your changes.

In some of the screens you will be asked to confirm if you want to exit Ignoring all changes. If you click Yes, the file will be closed without saving any changes. If you click No you will be returned to your original screen.

From the Browser, the Quit button will take you to a graphical display of the results.